让我们首先创建一个表-mysql> create table DemoTable
-> (
-> StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> StudentName varchar(20),
-> StudentMarks int,
-> Status varchar(20)
-> );
使用插入命令在表中插入一些记录-mysql> insert into DemoTable(StudentName,StudentMarks) values('Chris',79);
mysql> insert into DemoTable(StudentName,StudentMarks) values('David',59);
mysql> insert into DemoTable(StudentName,StudentMarks) values('Bob',60);
mysql> insert into DemoTable(StudentName,StudentMarks) values('Mike',45);
使用select语句显示表中的所有记录-mysql> select *from DemoTable;
这将产生以下输出-+-----------+-------------+--------------+--------+
| StudentId | StudentName | StudentMarks | Status |
+-----------+-------------+--------------+--------+
| 1 | Chr