SQLiteѧϰ±Ê¼Ç
SQLiteѧϰ±Ê¼Ç
1.²é¿´ÓÐÄÄЩÊý¾Ý¿â,ÏÔʾÊý¾Ý¿âÁбí
show databases;
2.ÏÔʾ±íµÄ½á¹¹
·½·¨Ò»£º
use student;
describe student;
·½·¨¶þ£º
des student.student;
·½·¨Èý£º
show columns from student;
3.ÏÔʾMYSQLµÄ°æ±¾
select version();
4.ÏÔʾ¿âÖеÄÊý¾Ý±í
use mysql;
show tables;
5.½¨¿â
create database ¿âÃû;
6.ɾ³ý¿â
drop database ¿âÃû;
7.½¨Êý¾Ý±í
use ¿âÃû
create table ±íÃû(×Ö¶ÎÁбí);
8.Çå¿Õ±íÖмǼ
delete from ±íÃû
9.ɾ³ýÊý¾Ý±í
drop table ±íÃû;
10.ÈçºÎµÇ½µ½mysql
ÔËÐÐcmd
½øÈëC:\Program Files\MySQL\MySQL Server 5.1\bin
Ö´ÐÐmysql -u root –p
»òÕßmysql -uroot –pliuchang
»òÕßmysql -uroot –p
»òÕßmysql –h localhost –uroot -p
ÊäÈëÃÜÂë¼´¿É
11.Í˳ömysql
Quit»òÕßexit
12.ÈçºÎÐÞ¸ÄÓû§µÄÃÜÂë
ÔÚDOSϽøÈëÈçÏÂĿ¼
C:\Program Files\MySQL\MySQL Server 5.1\bin
ÔËÐÐÈçÏÂÃüÁ
mysqladmin -uroot -pliuchang password lc
1¡¢¸øroot¼Ó¸öÃÜÂëlc¡£Ê×ÏÈÔÚDOSϽøÈëmysqlµÄbinĿ¼Ï£¬È»ºó¼üÈëÒÔÏÂÃüÁî
mysqladmin -uroot -password ab12
×¢£ºÒòΪ¿ªÊ¼Ê±rootûÓÐÃÜÂ룬ËùÒÔ-p¾ÉÃÜÂëÒ»Ïî¾Í¿ÉÒÔÊ¡ÂÔÁË¡£
13.½«Îı¾Êý¾Ýµ¼Èëµ½Êý¾Ý¿âÖÐ
load data local infile ‘ÎļþÃû’into table ±íÃû;
14.Êý¾ÝµÄµ¼³ö
select * from Êý¾Ý¿â.Êý¾Ý±íÃû into outfile ‘ÎļþÃû’;
15.Êý¾Ý¿âµÄ±¸·Ý
1.µ¼³öÕû¸öÊý¾Ý¿â
2.µ¼³öÒ»¸ö±í
Ó÷¨£ºmysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> µ¼³öµÄÎļþÃû
mysqldump -uroot -p student student>d:/learn/db_student.student.backup
3.µ¼³öÒ»¸öÊý¾Ý½á¹¹
Ó÷¨£ºmysqldump -uroot -p -d --add-drop-table Êý¾Ý¿âÃû>µ¼³öÎļþÃû
mysqldump -uroot -p -d --add-drop-table test>d:/learn/db_test.structure.backup
**×¢Ò⣺
-d±íʾûÓÐÊý¾Ý
--add-drop-table±íʾÔÚÿһ¸öcreateÓï¾ä֮ǰÌí¼ÓÒ»¸ödrop tableÓï¾ä
´ò¿ªc:/learn/db_test.structure.backupÎļþ£¬ºÍÏÈǰµÄÁ½¸öÎļþ±È½Ï£¬Äã»á·¢ÏÖ¸ÃÎļþÀïûÓÐÎÒÃDzåÈëµÄÊý¾Ý.
16.Êý¾Ý¿âµÄµ¼Èë
17.ÖØÃüÃûÊý¾Ý±í
mysql > alter table ÀϱíÃû³Æ rename бíÃû³Æ;
18.ɾ³ýÊý¾Ý¿âǰÓÐÌáʾ
Ïà¹ØÎĵµ£º
ÕâÆªÎÄÕÂÊÇʹÓÃSQLite C/C++½Ó¿ÚµÄÒ»¸ö¸ÅÒª½éÉܺÍÈëÃÅÖ¸ÄÏ¡£
ÓÉÓÚÔçÆÚµÄSQLiteÖ»Ö§³Ö5¸öC/C++½Ó¿Ú£¬Òò¶ø·Ç³£ÈÝÒ×ѧϰºÍʹÓ㬵«ÊÇËæ×ÅSQLite¹¦ÄܵÄÔöÇ¿£¬ÐµÄC/C++½Ó¿Ú²»¶ÏµÄÔö¼Ó½øÀ´£¬µ½ÏÖÔÚÓг¬¹ý150¸ö²»Í¬µÄAPI½Ó¿Ú¡£ÕâÍùÍùʹ³õѧÕßÍû¶øÈ´²½¡£ÐÒÔ˵ÄÊÇ£¬´ó¶àÊýSQLiteÖеÄC/C++½Ó¿ÚÊÇרÓõģ¬Òò¶øºÜÉÙ±»Ê¹Óõ½¡£¾¡¹ÜÓÐÕâ ......
ÕâЩÌìÒ»Ö±ÔÚæÏúÊÛ¹ÜÀíÈí¼þÒ×Âôͨ¿Í»§¶ËµÄ³ÌÐò±àд£¬ÓÉÓÚÐèÒª²ÉÓñ¾µØÊý¾Ý»º´æ»úÖÆÀ´Ìá¸ß³ÌÐòµÄÊý¾Ý·ÃÎÊЧÂÊ£¬ËùÒÔÐèÒªÔÚ¿Í»§¶ËʹÓÃÒ»¸öСÇɵı¾µØÊý¾Ý¿â¡£Õâ¸öÊý¾Ý¿âµ±È»ÒªÐ¡¶ø¾«º·µÄ¡£ÎÒÒ²²»Ïë×öÇ¿µÁ£¬ÓÚÊǾÍÑ¡ÔñSqlite°É——ÎļþÊý¾Ý¿â£¬Ö»ÒªÒ»¸öSqlite.dll¾Í¿ÉÒÔ²Ù×÷Êý¾Ý¿â¡£
²»µÃ²»³ÃÈ˱¾ÈËÊÇÓеã͵ÀÁ£¬Ad ......
1¡£´Ówww.sqlite.orgÏÂÔØSQLite 3.3.4µÄ°æ±¾
ΪÁË·½±ã£¬ÎÒ°ÑËü½âѹÁË£¬¾ÍÒ»¸öSQLite3.exe£¬·ÅÈëWindowsĿ¼Ï¡£
Cmd ½øÈëÃüÁîÐÐ
1)
´´½¨Êý¾Ý¿âÎļþ:
>SQLite3 d:\test.db »Ø³µ
¾ÍÉú³ÉÁËÒ»¸ötest.dbÔÚdÅÌ¡£
ÕâÑùͬʱҲSQLite3¹ÒÉÏÁËÕâ¸ötest.db
2)
ÓÃ.help¿ÉÒÔ¿´¿´ÓÐʲôÃüÁî
>.help »Ø³µ¼´¿É
3)¿ÉÒ ......
ʹÓð汾£ºsqlite-3.6.14.2
ÏÂÔØµØÖ·£ºhttp://www.sqlite.org/sqlite-3.6.14.2.tar.gz
Ê×ÏȲο¼readmeµÄÌáʾ£º
“
tar xzf sqlite.tar.gz ;# Unpack the source tree into "sqlite"
mkdir bld &nbs ......