Re: MySQL for Excel

[Marion Gordon]

Hay use the following code for creating table in MySQL database. It is possible to create a table at easy.

CREATE TABLE IF NOT EXISTS `tutorial` (

`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL,
`author` varchar(255) NOT NULL,
`price` float(4,2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;