mysqlÔöɾ¸Ä²é
²åÈëÒ»Ìõ¼Ç¼:
mysql> insert into table_name (column_name1,column_name2,.) values (value1,value2,..);
¸üÐÂÒ»Ìõ¼Ç¼£º
mysql> update tbl_name
set col_name1=expr1 [, col_name2=expr2 ...][WHERE where_definition]
[ORDER BY ...][LIMIT row_count];
ɾ³ýÒ»Ìõ¼Ç¼£º
mysql>delete from table_name where id=XX;
ɾ³ýÕû¸ö±íµÄÊý¾Ý£º
mysql> drop from table_name;
²éѯһÌõ¼Ç¼£º
mysql>select * from table_name where id=XX;
Ïà¹ØÎĵµ£º
¸ã¶¨MySQLÊý¾Ý¿âÖÐÎÄÄ£ºý¼ìË÷ÎÊÌâ
×÷Õß: bianceng, ¡¡³ö´¦:ITר¼ÒÍøÂÛ̳,¡¡ÔðÈαà¼: ³Â×Óç÷,¡¡
2009-10-28 07:00
¡¡¡¡ÔÚ MySQLÏ£¬ÔÚ½øÐÐÖÐÎÄÄ£ºý¼ìË÷ʱ£¬¾³£»á·µ»ØÒ»Ð©ÓëÖ®²»Ïà¹ØµÄ¼Ç¼£¬Èç²éÕÒ "%a%" ʱ£¬·µ»ØµÄ¿ÉÄÜÓÐÖÐÎÄ×Ö·û£¬È´Ã»ÓÐa×Ö·û´æÔÚ¡£
¡¡¡¡ÔÚ MySQLÏ£¬ÔÚ½øÐÐÖÐÎÄÄ£ºý¼ìË÷ʱ£¬¾³£»á·µ»ØÒ»Ð©Óë ......
֮ǰ£¬ÓÉÓÚ¿Í»§ÒªÇóÔÚcentOSϰ²×°ÏµÍ³Ó¦Óã¬Òò´ËÓлú»á½Ó´¥ÁËÒ»ÏÂCentOS£¬Ë³±ãÒ²Á˽âÁËÏÂCentOSµÄ³£¹æ²Ù×÷£¬»¹ÓÐÔÚCentOSϵÄMySQLÏà¹Ø²Ù×÷¡£
Ŀǰ¼¼Êõ¿ò¼ÜʹÓÃJSF£¨richfaces¡¢facelets£©+Spring+JPA£¨OpenJPA£©£¬²»Ê¹ÓÃÊý¾Ý¿âÒÀÀµµÄ´¥·¢Æ÷»ò´æ´¢¹ý³Ì£¬ËùÓÐÒµÎñÂß¼ÔÚweb·þÎñÆ÷ÉÏÖ´ÐУ¬Òò´ËÊý¾Ý¿â»ù±¾²»Óÿ¼ÂÇÒÆ ......
Ê×ÏȰ²×°±ØÐèµÄ¿ª·¢
°ü
sudo apt-get install gcc g++ libgcc1 libg++ make gdb
°²×°MYSQLµÄCÓïÑÔ¿ª·¢°ü
sudo apt-get install libmysql++-dev libmysql++2c2a libmysqlclient15-dev libmysqlclient15off
°ÑlibÎļþ¿½±´µ½¹«ÓÃ
sudo cp /usr/lib/mysql/* /usr/lib/
½¨Á¢Ò»¸öÐÂÎļþtest.cpp
vim test.cpp
ÊäÈëÄÚÈÝ
......
PS:ÎÒ½ñÌìÅäÖà ·þÎñÆ÷µÄʱºò³öÏÖµÄÎÊÌâ¾ÍÊÇÕâ¸ö£¬µ«ÊÇÕÕ×Å·½·¨¶¼×öÁË£¬Ñ¾µÄ¡£¡£»¹ÊÇûÓ㬼«¶ÈÓôÃÆËÀ¡£¡£°¥¡£¡£¡£ÎÒÒ²²»ÖªµÀʲôÔÒòÄØ¡£¡£¿ÉÄܵÄÔÒò¶¼ÕÒ¹ýÁË¡£¡£ÓôÃÆ°¡`~
apache2+mysql+php5+phpmyadminÅäÖÃÎÊÌ⣺ÎÞ·¨¼ÓÈëmysqlÀ©Õ¹£¬Çë¼ì²éphpÅäÖÃ...
°²×°Íêapache2+mysql+php5ºó£¬°²×°phpmyadmin²¢ÅäÖúÃÒÔºó£¬ÔÚä¯À ......
mysqldump -u[user] -p[password] [databasename] > [dump_name]
ÔÚ½« dump_name Õâ¸öµµ°¸¸´ÖƵ½Áíһ̨¼ÆËã»úÉÏ
Áíһ̨¼ÆËã»úÉÏÏȽøÈëmysql
½¨Á¢Ò»¸ö database ÔÙÖ´ÐÐÏÂÁÐÖ¸Áî
mysql -u[user] -p[password] [database_name] < [dump_name]
MYSQL¼¸ÖÖ±¸·Ý·½·¨¸ÅÊö
MysqlÊý¾Ý
¿â±¸·ÝÖ÷ÒªÓÐ4Ö ......