MySQL Database basic notes _mysql

Enter installation directory .../bin/mysql.exe

CD Replacement directory dir lists all files in the current directory

The c:\vesa\...\a> angle bracket is expressed in the A folder of the C/vasa/.

CD space ... Indicates an up-level directory

CD Space directory name indicates access to specified directory

CD Space Ted health indicates order view directory name

>mysql Space-u username-p password (that is, through the user name password connected to the database)

Show databases all databases

Use database name; Enter database

Show tables; display all data tables

SELECT * from datasheet name; View data in data table

Inserted: INSERT into field name (omit not written representation so field) values; (Field name 1-> value 1 Field name 2-> value 2 ... Same as the same number of orders)

Update: The Update table name set field name = value (where field name = value and field name = value)

Query: Select field List from table name (where field name = value and field name = value)

Delete: Delete from table name (where field name = value and field name = value)

Creation database: Create database name;

Delete list: drop table table name ... ；

Delete database: Drop DB database name;

View Table properties: Describe table name;

Modify table properties: ALTER TABLE name modify column field name type;

Modify table name: Rename table name to the form name to the table;

Create a data table: The CREATE table datasheet name (the item name type.) ., the item name type. .，...... ）；