MySQL Workbench Synchronization: error in CREATE TABLE IF NOT EXISTS `mydb`.`timestamps` ( -


i'm new mysql. tried creating few tables in new schema using mysql workbench. attempted "synchronize model database" completed errors. reason mysql workbench auto generated sql includes create table if not exists mydb.timestamps..... appears problem. closest thing find of relevance in workbench's schema gui editor has pane on right called modeling actions had default template called timestamps. didn't use in simple test project.

i using mysql 5.7.16 win64. mysql workbench: 6.3.7 (build 1199ce)

i realize has null value being put non-null field but, how table/field being created in first place if isn't part of tables?

can please lead me in right direction? came access novice , system different. can't schema design synchronized mysql.

***************************************************************************** * mysql workbench auto-generated sql - being made during synchronize... *****************************************************************************      -- mysql workbench synchronization     -- generated: 2016-11-08 06:30     -- model: new model     -- version: 1.0     -- project: name of project     -- author: turtle      set @old_unique_checks=@@unique_checks, unique_checks=0;     set @old_foreign_key_checks=@@foreign_key_checks, foreign_key_checks=0;     set @old_sql_mode=@@sql_mode, sql_mode='traditional,allow_invalid_dates';      create table if not exists `mydb`.`timestamps` (       `create_time`  null default current_timestamp,       `update_time`  null)     engine = innodb     default character set = utf8;      create table if not exists `mydb`.`tblworklog` (       `username` varchar(50) not null,       `tblusers_username` varchar(50) not null,       primary key (`username`),       index `fk_tblworklog_tblusers_idx` (`tblusers_username` asc),       constraint `fk_tblworklog_tblusers`         foreign key (`tblusers_username`)         references `mydb`.`tblusers` (`username`)         on delete no action         on update no action)     engine = innodb     default character set = utf8;      create table if not exists `mydb`.`tblusers` (       `username` varchar(50) not null,       `fname` varchar(50) null default null,       `mname` varchar(50) null default null,       `lname` varchar(50) null default null,       `tbluserscol` varchar(45) null default null,       `email` varchar(255) null default null,       `tblworklog_username` int(11) not null,       primary key (`username`))     engine = innodb     default character set = utf8;      create table if not exists `mydb`.`tbljobcodes` (       `jobcode` varchar(50) not null,       `shortname` varchar(100) null default null,       `longname` varchar(255) null default null,       `description` varchar(4000) null default null,       primary key (`jobcode`))     engine = innodb     default character set = utf8;      create table if not exists `mydb`.`tblroles` (       `roleid` varchar(25) not null,       `description` varchar(255) null default null,       primary key (`roleid`))     engine = innodb     default character set = utf8;       set sql_mode=@old_sql_mode;     set foreign_key_checks=@old_foreign_key_checks;     set unique_checks=@old_unique_checks;

--

***************************************************************************** * error message mysql workbench *****************************************************************************      executing sql script in server     error: error 1064: have error in sql syntax; check manual corresponds mysql server version right syntax use near 'null default current_timestamp,       `update_time`  null)     engine = innodb     default c' @ line 2     sql code:             create table if not exists `mydb`.`timestamps` (               `create_time`  null default current_timestamp,               `update_time`  null)             engine = innodb             default character set = utf8     sql script execution finished: statements: 3 succeeded, 1 failed     fetching view definitions in final form.     nothing fetch

try creating 1 table each time.

but belive problem using null default

check examples

should be:

 create table if not exists `mydb`.`timestamps` (       `create_time`  default current_timestamp,       `update_time`)     engine = innodb     default character set = utf8;

Comments

Post a Comment

Popular posts from this blog

php - How to add and update images or image url in Volusion using Volusion API -

actually have store importing products store product data insert , update image or image url not insert , update. this xml code name datapro.txt. <products_joined> <productcode>3710_012t</productcode> <vendor_partno>eah5450silent/di/1gd3(lp)</vendor_partno> <productname>test product ta</productname> <hideproduct>n</hideproduct> <stockstatus>20</stockstatus> <lastmodified>1/5/2016 10:25:00 am</lastmodified> <lastmodby>2</lastmodby> <productweight>0.9</productweight> <productprice>100</productprice> <productmanufacturer>asus tek</productmanufacturer> <vendor_price>32.69</vendor_price> <numproductssharingstock>0</numproductssharingstock> <categoryids>107</categoryids> <producturl>http://tebkq.mvlce.servertrust.com/productdetails.asp?productcode=3710_012t</producturl...
Read more

Laravel mail error `Swift_TransportException in StreamBuffer.php line 269: Connection could not be established with host smtp.gmail.com [ #0]` -

i developing website contact-us page guest users can send me email using gmail . anytime try send mail using contact-us form, error swift_transportexception in streambuffer.php line 269: connection not established host smtp.gmail.com [ #0] this mail.php return [ 'driver' => env('mail_driver', 'smtp'), 'host' => env('mail_host', 'smtp.gmail.com'), 'port' => 587, 'from' => ['address' => '', 'name' => ''], 'encryption' => env('mail_encryption', 'tls'), 'username' => env('mail_username'), 'password' => env(mail_password), 'sendmail' => '/usr/sbin/sendmail -bs', 'pretend' => env('mail_pretend', false), ]; this .env mail_driver=smtp mail_host=smtp.gmail.com mail_port=587 mail_username=afecjaped@gmail.com mail_password=********...
Read more

c# SetCompatibleTextRenderingDefault must be called before the first -

i tried search exception couldn't find solution on case i'am using code below invoke .net application : assembly assem = assembly.load(data); methodinfo method = assem.entrypoint; var o = activator.createinstance(method.declaringtype); method.invoke(o, null); the application invoked has form , in entrypoint of application : [stathread] static void main() { application.enablevisualstyles(); application.setcompatibletextrenderingdefault(false); //exception application.run(new form1()); } setcompatibletextrenderingdefault must called before first iwin32window object created in application. edit : assembly = assembly.load(data); methodinfo method = a.gettype().getmethod("start"); var o = activator.createinstance(method.declaringtype); method.invoke(o, null); you should create new method skips initialization...
Read more