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
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
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
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
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
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
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.
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
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
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
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
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
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.
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
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
15 matches
Mail list logo