RE: What is SAP R/3 Ver 4.6c installation procedure on PC?

In Relation to MaxDB, did you check out: http://www.mysql.com/products/maxdb/docs.html As for SAP itself, shouldn't that be the documentation kit that came with it? Yours Sincerely Darran Kartaschew -Original Message- From: Rahul Mandle [mailto:[EMAIL PROTECTED] Sent: Tuesda

RE: Wish List of Features

Hi Mark, 1. See the mysqldump utility. (separate to the mysqlcc and mysql). You can dump the whole server, a selected db, or table including or excluding the table data (ie structure only). eg. mysqldump -B -a -d -u -p > dumpfile.sql will dump the structure of database to file dumpfile.sql.

SELECT ... UPDATE

Hi Everyone, Is there an easy way to update a field for the last record referenced by an ID number? where that ID number is used on multiple rows? At the moment I am doing this which works: CREATE TEMPORARY TABLE tmp_user ( SELECT user_id, MAX(last_updated) AS max_last_updated FROM employee GR

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

RE: SELECT ... GROUP BY

MySQL the proper place to do this stuff... Darran -Original Message- From: Donny Simonton Sent: Monday, 8 March 2004 13:49 To: Darran Kartaschew; [EMAIL PROTECTED] Subject: RE: SELECT ... GROUP BY You should change it to something like this: Select * from posts group by user_id ord

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