复制mysql> CREATE TABLE test ( > name VARCHAR (15),本语 > email VARCHAR (25), > phone_number INT, > ID INT NOT NULL AUTO_INCREMENT, > PRIMARY KEY (ID)); mysql> show tables; mysql> show columns from tablename; mysql> INSERT INTO test VALUES mysql> (John, buggavin@gmail.com, mysql> 5554321, NULL); mysql> SELECT * FROM test mysql> WHERE (name = "John"); mysql> DELETE FROM test mysql> WHERE (name = ""); mysql> UPDATE test SET name = Mary mysql> WHERE name = "John"; 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17. |
喜欢
讨厌