I recall there is a command that will display suggested optimal columns
types for a given table based on the data stored in the table, but I haven't
been able to figure out what it is.
Help!
Thanks.
Ben Wiechman
Wisper High Speed Internet
[EMAIL PROTECTED]
Search the manual and the web for PROCEDURE ANALYSE() and some examples
of how to use it. (It's not obvious how to get good results). I think
Ronald Bradford has a good blog post on it.
Benjamin Wiechman wrote:
I recall there is a command that will display suggested optimal columns
types
SELECT * FROM tablename PROCEDURE ANALYSE()
Anyone know of a way to get the size of a row in bytes?
-Original Message-
From: Benjamin Wiechman [mailto:[EMAIL PROTECTED]
Sent: 24 August 2007 16:18
To: mysql@lists.mysql.com
Subject: Column type suggestions
I recall there is a command
We use float. I have no idea if that's better or worse, but that's what we use.
-Sheeri
On 4/26/06, René Fournier [EMAIL PROTECTED] wrote:
Just curious the majority use. I've been using decimal(18,14), but
that appears bigger than necessary... Maybe varcar(21) for latitude,
and varchar(22)
I worked on a system years ago that used binary encoded integer for
latitude longitude.
The Most Significant Bit (MSB) was a sign bit ( + or -).
The next bit was 180 degrees
The next bit was 090 degrees
The next bit was 045 degrees.
etc
Functions were written to transform these into human
Just curious the majority use. I've been using decimal(18,14), but
that appears bigger than necessary... Maybe varchar(21) for latitude,
and varchar(22) for longitude?
...Rene
Just curious the majority use. I've been using decimal(18,14), but
that appears bigger than necessary... Maybe varcar(21) for latitude,
and varchar(22) for longitude?
...Rene
But what about size. I reffered MySQL manual for 5.0, but didn't find
that what is he maximum size of binary data we can store in such
column.
Please help
Thanks and regards,
CPK
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: Re: Right column type for OLE objects
But what about size. I reffered MySQL manual for 5.0, but didn't find
that what is he maximum size of binary data we can store in such
column.
Please help
Thanks and regards,
CPK
--
MySQL General Mailing
Dear friends,
I need to store OLE objects such as Word, Excel OpenOffice, Autocad
documents in the database. Which will be the correct column type for
it?
Thanks and regards,
CPK
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
I'm using the MySQL 5.0.15 client to a 5.0 server all 32-bit windows.
It appears that the UNSIGNED_FLAG is being returned for column types of
timestamp.
Checking the flags variable of the MYSQL_FIELD structure indicates that the
following flags are returned:
Field-flags = 1249
NOT_NULL_FLAG
Subject: Re: Column type problem
As seen in manual there's no exact data type for your kind of data:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-type-overview.html
see also:
http://dev.mysql.com/doc/refman/5.0/en/column-types.html
so you can:
1. Use 1 timestamp column and 1 INT column just
As seen in manual there's no exact data type for your kind of data:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-type-overview.html
see also:
http://dev.mysql.com/doc/refman/5.0/en/column-types.html
so you can:
1. Use 1 timestamp column and 1 INT column just for milliseconds
2. Use BIGINT
Title: Column type problem
I am trying to create a table to import data on cpu usage based on certain programs. the following is a sample of the data. When I import into the tables their is no field type that matches up to this type of time data. The field type (time) is close
Hi ,
I using MySql from Visual Foxpro cross over ODBC 3.51 .
When I run a SELECT statement then the DECIMAL 15,0 MySql field arrived to
Foxpro as Currency type with 4 digits decimals!
The data not lost (15 digits long) but ,the decimals set to 4 and column type
is Currency .
I must always
Hi ,
More column type problem ...The MySql Text fields arrived as General (not
readable) field in VFP via ODBC...
By: Zoltan
- Original Message -
From: Szmutku Zoltán
To: mysql@lists.mysql.com
Sent: Monday, October 24, 2005 10:36 AM
Subject: column type problem
Hi ,
I using
Hi,
I have a column 'id' within a table :
CREATE TABLE `reference` (
*`*id*`* smallint(5) unsigned NOT NULL auto_increment,
`study_name` text,
`author` text NOT NULL,
`date` date NOT NULL default '-00-00',
`reference` varchar(250) NOT NULL default '',
`title` varchar(250) NOT NULL
It looks from googling as though I need to drop all foreign key
constraints on this column, perform the change and then reestablish the
foreign keys. Could anyone confirm or advise of a better solution?
That is the way ! :)
You need to drop the constrains...
Alter `reference` and make `id` INT
Gabriel PREDA [EMAIL PROTECTED] wrote on 03/16/2005 06:12:14 AM:
It looks from googling as though I need to drop all foreign key
constraints on this column, perform the change and then reestablish the
foreign keys. Could anyone confirm or advise of a better solution?
That is the way ! :)
. What is the correct column type to use to get
update3_time to contain day and time in the form MMDDhhmmss? Is
there a fuction or something to use in place of SOMETHING in the query?
Jason Joines
=
--
MySQL General Mailing List
For list archives: http
a TIMESTAMP field.
However, since you said that you didn't want to have the date changed each
time the record was updated that eliminates the TIMESTAMP as a possible
column type. Since it's quite frustrating to decipher formatted strings
(especially when you want to determine differences between two
another column changes. What is the correct column type to use to get
update3_time to contain day and time in the form MMDDhhmmss? Is
there a fuction or something to use in place of SOMETHING in the query?
the correct column type is DATETIME.
http://dev.mysql.com/doc/mysql/en
for the file chunk and looks like 0x2e04b273
The equivalent column type in MySQL would be an UNSIGNED INTEGER for
both of these.
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
offset ..
In C it is a UNSIGNED LONG and looks like : 0x2528
the second colun is a CRC for the file chunk and looks like 0x2e04b273
The equivalent column type in MySQL would be an UNSIGNED INTEGER for
both of these.
--
Roger
--
MySQL General Mailing List
For list archives: http
Hi ALL,
I have an application that reads files converts them and then inserts
them into a database. It has 2 columns that I need help with.
First is the OFFSET column - this stores the datafile offset ..
In C it is a UNSIGNED LONG and looks like : 0x2528
the second colun is a CRC for the
What is 'binary' in column type stand for?
is it describe how the data is stored (in biner value)?
what do we want use it for?
- encryption ?
- space efficiency ?
- fast index ?
- or ?
I've searched the mysql manual but didn't find any clue about it
thanks for your help before
Chenri J [EMAIL PROTECTED] wrote on 26/11/2004 10:52:51:
What is 'binary' in column type stand for?
is it describe how the data is stored (in biner value)?
what do we want use it for?
- encryption ?
- space efficiency ?
- fast index ?
- or ?
I've searched the mysql manual
What is 'binary' in column type stand for?
is it describe how the data is stored (in biner value)?
what do we want use it for?
- encryption ?
- space efficiency ?
- fast index ?
- or ?
AFAIK it's used for determining the behaviour while comparing values
(operators, sorting, etc
At 2:52 -0800 11/26/04, Chenri J wrote:
What is 'binary' in column type stand for?
is it describe how the data is stored (in biner value)?
what do we want use it for?
- encryption ?
- space efficiency ?
- fast index ?
- or ?
I've searched the mysql manual but didn't find any clue about
i am sort of confused about the SET column type... is there any place that
i
can go that will give a better example of it and how to use/create it than
the manual does??
If you read the user comments on the manual page
(http://dev.mysql.com/doc/mysql/en/SET.html) you'll see loads of examples
hi..
i am sort of confused about the SET column type... is there any place that i
can go that will give a better example of it and how to use/create it than
the manual does??
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Don't quote me on this but I don't think it makes a difference what
datatypes you use with multiple languages (I never even considered it with
English, Japanese and Korean) as long as the field is large enough to handle
the multiple bytes. You might wish to check out the Unicode support pages
Hello !
I am not very sure about this, and so, this could be viewed as a dumb newbie question.
I need to add various data in different languages into mysql. The data includes
characters such as A`WmdV², JÆÁõu, ÁÈøÓ uÁÔ¯, ÃnõÚ, ö£õ´¯õÚ,£¯ÚØÓ , etc.
Later, on a web page, people would
I've seen a number of references to the Too many columns error, but I'm
encountering something that appears to be different.
Basically, I'm trying to change a single column in a table (that has 20
columns) from VARCHAR(255) to ENUM(...) where the enum list contains about
900 entries, each a
no problems that i see.
- Original Message -
From: p shah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 03, 2003 12:23 PM
Subject: Mysql Date column type
Hi,
I have one question regarding date column type in
MYSQL.
Can I use the column type for date
Hi,
But will the search be any faster using Integer or
BigInt column type compared to using Date or DateTime
columnd type.
Regards,
--- Nitin [EMAIL PROTECTED] wrote:
no problems that i see.
- Original Message -
From: p shah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent
On Tue, 2 Dec 2003 22:53:47 -0800 (PST) p shah [EMAIL PROTECTED]
wrote:
What are the pros and cons for using Integer column
type for the date?
Please reply at the earliest.
Well there are *some* drawbacks but I dunno if they apply to you. For
instance, using PHP, when I do a select
Hi,
I have one question regarding date column type in
MYSQL.
Can I use the column type for date as Integer instead
of DateTime or Date to store the date as
mmddhhmmss or mmdd?
As I know MYSQL accepts this format. But I am not too
sure about the column type.
What are the pros and cons
: Ron McKeever [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 10:31 PM
To: [EMAIL PROTECTED]
Subject: Column type
Hi
I have a .txt file that is loaded into my table. This is done using LOAD
DATA INFILE One of the columns data is a unix timestamp from the
.txt file. The column
Hi
I have a .txt file that is loaded into my table. This is done
using LOAD DATA INFILE
One of the columns data is a unix timestamp from the .txt file.
The column is called begin.
I have created the column as a varchar before
and then converted the date using FROM_UNIXTIME(), so it can be
-Original Message-
From: John Hicks [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 22:03
To: Rudy Metzger; [EMAIL PROTECTED]
Subject: Re: Best practice column type for storing decimal currency
amounts?
Thanks for the reply, Rudy.
My source for the statement that decimal values
PROTECTED]
Subject: Best practice column type for storing decimal currency amounts?
Is there an accepted best practice on whether to store
decimal currency amounts (e.g. dollars and cents) in MySQL
decimal column types?
Certainly, the most straightforward way is to use decimal
columns
PROTECTED]
Sent: dinsdag 15 juli 2003 21:39
To: [EMAIL PROTECTED]
Subject: Best practice column type for storing decimal
currency amounts?
Is there an accepted best practice on whether to store
decimal currency amounts (e.g. dollars and cents) in
MySQL decimal column types?
Certainly
On 16 Jul 2003 at 16:02, John Hicks wrote:
Thanks for the reply, Rudy.
My source for the statement that decimal values are stored
as strings is:
http://www.mysql.com/doc/en/Numeric_types.html :
DECIMAL values may very well be stored as strings, but presumably
you're going to do some
Is there an accepted best practice on whether to store
decimal currency amounts (e.g. dollars and cents) in MySQL
decimal column types?
Certainly, the most straightforward way is to use decimal
columns. But it appears that such values are stored as
ASCII strings, which would be inefficient
Has anyone got a way to implement column type 'serial' in a innodb table?
-jpg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
John Griffin wrote:
Has anyone got a way to implement column type 'serial' in a innodb table?
-jpg
int unsigned not null auto_increment
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922
I'm actually doing the same thing. I settled on using TEXT, which allows
you to store a little over 65,000 bytes. Any resume longer than 65,000
characters really needs to be made shorter since that works out to
probably about 20 pages.
As an aside, I don't know which version of MySQL you are
probably go with the LONGTEXT, too.
HTH,
Tore.
- Original Message -
From: Tom Ray [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 11:28 AM
Subject: Column Type help
Hey there, I'm kinda new to using mysql to its full potential and I was
wondering something
Thanks for the help everyone, I'm gonna try the longtext approach and see
how that works for me.
-Original Message-
From: Tore Bostrup [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Wed, 26 Feb 2003 12:06:34 -0500
Subject: Re: Column Type help
The only two considerations I can think
I've bene trying to find info on how efficient queries are for the SET
datatype, specifically, how does
MySQL use indexes for SET column types.
I have looked in the O'Reilly MySQL Reference Manual, and at mysql.com and
have found effectively nothing on this subject.
For example, if i have a table
to datetime, and that breaks A LOT of formatting work I had done
previously when I thought I was only going to be able to keep with a
timestamp column type.
Could someone suggest a replacement query for the one above, where I would
not have to change my datetime column from timestamp to datetime
had to change my datetime_col column from
QL timestamp to datetime, and that breaks A LOT of formatting work I had done
QL previously when I thought I was only going to be able to keep with a
QL timestamp column type.
QL Could someone suggest a replacement query for the one above, where I would
QL
to datetime, and that breaks A LOT of formatting work I had done
previously when I thought I was only going to be able to keep with a
timestamp column type.
Could someone suggest a replacement query for the one above, where I would
not have to change my datetime column from timestamp to datetime
, and that breaks A LOT of formatting work I had done
previously when I thought I was only going to be able to keep with a
timestamp column type.
Could someone suggest a replacement query for the one above, where I would
not have to change my datetime column from timestamp to datetime?
Strange indeed
' for key 1
AK but
AK mysql SELECT * FROM settest WHERE FIND_IN_SET('C,A', chain)0;
AK Empty set (0.00 sec)
AK I guess it can be a bug.
It's not a bug, it's a behaviour of a SET column type.
When you INSERT C,A in the settest, this value will be re-ordered to
A,C at first. As chain can contain
mysql CREATE TABLE settest( chain SET( A, B, C ) NOT NULL,
UNIQUE INDEX ichain( chain ) );
mysql INSERT INTO settest SET chain=A,C;
mysql SELECT * from settest;
+---+
| chain |
+---+
| A,C |
+---+
mysql SELECT * FROM settest WHERE chain=A,C;
Gurus
I'm having trouble understanding the column type SET.
To explain my problem, I'll create a table, populate
it, and do selects.
mysql CREATE TABLE settest( chain SET( A, B, C ) NOT NULL,
UNIQUE INDEX ichain( chain ) );
mysql INSERT INTO settest SET chain=A,C;
mysql
,A', chain)0;
Empty set (0.00 sec)
I guess it can be a bug.
-Original Message-
From: Lopez David E-r9374c [mailto:r9374c;motorola.com]
Sent: Thursday, October 24, 2002 5:09 PM
To: Mysql List (E-mail)
Subject: Understanding MySQL column type SET
Gurus
I'm having trouble understanding
Dear friends,
I am developing a database application for our saleses
with PHP and MySQL.
Our sales must call the customers on time. They may
not be late to call the customers. The may not miss
the appointment to meet the customer on the telephone
line.
But I have a problem to implement
On 21-Oct-2002 Prabu Subroto wrote:
Dear friends,
I am developing a database application for our saleses
with PHP and MySQL.
Our sales must call the customers on time. They may
not be late to call the customers. The may not miss
the appointment to meet the customer on the
Dear friends,
I am developing a database application for our saleses
with PHP and MySQL.
Our sales must call the customers on time. They may
not be late to call the customers. The may not miss
the appointment to meet the customer on the telephone
line.
But I have a problem to implement the SQL
Dear friends,
I am developing a database application for our saleses
with PHP and MySQL.
Our sales must call the customers on time. They may
not be late to call the customers. The may not miss
the appointment to meet the customer on the telephone
line.
But I have a problem to implement the SQL
Hi,
I have a question about indexing a column of type SET. It seems that
generally the index is not too useful, since it always requires some
sort of expression to get what you want out of the set, and therefore
the index won't be used.
Example:
create table FOO (BAR
there). You can easily test
for yourself by trying
SELECT FIND_IN_SET( 1, -5,0,1,4,5, )
that it not even requires a column.
The thing is, I cannot make it set column-type, since I have no idea
what values it will be holding, but at the same time it will be
comma seperated list of integers. So I'll
Hi there,
I have a user table with lots of different column types. Now I do experiance
problems filtering out special date. The performance is really bad.
So maybe I did just pick the wrong column types?!
This is what I picked so far:
| Type | Null | Key | Default | Extra
|
Alex Vandiver writes:
Heya,
I've managed to repeatably crash mysqlgui by running a query that
returns a column of type year. Though it dumps core, gdb does not
provide a useful stack trace. Though this is not a serious bug, it is a
bit of an annoyance.
- Alex Vandiver
--
Heya,
I've managed to repeatably crash mysqlgui by running a query that
returns a column of type year. Though it dumps core, gdb does not
provide a useful stack trace. Though this is not a serious bug, it is a
bit of an annoyance.
- Alex Vandiver
--
Networking -- only one letter away from
Is a boolean column type possible in mysql? If not, what's the
most common
column type for true/false (or true/false/null) flags?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_16_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk
Is a boolean column type possible in mysql? If not, what's the most common
column type for true/false (or true/false/null) flags?
Thanks,
Chris
-
Before posting, please check:
http://www.mysql.com/manual.php
It occurred to me that a column type that functioned similar to timestamp
but for the id of user initiating the update would be very useful. What I
mean is a column that would automatically capture the userid that last
changed a row, much as a first timestamp column is automatically updated
Rich Bartell writes:
It occurred to me that a column type that functioned similar to timestamp
but for the id of user initiating the update would be very useful. What I
mean is a column that would automatically capture the userid that last
changed a row, much as a first timestamp column
Sinisa Milivojevic writes:
Rich Bartell writes:
It occurred to me that a column type that functioned similar to timestamp
but for the id of user initiating the update would be very useful.
No, no plans. This feature is very easy to implement in the
application program
Attila Soki wrote:
hi,
please help me... i can't understand why are my doubles incorrect.
create table test (dnum double(20,5));
insert into test values(8998);
insert into test values(8998.0001);
insert into test values(898.0001);
insert into test
Fax: +49-30-46307-388
- Original Message -
From: Attila Soki [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 08, 2001 12:44 AM
Subject: double column type why...
hi,
please help me... i can't understand why are my doubles incorrect.
create table test (dnum double
?
Hi !
Can you send me the ODBC trace ?
Thanks in advance
venu
-Original Message-
From: Adam Douglas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 10:52 AM
To: '[EMAIL PROTECTED]'
Subject: Access to MySQL Column Type Error
I'm trying to do an append query
]
CC: [EMAIL PROTECTED]
Subject: Re: Cannot change column type from varchar(32) to char(32)
Date: Wed, 1 Aug 2001 17:08:06 -0500 (CDT)
It might depend on the other columns in your table definition. Have
you
looked at the Silent Column Specification Changes?
http://www.mysql.com/doc/S/i
Hi !
Can you send me the ODBC trace ?
Thanks in advance
venu
-Original Message-
From: Adam Douglas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 10:52 AM
To: '[EMAIL PROTECTED]'
Subject: Access to MySQL Column Type Error
I'm trying to do an append query in Access
went wrong, and if I create
a little play table I can succesfully change the column type to char(32) from
varchar(32).
The table branch has just 180 rows in it.
I'd like to change the column types from varchar to char to speed up queries
etc.
Can anybody shed any light on what I'm doing wrong
(32) - but the type does not change to
char(32).
There's no error message or other indication of what went wrong, and if I create
a little play table I can succesfully change the column type to char(32) from
varchar(32).
The table branch has just 180 rows in it.
I'd like to change
).
There's no error message or other indication of what went wrong, and if I
create
a little play table I can succesfully change the column type to char(32) from
varchar(32).
The table branch has just 180 rows in it.
I'd like to change the column types from varchar to char to speed up queries
From: j.urban [EMAIL PROTECTED]
To: Lezz Giles [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Cannot change column type from varchar(32) to char(32)
Date: Wed, 1 Aug 2001 17:08:06 -0500 (CDT)
It might depend on the other columns in your table definition. Have you
looked at the Silent
I've been having some problems with currency calculations in SQL queries.
I've been using Double, but often get some very small rounding errors. What
is the recommended column type for currency in MySQL?
Aaron
-
Before
convert everything to pennies and use integers?
Aaron Clausen wrote:
I've been having some problems with currency calculations in SQL queries.
I've been using Double, but often get some very small rounding errors. What
is the recommended column type for currency in MySQL?
Aaron
On 05-Jun-01 Aaron Clausen wrote:
I've been having some problems with currency calculations in SQL
queries.
I've been using Double, but often get some very small rounding
errors. What
is the recommended column type for currency in MySQL?
DECIMAL(9,2)
Regards,
--
Don Read
Hello all!
Does MySQL have a function that converts an IP address from dotted decimal to binary,
and back
again?
Jason Bell
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Jason Bell wrote:
Hello all!
Does MySQL have a function that converts an IP address from dotted decimal to
binary, and back
again?
Jason Bell
INET_NTOA
INET_ATON
I'll leave it as an exercise to you to read Manual Chapter 7.4.12.
I had a column that was set to varchar(50) which ended up not being enough
space. So I went in and did a:
alter table main change description description varchar(255) not null;
It said everything went ok, I reimported the text file, but the words stop
after 50 characters still did I miss
You are expecting an awfull lot from mysql to remember data that it never
recorded. When you inserted something into the varchar(50) column that was
longer than 50 it dropped the rest of the string that would not fit.
Changing the column size will not bring back the data.
ryan
I had a column
I reimported the text file which should overwrite the data right which
did not work. If not how do I overwrite the data?
You are expecting an awfull lot from mysql to remember data that it
never
recorded. When you inserted something into the varchar(50) column that
was
longer than 50 it
: Changing column type
I reimported the text file which should overwrite the data right which
did not work. If not how do I overwrite the data?
You are expecting an awfull lot from mysql to remember data that it
never
recorded. When you inserted something into the varchar(50) column
I found a problem with MyODBC when linking tables to Access97. It considers
DECIMAL type as TEXT (and you know you can't change that without going into
code). I changed the column type into FLOAT and it fixed the problem, but
at the same time it would be nice if MyODBC either gave you a choice
Description:
There is a _severe_ problem when dealing with "timestamp" column: if I update
a column, also other columns are affected! I enclose a sample script to
show the problem
How-To-Repeat:
create table a(t1 timestamp, t2 timestamp);
insert into a values("2001-01-20","1999-03-04");
select *
Description:
There is a _severe_ problem when dealing with "timestamp" column: if I update
a column, also other columns are affected! I enclose a sample script to
show the problem
How-To-Repeat:
create table a(t1 timestamp, t2 timestamp);
insert into a values("2001-01-20","1999-03-04");
select *
At 12:31 AM -0100 2/2/01, [EMAIL PROTECTED] wrote:
Description:
There is a _severe_ problem when dealing with "timestamp" column: if I update
a column, also other columns are affected! I enclose a sample script to
show the problem
How-To-Repeat:
create table a(t1 timestamp, t2 timestamp);
MySQL always updates the first timestamp column on update, regardless.
-Original Message-
From: Alex Dusty [mailto:[EMAIL PROTECTED]]
Sent: February 1, 2001 7:28 PM
To: [EMAIL PROTECTED]
Subject: Severe problem in handling timestamp column type
Description:
There is a _severe_
96 matches
Mail list logo
