SQL+parser 源代码

use student_class select sname,ssex,grade from student,sc where student.sclass=sc.sclass and student.sno=sc.sno and cno='1'

select sclass,sno from sc where cno=1 and sno not in(select sno from sc where cno=2)

select * from student where not exists ( select * from sc where sno=student.sno and cno='1'and sclass=student.sclass )

use student_class select distinct student.* from student ,course,sc where student.sclass=sc.sclass and student.sno=sc.sno and…

use student_class select student.* from student ,sc where student.sclass=sc.sclass and student.sno=sc.sno and cno='2' and grad…

-- phpMyAdmin SQL Dump -- version 2.6.4-pl4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jan 20, 2006 a…

-- -- Add language preferences -- ALTER TABLE `user` ADD `language` VARCHAR( 4 ) DEFAULT 'FR' NOT NULL AFTER `password` ; -- -…

-- -- Firstname and lastname inversion -- ALTER TABLE `person` CHANGE `firstname` `lastname` VARCHAR( 45 ) CHARACTER SET latin1…

ALTER TABLE `person` ADD FULLTEXT `search` ( `lastname` , `firstname` , `note` ); ALTER TABLE `contact` ADD FULLTEXT `search` (…

-- -- Alter on table address -- ALTER TABLE `address` ADD `street_next` VARCHAR( 100 ) NOT NULL AFTER `street` ;