The Current DBMS mysql 5.0
Because of the reserved words, the field name if there is a reserved word, cannot execute SQL, so want to put all the column with the quotes like this
The create table ` cl_task_regex ` (
` id ` int the not null comment 'primary key sequence,
` cl_task_id ` int the not null,
` regexp ` varchar (128) the comment 'regular expressions,
` force ` smallint not null,
` remark ` varchar (512) the comment 'remarks',
` create_time ` timestamp not null comment 'late framework automatically by the system maintenance,
` update_time ` timestamp not null comment 'late framework automatically by the system maintenance,
The primary key (` id `)
);
This kind of thing, of course, can't and made by hand, so how to set up the powerdesigner to generate SQL scripts automatically when coupled with ` `? I want to add ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` ` `!!!!!!!!!!!
Is mysql5!!!!!!!!!!!!!!!
Not Oracle!!!!!!!!!!!
The field name must add `, for example: ` name `