MySQL Code Build table, add and revise (CRUD)

I. Establishment of the table

CREATE TABLE Student (    numberkey,//Fixed primary key does not necessarily have to be self-increment, but the hook on the self-increment must be the primary key.     Name varchar (null,//design interface, non-null constraint     sex bit,    height decimal (8,2),//  Total 8 digits, 2 digits after decimal     birthday datetime    )

Decimal type float Double decimal

String varchar--------Consider length

The rest is not necessary, because int, datetime, char, BOOL (bit) are all default, and will not be useless.

int default 4 bytes, datetime default 8 bytes, char default 2 bytes, bit (bool) default 1 bytes

MySQL Code Build table, add and revise (CRUD)