- mysql script
The CREATE TABLE IF NOT EXISTS ` test TABLE ` (
` field 1 ` varchar (50) DEFAULT NULL COMMENT 'comments 1,
` field 2 ` varchar (50) DEFAULT NULL COMMENT '2,
` field 3 varchar (100) the DEFAULT NULL COMMENT 'comments 3,
` field 4 ` varchar (50) DEFAULT NULL COMMENT 'comments 4,
` field 5 ` varchar (50) DEFAULT NULL COMMENT 'COMMENT 5',
` field 6 ` int (11) the DEFAULT NULL COMMENT '6',
` field 7 ` varchar (200) the DEFAULT NULL COMMENT 'comments 7',
` field 8 ` varchar (255) the DEFAULT NULL COMMENT 'COMMENT 8',
` field 9 ` varchar (255) the DEFAULT NULL COMMENT 'annotation 9',
` field 10 ` text COMMENT 'COMMENT 10',
` field 11 ` varchar (255) the DEFAULT NULL COMMENT 'COMMENT 11',
12 ` ` field in a datetime DEFAULT NULL COMMENT 'annotation 12',
` field 13 ` varchar (255) the DEFAULT 'new' COMMENT 'annotation 13',
` field 14 ` varchar (255) the DEFAULT 'latest' COMMENT 'comments 14'
` field 15 ` varchar (255) the DEFAULT NULL COMMENT 'COMMENT 15',
The KEY KEY ` 1 ` (` KEY _1_1 `),
KEY ` KEY 2 ` (` KEY _2_1 `),
KEY ` KEY 3 ` (` KEY _3_1 `),
KEY ` keys 4 ` (` KEY _4_1 `)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='table annotation;

. Etc.

O how to convert oracle table
Just manually change?

CodePudding user response:

 
- build table 
CREATE TABLE test TABLE (
The DEFAULT NULL field 1 varchar (50), 
DEFAULT NULL field 2 varchar (50) 
); 

- index 
The create index key1 on test form fields (1); 
The create index key2 on test form fields (2); 

- comments 
COMMENT on the table test table is' table annotation; 
COMMENT on the column test table. 1 is' 1 'comments field; 
COMMENT on the column test table. Field 2 is' 2 '. 

- delete table 
Drop table test table purge; 

CodePudding user response:

Purge the drop table test table; On the front, first remove, and then create, province had an error

CodePudding user response:

The text - & gt; clob

CodePudding user response:

2, 3 floor all say similar things,