Create a class table
create table class( id int primary key auto_increment, sname varchar(10) not null default '', gender char(1) not null default '', company varchar(20) not null default '', salary decimal(6,2) not null default 0.00, fanbu smallint not null default 0 )engine myisam charset utf8;
View the structure of a table desc [table name]
Add data to the table---select a table--> Add which columns of data-->What values to add respectively
Insert all columns
insert into class (id,sname,gender,company,salary ,fanbu) values (1,'张三','男','百度',8888.88,234);
or
insert into class values (1,'张三','男','百度',8888.88,234);
Insert only part of the column content
insert into class (sname,gender,salary) values ('刀锋','男',9000.00);
There is no id data inserted in the above example, but the id is auto-incrementing
Add multiple pieces of data at one time
insert into class (sname,company,salary) values ('刘备','皇室成员',15.28), ('曹操','宦官后代',88.45), ('孙策','江东集团',188.25);
update Modify the data in a table
Elements are
Change that table: class
Change those columns: gender, company, fanbu, etc.
What value should I change to:'Female','Qiandu'
Specify which one It takes effect locally: For example, id=2 (must add filter conditions)
update class set fanbu=123 where id=2 update class set fanbu=453,gender='男' where sname='孙策';
#Delete---Note: Deletion refers to deleting the entire row, and there is no deletion of a certain item in a flight. Several columns
#Delete elements
#Delete the data in that table: class
#Delete which row of data
Delete salary>8889 person
delete from class where salary>8889;
Delete the data of the entire table
delete from class;
The above is the addition, deletion and modification of the mysql table. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!