INSERT INTO table_name (column1,column2,column3,...)VALUES (value1,value2,value3,...);
DELETE FROM table_name WHERE id=1;
UPDATE table_name SET column1=value1,column2=value2,...WHERE some_column=some_value;
select * from table where id =1;
SELECT COUNT(DISTINCT address) FROM sceneDetail WHERE sceneId = 1931;
ALTER TABLE test_group ADD COLUMN id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
desc t1;
Set session transaction isolation level read uncommitted;
Start transaction;//或begin
Do query;//执行sql操作
commit;//提交
回滚
Set session transaction isolation level read uncommitted;
Start transaction;//或begin
Do query;//执行sql操作
Rollback;//回滚
select @@autocommit;
set autocommit=0;
导出到本服务器中
SELECT * FROM dictionary WHERE dicType ="qa.type" AND locale = "en_US" LIMIT 0, 1000 INTO OUTFILE "/var/lib/mysql-files/qa.sql";
导出到其他电脑(或服务器)中,也可以导出excel,csv文件
mysql -h 123.123.12.12 -u root -p -P 3306 -D MyDataBase -e "SELECT * FROM dictionary;" > e://1/1.sql
show variables like ‘%secure%’;
CREATE TABLE person1 AS SELECT * FROM person -- 复制表结构和表数据
CREATE TABLE person2 LIKE person;-- 只复制表结构
SHOW TABLE STATUS;
show variables like 'character%';