摘要：
mysql> use testDatabase changedmysql> set names gbk;Query OK, 0 rows affected (0.02 sec)mysql> #在PHP中,获取不同栏目的商品mysql> #在地址栏上获取$_GET['id']mysql> select goods_id,cat_id,goods_name from goods -> where cat_id=5;+----------+--------+------------+| goods_id | cat_id | goods_name 阅读全文
摘要：
mysql> set names gbk;Query OK, 0 rows affected (0.03 sec)mysql> use testDatabase changedmysql> show tables;+----------------+| Tables_in_test |+----------------+| account || class || goods || m1 || member || mian || salary || stu ... 阅读全文
摘要：
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;+-------+-------------+------+-----+---------+------- 阅读全文