MySQL Learning notes

MySQL Learning notes:

Take the school database as an example:

Create DATABASE school Character set UTF8 {character Set GBK indicates that the database uses a character set of GBK, and Utf8,unicode, etc.}

Drop Database School {delete}

Take the student table as an example

To create a table:

CREATE TABLE Student
(
ID int unsigned NOT NULL Auto_increment primary key, {int unsigned unsigned, not NULL is not empty, Auto_increment automatically increases index value, primary key Set as PRIMARY key}
Nmme Char (TEN) NOT null default '-') {default '-' is empty when this value is filled}

Delete all data in the table: delete from student

Delete tables: drop table Student

Add: Insert course values (NULL, ' swim ') or insert Course (X1,X2) (y1,y2) {You can insert only the value of the corresponding column}

Delete: Delete from course where id=3

Change: Update course set cname= ' badminton ' where id=4

Check:

MySQL Learning notes