¡¾×ª¡¿mysqlÏÂÈçºÎÖ´ÐÐsql½Å±¾
Ê×Òª²½Öè(Ò»°ã¿ÉÊ¡ÂÔ):
¿ªÆômysql·þÎñ(ĬÈÏÊÇ¿ª»úʱ¾Í×Ô¶¯ÔËÐÐÁË):
¿ØÖÆÃæ°å
-->¹ÜÀí¹¤¾ß-->·þÎñ,ÔÚÀïÃæÕÒµ½Ãû³ÆΪmysqlµÄÏî,Ë«»÷¾Í¿É¿´ËüµÄ·þÎñ״̬ÊÇÆô¶¯»¹ÊÇÍ£Ö¹,°ÑËüÉèΪÆô¶¯
Á¬½Ómysql:
ÔÚÃüÁîÐÐÏÂÊäÈë mysql -h
localhost -u root -p»Ø³µ,È»ºóÊäÈëÃÜÂë¼´¿É;»òÖ±½ÓÔËÐÐmysql×Ô´øµÄÁ¬½Ó¹¤¾ß,È»ºóÊäÈëÃÜÂë¼´¿É.
1.±àдsql½Å±¾,¼ÙÉèÄÚÈÝÈçÏÂ:
create database dearabao;
use dearabao;
create table niuzi (name varchar(20));
±£´æ½Å±¾Îļþ,¼ÙÉèÎÒ°ÑËü±£´æÔÚFÅ̵Ähello
worldĿ¼ÏÂ,ÓÚÊǸÃÎļþµÄ·¾¶Îª:F:\hello world\niuzi.sql
2.Ö´ÐÐsql½Å±¾,¿ÉÒÔÓÐ2ÖÖ·½·¨:
µÚÒ»ÖÖ·½·¨:
ÔÚÃüÁîÐÐÏÂ(δÁ¬½ÓÊý¾Ý¿â),ÊäÈë mysql -h localhost -u root -p123456 <
F:\hello world\niuzi.sql (×¢Òâ·¾¶²»ÓüÓÒýºÅµÄ!!) »Ø³µ¼´¿É.
µÚ¶þÖÖ·½·¨:
ÔÚÃüÁîÐÐÏÂ(ÒÑÁ¬½ÓÊý
¾Ý¿â,´ËʱµÄÌáʾ·ûΪ mysql> ),ÊäÈë source F:\hello world\niuzi.sql (×¢Òâ·¾¶²»ÓüÓÒýºÅµÄ)
»òÕß \. F:\hello world\niuzi.sql (×¢Òâ·¾¶²»ÓüÓÒýºÅµÄ) »Ø³µ¼´¿É
ÔÎĵØÖ·£ºhttp://www.cppblog.com/true/archive/2007/07/17/28174.html
Ïà¹ØÎĵµ£º
Ò»¡¢³£ÓÃ×Ö·û´®º¯Êý
1.CONCAT(str1,str2,...)
mysql> ? concat;
mysql> SELECT CONCAT('My', 'S', 'QL');
+-------------------------+
| CONCAT('My', 'S', 'QL') |
+-------------------------+
| MySQL ......
ͨÓñí±í´ïʽ Common Table Expressions
ͨÓñí±í´ïʽ£¨CTE£©ÊÇÒ»¸ö¿ÉÒÔÓɶ¨ÒåÓï¾äÒýÓõÄÁÙʱ±íÃüÃûµÄ½á¹û¼¯¡£ÔÚËûÃǵļòµ¥ÐÎʽÖУ¬Äú¿ÉÒÔ½«CTEÊÓΪÀàËÆÓÚÊÓͼºÍÅÉÉú±í»ìºÏ¹¦ÄܵĸĽø°æ±¾¡£ÔÚ²éѯµÄfrom×Ó¾äÖÐÒýÓÃCTEµÄ·½Ê½ÀàËÆÓÚÒýÓÃÅÉÉú±íºÍÊÓͼµÄ·½Ê½¡£Ö»Ð붨ÒåCTEÒ»´Î£¬¼´¿ÉÔÚ²éѯÖжà´ÎÒýÓÃËü¡£ÔÚCTEµÄ¶¨ÒåÖУ¬¿ÉÒÔÒ ......
1¡£select * from a where a.rowid=(select min(b.rowid) from b where a.id=b.id);
create test1(
nflowid number primary key,
ndocid number,
drecvdate date);
insert into test1 values (1, 12301, sysdate) ;
insert into test1 values (2, 12301, sysdate);
select * from test1 order by drecvdate:
......
To generate a deployment script using generate scripts
Open
Management Studio and connect to the SQL Server instance where the
managed assembly or database object to be deployed is registered.
In the Object Explorer
, expand the <server name>
and Databases
trees. Right-click ......