《Mysql入门mysql查询中使用LIMIT的小例子》要点: 本文介绍了Mysql入门mysql查询中使用LIMIT的小例子,希望对您有用。如果有疑问,可以联系我们。
导读:本节内容:mysql limit语法的例子sql语句:
Drop table employee;CREATE TABLE employee ( id int unsigned not null auto_in...
本节内容: mysql limit语法的例子MYSQL数据库
sql语句:? ?MYSQL数据库
Drop table employee;MYSQL数据库
CREATE TABLE employee ( ??? id int unsigned not null auto_increment primary key, ??? firstname varchar(20), ??? lastname varchar(20), ??? title varchar(30), ??? age int, ??? yearofservice int, ??? salary int, ??? perks int, ??? email varchar(60) );MYSQL数据库
INSERT INTO employee (firstname,lastName,title,age,yearofservice,salary,perks,email) values ("John","Chen","Senior Programmer",31,3,120000,25000,"j@jbxue.com");MYSQL数据库
INSERT INTO employee (firstname,email) values ("Jan","Pillai",32,4,110000,20000,"g@yahoo.com");MYSQL数据库
INSERT INTO employee (firstname,email) values ("Ane","Pandit","Web Designer",24,90000,15000,"a@jbxue.com");MYSQL数据库
INSERT INTO employee (firstname,email) values ("Mary","Anchor",27,2,85000,"m@mail.com");MYSQL数据库
INSERT INTO employee (firstname,email) values ("Fred","King","Programmer",75000,"f@net.com"); INSERT INTO employee (firstname,"Mac",80000,16000,"j@jbxue.com"); INSERT INTO employee (firstname,email) values ("Arthur","Sam",28,14000,"e@yahoo.com"); INSERT INTO employee (firstname,email) values ("Alok","Nanda",70000,10000,"a@yahoo.com"); INSERT INTO employee (firstname,email) values ("Susan","Ra","Multimedia Programmer","h@jbxue.com"); INSERT INTO employee (firstname,email) values ("Paul","Simon",23,1,12000,"ps@jbxue.com"); INSERT INTO employee (firstname,email) values ("Edward","Parhar",30,"a@jbxue.com"); INSERT INTO employee (firstname,email) values ("Kim","Hunter","Senior Web Designer","kim@coolmail.com"); INSERT INTO employee (firstname,email) values ("Roger","Lewis","System Administrator",100000,13000,"roger@mail.com"); INSERT INTO employee (firstname,email) values ("Danny","Gibson","danny@jbxue.com"); INSERT INTO employee (firstname,email) values ("Mike","Harper","Senior Marketing Executive",36,28000,"m@jbxue.com"); INSERT INTO employee (firstname,"Sunday","Marketing Executive",5,"monica@bijbxue.com"); INSERT INTO employee (firstname,email) values ("Jack","Sim",18000,"hal@jbxue.com"); INSERT INTO employee (firstname,email) values ("Joe","Irvine",72000,"joseph@jbxue.com"); INSERT INTO employee (firstname,email) values ("Henry","Ali","Customer Service Manager",9000,"shahida@jbxue.com"); INSERT INTO employee (firstname,email) values ("Peter","Champion","Finance Manager","peter@yahoo.com");MYSQL数据库
使用limit语法的例子: ?MYSQL数据库
select * from employee; SELECT firstname,lastName from employee LIMIT 5;编程之家PHP培训学院每天发布《Mysql入门mysql查询中使用LIMIT的小例子》等实战技能,PHP、MYSQL、LINUX、APP、JS,CSS全面培养人才。 (编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|