need auto increment value

Hello Everybody, i want to read the latest value of a autoincrement column from a java program. How can i do this? i want to do this in a single query insertion, is it possible?

Can't create table (errno: 604)

Hi, I get this error when trying to create newtables in a cluster. I just created about 27 tables using ndbcluster-engine without a problem. trying to create any more tables fails with this error. anybody knows? thx -- Sebastian Mork [EMAIL PROTECTED] -- MySQL General Mailing List For list

How to build a single temporary table from 3 tables on the fly

Can someone help point me in the right direction for this. This isn’t exactly what I want but once I have the solution to this I can work out the permutations I need. How do I select from 3 tables into a single table (consequtive rows not joined ones) and include a two new columns which is the

Re: Can't create table (errno: 604) (occurs when trying to create a primary key)

I've now figured out that the error occurs when I try to create any table that has a primary key. creating tables without the primary key works. hmm.. is there any limitation in the mysql (ndb)-settings that I've to change? Its the standard-installation of 4.1.21-max... -- Sebastian Mork [EMAIL

Urgent plsss

Can anyone tell me how can I import the *.gra (oracle db file) files to Navicat or Acess. Pls let me know in steps as I am v new to this field. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query Help plss

Thank u so much. It woked now! - Original Message - From: Visolve DB Team [EMAIL PROTECTED] To: Visolve DB Team [EMAIL PROTECTED]; Renish [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Tuesday, October 10, 2006 1:42 PM Subject: Re: Query Help plss Hi, Hope this link will you.

Re: need auto increment value

Hello, you can do it in two ways I guess: one is to do a second select (which you don't want): SELECT LAST_INSERT_ID(). another way is to use java.sql.Statement.RETURN_GENERATED_KEYS when you create your Statement, something along these lines: java.sql.PreparedStatement pstmt =

Re: optimizing mySQL

Hello Chris, Chris [EMAIL PROTECTED] writes: Surendra Singhi wrote: I am using mySQL 5.0 and I have 2 tables with few hundred millions of records. To optimize things, I am using MyISAM tables, using the smallest possible data type and have set indexes. Now, the problem which I am facing

Re: optimizing mySQL

Also, when a query takes too long I kill it by shutting down the server, is this safe or is there a better alternative (MyISAM tables)? Use show processlist to see the query that taking more time and use kill processid; for terminating the query . -- Praj Surendra Singhi wrote: Hello

RE: How to build a single temporary table from 3 tables on the fly

Thanks Phil It gives me a solution and some reading. Kerry -Original Message- From: Philip Mather [mailto:[EMAIL PROTECTED] Sent: 11 October 2006 10:02 To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: How to build a single temporary table from 3 tables on the fly

How can i drop tables with the same predix by using only one single statement?

How can i do if i want to drop tables with the same predix? For example, there is a database including a lot of tables,such as tableA,tableB(table*) Now,how can i drop those tables by using only one single statement? _

Re: Why does mysql drop index very very slow in a large table?

You could do that. You must also create a blank T1.MYI. Even then, MySQL will still go through its death-defying series of copies and index rebuilds anyway. You could look into the myisam_repair_threads system variable. Current MySQL installations have it set to 1. If this is greater than 1,

moving to other web server

hi, currently using mysql 4.0.18. want to move to 5.0 (latest stable version for commercil use). is there anytihng I have to be considered DB will not work? thanks. -afan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Group by and concatenate

Hi, I have the following data: mysql select Dealername,pc from ford_gb where pc='LE4 7SL'; +-+-+ | Dealername | pc | +-+-+ | CD Bramall Ford - Leicester | LE4 7SL | | CD Bramall Ford - Leicester | LE4

Re: How to build a single temporary table from 3 tables on the fly

Kerry, It gives me a solution and some reading. No probs, here's some actual code that I hacked together on a 4.1-sommat-or-other database, an important thing to note is to be careful of any Unique keys selected from the three individual tables as they may no longer be unique of course

Re: moving to other web server

Hi, Take a look at the answer written by Peter Brawley to Jason Chan at Oct 10, 2006, ~04:34 PM. Answer included below: Jason following statement works in 4 but not 5 SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as

RE: Group by and concatenate

Never mind. mysql select Dealername,pc,group_concat(pc) from ford_gb where pc='LE4 7SL' group by 1; ++-+--+ | Dealername | pc | group_concat(pc) | ++-+--+ | CD Bramall - Leicester |

Re: Group by and concatenate

Andrew, very possible, have a look at the GROUP_CONCAT function: http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html Dan On 10/11/06, Andrew Braithwaite [EMAIL PROTECTED] wrote: Hi, I have the following data: mysql select Dealername,pc from ford_gb where pc='LE4 7SL';

Re: How can i drop tables with the same predix by using only one single statement?

Hey 方外 醉月 wrote: How can i do if i want to drop tables with the same predix? For example, there is a database including a lot of tables,such as tableA,tableB(table*) Now,how can i drop those tables by using only one single statement?

date_add function

I'm having some trouble setting a future date within a table. I have one column 'this_date' which is a DATE field and I'm trying to add 90 days to it and set a column named 'future_date', also a DATE field. I don't know if the problem is that I'm trying to write the value into the 'this_date'

Re: date_add function

Ed Curtis wrote: I'm having some trouble setting a future date within a table. I have one column 'this_date' which is a DATE field and I'm trying to add 90 days to it and set a column named 'future_date', also a DATE field. I don't know if the problem is that I'm trying to write the value into

Re: date_add function

Why you don´t try this? UPDATE this_table SET this_date = $this_date, future_date = (DATE_ADD($this_date) INTERVAL 90 DAY) Ed Curtis [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] I'm having some trouble setting a future date within a table. I have one column 'this_date'

Re: date_add function

Your sql has more error. I´ll put the right way below. UPDATE this_table SET this_date = $this_date, future_date = DATE_ADD($this_date, INTERVAL 90 DAY) It´ll works fine. João Cândido de Souza Neto [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] Why you don´t try this?

Re: date_add function

Please check your syntax. It should look like this: UPDATE this_table SET this_date = $this_date, future_date = DATE_ADD($this_date,INTERVAL 90 DAY); Don't forget your WHERE clause or else you populate every row. - Original Message - From: João Cândido de Souza Neto [EMAIL PROTECTED]

Re: date_add function

On Wed, 11 Oct 2006, Mark Leith wrote: Ed Curtis wrote: I'm having some trouble setting a future date within a table. I have one column 'this_date' which is a DATE field and I'm trying to add 90 days to it and set a column named 'future_date', also a DATE field. I don't know if the

Re: date_add function

On Wed, 11 Oct 2006, Rolando Edwards wrote: Please check your syntax. It should look like this: UPDATE this_table SET this_date = $this_date, future_date = DATE_ADD($this_date,INTERVAL 90 DAY); Don't forget your WHERE clause or else you populate every row. Tried it, this is what I get

Re: date_add function

Please put the 2008-10-20 in single quotes if you r are doing this in PHP UPDATE this_table SET this_date = $this_date, future_date = DATE_ADD('$this_date',INTERVAL 90 DAY); - Original Message - From: Ed Curtis [EMAIL PROTECTED] To: Rolando Edwards [EMAIL PROTECTED] Cc: João Cândido de

Re: date_add function

Oops, also the $this_date UPDATE this_table SET this_date = '$this_date', future_date = DATE_ADD('$this_date',INTERVAL 90 DAY); - Original Message - From: Rolando Edwards [EMAIL PROTECTED] To: Ed Curtis [EMAIL PROTECTED] Cc: João Cândido de Souza Neto [EMAIL PROTECTED],

Re: date_add function

On Wed, 11 Oct 2006, Rolando Edwards wrote: Oops, also the $this_date UPDATE this_table SET this_date = '$this_date', future_date = DATE_ADD('$this_date',INTERVAL 90 DAY); Got it going guys, thanks again Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: date_add function

Ed Curtis wrote: UPDATE this_table SET this_date = NOW(), future_date = NOW() + INTERVAL 90 DAY; This is probably along the lines of what you want.. Actually I'm setting the DATE via drop down menus using PHP and creating the date by hand via variables. NOW() won't work in this

Re: date_add function

Our pleasure. Good day !!! - Original Message - From: Ed Curtis [EMAIL PROTECTED] To: Rolando Edwards [EMAIL PROTECTED] Cc: João Cândido de Souza Neto [EMAIL PROTECTED], mysql@lists.mysql.com Sent: Wednesday, October 11, 2006 12:48:29 PM GMT-0500 US/Eastern Subject: Re: date_add function

Re: moving to other web server

Still don't get it :( Hi, Take a look at the answer written by Peter Brawley to Jason Chan at Oct 10, 2006, ~04:34 PM. Answer included below: Jason following statement works in 4 but not 5 SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as

Re: moving to other web server

Still don't get it Did you read the section of that manual page headed "Join processing changes in MySQL 5.0.12"? It explains why and how to rewrite all such queries using explicit JOIN ... ON | USING syntax. PB - [EMAIL PROTECTED] wrote: Still don't get it :( Hi, Take

Re: Low priority copy?

Mysqlhotcopy can copy the files anywhere. Just have it copy under ur MySQL data directory and the new copy will be visible instantly. e.g. /var/lib/mysql/data/offline_copy U will instantly see a new database named offline_copy with the copy of ur table in it. Brian Dunning wrote: Thanks

Logging IP adresses

Is it possible to have a transaction automatically write the IP adress of the client to a field of a record? - This sig is dedicated to the advancement of Nuclear Power Tommy Nordgren [EMAIL PROTECTED] -- MySQL General Mailing List For list archives:

storing images in the database

Hi I want to store jpeg images in a mysql database from php in the form of 'blob' types. Is this possible and can you detail for me the steps to achieve this? Regards and thanks Rodney Courtis

Re: storing images in the database

On 10/10/06, Rodney Courtis [EMAIL PROTECTED] wrote: I want to store jpeg images in a mysql database from php in the form of 'blob' types. Is this possible and can you detail for me the steps to achieve this? For a nice size performance hit, yup:

java mysql alias is being displayed blank?

Does anyone know why a mysql alias would not display in the return a result? When I try to access say the first name with it's alias f_name, it is blank? , but it works for its column name first_name? This becomes more of a problem with subselects because how does one alias it? Thank you,

Re: optimizing mySQL

I have an update operation where I am able to update 10 million records in approx 2.5 mins. But when I tried to do the same update on say 40-50 million records, mysql takes forever to finish. Its the same table, and same update operation, i am just changing the range of ids using where

mysqldump quotes in MySQL 5.0.26

Hi, I have 2 identical Linux machines setup with identical my.cnf files (except for server-id) and both running 5.0.26. On server A, I run, mysqldump -h localhost -u root -p... --single-transaction --flush-logs --delete-master-logs --master-data=1 --databases db1 db2 dumpfile I copy

Re: moving to other web server

On Wed, 2006-10-11 at 13:12 -0500, Peter Brawley wrote: Still don't get it Did you read the section of that manual page headed Join processing changes in MySQL 5.0.12? It explains why and how to rewrite all such queries using explicit JOIN ... ON | USING syntax. This works in 4.x but not in

OLAP for MySQL or an Aggregrate Table

Anyone here uses OLAP, running in MySQL? Any OpenSOurce OLAP query tools? How does one goes about doing OLAP? Is there any documentation w/ MySQL anywhere. (I'm currently looking at Pentaho and Mondrian etc but the Pre-configured demo didn't work as it should, meaning it doesn't run for X reasons)

Re: mysqldump quotes in MySQL 5.0.26

Ian, those backticks are standard stuff for mysqldump. A couple of thoughts - 1, are you sure your 'create database' succeeds? 2, long shot, but are you FTPing in ASCII mode? This *might* mess up the backtick character. 3, instead of cat file.sql | mysql, try this mysql -u root -p file.sql

Re: How can i drop tables with the same predix by using only one single statement?

On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote: Hey 方外 醉月 wrote: How can i do if i want to drop tables with the same predix? If you are using 5.0: DELIMITER // DROP PROCEDURE drop_table_prefix// CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHAR(63))

Re: How can i drop tables with the same predix by using only one single statement?

On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote: Hey 方外 醉月 wrote: How can i do if i want to drop tables with the same predix? If you are using 5.0: DELIMITER // DROP PROCEDURE drop_table_prefix// CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHAR(63))

Re: How can i drop tables with the same predix by using only one single statement?

On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote: Hey 方外 醉月 wrote: How can i do if i want to drop tables with the same predix? If you are using 5.0: DELIMITER // DROP PROCEDURE drop_table_prefix// CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHAR(63))

Re: How can i drop tables with the same predix by using only one single statement?

On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote: Hey 方外 醉月 wrote: How can i do if i want to drop tables with the same predix? If you are using 5.0: DELIMITER // DROP PROCEDURE drop_table_prefix// CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHAR(63))

Re: mysqldump quotes in MySQL 5.0.26

Hi, yes, the create database succeeds. It's in a show databases. The error message is complaining about `db1` (i.e. quotes followed by backtick). I'm actually using rsync to copy the file (faster than ftp for some reason). But it also failed when I originally ftp'd it. I've also tried the