56,687
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE `test_data` (
`order_id` INT UNSIGNED auto_increment NOT NULL COMMENT 'Order numbers. Must be unique.',
`status` BOOL NOT NULL DEFAULT '0' COMMENT 'Whether data has been used or not. A value of 0 means FALSE.',
`date_used` DATETIME NULL COMMENT 'Date/time that the data was used.',
UNIQUE (
`order_id`
)
) ENGINE = innodb COMMENT = 'LoadRunner test data';
mysql> show variables like 'datadir';
+---------------+-----------------------------------------------+
| Variable_name | Value |
+---------------+-----------------------------------------------+
| datadir | C:\Program Files\MySQL\MySQL Server 5.1\DATA\ |
+---------------+-----------------------------------------------+
1 row in set (0.00 sec)
mysql>