摘要:
1.模糊查询SELECT * FROM mytable WHERE u_name LIKE '%01%'2.创建视图create view stu_mjasselect student.NO,student.NAME,student.SEX,student.BIRTHDAY,student.MEMBER,major.MAJORfrom student,majorwhere student.MAJOR_KEY=major.MAJOR_KEY3. 为table添加备注alter table 表名 comment '注释';4. 结果排序select *from z_ 阅读全文