Hello MySQL List,
Thanks Ken and HongKong0888 for the advice and suggestions.
I hate when these kinds of problems just fade away with no
resolution or analysis of the resolved issue. So, with that,
here is the explanation for what caused THIS particular
problem (can you say user error?).
In
As a follow up to my question, I did want to mention that the foreign key
I am using is unique.
- Asad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-to-many relation two
tables make sense, but then your FK can't be unique.
Stefan
Am Wednesday 15 June 2005 12:41 schrieb Asad Habib:
As a follow up to my question, I did want to mention that the foreign key
I am using is unique.
- Asad
--
Stefan Kuhn M. A.
Cologne University BioInformatics
relation two
tables make sense, but then your FK can't be unique.
Stefan
Am Wednesday 15 June 2005 12:41 schrieb Asad Habib:
As a follow up to my question, I did want to mention that the foreign key
I am using is unique.
- Asad
--
Stefan Kuhn M. A.
Cologne University BioInformatics
@lists.mysql.com
Subject: Re: Primary and Foreign Keys (Follow Up)
Hello. I appreciate your input. To clarify, I will provide you with an
example:
I have a table called business and another one called
food_business. The
field business_id is a primary key of table business and a
foreign key of
table
Don Stefani wrote:
Hello,
I am trying to import a table structure from ver 3.23.52 to ver
4.1.7-max and I am getting an error:
--- error -
|#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
I'd like to ask some questions regarding a work-around
for
bug #861, a configure problem preventing installation
on mac os x.
Status on bug is currently Need Feedback. Any
suggestions on
how to route questions to bug author and/or the
developer?
Thanks.
Ron
You could select the Add Comment tab on the bug report to add feedback, if
you wish, but that bug report is a year old, and it's for version 4.0.13. I
cannot be 100% certain, but I'd bet that it was the same bug I reported on
this list for 4.0.15, which was fixed in 4.0.16. You can read the
What amount of time is reasonable to expect for indexing an FK int field on
a simple table with about 30K records. It's running on my learning
machine -- an aging Pentium 5/133 box running RH 8 which is ordinarily
quite fast enough for my purposes. It's been running about six hours now,
and
things...),
then it's not hung. Just sit and wait. :-)
Matt
- Original Message -
From: D. R. Hansen
Sent: Wednesday, October 15, 2003 3:39 PM
Subject: ALTER TABLE z ADD INDEX... Speed: Follow up to LEFT JOIN
question
What amount of time is reasonable to expect for indexing an FK int
PM
Subject: ALTER TABLE z ADD INDEX... Speed: Follow up to LEFT JOIN
question
What amount of time is reasonable to expect for indexing an FK int
field on
a simple table with about 30K records. It's running on my learning
machine -- an aging Pentium 5/133 box running RH 8 which is ordinarily
I'm having this error and am not sure what's causing it. I'm using PHP/MySQL and
Apache on Windows XP.
I've looked at my server, user, password settings and they seem to be accurate, but
the error seems to indicate this is the problem.
Any help would be appreciated.
context ... I had proposed writing a new backend for mysql
tailored to read only very large and very wide (lots of columns)
tables (14G + )
in which queries never involved more than a small percentage
of the available columns (i.e. 5%) and often lacked WHERE
clauses.
A couple years ago I argued
Paul Flint [EMAIL PROTECTED] wrote:
Hello,
I have a bunch of text with Japanese in it that uses shift_jis encoding.
My initial tests show that this encoding has the same problems in MySQL
as it does in Perl: it gives false matches.
Joel Rees [EMAIL PROTECTED] wrote:
Have you
Andrew,
Tuesday, April 30, 2002, 5:33:27 AM, you wrote:
AW Thank you very much for the leads. I looked at the section in the manual
AW and still have a few questions (I have added some more info which might
AW help).
AW As a reminder my problem was ...
AW I have a DELETE statement:
AW
Victoria, et. al,
Thank you very much for the leads. I looked at the section in the manual
and still have a few questions (I have added some more info which might
help).
As a reminder my problem was ...
AW I have a DELETE statement:
AW delete bond_master,bond_data from bond_data where
AW
Message-
From: Andrew Wax [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 10:33 PM
To: [EMAIL PROTECTED]
Cc: Victoria Reznichenko
Subject: Follow-up DELETE ISSUE
Victoria, et. al,
Thank you very much for the leads. I looked at the section in the manual
and still have a few questions (I
One thing did occur to me though. I was looking at the syntax for
actually creating a database on the mysql server. I wanted to make sure
that those table types that are installed with mysql do not have to be
specified as _available_ to tables in a particular database. In other
words, when a
Hello,
On the same database, this query works:
$SQL_Exec_String = INSERT INTO Multimedia (Titolo,Descrizione,Logo,Link)
VALUES ('prova titolo','prova descrizione','.gif','prova link');;
$cur= odbc_exec( $cnx, $SQL_Exec_String );
This one gives this error:
ISQL_exec_String = Insert Into
Subject: [PHP] FOLLOW UP on column names not liked by odbc/php/access
Hello,
On the same database, this query works:
$SQL_Exec_String = INSERT INTO Multimedia (Titolo,Descrizione,Logo,Link)
VALUES ('prova titolo','prova descrizione','.gif','prova link');;
$cur= odbc_exec( $cnx
OOPS...
of couse the query below doesn't work, it doesn't have the table name
(see below however)
ISQL_exec_String = Insert Into (Artista, Opera, Label, Anno, Nazione,
CDNow, Autore, AutoreNome, Genere, GenereCustom, SulWeb, Autorizzato,
Unico, VALUES ('prova2', 'inedita', 'ignota',
hi,
in your sql command there are several errors:
it has the form
INSERT INTO (list of fieldnames)
VALUES (list of values);
but:
- there are more items in the list of values than in the list of
fieldnames. these lists should match.
- there's an extra comma after fieldname 'unico', and the
On Wednesday 05 December 2001 12:21, Dr. Michael Wittmann wrote:
- you dont need apostrophes for numeric fields. you get the table
definition using sql command 'DESC tablename'
Thanks to Michael and all the others who pointed out my errors. The query
works now. The real problem however,
Integration Technology Providers
-Original Message-
From: mweb [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 6:44 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP] Re: FOLLOW UP on column names not liked by
odbc/php/access
On Wednesday 05 December 2001 12:21
Hi all,
I have now managed to execute the configure script without any errors.
However, the Makefile generated still contains errors? Again, has anyone
ever managed to build and install myODBC under Irix? Any thoughts is
appreciated... thanks!
bypass spam filter: sql, mySQL, table,
25 matches
Mail list logo