原sql格式: CREATE TABLE student1
( id
int(11) NOT NULL AUTO_INCREMENT, name
varchar(50) NOT NULL, sex
varchar(1) DEFAULT NULL, PRIMARY KEY (id
) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
sql 无文本格式: CREATE TABLE student1
( id
int(11) NOT NULL AUTO_INCREMENT, name
varchar(50) NOT NULL, sex
varchar(1) DEFAULT NULL, PRIMARY KEY (id
) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
java格式: "CREATE TABLE student1
(\n" + "id
int(11) NOT NULL AUTO_INCREMENT,\n" + "name
varchar(50) NOT NULL,\n" + "sex
varchar(1) DEFAULT NULL,\n" + "PRIMARY KEY (id
)\n" + ") ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;\n";
c++格式: "CREATE TABLE student1
(\n" "id
int(11) NOT NULL AUTO_INCREMENT,\n" "name
varchar(50) NOT NULL,\n" "sex
varchar(1) DEFAULT NULL,\n" "PRIMARY KEY (id
)\n" ") ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;\n";
Delphi格式: 'CREATE TABLE student1
('#13#10 + 'id
int(11) NOT NULL AUTO_INCREMENT,'#13#10 + 'name
varchar(50) NOT NULL,'#13#10 + 'sex
varchar(1) DEFAULT NULL,'#13#10 + 'PRIMARY KEY (id
)'#13#10 + ') ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;'#13#10);
HTML格式:
<pre> <span style='color:#800000;font-weight:bold;'>CREATE</span> <span style='color:#800000;font-weight:bold;'>TABLE</span> <span style='color:#000080;font-weight:bold;'>`student1`</span> (
<span style='color:#000080;font-weight:bold;'>`id`</span> <span style='color:#000080;font-weight:bold;'>int</span>(<span style='color:#0000ff;'>11</span>) <span style='color:#800000;font-weight:bold;'>NOT</span> <span style='color:#800000;font-weight:bold;'>NULL</span> <span style='color:#800000;font-weight:bold;'>AUTO_INCREMENT</span>,
<span style='color:#000080;font-weight:bold;'>`name`</span> <span style='color:#000080;font-weight:bold;'>varchar</span>(<span style='color:#0000ff;'>50</span>) <span style='color:#800000;font-weight:bold;'>NOT</span> <span style='color:#800000;font-weight:bold;'>NULL</span>,
<span style='color:#000080;font-weight:bold;'>`sex`</span> <span style='color:#000080;font-weight:bold;'>varchar</span>(<span style='color:#0000ff;'>1</span>) <span style='color:#800000;font-weight:bold;'>DEFAULT</span> <span style='color:#800000;font-weight:bold;'>NULL</span>,
<span style='color:#800000;font-weight:bold;'>PRIMARY</span> <span style='color:#800000;font-weight:bold;'>KEY</span> (<span style='color:#000080;font-weight:bold;'>`id`</span>)
) <span style='color:#000000;'>ENGINE</span>=<span style='color:#000000;'>InnoDB</span> <span style='color:#800000;font-weight:bold;'>AUTO_INCREMENT</span>=<span style='color:#0000ff;'>8</span> <span style='color:#800000;font-weight:bold;'>DEFAULT</span> <span style='color:#000000;'>CHARSET</span>=<span style='color:#000000;'>utf8</span><span style='color:#ff0000;'>;</span></pre>