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

mysql Ð޸IJéѯÊý¾ÝµÄÎÊÌâ

select time from table

time
2009-09-12 12
2009-09-12 13
2009-09-12 14
2009-09-12 15

Ôõô½« ²éѯµÄÊý¾Ý±äΪ
time
2009-09-12 12ʱ
2009-09-12 13ʱ
2009-09-12 14ʱ
2009-09-12 15ʱ

Ôõôֱ½ÓÁ¬½Ó£¿select time+¡®Ê±¡¯ from table ÕâÑù²»ÐÐ

½â¾öÁË¡£¡£¡£select DATE_FORMAT(time,'%Y-%m-%d %Hʱ') from table


Ïà¹ØÎÊ´ð£º

¹ØÓÚphp»ñÈ¡mysqlµÄÖ¸¶¨¼Ç¼

ÈçÉÏ
phpÈç¹û»ñÈ¡mysql±í¼Ç¼µÄÖ¸¶¨ÐÅϢѽ£¿
±ÈÈçÏëÒª»ñÈ¡±ítableµÄpw_num×ֶεļǼ·Ö±ðΪ0£¬11£¬8£¬3£¬9
Ôõô²ÅÄÜ»ñµÃ×Ö¶Îpw_numÀïÃæ´óÓÚ5µÄֵѽ£¿£¨11£¬8£¬9£©

Çë¸ßÊÖ°ïæ½â¾öÒ»ÏÂ
лл

Òý ......

PHP °ÑwordÎĵµÄÚÈݵ¼ÈëmysqlÊý¾Ý¿â

ÎҼǵÃÔÚmysqlÖÐÓиöload data infile Óï¾ä¿ÉÒÔ°ÑwordÎĵµµÄÄÚÈÝ°´Ò»¶¨¸ñʽµ¼ÈëÊý¾Ý¿â£¬ÕâÑùµ¼ÈëµÄÊý¾ÝÀàÐͺÃÏñÖ»ÄÜÊÇÎı¾¸ñʽµÄÊý¾Ý£¬ÇëÎÊÓÐû¸üºÃµÄ·½·¨¿ÉÒÔµ¼ÈëÊý¾Ý¿â¡£

1¡£Èç¹ûÎÒÃÇÒª°ÑÊÔÌâµ¼ÈëÌâ¿â£¬ÄÇà ......

ÇëÎÊphpÅäºÏmysqlÔõôµÃ³öÈ«²¿Èí¼þÈÝÁ¿µÄºÍ£¿


mysql±È½Ï²Ë£¬
×Ö¶ÎÀïÃæÓиö MB ,²»ÊÇÊýÖµÐÍ£¬ÆäËüÓÐЩ¡°Î´Öª¡±£¬Ôõô²ÅÄܵóö×îÖÕÏà¼ÓµÄ½á¹û£¿
SQL code:

mysql> select * from t;
+----------+
| size |
+----------+
| 0.47 MB |
| NU ......

javaµ÷ÓÃmysqlÃüÁîµ¼ÈëÊý¾Ý

Java code:

public static void load(String filename) {
try {
@SuppressWarnings("unused")
Process process = Runtime.getRuntime().exec(
......

ÕÒmysql·þÎñͻȻµ±µôÔ­Òò

linuxÉϵÄmysql·þÎñÔÚ½Ú¼ÙÈÕͻȻµ±µô
ÏÖÔÚÕÒÔ­Òò£¬»³ÒÉÊÇ´ÅÅ̿ռ䲻¹»£¬ÏÖÔÚÐèÒªÕÒµ½È·ÔäµÄÖ¤¾Ý¡£
£±¡¡¾ßÌåÔÚÄĸöÎļþÏ¿ÉÒÔÕÒµ½£¬Ëûµ±µôµÄ¾ßÌåʱ¼äºÍÔ­Òò£¿
£²¡¡windowsÏÂcÅÌ¿ÉÒÔ±¨´ÅÅ̿ռ䲻¹»µÄÔ­Òò£¬²» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ