INSERT INTO table (id, column1, column2)
VALUES (1, 'A', 'X'), (2, 'A', '2')
ON DUPLICATE KEY UPDATE column1='A', column2='X';
INSERT IGNORE INTO table (id, column1, column2)
VALUES (1, 'A', 'X');
REPLACE INTO table (id, column1, column2)
VALUES (1, 'A', 'X');
START TRANSACTION;
SELECT * FROM table WHERE id = 1 FOR UPDATE;
-- 进行一些操作
COMMIT;
-- 导出基础参数
select * into outfile '/data/mysql/3306/tmp/employees.txt'
character set utf8mb4
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
from employees.employees1 limit 10;
-- 导入基础参数
load data infile '/data/mysql/3306/tmp/employees.txt'
replace into table demo.emp2
character set utf8mb4
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
(field1, field2, field3,,,,)
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。