Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 µÄ°æ±¾¡¾×ª×Ômsdn¡¿

ÈçºÎÈ·¶¨ËùÔËÐÐµÄ SQL Server 2005 µÄ°æ±¾
Ҫȷ¶¨ËùÔËÐÐµÄ SQL Server 2005 µÄ°æ±¾£¬ÇëʹÓà SQL Server Management Studio Á¬½Óµ½ SQL Server 2005£¬È»ºóÔËÐÐÒÔÏ Transact-SQL Óï¾ä£º
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
ÔËÐнá¹ûÈçÏ£º
²úÆ·° ......

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

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

jdbcÁ¬½Ósql server

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

sql »ù±¾²éѯÓï¾ä

SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ