I pasted the following in the sql window:
CREATE TABLE `test1` (
`invoice_id` bigint(20) unsigned NOT NULL,
`assignment_id` bigint(20) unsigned NOT NULL,
`invoicetype_id` smallint(6) unsigned default NULL,
`description` varchar(50) default NULL,
`amount` decimal(9,2) default NULL,
`billdate` date default NULL,
`onRDN` tinyint(1) default NULL,
PRIMARY KEY (`invoice_id`,`assignment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
I then clicked on the single green arrow (execute current query).
Message that it executed successfully is at bottom of window.
Table is not in object browser.
I clicked on the “refresh object browser” button in toolbar
Table is not in object browser.
I then clicked on the single green arrow (execute current query).
Message “Query batch completed with error(s) at bottom of window
Error Code : 1050
Table 'test1' already exists
(0 ms taken)
Above is error message (says table exists) – but you cant see it.
I exit out of SQLYOG and re-enter and the table is there.
What did I do wrong?
I have 6.05 enterprise.
