<> Paging query limit
SELECT * FROM employees LIMIT 0,5; # from 0 start , The starting index can be omitted SELECT * FROM employees LIMIT
5
<> Joint query
<> Insert statement insert into
# Mode 1 ： INSERT INTO beauty(NAME,sex,`phone`) VALUE(' Xu Fengnian ',' male ','13825425632');
# Support inserting multiple rows INSERT INTO beauty(NAME,sex,phone) VALUE(' Xu Fengnian 1',' male ','13825425632'), (
' Xu Fengnian 2',' male ','13825425632'), (' Xu Fengnian 3',' male ','13825425632') # Support sub query INSERT INTO beauty(
NAME,sex,phone) SELECT `boyName`,' male ','1654616516' FROM boys # Mode II INSERT INTO
beautySET NAME = ' Chen Zhibao ',sex = ' male ',phone = '13654875896';
<> Modify statement update
# Modify multi table records # Inline implementation UPDATE beauty b JOIN boys bo ON b.`boyfriend_id` = bo.`id` SET b.
`phone` = '114' WHERE bo.`boyName` = ' zhang wuji '; # Leftist realization UPDATE beauty b LEFT JOIN
boys boON b.`boyfriend_id` = bo.`id` SET b.`boyfriend_id` = 2 WHERE bo.`id` IS
NULL
<> Delete statement delete from
# Deleting a single table DELETE FROM beauty WHERE `phone` LIKE '%9'; # Deletion of multiple tables # Single table DELETE b FROM
beauty bJOIN boys bo ON b.`boyfriend_id` = bo.`id` WHERE bo.`boyName` = ' zhang wuji ';
# Double table DELETE b,bo FROM beauty b JOIN boys bo ON b.`boyfriend_id` = bo.`id` WHERE
bo.`boyName` = ' Huang Xiaoming ';
Technology