mysqlÊý¾Ý¿âͼƬ²åÈëºÍ¶ÁÈ¡
VCÏÂÔÚmysqlÊý¾Ý¿âÖÐÔõô²åÈëͼƬ(bmp¡¢jepg¸ñʽ)£¬ÁíÍâÔõô¶Á³öͼƬ²¢ÏÔʾ£¿
Çë¸÷λָµãһϣ¬Ð»Ð»¡£
PS:СµÜÊÇÓÃodbc¶ÁÈ¡Êý¾Ý¿â²Ù×÷¡£
Èç¹ûÎļþÔÚmysqlÊý¾Ý¿â·þÎñÉÏ£¬¿ÉÒÔÓÃload_fileº¯Êý£º
insert table tb_name(picture) values(load_file('d:\\test.jpb'));
ÖÁÓÚ¶Áร¬Ö»ÄÜÓóÌÐò¶Á³öÁ÷¡£
ÓÃbufferÁ÷¶ÁÈ¡
Ò»°ã²»»á°ÑͼƬ·ÅÔÚÊý¾Ý¿âÖУ¬Êý¾Ý¿âÖÐÖ»´æÍ¼Æ¬Â·¾¶
Ïà¹ØÎÊ´ð£º
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()
SQL code:
sqlÀïÊÇ£º
getdate()
ÒýÓÃ
now()
ѧϰ
SQL code:
select now();
SQL code:
TODAY()
?
SQL code:
select now();
/* ......
MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¾ÍÕÒÒ»±¾ºÜ»ù´ ......
¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿
1 nike 100 ϵͳʱ¼ä
2 nike 300 &n ......