Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

¹ØÓÚphpÁ¬½ÓÊý¾Ý¿âmysqlÎÊÌâ

ÎÒÏÖÔÚphp´úÂëÔÚwebÀï¶¼ÄÜÔËÐÐÆðÀ´ php apache¶¼ÅäÖúÃÁË
Á¬½ÓÊý¾Ý¿âÓýű¾Ò²ÄÜÔËÐÐ
ÔõôÓÃweb¾ÍÔËÐв»Á˰¡
ÓÃwebÔËÐв»ÁËʲôÒâ˼?web²»¾ÍÊÇphp½Å±¾Âð?

Òâ˼ÊÇrun as php script¿ÉÒÔ
µ«ÊÇÓà php web ......

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

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

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

Çë½ÌÒ»¸öjsp¼òµ¥µÄmysqlÎÊÌâ

ÊÇÒ»Ìõ¸üвÙ×÷£º
Java code:

¡­¡­
private Integer bonus = 0;
public Integer getBonus() {
return bonus;
}
public void setBonus(Integer bonus) {
this.bonus = bonus;
}
String SQL = ......

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

Java code:

public static void load(String filename) {
try {
@SuppressWarnings("unused")
Process process = Runtime.getRuntime().exec(
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ