Have you tried SQL Developer? It works great with Oracle and also
supports MySQL,
http://www.oracle.com/technology/products/database/sql_developer/files/what_is_sqldev.html
Cheers,
-Janek
On Tue, 2009-06-09 at 19:40 +0300, Mosaed zamil wrote:
Hello all,
I used Database Workbench on trial
;
+-+
| d |
+-+
| 2009-05-21 03:15:28 |
+-+
1 row in set (0.01 sec)
On Thu, 2009-05-21 at 15:19 -0600, John Meyer wrote:
Is Thu May 21 03:15:28 + 2009 a valid date/time string?
--
Best Regards,
-Janek Bogucki, CMDEV 5.0.
StudyLink
Hi,
Use a temporary table to store the ids and join to it for the final
update? That will at least avoid an error when the cursor selects zero
records.
Cheers,
-Janek
On Wed, 2009-05-20 at 16:05 -0400, W. Scott Hayes wrote:
Hello,
I would like to do a select on a table to get back the IDs
Hi,
mysql create temporary table t(i int);
mysql \! echo 1 /tmp/data.txt
mysql load data infile '/tmp/data.txt' into table t;
Query OK, 1 row affected (0.00 sec)
Records: 1 Deleted: 0 Skipped: 0 Warnings: 0
mysql select * from t;
+--+
| i|
+--+
|1 |
+--+
1 row in set
Hi,
mysql create table t(i int);
mysql insert into t values(1),(2),(3);
mysql select i, if(i = 1, 'low', 'high') from t order by i;
+--+---+
| i| if(i = 1, 'low', 'high') |
+--+---+
|1 | low |
|2 | high
Hi Octavian,
One approach is to use a trigger,
mysql set sql_mode = '';
mysql create table temp_date(d date default null);
mysql create trigger temp_date_bi before insert on temp_date for each row set
new.d = if(new.d = '-00-00', null, new.d);
mysql insert into temp_date(d)
Hi Olaf,
If you only need to compress the column *while* loading it from the csv file
then use load data infile with a user variable to do the compression at load
time,.
mysql create table t(uncompressed varchar(4000), compressed varbinary(1000));
Query OK, 0 rows affected (0.07 sec)
mysql \!
On Thu, 2009-04-23 at 17:58 +0100, Gabriel - IP Guys wrote:
The real question is whether they will let MySQL
wither
and die by not providing updates for it?
Well, MySQL is open source, right? And the source is available? I'm
sure
a team of devs will come to the rescue. As for MySQL, as
On Thu, 2009-04-23 at 17:58 +0100, Gabriel - IP Guys wrote:
The real question is whether they will let MySQL
wither
and die by not providing updates for it?
Well, MySQL is open source, right? And the source is available? I'm
sure
a team of devs will come to the rescue. As for MySQL, as
Hi,
When I try mysql_upgrade I get a connection problem,
$ mysql_upgrade -p
Enter password:
/usr/bin/mysqlcheck: Got error: 1045: Access denied for user
'root'@'localhost' (using password: YES) when trying to connect
Error executing '/usr/bin/mysqlcheck
Hi,
I have noticed in the man page for mysql from
MySQL-client-community-5.0.37-0.sles9.i586.rpm there is a repetition in
the my.cnf files read by mysql. I am wondering if this is at all
significant.
This is what man mysql shows for the
MySQL-client-community-5.0.37-0.sles9.i586.rpm install,
On Fri, 2007-03-16 at 18:43 +0900, Dave M G wrote:
MySQL Users,
I have a local website development environment where I have a master
MySQL database.
I have several web sites which use the exact same database structure.
The structure of the master database doesn't change very often, but
12 matches
Mail list logo