Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

23±¾mysqlµç×ÓÊé


mastering Phpmyadmin

Beginning Php And Mysql³ÌÐòÉè¼Æ

Beginning PHP and MySQL from Novice to Professional 3rd Edition

Head First PHP MySQL

MySQLÈëÞ­µä

MySQL Stored Procedure Programming

MySQL Phrasebook: Essential Code and Commands

MySQL Crash Course

MySQL Database Design and Tuning

The Definitive Guide to MySQL5 3rd Edition

MySQL The Definitive Guide To Using Programming And Administering MySQL 3rd

Beginning MySQL

MySQL5.0 Certification Study Guide

PHP MySQL Everyday Apps For Dummies

PhpºÍMySQL web¿ª·¢

PHP And MySQL For Dynamic WebSites 2nd Edition

Beginning PHP5 Apache and MySQL Web Development

Core Web Application Development With PHP and MySQL

How To Do Everything With PHP And MySQL

Beginning Php Apache Mysql Web Development

Sams Teach Yourself PHPMySQL And Apache All in One 2nd Edition

PHP5 and MySQL Bible

MySQL Cookbook



Ïà¹ØÎĵµ£º

CentOSÏÂMysqlʵÏÖÊý¾Ý¿âÖ÷´Óͬ²½

http://www.ej38.com/showinfo/mysql-130795.html

CentOSÏÂMysqlʵÏÖÊý¾Ý¿âÖ÷´Óͬ²½
Ò»¡¢»·¾³
¡¡¡¡A·þÎñÆ÷£º 192.168.10.42    Ö÷·þÎñÆ÷master¡¡¡¡CentOS 5¡¡¡¡Mysql 5.1.34
¡¡¡¡B·þÎñÆ÷£º 192.168.10.68    ¸±·þÎñÆ÷slave¡¡¡¡¡¡CentOS 5¡¡¡¡Mysql 5.0.56
¶þ¡¢ÉèÖÃMas ......

ÆäËûÊý¾Ý¿âÄ£ÄâʵÏÖmysqlµÄlimitÓï·¨

¼ÙÈçÎÒÓиöuser±í,ÎÒÏë²éѯ·ûºÏijЩÌõ¼þµÄµÚ50¸öÓû§¿ªÊ¼µÄ10¸öÓû§,ÇÒ²»ÄÜʹÓÃidºÅbetween andÄÇÑù²éѯ,Ó¦¸ÃÔõôдSQLÓï¾ä?
¡¡¡¡ÔÚmysqlÊý¾Ý¿âÖÐÓÐlimit,offsetÓï¾ä¿ÉÒÔ·½±ãµÄʵÏÖ,ÄÇôÔÚSQL serverÖÐÄØ?SQL ServerÊÇ·ñÖ§³ÖlimitºÍoffsetÓï¾äÄØ?
select top 10 * from
(select top 60 * from [user] order by userid) a ......

ExcelÊý¾ÝʹÓÃjdbcÖ±½Ó²åÈëMysqlÊý¾Ý¿â

import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import jxl.*;
public class ImportExcel {
public static void main(String[] args) {
File importExcel = new File("D:\\test\\test.xls");
try {
// Êý¾Ý¿âÁ¬½Ó
Class.forNa ......

ÀûÓÃmysqlµÄ×¢ÉäµãµÃµ½¸ü¶àmysqlµÄÐÅÏ¢

µ±×¢Éämysql¿âµÄÊäÈëµãµÄʱºò,ÎÒÃÇ¿ÉÒÔͨ¹ýversion()/user()/database()/password()µÈÄÚÖú¯ÊýÀ´µÃµ½mysqlµÄÏà¹ØÐÅÏ¢,ÆäʵÎÒÃÇÔÚ×¢ÉäµÄʱºò¿ÉÒÔÀûÓÃmysqlÄÚÖõıäÁ¿À´µÃµ½¸ü¶àµÄmysqlÐÅÏ¢
ÆäÖÐversion()¿ÉÒÔд³É@@versionÀ´°Ñversionµ±×ö±äÁ¿À´¶ÁÈ¡,ÕâÑùÒ»Ñù¿ÉÒԵõ½,ÆäËûµÄÄÚÖÃÊDz»¿ÉÒÔд³É±äÁ¿µÄÐÎʽ.
´ó¼Ò¶¼Ó¦¸ÃÓùýÀû ......

mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá

mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
mysql´æ´¢¹ý³ÌµÄ´´½¨£¬É¾³ý£¬µ÷Óü°ÆäËû³£ÓÃÃüÁî
mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
Ò».´´½¨´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
create procedure sp_name()
begin
………
end
2.²ÎÊý´«µÝ
¶þ.µ÷Óô洢¹ý³Ì
1.»ù±¾Óï·¨£ºcall sp_name()
×¢Ò⣺´æ´¢¹ý³ÌÃû³ÆºóÃæ±ØÐë¼ÓÀ¨ºÅ£¬ÄÄŸô洢¹ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ