当前位置：网站首页>Create a table in a MySQL database through Doc

Create a table in a MySQL database through Doc

2022-08-09 10:43:00 【Zuo Mingshui】

After entering doc:
show databases;
Show all databases
exit;
Launch doc
create database School;
Create a database
use School;
Enter database
create table StudentInfo(
name char(10),
age char(3) );
Create table
insert StudentInfo(name,age)
VALUES('David','18');
insert data
select *from StudentInfo;
query
update StudentInfo set age='12' where name='HAHA';
update data
insert into studentInfo (name,age)values('Jingzhu',20);
Insert data
delete from StudentInfo where age='20';
Delete data