Mysql database (basic) Notes

Mysql database (basic) notes go to the installation directory... /bin/mysql.exe cd change Directory dir list all files in the current directory c: \ vesa \... \ a> Angle brackets indicate vasa/in drive C... .. indicates entering the specified directory cd space ted key to view the directory name in sequence> mysql space-u user name-p password (connect to the database using the user name and password) show databases; display the names of all databases www.2cto.com use; show tables; select * from data table names; view data insertion in the data table: insert into field name (Omitted not to write the field) values value; (field name 1-> value 1 field name 2-> value 2... same Order)
Update: 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) create database: create database name; delete list: drop table name ...; delete database: drop database name; view table attribute: describe table name; modify table attribute: alter table name modify column field name type; modify table Name: rename table original table name to a later table name; create a data table: create table data table name (item name type .., item Name type ..,......); author Dtdd