æ¬èå 容ï¼
mysqlå¤å¶è¡¨ç»æãmysqlå¤å¶è¡¨æ°æ®ã
æ¬æä»ç»å ç§mysqlæ°æ®åºä¸æ·è´è¡¨çæ¹å¼ï¼å¸ææå©äºå¤§å®¶ææ¡mysqlæ·è´è¡¨æ¹é¢çç¥è¯ã
ä¾ï¼è¡¨ï¼
å¤å¶ä»£ç 代ç 示ä¾:
id     username   password
-----------------------------------
1      admin      *************
2      sameer     *************
3      stewart    *************
å建表çè¯å¥ï¼
å¤å¶ä»£ç 代ç 示ä¾:
CREATE TABLE IF NOT EXISTS `admin` (  `id` int(6) unsigned NOT NULL auto_increment,  `username` varchar(50) NOT NULL default '',  `password` varchar(100) default NULL,  PRIMARY KEY (`id`)  ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
1ãæ·è´è¡¨ç»æå°æ°è¡¨newadminä¸ã (ä¸ä¼æ·è´è¡¨ä¸çæ°æ®)
å¤å¶ä»£ç 代ç 示ä¾:
CREATE TABLE newadmin LIKE admin
2ãæ·è´æ°æ®å°æ°è¡¨ä¸ã
注æï¼è¿ä¸ªè¯å¥å ¶å®åªæ¯æselectè¯å¥çç»æ建ä¸ä¸ªè¡¨ã
æ以newadminè¿ä¸ªè¡¨ä¸ä¼æ主é®ï¼ç´¢å¼ã
å¤å¶ä»£ç 代ç 示ä¾:
CREATE TABLE newadmin AS  (  SELECT *  FROM admin  )
3ãçæ£çå¤å¶ä¸ä¸ªè¡¨ã
å¤å¶ä»£ç 代ç 示ä¾:
CREATE TABLE newadmin LIKE admin;Â Â INSERT INTO newadmin SELECT * FROM admin;
4ãæä½ä¸åçæ°æ®åºã
å¤å¶ä»£ç 代ç 示ä¾:
CREATE TABLE newadmin LIKE shop.admin;Â Â CREATE TABLE newshop.newadmin LIKE shop.admin;
5ãæ·è´ä¸ä¸ªè¡¨ä¸å ¶ä¸çä¸äºå段ã
å¤å¶ä»£ç 代ç 示ä¾:
CREATE TABLE newadmin AS  (  SELECT username, password FROM admin  )
6ãå°æ°å»ºç表çå段æ¹åã
å¤å¶ä»£ç 代ç 示ä¾:
CREATE TABLE newadmin AS  (  SELECT id, username AS uname, password AS pass FROM admin  )
7ãæ·è´ä¸é¨åæ°æ®ã
å¤å¶ä»£ç 代ç 示ä¾:
CREATE TABLE newadmin ASÂ Â (Â Â SELECT * FROM admin WHERE LEFT(username,1) = 's'Â Â )
8ãå建表çåæ¶å®ä¹è¡¨ä¸çå段信æ¯ã
å¤å¶ä»£ç 代ç 示ä¾:
CREATE TABLE newadmin  (  id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY  )  AS  (  SELECT * FROM admin  )