摘要:
mysql> set names gbk;Query OK, 0 rows affected (0.00 sec)mysql> use gyshopDatabase changedmysql> #查看goods表的建表语句mysql> show create table goods;+-------+----------------------------------------------------------------------------------------------------------------------------------------- 阅读全文
摘要:
mysql> #学习日期/时间类型mysql> #date型,存储 年-月-日mysql> show tables;ERROR 1046 (3D000): No database selectedmysql> use testDatabase changedmysql> show tables;+----------------+| Tables_in_test |+----------------+| account || class || salary || stu || test || test2 ... 阅读全文
摘要:
mysql> # 学习tinyint的参数并验证字节与范围的关系mysql> create table class ( -> sname varchar(20) not null default '', -> age tinyint not null default 0 -> )engine myisam charset utf8;Query OK, 0 rows affected (0.33 sec)mysql> desc class;+-------+-------------+------+-----+---------+------- 阅读全文