显示表的字段 desc person;
显示表的内容 select * from person;
显示数据库 show databases;
显示所有表 show tables;
delete from person;
INSERT INTO person VALUES (1, "John Brown[color=red]"(加引号), [/color]"1965-05-20[color=red]"(注意格式,并且加引号), [/color]8400 );
INSERT INTO person VALUES (2, "Richard Flint", "1959-01-14", 5200 );
INSERT INTO person VALUES (3, "Mike Stone", "1983-08-10", 12800);
INSERT INTO person VALUES (4, "Will Jasley", "1981-10-18", 10300);
INSERT INTO person VALUES (5, "Fillip Cornerbook", "1978-12-04", 4600 );
显示表的内容 select * from person;
显示数据库 show databases;
显示所有表 show tables;
delete from person;
INSERT INTO person VALUES (1, "John Brown[color=red]"(加引号), [/color]"1965-05-20[color=red]"(注意格式,并且加引号), [/color]8400 );
INSERT INTO person VALUES (2, "Richard Flint", "1959-01-14", 5200 );
INSERT INTO person VALUES (3, "Mike Stone", "1983-08-10", 12800);
INSERT INTO person VALUES (4, "Will Jasley", "1981-10-18", 10300);
INSERT INTO person VALUES (5, "Fillip Cornerbook", "1978-12-04", 4600 );