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

Mysql µ¼Èëµ¼³öµÄÎÊÌâ

¹ØÓÚMySqlµÄµ¼Èëµ¼³öÎÊÌâ
    ÔÚÖÕ¶ËÖУ¬½øÈëmysqlµÄ·¾¶ÏµÄbinÖУ¬ÔÚÕâ¸ö·¾¶Ï¿ÉÒÔÖ´ÐÐmysql£¬mysqldumpµÈÃüÁî¡£
    »òÕßÌí¼Ó»·¾³±äÁ¿ ÉèÖû·¾³±äÁ¿path "...(mysqlµÄ°²×°Â·¾¶ÏµÄbinĿ¼)"£¬ÕâÑù¾Í²»±Øÿ´Î¶¼½øÈëÉÏÃæËù˵µÄ·¾¶Ï²Ù×÷¡£
µ¼³öÒ»¸ö¿â£º
    mysqldump -u µÇ¼Ãû -p ¿âÃû > Òª½«´Ë¿âµ¼³öµ½µÄÎļþ
    eg: mysqldump -u root -p database1 > data1.sql
µ¼³öÒ»¸ö±í£º
    mysqldump -u µÇ¼Ãû -p ¿âÃû ±íÃû > Òª½«´Ë¿âµ¼³öµ½µÄÎļþ
    eg: mysqldump -u root -p database1 table1 > data2.sql
    ÁíÍ⣬mysqldumpÖеÄÒ»¸ö²ÎÊý -h ºóÃæ¸úÒ»¸öipµØÖ·£¬±íʾÊDzÙ×÷´Ëip»úÆ÷ÉϵÄmysqlÊý¾Ý¿â
    eg: mysqldump -h localhost -u root -p database1 table2 > data3.sql
µ¼Èëµ½Êý¾Ý¿âÖУº
    mysql -h ip -u µÇ¼Ãû -p ¿âÃû < Òª½«´Ë¿âµ¼³öµ½µÄÎļþ
    eg: mysql -h localhost -u root -database1 < data2.sql
    »òÕß
    ½øÈëmysqlÏÂ("mysql>")ʹÓÃsourceÃüÁîµ¼Èë
    eg: mysql> source D:\db\data3.sql


Ïà¹ØÎĵµ£º

SQL Server¡¢OracleºÍMySQLÖвé³öֵΪNULLµÄÌæ»»

SOURCE: CLICK HERE
±¾ÎĽ²ÊöSQL Server¡¢Oracle¡¢MySQL²é³öֵΪNULLµÄÌæ»»¡£
ÔÚSQL Server Oracle MySQLµ±Êý¾Ý¿âÖвé³öijֵΪNULLÔõô°ì?
1¡¢MSSQL: ISNULL()
Óï·¨
ISNULL ( check_expression , replacement_value )
²ÎÊý
check_expression
½«±»¼ì²éÊÇ·ñΪ NULLµÄ±í´ïʽ¡£check_expression ¿ÉÒÔÊÇÈκÎÀàÐ͵ġ£
re ......

Linux+Apache+Mysql+PhpÏêϸ°²×°Îĵµ

ËùÐèÈí¼þÔ´´úÂë°ü£º
httpd-2.2.4.tar.gz   mysql-5.0.27.tar.gz   php-5.2.1.tar.bz2
freetype-2.3.2.tar.gz   gd-2.0.34.tar.gz   jpegsrc.v6b.tar.gz
libpng-1.2.8.tar.bz2   libxml2-2.6.24.tar.bz2  zlib-1.2.2.tar.gz
°²×°Ë³Ðò£ºapache -> mysql ......

mysql ʱ¼ä¶Î²éѯ

24СʱÄڼǼ£¨¼´86400Ã룩
$sql="SELECT video_id,count(id)as n from `rec_down` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(add_time)<=86400 group by video_id order by n desc ";
$sql="select a.id,a.title,b.n from video_info a,(".$sql.")b where a.id=b.video_id order by n desc limit 20";
NÌìÄڼǼ ......

MySQL Á·Ï°ÊÖ¸å

MySQL Á·Ï°ÊÖ¸å
      MySQL ½éÉÜ
      MySQL ABÊÇÓÉMySQL´´Ê¼È˺ÍÖ÷Òª¿ª·¢ÈË´´°ìµÄ¹«Ë¾¡£MySQL AB×î³õÊÇÓÉDavid Axmark¡¢Allan
LarssonºÍMichael“Monty
”WideniusÔÚÈðµä´´°ìµÄ¡£
      ¹«Ë¾ÃûÖеēAB”ÊÇÈðµäÓ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ