IL PROTECTED]
Subject: Re: Problem with tables;
You need to do
desc spamdata;
NOT desc id.
Aman Raheja
Beauford wrote:
Hi,
I'm trying to create a table using the commands below, and everything
seems to work and the table is there - I just can's access any of the
fields. This happe
That's correct. You successfully created the table (you didn't get an
error message did you?) and neither wrote any records to nor changed any
records on the new table: "Query OK, 0 rows affected ..."
This format is more useful when you use the compound form of "CREATE
TABLE" that allows you to
ubject: Re: Problem with tables;
You need to do
desc spamdata;
NOT desc id.
Aman Raheja
Beauford wrote:
>Hi,
>
>I'm trying to create a table using the commands below, and everything
>seems to work and the table is there - I just can's access any of the
>fields. This h
You need to do
desc spamdata;
NOT desc id.
Aman Raheja
Beauford wrote:
Hi,
I'm trying to create a table using the commands below, and everything seems
to work and the table is there - I just can's access any of the fields. This
happens on both my Windows and Linux versions of MySQL. Any help is
app
Hi Beauford,
Try this:
desc spamdata ;
Regards,
Laercio Cavalcanti.
-Original Message-
From: Beauford [mailto:[EMAIL PROTECTED]
Sent: quinta-feira, 16 de setembro de 2004 01:19
To: [EMAIL PROTECTED]
Subject: Problem with tables;
Hi,
I'm trying to create a table using the com
>> CREATE TABLE spamdata (
>> id bigint(20) NOT NULL,
>> dates varchar(60) NOT NULL,
>> probe varchar(100) NOT NULL,
>> ip varchar(15) NOT NULL,
>> fqdnvarchar(100) NOT NULL,
>> reason varchar(100) NOT NULL,
>> portvarchar(2) NOT NULL
> Hi,
>
> I'm trying to create a table using the commands below, and everything
seems
> to work and the table is there - I just can's access any of the fields.
This
> happens on both my Windows and Linux versions of MySQL. Any help is
> appreciated. Note, I have 8 other databases that I created wit
ROTECTED]
Sent: September 16, 2004 12:19 AM
To: [EMAIL PROTECTED]
Subject: Problem with tables;
Hi,
I'm trying to create a table using the commands below, and everything seems
to work and the table is there - I just can's access any of the fields. This
happens on both my Windows and Lin
Hi,
I'm trying to create a table using the commands below, and everything seems
to work and the table is there - I just can's access any of the fields. This
happens on both my Windows and Linux versions of MySQL. Any help is
appreciated. Note, I have 8 other databases that I created with no proble
Johan Jonkers <[EMAIL PROTECTED]> wrote:
> and my table is marked crashed :-(
Please please upgrade to latest version (4.0.20) in binary format (download
from www.mysql.com) and check on it. Good chances are that everything will run
fine.
--
For technical support contracts, goto https://or
V. M. Brasseur wrote:
$> perror 145
Error code 145: Error 145 occurred.
145 = Table was marked as crashed and should be repaired
I think `myisamchk` needs to come into play here (both on slave and
master at this point).
Yea I know, and I had done that like a few days ago because it gave me
the s
$> perror 145
Error code 145: Error 145 occurred.
145 = Table was marked as crashed and should be repaired
I think `myisamchk` needs to come into play here (both on slave and
master at this point).
http://dev.mysql.com/doc/mysql/en/myisamchk_syntax.html
http://dev.mysql.com/doc/mysql/en/Repair.h
Hi,
I'm using mysql 4.0.12 and I got a database that holds the DMOZ data
(master/slave config). Now this is a (to me anyways) pretty big
database(4 million some links, with fulltext indexes). However I have a
problem with it. For some reasons I can't get a grip on, the table
crashes. (error 145
That is as high as an unsigned tinyint can go.
Change it to an int.
Tony Devlin wrote:
>I have a problem with MySQL. I am trying to insert data using INFILE, and
>it works, except that it ALWAYS stop at 255 (autoindex) and will not go any
>further, either by manual insert or textfile insert. I
Tony,
Friday, August 30, 2002, 1:35:16 AM, you wrote:
TD> I have a problem with MySQL. I am trying to insert data using INFILE, and
TD> it works, except that it ALWAYS stop at 255 (autoindex) and will not go any
TD> further, either by manual insert or textfile insert. I am running MySQL
TD> 3.2
Tony,
What data type is the "autoindex" field/column?
=dn
> I have a problem with MySQL. I am trying to insert data using INFILE, and
> it works, except that it ALWAYS stop at 255 (autoindex) and will not go
any
> further, either by manual insert or textfile insert. I am running MySQL
> 3.23
I have a problem with MySQL. I am trying to insert data using INFILE, and
it works, except that it ALWAYS stop at 255 (autoindex) and will not go any
further, either by manual insert or textfile insert. I am running MySQL
3.23.38-max-nt on a Windows 2000 Server.
Is this a known issue? something
No, I don't do such things, the 'replication' means only that I download
from an other machine some text files, with e-mail addresses and insert
them into the table. So no id nor other fields are replicated, just the
email field from a text file. (a perl script reads and inserts them).
The strang
If you are using 'replication', and trying to do bi-directional
replication, you will ( unless you are very careful ) have this problem.
The auto increment id is passed with the rest of the data to the slave.
If you are inserting on both masters and each assigns the same id, the
replication will
Hello!
I'm new at this list, but as far as I could search through the archives,
I didn't find the reason of my problem.
Here it is:
I manage a list of mailing-list members with approx. 8000 records in
this table:
+---+--+--+-+-++
| Field |
20 matches
Mail list logo
