#练习1#已经存在数据库test04_emp,两张表emp2和dept2CREATEDATABASE test04_emp;use test04_emp;CREATETABLE emp2(
id INT,
emp_name VARCHAR(15));CREATETABLE dept2(
id INT,
dept_name VARCHAR(15));
【题目】
#1.向表emp2的id列中添加PRIMARY KEY约束 altertable emp2
modifycolumn id intprimarykey;altertable emp2
addprimarykey(id);#2. 向表emp2中添加列dept_id,并在其中定义FOREIGN KEY约束,与之相关联的列是dept2表中的id列altertable emp2
addcolumn dept_id int;
createdatabase test01_library;createtable books(
id int,
name varchar(50),
authors varchar(100),
price float,
pubdate year,
note varchar(100),
num int)
altertable books
modifycolumn id int(11)primarykey;oraltertable books
addcolumnprimarykey(id);altertable books
modify id int(11)auto_increment;altertable books
name varchar(50)notnull;