mysql ±¨´í´úÂë˵Ã÷
mysql³ö´íÁË,ÒÔÇ°ÍùÍù¿¿²Â.ÓÐÁËÕâÕűí,Ò»²é¾Í³öÀ´ÁË.·½±ã²»ÉÙ.Ìع²ÏíÓÚÖÚ
1005£º´´½¨±íʧ°Ü
1006£º´´½¨Êý¾Ý¿âʧ°Ü
1007£ºÊý¾Ý¿âÒÑ´æÔÚ£¬´´½¨Êý¾Ý¿âʧ°Ü
1008£ºÊý¾Ý¿â²»´æÔÚ£¬É¾³ýÊý¾Ý¿âʧ°Ü
1009£º²»ÄÜɾ³ýÊý¾Ý¿âÎļþµ¼ÖÂɾ³ýÊý¾Ý¿âʧ°Ü
1010£º²»ÄÜɾ³ýÊý¾ÝĿ¼µ¼ÖÂɾ³ýÊý¾Ý¿âʧ°Ü
1011£ºÉ¾³ýÊý¾Ý¿âÎļþʧ°Ü
1012£º²»ÄܶÁȡϵͳ±íÖеļǼ
1020£º¼Ç¼Òѱ»ÆäËûÓû§ÐÞ¸Ä
1021£ºÓ²ÅÌÊ£Óà¿Õ¼ä²»×㣬Çë¼Ó´óÓ²ÅÌ¿ÉÓÿռä
1022£º¹Ø¼ü×ÖÖظ´£¬¸ü¸Ä¼Ç¼ʧ°Ü
1023£º¹Ø±Õʱ·¢Éú´íÎó
1024£º¶ÁÎļþ´íÎó
1025£º¸ü¸ÄÃû×Öʱ·¢Éú´íÎó
1026£ºÐ´Îļþ´íÎó
1032£º¼Ç¼²»´æÔÚ
1036£ºÊý¾Ý±íÊÇÖ»¶ÁµÄ£¬²»ÄܶÔËü½øÐÐÐÞ¸Ä
1037£ºÏµÍ³ÄÚ´æ²»×㣬ÇëÖØÆôÊý¾Ý¿â»òÖØÆô·þÎñÆ÷
1038£ºÓÃÓÚÅÅÐòµÄÄÚ´æ²»×㣬ÇëÔö´óÅÅÐò»º³åÇø
1040£ºÒѵ½´ïÊý¾Ý¿âµÄ×î´óÁ¬½ÓÊý£¬Çë¼Ó´óÊý¾Ý¿â¿ÉÓÃÁ¬½ÓÊý
1041£ºÏµÍ³ÄÚ´æ²»×ã
1042£ºÎÞЧµÄÖ÷»úÃû
1043£ºÎÞЧÁ¬½Ó
1044£ºµ±Ç°Óû§Ã»ÓзÃÎÊÊý¾Ý¿âµÄȨÏÞ
1045£º²»ÄÜÁ¬½ÓÊý¾Ý¿â£¬Óû§Ãû»òÃÜÂë´íÎó
1048£º×ֶβ»ÄÜΪ¿Õ
1049£ºÊý¾Ý¿â²»´æÔÚ
1050£ºÊý¾Ý±íÒÑ´æÔÚ
1051£ºÊý¾Ý±í²»´æÔÚ
1054£º×ֶβ»´æÔÚ
1065£ºÎÞЧµÄSQLÓï¾ä£¬SQLÓï¾äΪ¿Õ
1081£º²»Äܽ¨Á¢SocketÁ¬½Ó
1114£ºÊý¾Ý±íÒÑÂú£¬²»ÄÜÈÝÄÉÈκμǼ
1116£º´ò¿ªµÄÊý¾Ý±íÌ«¶à
1129£ºÊý¾Ý¿â³öÏÖÒì³££¬ÇëÖØÆôÊý¾Ý¿â
1130£ºÁ¬½ÓÊý¾Ý¿âʧ°Ü£¬Ã»ÓÐÁ¬½ÓÊý¾Ý¿âµÄȨÏÞ
1133£ºÊý¾Ý¿âÓû§²»´æÔÚ
1141£ºµ±Ç°Óû§ÎÞȨ·ÃÎÊÊý¾Ý¿â
1142£ºµ±Ç°Óû§ÎÞȨ·ÃÎÊÊý¾Ý±í
1143£ºµ±Ç°Óû§ÎÞȨ·ÃÎÊÊý¾Ý±íÖеÄ×Ö¶Î
1146£ºÊý¾Ý±í²»´æÔÚ
1147£ºÎ´¶¨ÒåÓû§¶ÔÊý¾Ý±íµÄ·ÃÎÊȨÏÞ
1149£ºSQLÓï¾äÓï·¨´íÎó
1158£ºÍøÂç´íÎ󣬳öÏÖ¶Á´íÎó£¬Çë¼ì²éÍøÂçÁ¬½Ó×´¿ö
1159£ºÍøÂç´íÎ󣬶Á³¬Ê±£¬Çë¼ì²éÍøÂçÁ¬½Ó×´¿ö
1160£ºÍøÂç´íÎ󣬳öÏÖд´íÎó£¬Çë¼ì²éÍøÂçÁ¬½Ó×´¿ö
1161£ºÍøÂç´íÎó£¬Ð´³¬Ê±£¬Çë¼ì²éÍøÂçÁ¬½Ó×´¿ö
1062£º×Ö¶ÎÖµÖظ´£¬Èë¿âʧ°Ü
1169£º×Ö¶ÎÖµÖظ´£¬¸üмǼʧ°Ü
1177£º´ò¿ªÊý¾Ý±íʧ°Ü
1180£ºÌá½»ÊÂÎñʧ°Ü
1181£º»Ø¹öÊÂÎñʧ°Ü
1203£ºµ±Ç°Óû§ºÍÊý¾Ý¿â½¨Á¢µÄÁ
Ïà¹ØÎĵµ£º
×î½üÔÚѧϰSSH£¬ÓÉÓÚΪÁ˽ÚÔ¼Äڴ棬ËùÒÔ¾Í×¼±¸Ê¹ÓÃMYSQL´úÌæOracle£¬ÎªÁ˸üÉîÒ»²½µØÁ˽âMySQL£¬ÓÚÊǾͼƻ®°²×°noinstall°æ±¾£¬Õâ°æ±¾±È°²×°°æ¿ÉÂ鷳һЩ£¬ÌرðÊÇÅäÖ÷½Ã棬Èç¹ûÅäÖúõĻ°¾Í¿ÉÒÔÔÚһ̨»úÆ÷ÉÏÔËÐжà¸ö°æ±¾µÄMYSQL£¬ÔÚÍøÉÏÕÒÁËÇ°±²ÃǵıʼǺóѧϰÍê±ÏºóÔټǼһ±Ê£¬¾ÍÎÒÕâ¼ÇÐÔ£¬¹À¼Æà ......
DELIMITER $$
DROP PROCEDURE IF EXISTS `hotel`.`prc_page_hotel_result`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `hotel`.`prc_page_hotel_result`(
in currpage int,
in columns varchar(500),
in tablename &n ......
³£³£Óöµ½´óÊý¾ÝÁ¿Æµ·±¶ÁдÊƱػᵼÖ·þÎñÆ÷µÄÐÔÄÜϽµ¡£ÏÂÃæ¼Ç¼һ϶ÔmysqlµÄÓÅ»¯ÅäÖÃ
1.Ê×ÏȹرÕauto commit¡£
2.¶ÔÓÚÊý¾Ý±íʹÓÃInnoDB¡£
3.¹Ø±ÕÍâ¼üÔ¼Êø¡£
4.²ÉÓöàÖµ²åÈë“INSERT INTO ±íÃû VALUES (1,2), (5,5), ...;” Èç¹ûÓдóÁ¿²¢·¢¿ÉÒÔÓøü¸ÄINSERT INTOΪ INSERT DELAYED INTO¿ÉÒÔÔڳ̶ÈÉϽ⾠......
<?php
/*
* by:lenush
* qicq:707207845
* email:lenus-h@163.com
* site:www.hackthiswebsite.cn
* that's all
*
*/
class mysql{
private $db_host; //Êý¾Ý¿âÖ÷»ú
private $db_user; //Êý¾Ý¿âÓû§Ãû
private $d ......