show columns

Reprint: http://www.cnblogs.com/linjiqin/archive/2013/03/01/2939384.htmlMySQL installation directory (Ubuntu system)Database directory/var/lib/mysql/Configuration file/usr/share/mysql (mysql.server command and configuration file)Related commands/usr/

Sql–alter Sql–altertable of Contents Character Engine Add Drop Primary key: FOREIGN key Default Modify Change Rename generally cannot be changed, the data may be wrong to change CharacterCreate

Article excerpt from: http://www.cnblogs.com/linjiqin/archive/2013/03/01/2939384.html thanks bo friends to share O (∩_∩) o~MySQL Common commandsMySQL installation directoryDatabase directory/var/lib/mysql/Configuration file/usr/share/mysql

one, basic command line Operation1. Displays the list of databases in the current database server:mysql> show DATABASES;2, establish database:mysql> create database name;3, set up the data table:mysql> use library name;mysql> CREATE TABLE table name

We often encounter some cases of inserting Chinese characters into the MySQL database, but when we select them, we find garbled characters. For example, we enter and exit such a record from Table a: I a (,); When you access it, you may find that

The ORACLE tutorial is: MySQL Security Guide (3) (go ). MySQL Security Guide (3)Author: Yan Zi2.4 set users without GRANTIf you have a MySQL version earlier than 3.22.11, you cannot use the GRANT (or REVOKE) statement to set user and access

1. Create a data table --- BASICS (skipped by experts) Orthodox method: create [TEMPORARY] table name [if not exists](Column item definition created)[Table options][Partition options]; # The Orthodox creation method. For specific parameters, refer

Mysql database Quick Start (1), mysql database Quick Start1. Database Operations 1.1 connect to the mysql server Mysql-u root (User Name)-p 1.2 exit the mysql Command Prompt window. Exit 1.3 view version Select version (); 1.4 list databases Show

Create, view, and insert MySQL Data Tables.Data Table: a data table (or table) is one of the most important components of a database and the basis of other objects. 1. First, open a database (here I open a new aaa database ). Open the database: use +

Mysql common command lines Mysql common command lines First, start and stop the mysql Service Net stop mysql Net start mysql Second, log on to mysql Syntax: mysql-u user name-p User Password Enter the mysql-uroot-p command, press enter and prompt

This article mainly introduces a simple and practical php database class for mysql operations. it not only contains common php operations for mysql databases, but also contains the filtering function for dangerous characters, it is very practical.

This article describes how to obtain the field name and detailed information of a mysql data table by using PHP. This article also describes how to obtain the data table structure and list database data tables, you can refer to the following SQL

Mysql does not take a long time to learn. database operations simply add records, search records, delete records, and modify records. The following commands are summarized to share with you: connection command: mysql-h [host address]-u [user name]-p

PHP & amp; MYSQL review outline. PHPMYSQL review outline 1. PHP syntax ◆ data types PHP only contains three basic data types: integer, floating point (or real number, double precision), and string. String available single quotes and PHP & MYSQL

Mysql official introduction to Insomecases, theservercreatesinternaltemporarytableswhileprocessingqueries. SuchatablecanbeheldinmemoryandprocessedbytheMEMORYstorage... mysql official introduction In some cases, the server creates internal temporary

This article mainly introduces the summary of common commands for MySQL to view and clear tables. it is the basic knowledge in MySQL getting started. For more information, see View MySQL database tablesGo to MySQL Command line client View the

Mysql common commands (LinuxWindows) View database status: service mysqld status Start Database: service mysqld start Enter the database: mysql-u root-p123456; List databases: show databases; Select database: use databaseName; List tables:

One of MySQL study notes: bitsCN.com MySQL has a command line named mysql. enter mysql at the prompt and the following simple prompt will appear: ~ mysqlWelcome to the MySQL monitor. Commands end with ; or /g.Your MySQL connection id is

This article describes how to use the describe command in MySQL. The describe command is mainly used to obtain information about tables or columns. For more information, see 1. the describe command is used to view detailed design information of a

MySQL learning footprint record 02-SELECT bitsCN.com MySQL learning footprint record 02-SELECT Table structure and data used in this query mysql> SHOW COLUMNS FROM products; +------------+--------------+------+-----+---------+-------+| Field