CTED]
Sent: Monday, February 12, 2001 1:21 AM
Subject: Re: CREATE TABLE / Telnet (Linux / Unix server)
Check the structure of txt file. Does it created with SELECT ... INTO
OUTFILE? Check command syntax.
- Original Message -----
From: Joel Holtzman [EMAIL PROTECTED]
To: Nielsen [EMAIL
I've had questions about this too. What happens if I have a primary key, and
the text file has the columns that are in the existing table, with records.
And I want to insert them. How do I get rid of that duplicate error? I read
the manual, about 'ignore' but I can't get it to work.
Any ideas?
Hello, I'm looking at the manual, and I cannot find the answer to this simple question.
What is the datatype in mysql for boolean? In Access it's yes/no.
What about mysql?
Thanks
Joel
Hello, I always wanted a gui interface to use on my win 98 pc to connect to mysql, and
create/edit tables. However, i always get an access denied error, saying I'm not
allowed to connect to the mysql server.
However, via telnet, I am fine.
The support for the software sucks, and all the
Hello, I noticed that while access databases use 'memo' mysql does not. It
uses blob. Anyway, I used it for a discussion board, and it stores messages,
but it won't display on my web page via asp.
It would work via access using 'memo' not 'text'.
So what conditions apply when
Hello, what is the correct syntax forignore?
I have a table with columsn already put in, and primary key has 0 as value.
When I do "load data infil 'file.txt'...
it gives a duplicate error. Documentation says to use 'ignore'. But I can't get it to
work.
What is the *correct* syntax to load a
Hello, via telnet with mysql server on linux, I try to delete a table, but it won't
work. I'm browsing the documentation, I can't see what will work. I can do this via
asp, but I'd love to know the command for something that should be as simple as
mysql Delete (tablename) from (Database name);
Thank you, I learned that I needed:
Drop *table* tablename
Thanks for your help, guys. I appreciate it
Joel
- Original Message -
From: [EMAIL PROTECTED]
To: Joel Holtzman [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, February 02, 2001 3:51 PM
Subject: Re: Deleting table
Hello, I have one question about the 'load data' function.
Below is the what I have for 'actor.txt' for a text file I want to load to table
'actor'
| ID | fFirst | Last