FirebirdSQL/1/4
出自VFP Wiki
在2008年8月23日 (六) 20:27由VidelZelva (對話 | 貢獻)所做的修訂版本
domdelpas
使ç¨iSQL測試--å¨Linuxä¸ç¤ºç¯
第ä¸æ¥ â ååè³æ庫
$cd /opt/firebird/bin
$isql -user sysdba -password <password*>
SQL>connect /opt/firebird/examples/employee.gdb;
SQL>select * from sales;
SQL>select rdb$relation_name from rdb$relations;
SQL>help;
SQL>quit;
第äºæ¥ - 建ç«è³æ庫路å¾åæ¬é
- 1) åå¦firebirdç®éä¸åå¨,è«ç¨root身å建ç«ï¼
- $su - root
- $mkdir -p /var/firebird
- $chown firebird:firebird /var/firebird
- 2) 建ç«firebirdæ¬éè³ææª
- run the following script:
- $cd /opt/firebird/bin
- $./createDBAlias.sh test.fdb /var/firebird/test.fdb
- 3)
- $vi /opt/firebird/aliases.conf and add the line at the end of the file:
- test.fdb /var/firebird/test.fdb
- 4) 建ç«è³æ庫:
- $/opt/firebird/isql -u sysdba -p <password*>
- SQL>create database 'localhost:test.fdb';
- SQL>quit;
- 5) å¨è¨å®æª/opt/firebird/firebird.conf æååæ¸DatabaseAccess,å¯ä»¥è®æåè¨å®å¥å.
- $/opt/firebird/isql -u sysdba -p <password*>
- SQL>create database '/var/firebird/test.fdb';
- SQL>quit;
- $/opt/firebird/isql -u sysdba -p <password*>
- SQL>connect '/var/firebird/test.fdb';
- SQL>quit;
注ï¼å¯ç¢¼åæ¼å¯ç¢¼æªã/opt/firebird/SYSDBA.password