Re: Does 'insert' return a value?

Martijn Tonies wrote: No,I mean the position of the recorde in the table In the SQL world, records don't have a "position" in a table. When you request data, you will get a "resultset", not access to a table. The resultset is derived from the actual table data. He wants the last_insert_i

Re: Does 'insert' return a value?

> No,I mean the position of the recorde in the table In the SQL world, records don't have a "position" in a table. When you request data, you will get a "resultset", not access to a table. The resultset is derived from the actual table data. Martijn Tonies Database Workbench - development to

Creating new table from distinct entries

MySQL 4.1.21-community-nt I have a table in my database that has a Primary key on 2 fields (MyID and MyChange) and a field that indicates if there is a problem with the record (MyError)- I want to create a new table that only has unique MyIDs and where there is more than 1 I only want the rec

big5 stored as latin1 and want utf

In the manual we see If you have non-`latin1' data stored in a 4.0 `latin1' table and want to convert the table column definitions to reflect the actual character set of the data, use the instructions in *Note Charset-conversion::. But what about e.g., users who have big5 data sorted as lati

warn before mentioning deprecated material

In the manual we see: * Columns selected for output can be referred to in `ORDER BY' and `GROUP BY' clauses using column names, column aliases, or column positions. Column positions are integers and begin with 1: mysql> SELECT college, region, seed FROM tournament

Re: Upgrade issue

Hi David, > Go from 4.1 to 5.0 to 5.1 . This is safer. Thanks for the advise, I'll plan this route. I still have the problem that 5.1 has no 'mysql_upgrade' program. I would really be interested in hearing from somebody from MySQL. Does this version need no upgrading? I am confused... R

Re: Upgrade issue

Hi David, > Go from 4.1 to 5.0 to 5.1 . This is safer. Thanks for the advise, I'll plan this route. I still have the problem that 5.1 has no 'mysql_upgrade' program. I would really be interested in hearing from somebody from MySQL. Does this version need no upgrading? I am confused... R

Re: Upgrade issue

On Mon, Oct 23, 2006 at 01:49:14PM +0100, Ben Clewett wrote: > MySQL, > > I am trying to upgrade from 4.1 to 5.1. > > Your manual states I should run mysql_upgrade. > > But there is no such program in our pre-compiled binary, only a man page! > > $ find . -name "mysql_upgrade*" > ./mysql-5.1.11

R: replica on 5.0.26 doesn't work any more

Now it's ok I have just deleted all logs and relay files included master.info and relay-log.info. The log files were named fep1_x, while the host is named differently ( \\arlati-e ). Mybe the "relay-log=fep1-relay-bin" is not working well, so the replication looks only for files named arlat

replica on 5.0.26 doesn't work any more

Hi I upgrade mysql on win2000 from 5.0.18 to 5.0.26. Inside my.ini I have this setup # # Replica DB # server-id=1 log-bin=pmv_manager_log_bin relay-log=fep1-relay-bin replicate-ignore-table=pmv_manager.parametri_configurazione replicate-ignore-table=pmv_manager.lista_fep

RE: help with query: select customers that ARO NOT in orders t

You're right. A join is often more efficient than a subselect especially if you have good indices set up. I believe the "IS NULL" will also get optimized away in your query. In this example I personally like the subselect syntax for it's explicitness if the speed difference is negligible. For l

RE: help with query: select customers that ARO NOT in orders table

Is a sub-select more efficient than an outer join? SELECT cust_id FROM customers LEFT JOIN orders on customers.cust_id = orders.cust_id WHERE orders.cust_id IS NULL; Or am I missing something (as usual)? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, C

Re: Does 'insert' return a value?

> When I insert a record into a table > Does the insert return a value that where the record have been inserted > into? What do you mean by "where the record have been inserted into"? The physical position? Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Prod

Upgrade issue

MySQL, I am trying to upgrade from 4.1 to 5.1. Your manual states I should run mysql_upgrade. But there is no such program in our pre-compiled binary, only a man page! $ find . -name "mysql_upgrade*" ./mysql-5.1.11-beta-aix5.2-powerpc-64bit/man/man1/mysql_upgrade.1 However the on-line manual

Re: Does 'insert' return a value?

黄小聪 wrote: When I insert a record into a table Does the insert return a value that where the record have been inserted into? No. You need to "select last_insert_id()" or use a function in your programming language (eg php has php.net/mysql_insert_id). -- MySQL General Mailing List For list

RE: Reports

Try this: www.eclipse.org/birt Andy -Original Message- From: Kristen G. Thorson [mailto:[EMAIL PROTECTED] Sent: 20 October 2006 15:07 To: Ahmad Al-Twaijiry; MySQL List Subject: RE: Reports > -Original Message- > From: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECTED] > Sent: Friday,

Does 'insert' return a value?

When I insert a record into a table Does the insert return a value that where the record have been inserted into?