sql 数据库插入 question

1.表 course 结构

2. 插入数据

INSERT INTO course ( cno, cname, pcno, credit ) VALUES ( '1', '数据库', '5', 4 ); INSERT INTO course ( cno, cname, pcno, credit ) VALUES ( '2', '数学', 'null', 6 ); INSERT INTO course ( cno, cname, pcno, credit ) VALUES ( '3', '信息系统', '1', 3 ); INSERT INTO course ( cno, cname, pcno, credit ) VALUES ( '4', '操作系统', '6', 4 ); INSERT INTO course ( cno, cname, pcno, credit ) VALUES ( '5', '数据结构', '7', 4 ); INSERT INTO course ( cno, cname, pcno, credit ) VALUES ( '6', '数据处理', 'null', 3 ); INSERT INTO course ( cno, cname, pcno, credit ) VALUES ( '7', 'pascal 语言', '6', 4 );

3.出现了问题

4. 问题解决
5. alter table course alter COLUMN pcno varchar(10);(已经解决)