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,
code
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 commands
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
: 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 happens on both my Windows and Linux versions
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
: 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 happens on both my Windows and Linux
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
: 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 Linux versions of MySQL. Any
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
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
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
$ 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
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
: Tuesday, July 08, 2003 5:26 PM
To: [EMAIL PROTECTED]
Subject: Re: MySQLDriverCS Data Typing problem in tables
I don't know anything about MySQLDriverCS but if you continue to have
problems, you might try my provider at www.bytefx.com
Reggie,
You've ended a week's worth of frustration
I don't know anything about MySQLDriverCS but if you continue to have
problems, you might try my provider at www.bytefx.com
Reggie,
You've ended a week's worth of frustration for me! Thanks a million! You've
got a great product, even if it's not a release version yet!
FYI, I only had to
I'm really hoping someone here can at least point me in a new direction.
For background, I'm using MySQLDriverCS and C# in
VS.NET 2003.
I can create the connection, read in data, and even display it fine. The
problem I'm encountering is that everything is typed as a string, even
though it may
: MySQLDriverCS Data Typing problem in tables
I'm really hoping someone here can at least point me in a new direction.
For background, I'm using MySQLDriverCS and C# in
VS.NET 2003.
I can create the connection, read in data, and even display it fine. The
problem I'm encountering
PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table type)
I have discovered a performace issue when joining several tables together.
The performance is extremely poor when performing select queries using the
WHERE clause and joining the tables with the pk_media_id =
change to make it quicker.
-Original Message-
From: Joseph Dietz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 10:40 AM
To: [EMAIL PROTECTED]
Subject: Severe performace problem linking tables with
mysql
PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table
Joseph Dietz wrote:
MediasMediaAuthorsAuthors
pk_media_id fk_media_id, fk_author_id pk_author_id
In your table definition, is there an index on each of your keys shown
above? What kind of performance 'degredation'? How many values are you
Hi.
On Wed 2002-12-18 at 18:40:04 +, [EMAIL PROTECTED] wrote:
PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table type)
I have discovered a performace issue when joining several tables together.
The performance is extremely poor when performing select queries using
sec)
From: Benjamin Pflugmann [EMAIL PROTECTED]
To: Joseph Dietz [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Severe performace problem linking tables with mysql
Date: Wed, 18 Dec 2002 22:22:00 +0100
Hi.
On Wed 2002-12-18 at 18:40:04 +, [EMAIL PROTECTED] wrote:
PLATFORM: 3.23.52
: Severe performace problem linking tables with mysql
PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table
type)
I have discovered a performace issue when joining several tables
together.
The performance is extremely poor when performing select queries using
the
WHERE clause
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
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
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
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?
HEllo!
Is it possible to create a merge table for
tables from different databases.
I wrote this script for database collection:
CREATE TABLE dict
(
url_id int(11) DEFAULT '0' NOT
NULL,
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 |
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
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
31 matches
Mail list logo