MySQLѧϰ(2)ʱ¼äÀàÐÍ
DAT_E,TIM_E,DAT_ETIME,TIM_ESTAMP,Y_EAR
MySQLÖ§³Ö¶àÖÖ¸ñʽ»¯·½Ê½£¬²åÈëʱ¿ÉÒÔÊÇ×Ö·û´®£¬¿ÉÒÔʹÊý×Ö¡£
MySQL´ú±í×Ö·û´®µÄ·½Ê½ÓÐÁ½ÖÖ£¬Ò»Êǵ¥ÒýºÅ£¬ÁíÒ»ÖÖÊÇË«ÒýºÅ¡£
ÓÖÒ»´ÎÌύʧ°Ü£¬¿´À´CSDNµÄBUG»¹ÊǺܴóµÄ¡£
ÔÒò»ù±¾È·¶¨£¬ÊÇÒòΪDATE£¬TIME£¬DATETIME£¬TIMESTAMP£¬YEARΪMySQLÊý¾ÝµÄ¹Ø¼ü×Ö£¬Ò²ÊÇÆäËûÊý¾Ý¿âµÄ¹Ø¼ü×Ö£¬²åÈëʱ¾Í»á±¨´í£¬Õâʱºò¿É¼û׼ȷµÄ´íÎóÌáʾµÄÖØÒªÐÔ¡£
Ïà¹ØÎĵµ£º
MySQL ODBC connection strings
Open connection to local MySQL database using MySQL ODBC 3.51 Driver
"Provider=MSDASQL; DRIVER={MySQL ODBC 3.51Driver}; SERVER= localhost; DATABASE=Your_MySQL_Database; UID= Your_Username; PASSWORD=Your_Password; OPTION=3"
MySQL OLE DB & OleDbConnection (.NET fr ......
1.MySQL´´½¨ÊÓͼµÄ¼òµ¥Óï¾äΪ£ºCREATE VIEW view_name AS SELECT * from TABLE_NAME;
²»ÄܶԴ¥·¢Æ÷´´½¨ÊÓͼ(VIEW)¡£µ«ÊÇÔÚ5.1.4ÖÐÊÇÕâÑùÃèÊöµÄ£¬A view can be created from many kinds of SELECT statements. It can refer to base tables or other views. It can use joins, UNION, and subqueries¡£´óÖÂÒâ˼ÊÇÊÓÍ ......
µ¼³öÊÇ,ûÓÐÖ¸¶¨±àÂë
·½·¨Ò» phpmyadmin´¦Àí·½Ê½
¼ì²éphp-mbstringÊÇ·ñÓпÉ×°,ûÓа²×°ÉÏ yum -y install php-mbstring
´ò¿ªphpmyadmin Öе¼³ö,ÔÙ´Óphpmyadmin µ¼ÈëÊÇѡȡ¶þÖÆ½ø(binary)
Èç¹û»¹²»ÐÐ,ÔÚmy.cnf mysqldÖмÓÈë default-character=ÄãµÄ±àÂë, ÖØÆômysql ÔÙÊÔ ......
create procedure getInfor2()
BEGIN
declare _abc varchar(200);
declare stopFlag int;
DECLARE cursor_name CURSOR
FOR
select zhuanyuan from server;
DECLARE CONTINUE HANDLER FOR NOT FOUND set stopFlag=1;
OPEN cursor_name;
REPEAT
FETCH cursor_name INTO _abc;
begin
if _abc='root'
the ......