Re: MySQL Create Table Error

2005-03-25 Thread David Blomstrom
Please ignore this thread. I think my main problem is I need glasses! --- David Blomstrom <[EMAIL PROTECTED]> wrote: > Can someone tell me what I'm doing wrong? When I > first > tried to create this table, I got an error message > pointing out two fields that looked perfectly fine > to > me. I cou

MySQL Create Table Error

2005-03-25 Thread David Blomstrom
Can someone tell me what I'm doing wrong? When I first tried to create this table, I got an error message pointing out two fields that looked perfectly fine to me. I couldn't figure it out, so I just deleted the fields - but it then fingered two different fields. I deleted them, and now it says the

RE: Create Table Error 1071

2004-10-11 Thread Anil Doppalapudi
2:16 AM To: [EMAIL PROTECTED] Subject: Create Table Error 1071 How can I fix the following error? I got this via phpMyAdmin Error SQL-query : CREATE TABLE `adminpages` ( `adminpageid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT , `file_name` VARCHAR( 255 ) NOT NULL , `page_title` VARCHAR( 255

Re: float in PROCEDURE ANALYSE() / misleading CREATE TABLE error

2004-05-03 Thread Jeremy Zawodny
On Mon, May 03, 2004 at 05:56:03PM +0200, Hans-Peter Grimm wrote: > Hi, > > I think there is > > 1) a problem with FLOAT recommendations in PROCEDURE ANALYSE > 2) a minor problem with CREATE TABLE(f FLOAT(,...)) I think that there is maybe: 3) a bug in PROCEDURE ANALYSE that you should report i

float in PROCEDURE ANALYSE() / misleading CREATE TABLE error

2004-05-03 Thread Hans-Peter Grimm
Hi, I think there is 1) a problem with FLOAT recommendations in PROCEDURE ANALYSE 2) a minor problem with CREATE TABLE(f FLOAT(,...)) Please correct me if I'm wrong. With MySQL 4.0.17, the query SELECT * FROM my_table PROCEDURE ANALYSE(); gives me the following result for a DOUBLE NOT NULL col

Create Table error with MySQL version 3.23.39-max-nt, Access 2000, and MyODBC 2.50.39-nt

2002-07-24 Thread Liz Craig
I am currently using MySQL version 3.23.39-max-nt, MS Access 2000 as my gui, and MyODBC 2.50.39-nt I am able to run reports, queries and use the SQL pass through in access to retrieve data from the MySQL database through MyODBC. The problem is that I can not create a table in MySQL from Acces

Re: InnoDB create table error 150

2002-02-15 Thread Heikki Tuuri
Hi! It is a bug in the FOREIGN KEY syntax parser. It is confused by the column name e_foreigncurrency The bug appears if the string 'foreign' is succeeded by a non-space character in a CREATE TABLE statement. Workaround: change the column name to e_currencyforeign, for example. Fixed in 3.23.

InnoDB create table error 150

2002-02-14 Thread Richard R. Harms
The create table command included at the end of this message gives the following error: ERROR 1005: Can't create table './catalogmgr/macitm_vendordfrom.frm' (errno: 150) Creating it with type=myisam, and then doing an alter table and converting it to innodb works okay. It just cannot be initi

Re: mysql create table error

2002-02-05 Thread Heikki Tuuri
e Science >757 S.Raymond >Pasadena, CA 91105 >Tel: 626-584-5900 >email: [EMAIL PROTECTED] > >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >Sent: Monday, February 04, 2002 11:02 AM >To: Demirchyan Oganes-AOD098 >Subject: Re: mysql cr

Re: mysql create table error

2002-02-04 Thread DL Neil
Oganes, > I have the following create table, and I get the following error when I create it. > It used to work before. Can anyone help? > > CREATE TABLE PROTOCOL_GROUPING( > PROTOCOL_GROUPING_ID MEDIUMINT(20), > GROUP_NAMEVARCHAR(50)NOT NULL, > PROTOCOL_ID

RE: mysql create table error

2002-02-04 Thread Demirchyan Oganes-AOD098
AM To: Demirchyan Oganes-AOD098 Subject: Re: mysql create table error Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message

Re: Create Table error convert from DB2 to MySQL with Java?

2001-10-24 Thread Paul DuBois
At 21:29 -0400 10/24/01, [EMAIL PROTECTED] wrote: >Greeting! I am trying to convert an application from a DB2 based >program to MySQL. We are still evaluating MySQL and learning. >We are using Java and the JDBC driver mm.mysql.jdbc-1.2c to >create the database. The Java version of this program usi

Create Table error convert from DB2 to MySQL with Java?

2001-10-24 Thread jwubbel
Greeting! I am trying to convert an application from a DB2 based program to MySQL. We are still evaluating MySQL and learning. We are using Java and the JDBC driver mm.mysql.jdbc-1.2c to create the database. The Java version of this program using this driver is not creating some of the tables.

Re: create table error

2001-03-23 Thread Thalis A. Kalfigopoulos
On Fri, 23 Mar 2001, Daniel Adams wrote: > Can someone please tell me what the problem is below. All I am trying to > do is pipe a backup created with mysqldump into mysql and it gives me > this error: > > ERROR 1071 at line 1291: Specified key was too long. Max key length is > 500 It is exc

create table error

2001-03-23 Thread Daniel Adams
Can someone please tell me what the problem is below. All I am trying to do is pipe a backup created with mysqldump into mysql and it gives me this error: ERROR 1071 at line 1291: Specified key was too long. Max key length is 500 Here is the query where the error is: CREATE TABLE list ( l