MySQL µÄÍâ¼üÓë²ÎÕÕÍêÕûÐÔ
1. ʲôÊDzÎÕÕÍêÕûÐÔ?
——————–
²ÎÕÕÍêÕûÐÔ(ÍêÕûÐÔÔ¼Êø)ÊÇÊý¾Ý¿âÉè¼ÆÖеÄÒ»¸öÖØÒª¸ÅÄµ±Êý¾Ý¿âÖеÄÒ»¸ö±íÓëÒ»¸ö»ò¶à¸ö±í½øÐйØÁªÊ±¶¼»áÉæ¼°µ½²ÎÕÕÍêÕûÐÔ¡£±ÈÈçÏÂÃæÕâ¸öÀý×Ó£º
ÎÄÕ·ÖÀà±í - categories
category_id name
1 SQL Server
2 Oracle
3 PostgreSQL
5 SQLite
ÎÄÕ±í - articles
article_id category_id title
1 1 aa
2 2 bb
3 4 cc
¿É¼ûÒÔÉÏÁ½¸ö±íÖ®¼äÊÇͨ¹ýcategory_id£¬ÆäÖÐcategories±íÓÐ4Ìõ¼Ç¼£¬articles±íÓÐ3Ìõ¼Ç¼¡£
È»¶ø¿ÉÄÜÒòΪijÖÖÔÒòÎÒÃÇɾµôÁËcategories ±íÖÐcategory_id=4µÄ¼Ç¼£¬¶øarticles±íÈ´»¹ÊÇÓÐÒ»Ìõ
category_id=4µÄ¼Ç¼£¬ºÜÃ÷ÏÔ£¬category_id=4µÄÕâÌõ¼Ç¼²»Ó¦¸Ã´æÔÚÔÚarticles±íÖУ¬ÕâÑù»áºÜÈÝÒ×Ôì³ÉÊý¾Ý´íÂÒ¡£
Ïà·´£¬Íâ¼ü¹Øϵ(Foreign Key relationships)ÌÖÂÛµÄÊǸ¸±í(categories)Óë×Ó±í(articles)µÄ¹Øϵ£¬
ͨ¹ýÒýÈëÍâ¼ü(Foreign Key)Õâ¸ö¸ÅÄîÀ´±£Ö¤²ÎÕÕÍêÕûÐÔ(Referential integrity)£¬½«Ê¹»áÊý¾Ý¿â±äµÄ·Ç³£¼òµ¥¡£±ÈÈ磬Ҫ
Òª×öµ½É¾³ýcategories±íÖÐcategory_id=4¼Ç¼µÄͬʱɾ³ý articles ±íÖÐcategory_id=4µ
Ïà¹ØÎĵµ£º
ÖØа²×°£¬³öÏÖ/etc/init.d/mysql: line 115: /etc/mysql/debian-start: ûÓиÃÎļþ»òĿ¼
invoke-rc.d: initscript mysql, action "start" failed.
ʹÓÃÃüÁsudo aptitude purge mysql-server mysql-server-5.0
È»ºóÔÚÖØа²×°....
apt-get install mysql-server-5.0 ......
ÐÞÕýһϣºÎÒÔÚWindowsϵÄʵ¼Ê²Ù×÷ÈçÏÂ
1.¹Ø±ÕÕýÔÚÔËÐеÄMySQL¡£
2.´ò¿ªDOS´°¿Ú£¬×ªµ½mysql\binĿ¼¡£
3.ÊäÈëmysqld½â --skip-grant-tables»Ø³µ¡£Èç¹ûûÓгöÏÖÌáʾÐÅÏ¢£¬ÄǾͶÔÁË¡£
4.ÔÙ¿ªÒ»¸öDOS´°¿Ú£¨ÒòΪ¸Õ²ÅÄǸöDOS´°¿ÚÒѾ²»Äܶ¯ÁË£©£¬×ªµ½mysql\binĿ¼¡£
5.ÊäÈëmysql»Ø³µ£¬Èç¹û³É¹¦£¬½«³öÏÖMySQL ......
#!/usr/bin/env python
# -*-coding:UTF-8-*-#ÕâÒ»¾ä¸æËßpythonÓÃUTF-8±àÂë
#=========================================================================
#
# NAME: Python MySQL test
#
# AUTHOR: benyur
# DATE : 2004-12-28
#
# COMMENT: ÕâÊÇÒ»¸öpythonÁ¬½ÓmysqlµÄÀý×Ó
#
#================ ......
Æô¶¯£ºnet start mySql;
¡¡¡¡½øÈ룺mysql -u root -p/mysql -h localhost -u root -p databaseName;
¡¡¡¡ÁгöÊý¾Ý¿â£ºshow databases;
¡¡¡¡Ñ¡ÔñÊý¾Ý¿â£ºuse databaseName;
¡¡¡¡Áгö±í¸ñ£ºshow tables£»
¡¡¡¡ÏÔʾ±í¸ñÁеÄÊôÐÔ£ºshow columns from tableName£»
¡¡¡¡½¨Á¢Êý¾Ý¿â£ºsource fileName.txt;
¡¡¡¡Æ¥Åä× ......
1. ¹ØÓÚ±¾ÎÄ
±¾ÎĽ«ÒÔMySQL 5.0.51ΪÀý£¬ÒÔCentOS 5Ϊƽ̨£¬½²ÊöMySQLÊý¾Ý¿âµÄ°²×°ºÍÉèÖá£
2. ¹ØÓÚMySQL
MySQLÊÇ×îÁ÷ÐеĿªÔ´SQLÊý¾Ý¿â¹ÜÀíϵͳ£¬ËüÓÉMySQL AB¿ª·¢¡¢·¢²¼ºÍÖ§³Ö¡£MySQL ABÊÇÒ»¼ÒÓÉMySQL¿ª·¢ÈËÔ±´´½¨µÄÉÌÒµ¹«Ë¾£¬ËüÊÇÒ»¼ÒʹÓÃÁËÒ»Öֳɹ¦µÄÉÌҵģʽÀ´½áºÏ¿ªÔ´¼ÛÖµºÍ·½·¨Â۵ĵڶþ´ú¿ªÔ´¹«Ë¾¡£MySQLÊÇMySQL ......