竹貓星球

代碼: 選擇全部

$cfg['Servers'][$i]['pmadb'] string 
The name of the database containing the linked-tables infrastructure. 

See the Linked-tables infrastructure section in this document to see the benefits of this infrastructure, and for a quick way of creating this database and the needed tables. 

If you are the only user of this phpMyAdmin installation, you can use your current database to store those special tables; in this case, just put your current database name in $cfg['Servers'][$i]['pmadb']. For a multi-user installation, set this parameter to the name of your central database containing the linked-tables infrastructure. 

代碼: 選擇全部

SQL 語法: 

CREATE TABLE `bbs` (

) 
MySQL 傳回：  

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 

代碼: 選擇全部

CREATE TABLE `pma_column_info` (
       id int(5) unsigned NOT NULL auto_increment,
       db_name varchar(64) NOT NULL default '',
       table_name varchar(64) NOT NULL default '',
       column_name varchar(64) NOT NULL default '',
       `comment` varchar(255) NOT NULL default '',
       mimetype varchar(255) NOT NULL default '',
       transformation varchar(255) NOT NULL default '',
       transformation_options varchar(255) NOT NULL default '',
       PRIMARY KEY (id),
       UNIQUE KEY db_name (db_name, table_name, column_name)
     ) TYPE=MyISAM COMMENT='Comments for Columns';