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

sql Óï¾ä×ܽá

mysql :  ½«Ò»¸ö±íµÄÊý¾Ý²åÈëµ½newT ÖÐ
£¨newT ±íÐë´æÔÚ£¬ÇҽṹÓëselect Óï¾ä¶ÔÓ¦µÄ½á¹¹Í¬  £¬×îºÃ²»ÓÃ* ¶øÊǾßÌå×ֶΣ©    
       insert into newT select * from t1 where ...
Ò²¿ÉÒÔcreate table newT select f1,f2 from t1; (select into µÄÌæ´ú·½·¨£¬mysql ²»Ö§³Öselect into )
MySQL²»Ö§³ÖSelect Into
database table µÄ±¸·Ý
mysqldump -uroot -proot -h192.101.111.111  databaseName [tableName]  >a.sql
Éú³É±í½á¹¹¼°ÀïÃæµÄËùÓÐÊý¾Ý
£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½
¿ÉÒÔÓÃÏÂÁÐÓï¾ä
source a.sql ÖØÐµ¼Èë
µ±È»µ¼Èë֮ǰ¿ÉÒÔÐÞ¸Äa.sql ÀïµÄÄÚÈÝ£¬Èç±íÃû£¬Èç´Ë¿ÉʵÏÖ±¸·Ý
½«Êý¾Ý±¸·Ý£¬£¨²»Êǵ¼³ösql Óï¾ä£¬¶øÖ»µ¼³ö ÆäÖÐ µÄÊý¾Ý£©
select * into outfile 'c:\out.txt' from tableName where ...;
¶ÔÓ¦µÄµ¼È룺
load data local infile 'c:\out.txt'  into table positiondata  fileds terminated by ';' (userid ,username );


Ïà¹ØÎĵµ£º

SQL Server 2005ÐÂÌØÐÔ£¬²¿·Ö±¸·Ý£¨partial backup£©

Ò²ÊÇSQL Server 2005´øÀ´µÄÐÂÌØÐÔ£¬²¿·Ö±¸·Ý£¨partial backup£©×Ô¶¯´´½¨Êý¾Ý¿âÖÐÖ÷Îļþ×éºÍËùÓ줻î¶Áд¹¦ÄܵÄÎļþ×éµÄ±¸·Ý¡£Èç¹û±¸·Ý´æÔÚÖ»¶ÁÎļþ×éµÄÊý¾Ý¿â£¬²¿·Ö±¸·Ý½«Ö»¶ÔÖ÷Îļþ×é½øÐб¸·Ý¡£Õâ¸öÑ¡Ïî¶ÔÓÚÄÇЩ´æÔÚÖ»¶ÁÎļþ×éµÄ³¬´óÐÍÊý¾Ý¿âÊÇÀíÏëµÄ£¬Ëü²»ÐèÒªÏñÄÇЩ¿ÉдµÄÎļþ×鱸·ÝµÃÄÇôƵ·±¡£
³ýÁËÐèÒªÖ¸¶¨READ_WRIT ......

SQL ServerÓëExcelÊý¾Ý»¥µ¼

SQL ServerÓëExcelÊý¾Ý»¥µ¼
´ÓSQL ServerÖе¼Èë/µ¼³ö Excel µÄ»ù±¾·½·¨
/*=================== µ¼Èë/µ¼³ö Excel µÄ»ù±¾·½·¨ ===================*/
´ÓExcelÎļþÖÐ,µ¼ÈëÊý¾Ýµ½SQLÊý¾Ý¿âÖÐ,ºÜ¼òµ¥,Ö±½ÓÓÃÏÂÃæµÄÓï¾ä:
/*========================================================*/
--Èç¹û½ÓÊÜÊý¾Ýµ¼ÈëµÄ±íÒѾ­´æÔÚ
ins ......

ÍâÁ¬½ÓsqlµÄÒ»¸öÎÊÌâ

µ±ÔÚÄÚÁ¬½Ó²éѯÖмÓÈëÌõ¼þʱ£¬ÎÞÂÛÊǽ«Ëü¼ÓÈëµ½join×Ӿ䣬»¹ÊǼÓÈëµ½where×Ӿ䣬ÆäЧ¹ûÊÇÍêȫһÑùµÄ£¬µ«¶ÔÓÚÍâÁ¬½ÓÇé¿ö¾Í²»Í¬ÁË¡£µ±°ÑÌõ¼þ¼ÓÈëµ½ join×Ó¾äʱ£¬»á·µ»ØÍâÁ¬½Ó±íµÄÈ«²¿ÐУ¬È»ºóʹÓÃÖ¸¶¨µÄÌõ¼þ·µ»ØµÚ¶þ¸ö±íµÄÐС£Èç¹û½«Ìõ¼þ·Åµ½where×Ó¾äÖУ¬½«»áÊ×ÏȽøÐÐÁ¬½Ó²Ù×÷£¬È»ºóʹÓÃwhere×Ó¾ä¶ÔÁ¬½ÓºóµÄÐнøÐÐɸѡ¡ ......

jdbcÁ¬½Ósql server

import java.sql.*;
public class JdbcUtil
{
    public static void close(Statement st, Connection con)
    {
        try
        {
          &nb ......

Sql Sever 2005 ÊÓͼµÄ²Ù×÷

ºÜ¶àÈËÌØ±ðϲ»¶ÓÃÊÓͼ,µ«ÓеÄÈË´ÓÀ´²»ÓÃÊÓͼ.Õâ¶¼ÊÇÁ½ÖÖ²»Á¼µÄϰ¹ß.     ÒªÃ÷È·ÊÓͼ¿ÉÒÔÍê³ÉµÄ¹¤×÷ÒÔ¼°Ê¹Óó¡ºÏ.
     1.×èֹѡÔñ±£ÃÜÁÐ
     2.½µµÍÓû§¶ÁÈ¡Êý¾Ý¿âÄÚÊý¾ÝµÄ¸´ÔÓÐÔ  
     3.ÔÚÊý¾Ý¿âÖÐÌí¼ÓË÷ÒýÒÔ¼ÓËÙ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ