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

mysqlºÍsqlserverÖв鿴µ±Ç°¿âÖÐËùÓбíºÍ×Ö¶ÎÐÅÏ¢

>>mysql:
1¡¢²é¿´ËùÓбíÃû£º
show tables [from db_name];
2¡¢²é¿´×Ö¶ÎÐÅÏ¢
SHOW FULL COLUMNS from db_name.table_name
»ñÈ¡ÒÔÏÂÐÅÏ¢
Field £º×Ö¶ÎÃû
Type£º×Ö¶ÎÀàÐÍ
Collation£º×Ö·û¼¯ £¨mysql 5.0ÒÔÉÏÓУ©
Null £ºÊÇ·ñ¿ÉÒÔΪNULL
Key£ºË÷Òý£¨PRI,unique,index)
Default£ºÈ±Ê¡Öµ
Extra£º¶îÍ⣨ÊÇ·ñ auto_increment)
Privileges£ºÈ¨ÏÞ
Comment£º±¸×¢£¨mysql 5.0ÒÔÉÏÓÐ)
>>sqlserver
1¡¢²é¿´ËùÓÐÓû§½¨±íÃû
select name from Sysobjects where xtype='U' order by name;
2¡¢²é¿´×Ö¶ÎÐÅÏ¢
SELECT
a.colorder as ×Ö¶Î˳ÐòºÅ,
a.name as ×Ö¶ÎÃû³Æ,
a.collation as ÅÅÐò×Ö·û¼¯,
ÊÇ·ñ×Ô¶¯Ôö³¤Êý×Ö=case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then 'yes'else 'no' end,
ÊÇ·ñÖ÷¼ü=case when exists(SELECT 1 from sysobjects where xtype='PK' and name in (
SELECT name from sysindexes WHERE indid in(
SELECT indid from sysindexkeys WHERE id = a.id AND colid=a.colid
))) then 'yes' else 'no' end,
×Ö¶ÎÀàÐÍ=b.name,
×ֶ㤶È=a.length,
×Ö¶Î×Ö·û³¤¶È=COLUMNPROPERTY(a.id,a.name,'PRECISION'),
СÊýλÊý=isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0),
ÊÇ·ñΪNULL=case when a.isnullable=1 then 'yes'else 'no' end,
ȱʡֵ=isnull(e.text,'')
from syscolumns a
left join systypes b on a.xtype=b.xusertype
inner join sysobjects d on a.id=d.id and (d.xtype='U' or d.xtype='V') and d.name<>'dtproperties'
left join syscomments e on a.cdefault=e.id
where d.name='purchase_medicine'
order by a.colorder


Ïà¹ØÎĵµ£º

MySQL 5.1 °²×°ÅäÖÃͼ½â


Ò»¡¢MySQL5.1°²×°
       ´ò¿ªÏÂÔصݲװÎļþ£¬³öÏÖÈçϽçÃ棺
 
mysql°²×°Ïòµ¼Æô¶¯£¬µã»÷“next”¼ÌÐø
 
        Ñ¡Ôñ°²×°ÀàÐÍ£¬ÓГTypical£¨Ä¬ÈÏ£©”¡¢“Complete£¨ÍêÈ«£©”¡¢“Custom£¨Óû§×Ô¶ ......

mysql ÊÂÎñ´¦Àí


¹ØÓÚMySQLÊÂÎñ´¦Àíѧϰ¼Ç

START TRANSACTION, COMMITºÍROLLBACKÓï·¨
START TRANSACTION | BEGIN [WORK]
COMMIT [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
ROLLBACK [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
SET AUTOCOMMIT = {0 | 1}
START
TRANSACTION»òBEGINÓï¾ä¿ÉÒÔ¿ªÊ¼Ò»ÏîеÄÊÂÎñ¡£COMMIT¿ÉÒÔÌá½»µ±Ç°ÊÂÎñ ......

python mysqlµ¼ÈëÊý¾Ý

[root@pku-fan MySQL]# cat limbs.sql
CREATE DATABASE cookbook;
USE cookbook;
DROP TABLE IF EXISTS limbs;
CREATE TABLE limbs
(
    thing   VARCHAR(20),    # what the thing is
    legs    INT,     ......

mysql ʱ¼äº¯Êý

ÀïÊÇÒ»¸öʹÓÃÈÕÆÚº¯ÊýµÄÀý×Ó¡£ÏÂÃæµÄ²éѯѡÔñÁËËùÓмǼ£¬Æädate_colµÄÖµÊÇÔÚ×îºó30ÌìÒÔÄÚ£º 
¡¡¡¡mysql> SELECT something from table 
¡¡¡¡WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) <= 30; 
   select   TO_DAYS(NOW());
   select now() ;
¡¡¡¡DAYOFWEEK( ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ