比如这个SQL表格的创建
db.exec("
CREATE TABLE `user_timeline` (
`no` int(11) NOT NULL AUTO_INCREMENT,
`created_at` datetime DEFAULT NULL,
`id` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
`text` text CHARACTER SET utf8,
`original_pic` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
`reposts_count` smallint(5) unsigned DEFAULT NULL,
`comments_count` smallint(5) unsigned DEFAULT NULL,
`re_created_at` datetime DEFAULT NULL,
`re_id` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
`re_text` text CHARACTER SET utf8,
`re_original_pic` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (`no`),
UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk$$
");
除了“ ABC” +
“EFG ”的方法。
另我按网上的最后加'\'的方法,字符串块没有被同一颜色注释掉,只有第一行显示颜色,为什么?
有像注释块的 /* ABC
EFG */
这样方便的办法吗?