MySQL Note: Data insertion

First, insert the record

CREATE DATABASEMYDB; UseMYDB;CREATE TABLE IDENTITY(NAMECHAR( -)PRIMARY KEY, BIRTHDATETIME  not NULL, HOMECHAR( -));CREATE TABLESTUDENT ( Number INT PRIMARY KEYauto_increment, NAMECHAR( -) not NULL, AgeTINYINT   not NULL, HOMECHAR( -));INSERT  intoSTUDENTVALUES( -,'Curry',Ten,'Golden State'); #不指定字段名INSERT  intoSTUDENT (NAME, age, HOME)VALUES('Durant', One,'Golden State'); #指定字段名INSERT  intoSTUDENT (NAME, age, HOME)VALUES  ('Curry', -,'Golden State'),  ('Durant', in,'Golden State'),  ('James', at,'Cleveland'),  ('Irving', One,'Boston'); #插入多条记录INSERT  intoSTUDENT (NAME, age, HOME)SELECTNAME, Timediff (now (), BIRTH), HOME from IDENTITY; #插入查询结果SELECT * fromSTUDENT;DROP DATABASEMYDB;

View Code

Second, update the record

INSERT  intoSTUDENTVALUES( *,'Durant',0, in,'Oklahoma');UPDATESTUDENTSETHOME= 'Golden State'WHERE  Number =  *;

View Code

Third, delete records

DELETE  from STUDENT WHERE = ' Golden State ' ; #清除指定条件的数据 DELETE  from STUDENT; #清空所有数据

View Code

MySQL Note: Data insertion