ÕýÈ·Àí½âMysqlµÄÁÐË÷ÒýºÍ¶àÁÐË÷Òý
MysqlÊý¾Ý¿âÌṩÁ½ÖÖÀàÐ͵ÄË÷Òý£¬Èç¹ûûÕýÈ·ÉèÖã¬Ë÷ÒýµÄÀûÓÃЧÂÊ»á´ó´òÕÛ¿ÛÈ´ÍêÈ«²»ÖªÎÊÌâ³öÔÚÕâ¡£
CREATE TABLE test (
id INT NOT NULL,
last_name CHAR(30) NOT NULL,
first_name CHAR(30) NOT NULL,
PRIMARY KEY (id),
INDEX name (last_name,first_name)
);
ÒÔÉÏ´´½¨µÄÆäʵÊÇÒ»¸ö¶àÁÐË÷Òý£¬´´½¨ÁÐË÷ÒýµÄ´úÂëÈçÏ£º
CREATE TABLE test (
id INT NOT NULL,
last_name CHAR(30) NOT NULL,
first_name CHAR(30) NOT NULL,
PRIMARY KEY (id),
INDEX name (last_name),
INDEX_2 name (first_name)
);
Ò»¸ö¶àÁÐË÷Òý¿ÉÒÔÈÏΪÊÇ°üº¬Í¨¹ýºÏ²¢(concatenate)Ë÷ÒýÁÐÖµ´´½¨µÄÖµµÄÒ»¸öÅÅÐòÊý×é¡£ µ±²éѯÓï¾äµÄÌõ¼þÖаüº¬last_name ºÍ first_nameʱ£¬ÀýÈ磺
SELECT * from test WHERE last_name='Kun' AND first_name='Li';
sql»áÏȹýÂ˳ölast_name·ûºÏÌõ¼þµÄ¼Ç¼£¬ÔÚÆä»ù´¡ÉÏÔÚ¹ýÂËfirst_name·ûºÏÌõ¼þµÄ¼Ç¼¡£ÄÇÈç¹ûÎÒÃÇ·Ö±ðÔÚlast_nameºÍfirst_nameÉÏ´´½¨Á½¸öÁÐË÷Òý£¬mysqlµÄ´¦Àí·½Ê½¾Í²»Ò»ÑùÁË£¬Ëü»áÑ¡ÔñÒ»¸ö×îÑϸñµÄË÷ÒýÀ´½øÐмìË÷£¬¿ÉÒÔÀí½âΪ¼ìË÷ÄÜÁ¦×îÇ¿µÄÄǸöË÷ÒýÀ´¼ìË÷£¬ÁíÍâÒ»¸öÀûÓò»ÉÏÁË£¬ÕâÑùЧ¹û¾Í²»Èç¶àÁÐË÷ÒýÁË¡£
µ«ÊǶàÁÐË÷ÒýµÄÀûÓÃÒ²ÊÇÐèÒªÌõ¼þµÄ£¬ÒÔÏÂÐÎʽµÄ²éѯÓï¾äÄܹ»ÀûÓÃÉ϶àÁÐË÷Òý£º
SELECT * from test WHERE last_name='Widenius';
SELECT * from test WHERE last_name='Widenius' AND first_name='Michael';
SELECT * from test WHERE last_name='Widenius' AND (first_name='Michael' OR first_name='Monty');
SELECT * from test WHERE last_name='Widenius' AND first_name >='M' AND first_name < 'N';
ÒÔÏÂÐÎʽµÄ²éѯÓï¾äÀûÓò»É϶àÁÐË÷Òý£º
SELECT * from test WHERE first_name='Michael';
SELECT * from test WHERE last_name='Widenius' OR first_name='Michael';
¶àÁн¨Ë÷Òý±È¶Ôÿ¸öÁзֱð½¨Ë÷Òý¸üÓÐÓÅÊÆ£¬ÒòΪË÷Òý½¨Á¢µÃÔ½¶à¾ÍÔ½Õ¼´ÅÅ̿ռ䣬ÔÚ¸üÐÂÊý¾ÝµÄʱºòËٶȻá¸üÂý¡£
ÁíÍ⽨Á¢¶àÁÐË÷Òýʱ£¬Ë³ÐòÒ²ÊÇÐèҪעÒâµÄ£¬Ó¦¸Ã½«ÑϸñµÄË÷Òý·ÅÔÚÇ°Ã棬ÕâÑùɸѡµÄÁ¦¶È»á¸ü´ó£¬Ð§Âʸü¸ß¡£
Ïà¹ØÎĵµ£º
MySQL ÃüÁîÐÐ
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö² ......
»·¾³£ºÁ½Ì¨·þÎñÆ÷IP:192.168.30.57\192.168.30.58
1¡¢ÏÂÔØmysql-5.0.86-linux-i686-glibc23.tar.gz µ½http://dev.mysql.com/downloads/mysql/5.0.html#linuxÏÂÔØ
2¡¢½âѹ tar -zxvf
mysql-5.0.86-linux-i686-glibc23.tar.gz
3¡¢´´½¨Á´½Ó ln -s
mysql-5.0.86-linux-i686-g ......
Ò»:mysqlÀïÄ¿Ç°Ö»Ö§³Ö4ÖÖË÷Òý·Ö±ðÊÇ:b-tree,full-text,hashÒÔ¼°r-treeË÷Òý b-treeË÷ÒýÓ¦¸ÃÊÇmysqlÀï×î¹ã·ºµÄË÷ÒýµÄÁË,³ýÁËarchive,»ù±¾ËùÓеĴ洢ÒýÇ涼֧³ÖËü. 1.b-treeÔÚmyisamÀïµÄÐÎʽºÍinnodbÉÔÓв»Í¬ ÔÚinnodbÀïÃæÓÐÁ½ÖÖÐÎ̬:ÆäÒ»ÊÇprimary keyÐÎ̬Æäleaf nodeÀï´æ·ÅµÄÊÇÊý¾Ý.¶øÇÒ²»½ö´æ·ÅÁËË÷Òý¼üµÄÊý¾Ý,»¹´æ·ÅÁËÆ ......
#include <stdio.h>
#include <windows.h>
#include <mysql.h>
#define host "localhost"
#define username "root"
#define password "123"
#define database "oa"
MYSQL *conn;
int main()
{
MYSQL_RES *res_set;
MYSQL_ROW row;
unsigned int i,ret;
FILE *fp;
MYSQL_FIELD *field;
......
²ÉÓõÄÊÇMySql¹Ù·½ÌṩµÄ.NET connector£¬´ËÇý¶¯Ö»ÐèÒªÏÂÔؼ´¿ÉʹÓãºhttp://dev.mysql.com/downloads/connector/net/1.0.html
ÔÚʹÓÃÖлýÀÛÁ˼¸µã¾Ñ飺
1)ʹÓÃParameter²ÎÊýÐÎʽÌá½»Commandʱ±ØÐëÒª°Ñ"@"ºÅ»»³É"?"ºÅ£¬ÕâÒ»µãÈÃÎÒÀ§»óÁËÒ»Ì죬ֻÊDz»Ã÷°×MySQLΪºÎÒª¸ãÌØÊâÄØ£¬ÏóMS¡¢ODP.NE ......