Hi
I have a database whose table has a column, which has a datatype longtext.
I then try a query
mysql> select MY_DATE from my_table where MLC_DATE between '09/22/2003' AND
'10/21/2
003';
I thought it would fail since the datatype isnt DATE nor TIMESTAMP.
But from the result, it seems to work.
1
Hi
1 - I have a column whose datatype is longtext. Its content is 08/06/2003;
I created a new column whose datatype is DATE. Its content is null now.
How do write a SQL statement that
inputs each row from 08/06/2003 in the
old column to 2003-08-06 in a new column ?
Eg:
old column name - my_date
ne
Hi
How do I rename a new column ?
How do I drop a column ?
>From MySQL documentation, it refers
to rename/drop table.
I dont want to do that.
Thanks Paul for your aid.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi
1- Is there a command to rename an existing database ?
2- If not, how does one create a new database from an existing database ?
could you show me the steps?
Any help is appreciated.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:/
Hi
I have a few tables in a database Z, namely
table
a
b
c
In table a, the columns are
my_date - longtext
num - int(11)
eg:
mysql> select * from a;
+--+--+--+
| my_date | x|
+--+--+
| 08/06/2002 |1 |
| 08/07/2002 |2 |
+--+--+--
Hi
1) Suppose, in a file, say testfile.sql,
it contains a line
eg:
LOAD DATA INFILE "mlc_stat_" INTO table mlc FIELDS TERMINATED BY '|' ;
And further suppose the record in file mlc_stat_ already exists in the
table mlc.
Does MySQL have the ability to stop inserting this duplicated record
Hi
1) Suppose, in a file, say testfile.sql,
it contains a line
eg:
LOAD DATA INFILE "mlc_stat_" INTO table mlc FIELDS TERMINATED BY '|' ;
And further suppose the record in file mlc_stat_ already exists in the
table mlc.
Does MySQL have the ability to stop inserting this duplicated record
> -Original Message-
> From: Wong Zach-CHZ013
> Sent: Wednesday, May 22, 2002 7:11 PM
> To: [EMAIL PROTECTED]
> Subject: Duplicate Record
>
> Hi
> 1) Suppose, in a file, say testfile.sql,
> it contains a line
> eg:
> LOAD DATA INFI
