MySQLѧϰ(2)ʱ¼äÀàÐÍ
DAT_E,TIM_E,DAT_ETIME,TIM_ESTAMP,Y_EAR
MySQLÖ§³Ö¶àÖÖ¸ñʽ»¯·½Ê½£¬²åÈëʱ¿ÉÒÔÊÇ×Ö·û´®£¬¿ÉÒÔʹÊý×Ö¡£
MySQL´ú±í×Ö·û´®µÄ·½Ê½ÓÐÁ½ÖÖ£¬Ò»Êǵ¥ÒýºÅ£¬ÁíÒ»ÖÖÊÇË«ÒýºÅ¡£
ÓÖÒ»´ÎÌύʧ°Ü£¬¿´À´CSDNµÄBUG»¹ÊǺܴóµÄ¡£
ÔÒò»ù±¾È·¶¨£¬ÊÇÒòΪDATE£¬TIME£¬DATETIME£¬TIMESTAMP£¬YEARΪMySQLÊý¾ÝµÄ¹Ø¼ü×Ö£¬Ò²ÊÇÆäËûÊý¾Ý¿âµÄ¹Ø¼ü×Ö£¬²åÈëʱ¾Í»á±¨´í£¬Õâʱºò¿É¼û׼ȷµÄ´íÎóÌáʾµÄÖØÒªÐÔ¡£
Ïà¹ØÎĵµ£º
1¡¢Ð½¨Êý¾ÝÔ´Îļþmysql-ds.xml,ÎļþÄÚÈÝÈçÏ£º
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/mydatabase?useUnico ......
http://www.mysql.cn/
ÊÂÎñ£¬²ÎÊý£¬Ç¶Ì×µ÷Óã¬Óα꣬ѻ·, ´¥·¢Æ÷£¬ÊÓͼ£¬Ô¼Êø, Ë÷Òý£¬¡£¡£¡£
1. ´´½¨ÊµÀýÊý¾Ý¿â
create database db5;
use db5;
2.´´½¨Ò»¸ö¼òµ¥µÄ¹¤×÷±í,²¢²åÈëÊý¾Ý
create table t(s1 int);
insert into t values(5);
3.´´½¨³ÌÐòʵÀý crea ......
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 ......
×î½üÓõ½ÁËÒ»¿îÊý¾Ý¿âͼÐλ¯¹ÜÀí¹¤¾ßNavicat for MySQL £¬Ê¹ÓÃÖ®ºóÓÐÒ»Öָоõ£ºÔÀ´±à³Ì¿ÉÒԺܸßЧ£¡
ÒÔǰʹÓÃMySQLʱ£¬Ã¿´Î¶¼Ö»ÄÜÔÚÀàËÆDOSµÄ½çÃæ¿ª·¢£¬Ê¹Óùٷ½ÌṩµÄ¹¤¾ßºÜÈÝÒ׾ͱ»¿¨µ½ÁË£¬¾õµÃ»¹ÊÇ×ÖÌõ½çÃæ±È½Ï¸ßЧ£¬µ«ÊdzõѧMySQL,ºÜ¶à¹¦Äܶ¼»¹Ã»ÓÐÍêÈ«Çå³þ£¬Ê¹Óð²È«ÐÔÉϵĿ¼ÂÇÒ²²»¹»³ÉÊì¡£ÕâʱºòÎÒ¿ ......
MySQL5.X¶¼ÒѾ·¢²¼ºÃ¾ÃÁË£¬µ«ÊÇ»¹ÓкܶàÈËÈÏΪMySQLÊDz»Ö§³ÖÊÂÎñ´¦ÀíµÄ£¬Õâ²»µÃ²»¹ÖËûÃÇÊǹª¹ÑÎŵ쬯äʵ£¬Ö»ÒªÄãµÄMySQL°æ±¾
Ö§³ÖBDB»òInnoDB±íÀàÐÍ£¬ÄÇôÄãµÄMySQL¾Í¾ßÓÐÊÂÎñ´¦ÀíµÄÄÜÁ¦¡£ÕâÀïÃæ£¬ÓÖÒÔInnoDB±íÀàÐÍÓõÄ×î¶à£¬ËäÈ»ºóÀ´·¢ÉúÁËÖîÈçOracleÊÕ
¹ºInnoDBµÈÁîMySQL²»Ë¬µÄÊÂÇ飬µ«ÄÇЩÉÌÒµÉϵĶ·ÕùÓë¼¼ÊõÎ޹أ ......