pg和mysql使用差异v0.1.docVIP

pg和mysql使用差异v0.1 -- 璇︾粏娴嬭瘯: 1.涓婚敭鑷闀挎柟寮忎笉鍚? pg浣跨敤sequence瀹炵幇,鍙互鏂逛究鑾峰彇褰撳墠sequence鍊? mysql浣跨敤 AUTO_INCREMENT鏉ュ疄鐜?涓嶆柟渚胯幏鍙栧綋鍓嶆彃鍏ユ暟鎹殑涓婚敭id ,mysql鏈塋AST_INSERT_ID() 鍑芥暟,浣嗘槸姝ゅ嚱鏁版槸渚濊禆浜庝細璇濈殑.闇€瑕佹厧閲嶄娇鐢? pg: create table t_id(id serial primary key, name varchar(1024)); 浼氳嚜鍔ㄧ敓鎴? LOG: statement: create table t_id(id serial primary key,name varchar(1024)); NOTICE: CREATE TABLE will create implicit sequence t_id_id_seq for serial column t_id.id NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index t_id_pkey for table t_id DEBUG: building index t_id_pkey on table t_id create table t_id(id serial primary key, name varchar(1024)); insert into t_id(name) values(cross); insert into t_id(name) values(crossmo_||currval(t_id_id_seq::regclass)),(crossmo_||currval(t_id_id_seq::regclass)); -- pg澶勭悊鍏?鏌ヨ currval(t_id_id_seq::regclass) ,鍐峣nsert ,鍥犳鏌ヨ缁撴灉濡備笅: demo=# select * from t_id; LOG: statement: select * from t_id; id | name ----+----------- 1 | cross 2 | crossmo_1 3 | crossmo_2 mysql: drop table t_id cascade ; create table t_id(id int primary key auto_increment, name varchar(1024)); insert into t_id(name) values(crossmo01),(crossmo02); INSERT into t_id(name) VALUES( CONCAT(crosoo,LAST_INSERT_ID()),( CONCAT(crosoo,LAST_INSERT_ID()); INSERT into t_id(name) VALUES( CONCAT(crosoo,LAST_INSERT_ID()); INSERT into t_id(name) VALUES( CONCAT(crosoo,LAST_INSERT_ID()); create table t_id(id int primary key auto_increment, name varchar(1024)) CHARACTER SET=utf8 COLLATE=utf8_bin; drop table t_id cascade ; create table t_id(id int primary key auto_increment, name varchar(1024)) CHARACTER SET=utf8 COLLATE=utf8_bin; insert into t_id(name) values (crossmo),(cRossmo); select * from t_id where name like %R%; --杩斿洖缁撴灉鍙湁1鏉℃暟鎹? create table t_id1(id int primary key auto_increment,name varchar(30)); INSERT into t_id1(name) VALUES( CONCAT(crosoo,LAST_INSERT_ID())); INSERT into t_id(name) VALUES( CONCAT(crosoo,LAST_INSERT_ID())); SELECT LAST_INSERT_ID(); 7 select * from t_id1; 1 cr