Re: IDE

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 bas

Re: Stored Procedure Data Types

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

Re: Date Time

%Y')); mysql> select * from t; +-+ | 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? >

Re: load data into temporary table

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 se

Re: If condition in select query / insert /update

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 | hig

Re: Inserting a default null date

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) values('20

Re: Unix compress equivalent

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> \

RE: Oracle , what else ?

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

RE: Oracle , what else ?

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 M

mysql_upgrade not running mysql_check: Access denied for user 'root'@'localhost'

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 --check-up

Duplication in sles9 for my.cnf

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,

Re: Synchronizing a remote database with a local database

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 o