1:一个表中有多个主键
复合主键
create table sc
( studentno int, courseid int, score int, primary key (studentno,courseid) );
2:数据库中使用中文存储
CREATE DATABASE `articles` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
3:sql语句的不错的教程
http://www.w3school.com.cn/sql/sql_alter.asp
4:修改表内容
update class set C_year = "2011" where C_id = 1;
5:删除一行
delete from test where T_id="1";
6:比较不错哦,php当中常用的Mysql函数
http://www.php.net/manual/zh/ref.mysql.php
7: 在表中设置外键
create table notice_ziliao(Z_id varchar(20) primary key,Z_date varchar(20),Z_name varchar(128),Z_T_id varchar(40),foreign key(Z_T_id) references teacher(T_id));
这个foreign key 中的(Z_T_id)不要画蛇添足的加上双引号或者是引号,否则报语法错误