List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:January 31 2011 12:39pm
Subject:Re: Table creation
View as plain text  
Am 31.01.2011 13:34, schrieb M. Rodrigo Monteiro:

> 2011/1/31 João Cândido de Souza Neto <joao@stripped>:
>> CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome`
>> VARCHAR(10)) ENGINE=InnoDB;
>>
> 
> I forget to put in the e-mail. I tryied with ENGINE and TYPE, samething.

seems there is "skip-innodb" in your configuration
what do "show engines;" say?

i would recommend "sql-mode = STRICT_ALL_TABLES" in /etc/my.cnf
where ever no dirty applications are running which depends
on the bad standard behavior silently ignore errors

-- 

Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
Table creationM. Rodrigo Monteiro31 Jan
  • Re: Table creationjoao31 Jan
    • Re: Table creationM. Rodrigo Monteiro31 Jan
      • Re: Table creationRodrigo Ferreira31 Jan
      • Re: Table creationReindl Harald31 Jan
  • Re: Table creationjoao31 Jan
    • Re: Table creationAnanda Kumar31 Jan
  • Re: Table creationReindl Harald31 Jan
  • Re: Table creationjoao31 Jan
    • Re: Table creationM. Rodrigo Monteiro31 Jan
      • Re: Table creationpetya31 Jan
Re: Table creationM. Rodrigo Monteiro31 Jan