Re: Table creation

Hi, You should check your error logs for innodb errors, there will be the key to the solution. If you want to avoid this behaviour, you can set innodb=force in your configuration file to make innodb error fatal, or set sql_mode to 'NO_ENGINE_SUBSTITUTION'. Peter Boros On 01/31/2011 08:21 PM

Re: Table creation

2011/1/31 João Cândido de Souza Neto : > I´m not so sure about that, but I think in MySql 3.23 the InnoDB engine was > disabled by default so you must be almost a PhD to enable it. But the version of MySQL is 5.1 as you can see below... > > What about updating server? > > # cat /etc/redhat-rel

Re: Table creation

I´m not so sure about that, but I think in MySql 3.23 the InnoDB engine was disabled by default so you must be almost a PhD to enable it. What about updating server? -- João Cândido de Souza Neto ""M. Rodrigo Monteiro"" escreveu na mensagem news:AANLkTimPVMS_e3dQyHS=bRyOy5WYp78hYhv6mN=2b.

Re: Table creation

Am 31.01.2011 13:34, schrieb M. Rodrigo Monteiro: > 2011/1/31 João Cândido de Souza Neto : >> 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"

Re: Table creation

'TYPE' is deprecated since long time ago and should be replaced everywhere with 'ENGINE' with mysql 5.5 'TYPE' is a hard error which can be problematic if running statement-based replication with a 5.1 master and 5.5 slave because the master writes the statement to binlog and slave will stop repli

Re: Table creation

rigo Monteiro wrote: From: M. Rodrigo Monteiro Subject: Re: Table creation To: mysql@lists.mysql.com Date: Monday, January 31, 2011, 10:34 AM Hi! 2011/1/31 João Cândido de Souza Neto : > CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome` > VARCHAR(10)) ENGINE=InnoDB; > I f

Re: Table creation

On Mon, Jan 31, 2011 at 09:39, Reindl Harald wrote: > seems there is "skip-innodb" in your configuration > what do "show engines;" say? In my.cnf (comment) #skip-innodb mysql> show engines; ++-++--+--

Re: Table creation

what does 'show create table teste2" shows 2011/1/31 João Cândido de Souza Neto > Please, give us some information about your server. > > -- > João Cândido de Souza Neto > > ""M. Rodrigo Monteiro"" escreveu na mensagem > news:AANLkTikw2rDzhZU2+SmVeiPnVCYB-Q=vce5nufa7o...@mail.gmail.com... >

Re: Table creation

Hi! 2011/1/31 João Cândido de Souza Neto : > 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. Regards, Rodrigo. -- M. Rodrigo Monteiro "Free as in Freedom, not free as in free

Re: Table creation

CREATE TABLE `DATABASE`.`Teste2`(`id` SMALLINT(2) , `nome` VARCHAR(10)) ENGINE=InnoDB; -- João Cândido de Souza Neto ""M. Rodrigo Monteiro"" escreveu na mensagem news:AANLkTikv4dtLTh+BMqxCwcCw5K59PU5W=zrt3j3th...@mail.gmail.com... Hi! I'm trying to create a InnoDB table. CREATE TABLE `DAT

Re: Table creation fail

Yes, but few exceptions; Column level constraints are applicable to that column only, whereas table level constraints are used to define composite keys like primary key for the combination of two or more columns in a table. column level constraints contain all types of constraints (like, not null

Re: Table creation fail

> > A Primary key constraint can be defined at various levels: > >* Primary key constraint defined at column level > Syntax: () Primary Key >* Primary key constraint defined at table level > Syntax: Primary key (, ) > Aren't those two alternate sy

Re: Table creation fail

Correct, a primary key is used to uniquely identify each row in a table. It can either be part of the actual record itself , or it can be an artificial field (one that has nothing to do with the actual record). A primary key can consist of one or more fields on a table. When multiple fields are use

Re: Table creation fail

Hi David, all! David Stoltz wrote: > Actually, > > > > That table isn't supposed to have a PK, so I removed that, and it > works...same effect you suggested. Even if you currently don't need a primary key in that table, IMO you should still define one. Use some 'id_testresult' column with an

RE: Table creation fail

Actually, That table isn't supposed to have a PK, so I removed that, and it works...same effect you suggested. Thanks! From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com] Sent: Wednesday, June 23, 2010 12:29 PM To: David Stoltz Cc: mysql@lists.mysql.com Subject: Re:

Re: Table creation fail

David, You did not define a primary key for the table. The "PRIMARY KEY ( ) " is expecting a column name inside the "( )" Mike At 11:21 AM 6/23/2010, David Stoltz wrote: Hi Folks, I use an online SQL Design tool to design my tables, etc. This generates script code that I can run in phpM

Re: Table creation fail

Hi, default cannot be used with primary key. mysql> CREATE TABLE `testresults` ( -> -> `id_employees` INTEGER DEFAULT NULL , -> `id_test_test` INTEGER DEFAULT NULL , -> `testdate` DATE DEFAULT NULL , -> `result` VARCHAR( 10 ) DEFAULT NULL , -> `resultsdescription` MEDIUMTE

Re: Table creation Time stamp

Hi! - Original Message - From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, October 13, 2004 6:43 PM Subject: RE: Table creation Time stamp --=_alternative 005527E185256F2C_= Content-Type: text/plain; charset="US-ASCII" By Jove! you are right!

RE: Table creation Time stamp

ly for Myisam table type and not for InnoDB table > type. where can we find for Innodb Table type > > > Thanks > Anil > DBA > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 13, 2004 8:18 PM > To: Anil

RE: Table creation Time stamp

] Subject: Re: Table creation Time stamp use the command: SHOW TABLE STATUS http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Anil Doppalapudi" <[EMAIL PROTECTED]> wrote on 10/13/2004 10:42:11 AM: >

Re: Table creation Time stamp

SHOW TABLE STATUS LIKE 'your_table_name'; See the manual for details . Michael Anil Doppalapudi wrote: Hi, where can we find the time stamp of table creation i.e when that table was created Thanks Anil DBA -- MySQL General Mailing List Fo

Re: Table creation Time stamp

use the command: SHOW TABLE STATUS http://dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Anil Doppalapudi" <[EMAIL PROTECTED]> wrote on 10/13/2004 10:42:11 AM: > Hi, > > > where can we find the time stamp of table creati

RE: table creation

Create the column as a timestamp and the column will be updated on insert and update. -Original Message- From: Mikel - [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 10:17 AM To: [EMAIL PROTECTED] Subject: table creation Hello list: Is it possible to create a table with a

Re: Table Creation

In the last episode (Nov 06), Arnoldus Th.J. Koeleman said: > What is wrong with this table creation > > > CREATE TABLE `spid_1__0` ( > `recordname` varchar(255) NOT NULL default '', > `data` enum NOT NULL, You didn't specify the values for your enum type. When you post questions like this,

Re: Table Creation

> What is wrong with this table creation > CREATE TABLE `spid_1__0` ( > `recordname` varchar(255) NOT NULL default '', > `data` enum NOT NULL, > PRIMARY KEY (`recordname`,`data`) > ) TYPE=MyISAM ROW_FORMAT=DYNAMIC; What is the specific error you are getting? W/o knowing that information, I

Re: table creation problems

At 18:11 +0200 6/28/03, anders thoresson wrote: Hi, I've three tables that my local MySQL server accepts, but when I try to create the same three tables on my ISP's server, it doesn't work. These are the three tables: CREATE TABLE un_user ( u_id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,

Re: table creation - arrays ?

;To: "Hans Nerdell" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > >Subject: Re: table creation - arrays ? > >Date: Sat, 14 Jun 2003 11:23:01 +0900 > > > >I have read that Arrays are not coming before 5.0. > > > >have a look in the Documentation and the UC pr

Re: table creation - arrays ?

I have read that Arrays are not coming before 5.0. have a look in the Documentation and the UC presentations. Best regards NIls Valentin Tokyo/Japan 2003年 6月 10日 火曜日 22:25、Hans Nerdell さんは書きました: > table creation - arrays ? > > how are rows as ARRAYS specified and created on a table ? > > wbrgd

Re: table creation - arrays ?

Arrays are not currently supported in any production-release versions of MySQL. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "Hans Nerdell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, 10 June, 2003 09:25 Subject: table creation - array

Re: table creation error with innodb/ sql,query

Original Message - > From: "Chris Tucker" <[EMAIL PROTECTED]> > To: "kayamboo" <[EMAIL PROTECTED]> > Sent: Tuesday, September 17, 2002 5:35 PM > Subject: Re: table creation error with innodb/ sql,query > > > > InnoDB requires that you ha

Re: table creation error with innodb/ sql,query

ROTECTED]> To: "kayamboo" <[EMAIL PROTECTED]> Sent: Tuesday, September 17, 2002 5:35 PM Subject: Re: table creation error with innodb/ sql,query > InnoDB requires that you have an index on both ends of a foreign key > constraint. Thus, you need to index the "type

Re: Table Creation Question

Davis, Charles M writes: > Hello, > > I downloaded the beta version of MySQLGUI and was unable to perform any > table creation. Is this feature currently not supported? > > Thanks, > Charles > > Charles Davis > Member Engineering Staff, Data Analysis Systems > Lockheed Martin - Naval Electronic

Re: Table Creation

Please, go through the manual found at http://www.mysql.com - -sherzodR phone: (517) 774-2702 email: [EMAIL PROTECTED] On Wed, 27 Jun 2001, Richard Bergeron wrote: > Hi, > > I'm new to this flavor of SQL, I've downloaded WinMySQLadmin version 1.1 for Win98, > I seem

RE: Table Creation woes

describe is a reserved word, use another name for the column. http://www.mysql.com/doc/R/e/Reserved_words.html > can someone tell me what I'm doing wrong here?I keep getting the error > "You have an error in your SQL syntax near 'describe text, fulltext text, > section VARCHAR (32) DEFAULT '

Re: Table Creation woes

At 5:52 PM -0400 6/6/01, Matt \"TrollBoy\" Wiseman wrote: >can someone tell me what I'm doing wrong here?I keep getting the error >"You have an error in your SQL syntax near 'describe text, fulltext text, >section VARCHAR (32) DEFAULT '0', type VARCHAR' at line 6" and I don't >understand why:

Re: Table Creation woes

describe is a reserved word and so is fulltext, I think. - Original Message - From: "Matt "TrollBoy" Wiseman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 07, 2001 5:52 Subject: Table Creation woes > can someone tell me what I'm doing wrong here?I keep getting th

Re: Table Creation woes

Hi, Your problem is a common mistake made by those who don't read the manual. http://www.mysql.com/doc/R/e/Reserved_words.html as described in the above web-page, "describe" is a reserved word. Regards, Jorge MySQL Development Team For technical support contracts, go to https://order.mysql.co