multiple table update

update gci_copy,dis set gci_copy.products_description=concat_ws('',gci_copy.products_description,dis.products_model,dis.products_description) where gci_copy.products_image=dis.products_image only able to caoncat one match possiable work arounds. __

Weekly activity report

Response -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Timestamp and alter table

Hi, I have a table that looks like: mysql> desc test; +---+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-+---+ | timestamp | timestamp(14) | YES | | NULL| | |

Re: query date ranges

Kevin Waterson wrote: I have been trying this is several ways, currently I have a mess MySQL 4.1.1 PHP as the interface I have a table of with a date range called seasons. in it I have two date ranges and an amount to be charged for each day in the range 2004-01-01 00:00:00 2004-06-01 00:00:

Re: SELECT ... GROUP BY

Three solutions to this problem, including the one here, are discussed in the manual: Michael Darran Kartaschew wrote: Excellent, that worked... Yours Sincerely Darran -Original Message- From: Daniel Kasak [mailto:[

RE: SELECT ... GROUP BY

Excellent, that worked... Yours Sincerely Darran -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Monday, 8 March 2004 14:03 To: Darran Kartaschew; [EMAIL PROTECTED] Subject: Re: SELECT ... GROUP BY You need to do this in 2 steps. Step 1: select user_id, max(last

RE: SELECT ... GROUP BY

I tried: Select * from posts group by user_id order by username, last_updated DESC but it still gave the same result, (ie first post and not last post). Or did I miss something? Additionally I'm using MySQL as the backend DB to a php app. I know I can do all this in php, but consider MySQL the

Re: SELECT ... GROUP BY

Darran Kartaschew wrote: Warning: SQL newbie... I'm trying to create a query where the most recent entry for each user is returned from a forum table, and sorted by username. The fields are simply: user_id, username, post, last_updated. No primary key defined. I've tried the simple "SELECT

RE: SELECT ... GROUP BY

You should change it to something like this: Select * from posts group by user_id order by username, timestamp DESC That should give you the last post. Donny > -Original Message- > From: Darran Kartaschew [mailto:[EMAIL PROTECTED] > Sent: Sunday, March 07, 2004 9:42 PM > To: [EMAIL PROT

SELECT ... GROUP BY

Warning: SQL newbie... I'm trying to create a query where the most recent entry for each user is returned from a forum table, and sorted by username. The fields are simply: user_id, username, post, last_updated. No primary key defined. I've tried the simple "SELECT * FROM posts GROUP BY user_id

Re: Query Optimization

At 21:55 -0300 3/7/04, Volnei Galbino wrote: Hi, Does anybody know where I can find information about "query optimization" in MySQL? Of which the techniques that are used? Regards, Volnei Galbino Yes, there's a chapter on optimization in the MySQL Reference Manual. http://www.mysql.com/doc/en/My

Query Optimization

Hi, Does anybody know where I can find information about "query optimization" in MySQL? Of which the techniques that are used? Regards, Volnei Galbino

Stored procedure strange behavior?

Hi I have a few questions concerning stored procedures: 1. If I create a stored procedure (like the one below), why does the returned values not change, though in the stored prcoedure the id has been generated? 2. Is there any better way to hand over multiple values and how can I unset global

Re: ibdata1

At 12:24 -0300 3/5/04, cytron wrote: I lost my ibdata1 file, I don't have backup, and now my tables InnoDB don't open. Well, that's a problem. If you've lost your data, and you have no backup, then ... you've lost your data. Possibly if your operating system allows some kind of undelete operation,

Re: mysqldump of UTF8 db

Odd. When I dump my utf8 database it works fine. I use mysqldump -u user --password=password -a -A --add-drop-table -c >public_html/backup.sql This backs up my entire database. Here is the limk to it in the manual http://www.mysql.com/doc/en/mysqldump.html I hope it helps. Respectfully, Ligaya

RE: Possible drawbacks of suggested mysql install?

Hi, we started with tha same configuration you have, and tune the MS Sql and MySQL for the memory the server (windows NT smallbusiness 4.0), and started to try our aplications against the two off them. All work really nice the two server with the same database and the same data and MySQL work fast

Re: using create table with show fields

At 20:13 +0700 3/7/04, neal wrote: I would like to do something like Create table xyz as show fields from test.abc; Or maybe Select Field from (show fields from test.abc); Is this possible ?, can I treat the execution of 'show fields' as a select statement Thanks, Neal Katz Sounds like you want

Re: transactions

Andre, - Original Message - From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Sunday, March 07, 2004 3:28 PM Subject: transactions > Hello there. > > i'm working with transactions, and i have one situtation where i start a > transaction and execute the insert/update st

Re: Hierarchical list...

check this thread - lots of links for more info. http://lists.mysql.com/mysql/157588 olinux --- Richard Carlier wrote: > Hi ! > > There is any way to have hierarchical list with > Mysql, like the Oracle > START WITH and CONNECT BY ? > __ Do you Yahoo!? Yahoo

MySQL Cluster on Windows

I'm trying to understand whether setting up a MySQL cluster running on Windows 2000/2003 is possible. I am not a cluster expert, actually I have only read the MS white papers about it and done some Google search, but still not tried to do it in practice, so forgive me if I make silly questions. S

Re: Partial Replication ?

You can suppress writing the delete query to the binary log. mysql>set sql_log_bin = 0; mysql>delete ... ; mysql>set sql_log_bin=1; Bonnet R?my <[EMAIL PROTECTED]> wrote: > Hello, > > I have a database which is flushed every four hours, > and > I want to replicate it without replicating the del

Hierarchical list...

Hi ! There is any way to have hierarchical list with Mysql, like the Oracle START WITH and CONNECT BY ? Something like : CREATE TABLE links_categories ( id int(11) NOT NULL auto_increment, parent int(11) default NULL, libelle varchar(50) default NULL, PRIMARY KE

Re: VB and mySql

I am new to mysql and started a tutorial for it and php. Mysql is running ok on my redhat server. I thought VB might be to unstable. VB is easy to use but I think its not web based. Also all the job adds I see want mysql and php. thanks for responding Walt - Original Message - From: "

AW: VB and mySql

Walt You can also use VB with MySQL without problems. There are several connectors available at the MySQL site Freddie -Ursprüngliche Nachricht- Von: Walt [mailto:[EMAIL PROTECTED] Gesendet: Sonntag, 7. März 2004 18:01 An: [EMAIL PROTECTED] Betreff: VB and mySql I used to program with

RE: VB and mySql

You shouldn't have any problems using VB to write software with MySQL. -Original Message- From: Walt [mailto:[EMAIL PROTECTED] Sent: Sunday, March 07, 2004 11:01 AM To: [EMAIL PROTECTED] Subject: VB and mySql I used to program with VB using MS access as the db. VB was very quick to dev

VB and mySql

I used to program with VB using MS access as the db. VB was very quick to develope nice looking forms. Which language would be the best to use with mysql to create similiar forms. These forms would be for scrolling through the db, adding, updating, deleteing, printing... Walt

Re: Selectinmg most recent dates from multiple table items

SELECT DISTINCT sensor_id, other_fields FROM table_name ORDER BY time_stamp_field DESC LIMIT 40 Not sure if that will work, but does it point you in the right direction? j- k- On Saturday 06 March 2004 07:22 pm, Tim McDonough wrote: > On Sat, 06 Mar 2004 20:40:24 -0600, Paul DuBois wrote

transactions

Hello there. i'm working with transactions, and i have one situtation where i start a transaction and execute the insert/update statement, then i execute another start transaction for another db and execute the insert/update, and if this return a error i do the rollback, and then i do the rollback

using create table with show fields

I would like to do something like Create table xyz as show fields from test.abc; Or maybe Select Field from (show fields from test.abc); Is this possible ?, can I treat the execution of 'show fields' as a select statement Thanks, Neal Katz

MySQL and FreeBSD 5.x - Using LinuxThreads or not?

Hi all, We are about to upgrade one of our database servers to a Dual Xeon machine with HT. We have been testing FreeBSD 5.x for 6-7 months on a Uniprocessor box and we haven't had any problems with the platform. We would like to use FreeBSD 5 on our new database server since the SMP support is s