MySQL²éѯЧÂÊÓÅ»¯ Ìí¼ÓË÷ÒýÃüÁî
1.PRIMARY KEY£¨Ö÷¼üË÷Òý£©
mysql>ALTER TABLE `table_name` ADD PRIMARY KEY ( `column` )
2.UNIQUE(ΨһË÷Òý)
mysql>ALTER TABLE `table_name` ADD UNIQUE (
`column`
)
3.INDEX(ÆÕͨË÷Òý)
mysql>ALTER TABLE `table_name` ADD INDEX index_name ( `column` )
4.FULLTEXT(È«ÎÄË÷Òý)
mysql>ALTER TABLE `table_name` ADD FULLTEXT (
`column`
)
5.¶àÁÐË÷Òý
mysql>ALTER TABLE `table_name` ADD INDEX index_name ( `column1`, `column2`, `column3` )
Ïà¹ØÎĵµ£º
1. ¸½¼ÓÏîÒ»¶¨ ¼ÓÉÏlibmysql.lib¡£
2. include Ò»¶¨¼ÓÉÏ mysqlµÄinclude£¨ÒòΪҪÅÜÕâ¹Ø¼üÒ»¾ä
#include <mysql.h>£©
3 lib Ò»¶¨¼ÓÉÏ mysqlµÄlib
ºÃÁËÏÂÃæÊÇʵÀýºÍphpº¯Êý»ù±¾Ò»ÑùµÄ¡£±¾È˲»¿ÉÄܸøÄã·ÒëÎĵµ£¬º¯Êý²»¶®×Ô¼º¿´¡£
#include
<windows.h>//ÓÃÕâ¸ö·½±ã£¬°üº¬winsock.hËùÒ ......
ÒýÓà ҹÂä¹ÅÁú µÄ MySql Administrator µÄ¼òµ¥Ê¹Óã¨Í¼£©
MySQL AdministratorÌṩͼÐνçÃæÒÔ°ïÖúÄã¹ÜÀíMySQLÊý¾Ý¿â£¬WindowsÓû§¿ÉÒÔͨ¹ýÃüÁîÌáʾÐÐÔËÐÐMySQL
Administrator£¬ÔÚÓàÏÂʱ¼äÀïÎÒ¼Ù¶¨ÄãÒѾ°²×°ÁËMySQL Administrator£¬²¢ÇÒ½«Ê¹ÓÃÏà¹ØͼÀý¡£
MySQL
AdministratorÖ÷½çÃæ
¡¡¡¡´´½¨Êý¾Ý¿â
......
´ó²¿·Ö·þÎñÆ÷¹ÜÀíÔ±ÖªµÀMySQLÊý¾Ý¿â¹ÜÀíϵͳ£¨RDBMS£©ÊǸ߶ÈÁé»îµÄÈí¼þ¿é£¬´øÓз¶Î§¹ãÀ«µÄÆô¶¯Ñ¡Ï¿ÉÒÔÓÃÀ´ÐÞ¸ÄÏà¹ØÐÐΪ¡£È»¶ø£¬´ó²¿·ÖÈËÈ´²»
Çå³þ£¬±ê×¼MySQL¿Í»§¶Ë´øÓÐͬµÈ´óÁ¿µÄÆô¶¯Ñ¡ÏÆäÖÐһЩÔÚÈÕ³£MySQL½»»¥×÷ÓÃÖм«ÎªÓÐÓá£ÕâЩѡÏî±¾Éí²»ÊÇ
“ÃØÃÜ”£¬¶øËüÃÇÖкܶàδ±»Ê¹Óã¬ÉõÖÁÆäÖÐһЩ¿ÉÒÔÏÔÖø ......
1.install mysql
get mysql
http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.1/mysql-5.1.41-linux-i686-icc-glibc23.tar.gz
[root@localhost mysql]# tar -zxvf mysql-5.1.41-linux-i686-icc-glibc23.tar.gz
[root@localhost mysql]# cd mysql-5.1.41-linux-i686-icc-glibc23
[root@localhost mysql]# vim RE ......
mysqlµ¼³ösql½Å±¾ ÊÕ²Ø
×¢ÒâÊÂÏî:
*±ØÐëÔÚD:\LTSOFT\MYSQL4\bin> mysqldump -u root -p test > c:\a.sql
ÏȵýøÈëmysql°²×°Ä¿Â¼µÄbinÏ£¨¿ÉÒÔ¿´µ½ÀïÃæÓÐmysqldump.exe£©£¬Í¨³£mysqlĬÈÏ°²×°ÔÚC:\Program Files\MySQL\MySQL Server 5.0
* ²»ÄܽøÈëmysql ÃüÁîÀï.
MySQLµ¼³ ......