MySQL基本语法

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";