Mysql 基础练习 01
Mysql 基础练习 01 根据表格创建数据库表,注意编码。 createdatabasedb01defaultcharsetutf8collateutf8_general_ci;usedb01;createtableuserinfo(idintnotnullauto_incrementprimarykey,namevarchar(32)notnull,passwordvarchar(64)notnull,genderenum('male','female')notnull,emailvarchar(64)notnull,amountdecimal(10,2)notnulldefault0,ctimedatetime)defaultcharset=utf8;showtables;+----------------+ |Tables_in_db01|+----------------+ |userinfo|+----------------+ 1rowinset 插入任意五条数据 insertintouserinfo(name,`password`,gender,email)values("zhangsan","zhang123","male","zhangsan@example.com");insertintouserinfo(name,`password`,gender,email)values("murong","murong123","female","murong@example.com");insertintouserinfo(name,`password`,gender,email,amount)values("waner","waner123","female","waner@example.com",1234.123);insertintouserinfo(name,`password`,gender,email,amount)values("wangwu","wangwu123","male","wangwu@example.com",3432.23);insertintouserinfo(name,`password`,gender,email,amount)values("wangyuyan","wang123","female","wangyuyan@example.com",394023);select*fromuserinfo;+----+-----------+-----------+--------+-----------------------+-----------+--------+ |id|name|password|gender|email|amount|ctime|+----+-----------+-----------+--------+-----------------------+-----------+--------+ |1|zhangsan|zhang123|male|zhangsan@example.com|0.00|<null>||2|murong|murong123|female|murong@example.com|0.00|<null>||3|waner|waner123|female|waner@example.com|1234.12|<null>||4|wangwu|wangwu123|male|wangwu@example.com|3432.23|<null>||5|wangyuyan|wang123|female|wangyuyan@example.com|394023.00|<null>|+----+-----------+-----------+--------+-----------------------+-----------+--------+ (END)非法数据: 由于 gender 列使用的是 enum , 只能接受 male / female。