MySQL Learning notes

MySQL Learning notes  

add:insert Delete: delete change: Update check:Select

Database:

created: Create database name ';

modified:rename database ' database name ' to '

Delete : Drop database name ';

Table:

created: Createtable ' database name ' . ' table name ' (' field 1 ', ' Field 2 ', ' Field 3 ');

modified:rename table ' database name ' . ' old table name ' to ' database name '. ' new table name ' `

Delete:drop table ' name '

Empty:truncate table ' name '

Data:

multiple conditions are connected with and, * on behalf of all ;

add:insert INTO ' table name ' (' field 1 ', ' field 2 ', ' field 3 ') value (' value 1 ', ' value 2 ', ' value 3 '), (' value 1 ', ' value 2 ', ' Value 3 ');

Delete :delete from ' table name ' where ' field ' = condition ;

change:update ' table name ' Set ' field ' = ' new value ' where ' table name '. ' Field ` = conditions ;

Check:select * from ' table name ' where ' field ' = condition ;

Splicing of variables:

variable outside with curly braces ;

Example :$name = ' o ';

$sql = "INSERT INTO ' userinfor ' (' userId ', ' userName ', ' PassWord ', ' Vipgrade ') VALUES (null, ' {$name} ', ' 123456 ', ' 1 ') ";

MySQL Learning notes