´ó¼ÒºÃ£¬ÎÒÓõÄÊÇMYSQLÊý¾Ý¿â¡£
ÎÒµÄÊý¾Ý¿âÃû£ºmoon;
ÓÐÒ»¸öÆæ¹ÖµÄÏÖÏó£º
1¡£ÎÒ½«ÎÒµÄMYSQLÊý¾Ý¿âÈí¼þɾ³ýÁË¡££¨¼´½«C:\Program Files\MySQLϵÄÎļþ¼ÐMySQL Server 5.1ɾ³ýÁË£©Ã»¹Ø»úµÄÇé¿öÏ»¹ÊÇÄÜÓá£ÎÒµÄÍøÕ¾»¹ÄÜ·ÃÎÊ¡£
2¡£µ±ÎÒÔڿظæÃæ°åÖн«MYSQLɾ³ýºó£¬Ã»¹Ø»úʱ²»ÄÜÓã¬ÎҹػúÔÙ¿ª»úÒ²²»ÄÜÓá£
3¡£µ±ÎÒÔÙÒ»´Î° ......
ÎÒµÄÊý¾Ý¿âÖÐÓÐÒ»ÁеÄÖµÊÇ¡°²âÊÔÊÙÃü¡±£¬µ«ÊÇÔÚËü´æ´¢µÄ·½Ê½ºÃÏñÊǵ¥×Ö½Ú¸ñʽ...ÔÚÍâ±ßµÄ²éѯÓï¾äÊÇlike '%²âÊÔÊÙÃü%' Á½¸öû°ì·¨¶Ô±È£¬ÄÇλ´óϺ¸ø³ö¸öת»»µÄ´úÂë...СµÜл¹ýÁË
µ¥×Ö½ÚÓÃlike ? ???
Ö±½ÓÓÃ=ºÅ²»ÐÐÂ𣿣¿£¿
²»ÊǵȺŲ»µÈºÅµÄÎÊÌâ....Êý¾Ý¿âÖÐÊÇÕâÖÖ×Ö·ûÊÙÃü²âÊ ......
Àý:
insert into tablename values('select * from tablename')£»
ÎÒÏëÈÃselect * from tablenameÔÑùµÄ·Åµ½tablenameÖУ¬ÇëÎʸ÷룬sqlÎÄÔõô¸Ä°¡
select * from tablename ×÷Ϊ×Ö·û´®£¬²»ÈÃÆäÖ´ÐÐ!!
лл£¡£¡
insert into tablename select * from tablename
SQL code:
insert into tablename select 'sele ......
¶Áȡϵͳʱ¼äÇ°3¸öСʱÌá½»µÄËùÓÐÊý¾Ý£¿ÕâÑù¸ÄÔõô×ö£¿
ÒýÓÃ
¶Áȡϵͳʱ¼äÇ°3¸öСʱÌá½»µÄËùÓÐÊý¾Ý£¿ÕâÑù¸ÄÔõô×ö£¿
±íÀï¼Ó×ֶΠ±£´æʱ¼ä ¼´¿É
Èç¹ûÄãÏëÒªµÄÊÇÈ«²¿µÄÊý¾ÝµÄ»° Äã²»Èç»»¸ö·½Ïò¿¼ÂÇ ±ÈÈçÿÈý¸öСʱ±¸¸ö·Ý¡£¡£
²»ÊÇÐèҪȫ²¿Êý¾Ý£¬¾ÍÊǼÓÈëÎÒµ±Ç°Ê±¼ä²éѯ°É£¬ÎÒÒªµÃµ½µ±Ç°Ê±¼äÇ°Èý¸öСʱ² ......
±ÈÈçÒ»ÕűíÖÐÓÐname,idÁ½ÁÐ,ÒªµÃµ½2ÕâÑùµÄ½á¹û
Ö»ÒªsqlÓï¾ä,²»ÒªÆäËüµÄ³ÌÐòÐÖú
È¥mysqlµÄ°æÈ¥ÎÊ°É
ÎÒûÕÒµ½mysqlµÄ°æ,,,
ÒýÓÃ
È¥mysqlµÄ°æÈ¥ÎÊ°É
ͬÒâ.
ллjosy,ÎÒ¸ÕÕÒµ½mysql°æÇø,²»¹ýÎҵķֲ»¹»ÁË,ÓôÃÆ
......
´ó¼ÒºÃ£¬ÎÒ°ÑͼƬ´æÔÚÁËMYSQLÊý¾Ý¿âÖУ¬ÏÖÔÚÎÒÏëÏÔʾÔÚWEBÒ³ÃæÉÏ¡£Åöµ½ÁËÁ½¸öÎÊÌâ¾ÍÊÇ 1£¬ÏÔʾͼƬµÄPHP´úÂë±ØÐ붥¸ñд£¬Ç°ÃæÈç¹ûÓдúÂëÊä³ö»òÓпոñÖ®Àà¾Í»áÊä³öÂÒÂë¡£´æÈëûÓÐÎÊÌ⣬ÎҾͲ»ÁгöÁË£¬ÏÔʾͼƬ´úÂëÏêϸÈçÏ£º
<?php
// Á¬½ÓÊý¾Ý¿â
$conn = mysql_connect("localhost", "root", &qu ......
×ܼǼÊý:1662; ×ÜÒ³Êý:277; ÿҳ6 Ìõ;
Ê×Ò³ ÉÏÒ»Ò³ 1
[2] [3] [4] [5] [6] [7] [8] [9] [10] ÏÂÒ»Ò³ βҳ