Welcome!
餃
閮餃
蝢撖園
蝢撖嗥曄
蝢撖嗉憯
蝢撖嗉賣
蝢撖嗅啣
擐
>
摮豢雄 / Cultivation Career
>
摮賊 Academy
>
蝘摮
>
蝘
>
Linux蝟餌絞蝞∠
>
PostgreSQL
Advanced
PostgreSQL
雿:
銝餅:
Tags:
Message:
HP Wrote: ------------------------------------------------------- > 1. PostgreSQL 瘝 CREATE TABLE IF NOT EXISTS > 隤瘜 > > 銋銋銝憟賢 PostgreSQL > 隤瘜瘥頛撘梧雿鈭撖虫 PostgreSQL > 芸斗 table > 摮刻佗隞亦湔亙神 CREATE TABLE > 撠勗臭誑鈭 > > 2. PostgreSQL CREATE TABLE 銝賢遣 > non-unique key > > MySQL 銝剖虜璅隤瘜嚗 > CREATE TABLE table ( > request_id BIGINT UNSIGNED NOT NULL > AUTO_INCREMENT PRIMARY KEY , > user_id INT UNSIGNED NOT NULL , > KEY (user_id) > ); > > 敺 KEY (user_id) > 臬遣蝡銝臭嗥 index嚗雿 > PostgreSQL 銝 CREATE TABLE 芾賢遣蝡 UNIQUE > INDEX嚗典箸砌閬撱 non-unique key > 芾賜函唬誑 CREATE INDEX 撱箇 > > 3. PostgreSQL 瘝 BIGINIT UNSIGNED / INT > UNSIGNED data type > > PostgreSQL MySQL Data type 撠扯”嚗 > > http://en.wikibooks.org/wiki/Converting_MySQL_to_P > ostgreSQL#Data_Types > > > 鞈嚗 > 1. Postgresql: how to create table only if it does > not already exist? > http://stackoverflow.com/questions/435424/postgres > ql-how-to-create-table-only-if-it-does-not-already > -exist > 2. Converting MySQL to PostgreSQL > http://en.wikibooks.org/wiki/Converting_MySQL_to_P > ostgreSQL