t_test.sql

来自「use form to access different mysql datab」· SQL 代码 · 共 32 行

/*
MySQL Backup
Source Host:           10.160.100.166
Source Server Version: 5.0.22-community-nt
Source Database:       hippo_ajax
Date:                  2006/08/10 09:31:00
*/

SET FOREIGN_KEY_CHECKS=0;
use hippo_ajax;
#----------------------------
# Table structure for t_test
#----------------------------
CREATE TABLE `t_test` (
  `f_id` int(4) unsigned NOT NULL auto_increment,
  `f_email` varchar(200) NOT NULL default '',
  `f_name` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`f_id`)
) ENGINE=MYISAM CHARACTER SET big5 COLLATE big5_chinese_ci;
#----------------------------
# Records for table t_test
#----------------------------

set names 'big5';

insert  into t_test values 
(1, '[e-mail]', 'David'), 
(2, '[e-mail]', 'Hippo'), 
(3, '[e-mail]', 'Emily'), 
(4, '[e-mail]', 'service');