ORDER ENQUIRY

await your prompt response as soon as you receive this mail,i will be be very glad if you treat this email with good concern Warm Regards Helen

Mainframe, AS400, COBOL and others

, and Revenue and most importantly with verified opt-in Email Addresses. Let me know your thoughts. I appreciate your time and value of your business. Look forward to hearing from you Best Regards, Helen Young Marketing Analyst WML Marketers Any business list; You name it, We ha

transfer huge mysql db between partitions

where it is on the original partition. Also, the table is a few Gb, so the quickest way possible would be best :) Any advice much appreciated! Helen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: adding columns to a large table

Thanks for all the help on this one. Its a MyISAM table. I ended up creating a temp table and selecting the data in... took 2 mins. I feel totally blonde for not thinking of that earlier! Thanks for being there, everyone! Helen - Original Message - From: praj To: Helen M

adding columns to a large table

Any advice much appreciated! Helen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

changing datadir

d restore... but if anyone has a better way, please let me know! Helen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

quickie for a non-blonde!

If I have a table primary key id | code| name 1 | ABC | company 1 name 2 | ABC | company 1 name 3 | ABC | new company 1 name 4 | ABC | new company 1 na

Re: a tricky join

er_ref | sum(amount) 2/1/01 | 100 | 1250 3/1/01 | 101 | 12500 Helen Quoting Helen M Hudson <[EMAIL PROTECTED]>: So, if my table structure was: id | date | order_ref | amount 1 | 1/1/01 | 100 | 1000 << th

a tricky join

| 2/1/01 | 100 | 50 I'd like to end up with latest_date_on_order | order_ref | sum(amount) 2/1/01 | 100 | 1250 I know its a one-liner for someone who has reached the light... so any help very much appreciated! Helen

Moving databases between machines and server versions simultaneously

databases by using mysqldump. Thanks Helen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Newbie help - change datatype of a table

how can i change the data type of a table? I'm not sure if that is my problem. If anyone is interested here is a link what I've been trying to do: http://www.phpbuilder.com/board/showthread.php?threadid=10248279&goto=newpost Thanks for any help given! H

FYI for all newbies

I highly recommend you go to http://www.mysqlstudio.com/ and buy Navicat. Extremely helpful GUI for creating and managing your MySQL databases! H -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

access denied

mysql> CREATE DATABASE csttrainrep -> ; ERROR 1044: Access denied for user: '@localhost' to database 'csttrainrep' mysql> GRANT ALL ON csttrainrep. TO helen -> ; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to y

mysqld starts and ends

when I enter: cd /usr/local/mysql sudo chown -R mysql data/ sudo echo sudo ./bin/mysqld_safe & mysqld starts and ends. I am using a Mac with OSX 10.2.4 and have installed 4.0.4 Any assistance would be greatly appreciated! Helen