¹ØÓÚMysql´æ´¢¹ý³ÌÖеIJåÈëÓï¾ä
ÎÒʹÓÃµÄ MySQL Connector/NET 6.1.3 Ö´ÐÐÒ»¸ö´æ´¢¹ý³Ì£¬Õâ¸ö´æ´¢¹ý³ÌºÜ¼òµ¥£¬¾ÍÁ½¸öInsertÓï¾ä£¬·Ö±ð°ÑÍⲿ´«ÈëµÄ²ÎÊý²åÈëµ½Á½¸ö±íÖС£
½á¹ûÊý¾ÝÊÇ²å½øÈ¥ÁË£¬µ«ÊDzåÈëµÄÊý¾Ý£¬È´Ã»ÓжÔÓ¦Ö¸¶¨µÄÁУ¬Âé·³´ó¼Ò¸ø¿´¿´
CREATE DEFINER=`abc`@`%` PROCEDURE `InsertAllInfos`
(`@A` varchar(200),
`@B` varchar(50),
`@C` varchar(100),
`@D` varchar(100))
BEGIN
SET NAMES 'utf8 ';
INSERT INTO Table1
(
A,B
)
VALUES
(
@A,@B
)
INSERT INTO Table2
(
C,D
)
VALUES
(
@C,@D
);
END;
ûÓвåÈëµ½Ö¸¶¨µÄÁУ¿
INSERT INTO Table1
( A,B ) VALUES ( @A,@B ) ;
INSERT INTO Table2
( C,D ) VALUES (@C,@D );
±íµÄ×Ö·û¼¯ÊÇ·ñÊÇutf8?
Êǵ쬼òµ¥Ëµ£º¾ÍÊÇÎÒͨ¹ý´æ´¢¹ý³Ì·Ö±ðÏò Table1ºÍTable2 ¸÷²åÈë10¸öÖµ£¬µ«ÊÇÕâЩֵûÓвåÈëµ½Ö¸¶¨µÄÁС£
µ«ÊÇÕâЩֵûÓвåÈëµ½Ö¸¶¨µÄÁС££º
±íÖÐÊÇ·ñÓÐÏàÓ¦µÄ×ֶΣ¿¼ì²éһϱí½á¹¹£¬²åÈ뵽ʲô×ֶΣ¿
Á¬½ÓµÄÊý¾Ý¿âÊÇ·ñÊǹ¤×÷¿â£¿
ËùνµÄ¹¤×÷¿âÊÇÖ¸£ºÍ¬Ê±ÓÐÆäËû²Ù×÷µÄ»ò±»Ê¹ÓõĿ⣬ÊÇÕâ¸öÒâ˼Âð£¿Èç¹ûÊÇÕâ¸öÒâ˼£¬Õâ¸ö¿â²»Êǹ¤×÷¿â
DESC ÄãµÄ±í£¬Ìù½á¹û
(`v_A` var
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡
Íò·Ö¸Ðл£¡
String SQL=&q ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......