|
| Iniciado por guest, 21,abr. 2015 16:13 - 2 respuestas |
| |
| | | |
|
| |
| Publicado el 21,abril 2015 - 16:13 |
Is there a way to create an SQL import file for a set of tables i have created in Windev, they need to be converted/created into MySQL.
its a create table query something like this below, just wondered if there was any way this query could be done within windev for each table?
CREATE TABLE IF NOT EXISTS `my_comments` (
`comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0',
`comment_author` tinytext NOT NULL,
`comment_author_email` varchar(100) NOT NULL DEFAULT '',
`comment_author_url` varchar(200) NOT NULL DEFAULT '',
PRIMARY KEY (`comment_ID`),
KEY `comment_post_ID` (`comment_post_ID`))
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;
thanks
ISO |
| |
| |
| | | |
|
| | |
| |
| Publicado el 21,abril 2015 - 16:30 |
Hi
there is an option to generate the SQL creation script in the analysis editor menu
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 21,abril 2015 - 16:45 |
Found it, works great
cheers
iso |
| |
| |
| | | |
|
| | | | |
| | |
|