Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

url´æÈëmysqlÊý¾Ý¿âǰµÄʱºòÒª½øÐÐʲô´¦Àí£¿

SQL code:
UPDATE `footballmatch`.`promote` SET `pr_ballhype` = http://ballhype.com/post/url/?url=http%3A//www.allfootballtv.com/%3Fp%3D369&league=8 WHERE `promote`.`fm_post_id` =369


ÒÔÉÏsqlÓï¾ä´æÈëmysqlÖеÄʱºòÌáʾ´íÎó£º
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '://ballhype.com/post/url/?url=http%3A//www.allfootballtv.com/%3Fp%3D369&league=8' at line 2


pr_ballhype ×Ö¶ÎÀàÐÍΪvarchar

ÇëÎʸÃÈçºÎÐÞ¸ÄÄØ£¿


varcharÐÍ¿´¿´×Ö·ûÊÇ·ñ×ã¹»Óá£
UPDATE `footballmatch`.`promote` SET `pr_ballhype` = 'http://ballhype.com/post/url/?url=http%3A//www.allfootballtv.com/%3Fp%3D369&league=8'  WHERE `promote`.`fm_post_id` =369 //·ÖºÅÉÙ²»ÁË£¡

htmlspecialchars(),

ÒýÓÃ
varcharÐÍ¿´¿´×Ö·ûÊÇ·ñ×ã¹»Óá£
UPDATE `footballmatch`.`promote` SET `pr_ballhype` ='http://ballhype.com/post/url/?url=http%3A//www.allfootballtv.com/%3Fp%3D369&league=8'  WHERE `promote`.`fm_post_id` =369 //·ÖºÅÉÙ²»ÁË£¡


ȷʵÊǼӸöÒýºÅ¾ÍÐÐÁË£¬Ð»Ð»ÁË


Ïà¹ØÎÊ´ð£º

oracle ¶ÔÓ¦µÄMySQLÓï¾ä

orcle Óï¾ä create table book1(name, price) as select book_name, price form book;
¶ÔÓ¦µÄMySQLµÄÓï¾äÊÇʲô

create table book1 as select book_name, price form book; ÕâÑùÔÚMySQLÀï¿ÉÒÔ£¬µ«ÊÇÈ´² ......

C#ÔõôÁ¬½ÓMySql£¿

C#ÔõôÁ¬½ÓMySql£¿
sqlÓï¾ä·ÅÄÄ?
½á¹û¼¯ÔõôÓã¿
Çó½â´ð
Â¥Ö÷£¬ÓÐʱºòѧ»á×Ô¼ºÕҴ𰸣¬×Ô¼ºÄܽâ¾öµÄ¾¡Á¿×Ô¼º½â¾ö¡£
ÎÒÒ²ÊǰٶȵĴð°¸Ï£Íû¶ÔÄãÓаïÖú
MySQLConnection DBConn;
    &nb ......

½ô¼±ÇóÖú£ºmysql´´½¨Ë÷Òý³öÎÊÌâÁË

´ó¼ÒºÃ£¬ÎÒÔÚ´´½¨Ë÷Òýʱ£¬³öÏÖ´íÎóÌáʾ£¬´úÂëÈçÏ£º

create uique index stu_cou_index on student_info.results (student_id, course_id);
show index from student_info.results;

±£´æÎªindex.s ......

ÈçºÎÔÚWindowsÉϰ²×°Á½¸öMysql·þÎñ



Çå²Î¿¼

×î½üÖ»ÊÇºÃÆæ£¬ÏëÖªµÀÔÚwinÏÂÄܲ»ÄÜͬʱÔËÐÐÁ½¸ömysql £¬ÎÒÖ»ÊǾõµÃÉèÖõÄʱºòmysqlµÄ·þÎñ¶Ë¿Ú²»ÄÜÒ»Ñù£¬ÉèÖò»Í¬µÄ¶Ë¿ÚºóÓ¦¸Ã¿ÉÒÔ£¬¿ÉÊǾßÌå·½·¨»¹ÊDz»ÖªµÀ£¬ºóÀ´¾­¹ý²éѯ×ÊÁÏ×Ü

×î½ü ......

Á¬½ÓMySQLʱUnknown columnÎÊÌ⣬Çó¸ßÊÖ½â´ð

import java.sql.*;

public class A
{
public static void main(String[] args)
{
try
{
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ