加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长学院 > MySql教程 > 正文

Mysql入门mysql查询中使用LIMIT的小例子

发布时间:2020-12-12 02:25:22 所属栏目:MySql教程 来源:网络整理
导读:《Mysql入门mysql查询中使用LIMIT的小例子》要点: 本文介绍了Mysql入门mysql查询中使用LIMIT的小例子,希望对您有用。如果有疑问,可以联系我们。 导读:本节内容:mysql limit语法的例子sql语句: Drop table employee;CREATE TABLE employee ( id int uns

《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全面培养人才。

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读