mysql - order by,limit,offset, MySQL

mysql - order by,limit,offset

DROP TABLE IF EXISTS tutorials_tbl;

create table tutorials_tbl(
   tutorial_id INT NOT NULL AUTO_INCREMENT,
   tutorial_title VARCHAR(100) NOT NULL,
   tutorial_author VARCHAR(40) NOT NULL,
   submission_date DATE,
    datetime DATETIME,
    timestamp TIMESTAMP,
    year YEAR,
   PRIMARY KEY ( tutorial_id )
);

INSERT INTO tutorials_tbl 
   (tutorial_title, tutorial_author, submission_date,datetime,year)
   VALUES
   ("Learn PHP", "John Poul", NOW(),NOW(),NOW());
   
 INSERT INTO tutorials_tbl 
   (tutorial_title, tutorial_author, submission_date,datetime,year)
   VALUES
   ('2'|1|'7', "John Poul", '1973-12-30''','1973-12-30''',1901-1||1901-0);

SELECT tutorial_id, tutorial_title FROM tutorials_tbl ORDER BY tutorial_id LIMIT 20 OFFSET 1;

/*ORDER BY*/
-- SELECT tutorial_id, tutorial_title FROM tutorials_tbl ORDER BY 0 LIMIT 20 OFFSET 1; -- order by 0 gives error
SELECT tutorial_id, tutorial_title FROM tutorials_tbl ORDER BY ((1=0) and sleep(5)) LIMIT 20 OFFSET 1;

/*LIMIT*/
SELECT tutorial_id, tutorial_title FROM tutorials_tbl ORDER BY tutorial_id LIMIT 1; select 1=0 and sleep(5); --   OFFSET 1;

/*OFFSET*/
SELECT tutorial_id, tutorial_title FROM tutorials_tbl ORDER BY tutorial_id LIMIT 20 OFFSET 1;select 1=0 and sleep(5);


run \| edit \| history \| help	0