Re: Please help with syntax for mysqldump

2004-01-13 Thread Andrew Boothman
Matthew Stuart wrote: mysqldump is run at the system command-line, not within the mysql client environment. This is most likely to be my problem then. I assumed that what is called the system command line to be the mysql client environment. The tutorial book that I have been going through ins

Re: Please help with syntax for mysqldump

2004-01-13 Thread zzapper
On Tue, 13 Jan 2004 14:07:38 +, Matthew Stuart <[EMAIL PROTECTED]> wrote: Similarly. SELECT intDEVID,txtDEVPOSTCODE INTO OUTFILE "c:/aaa/dump.sql" from ytbl_development; (dump.sql file must NOT already exist) zzapper (vim & cygwin & zsh) -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-

Re: Please help with syntax for mysqldump

2004-01-13 Thread Matthew Stuart
mysqldump is run at the system command-line, not within the mysql client environment. This is most likely to be my problem then. I assumed that what is called the system command line to be the mysql client environment. The tutorial book that I have been going through instructs me to issue this

Re: Please help with syntax for mysqldump

2004-01-13 Thread Hassan Schroeder
Matthew Stuart wrote: I am really struggling with a mysqldump. I am trying to create a dump of a complete database called csi_db01 and I am trying to save the dump file to My Documents on the C drive. I am sure I am doing right, but could somebody email me the full syntax to use which comes af

Re: Please help with syntax for mysqldump

2004-01-13 Thread zzapper
On Tue, 13 Jan 2004 14:07:38 +, Matthew Stuart <[EMAIL PROTECTED]> wrote: >I am really struggling with a mysqldump. I am trying to create a dump >of a complete database called csi_db01 and I am trying to save the dump >file to My Documents on the C drive. > >I am sure I am doing right, but c

Re: Please help with syntax for mysqldump

2004-01-13 Thread jeffrey_n_Dyke
>I am really struggling with a mysqldump. I am trying to create a dump >of a complete database called csi_db01 and I am trying to save the dump >file to My Documents on the C drive. >I am sure I am doing right, but could somebody email me the full syntax >to use which comes after the mysql>

Please help with syntax for mysqldump

2004-01-13 Thread Matthew Stuart
I am really struggling with a mysqldump. I am trying to create a dump of a complete database called csi_db01 and I am trying to save the dump file to My Documents on the C drive. I am sure I am doing right, but could somebody email me the full syntax to use which comes after the mysql> If I ca

Re: Please help with syntax !!!

2001-07-25 Thread Maes Jean-Claude
: "Zbigniew Szczesny" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 25, 2001 5:40 PM Subject: Please help with syntax !!! Hello ! This is a syntax taken from MS Access: SELECT messages.message_id, messages_1.message_id FROM messages AS messages_1 INNER JOI

Re: Please help with syntax !!!

2001-07-25 Thread Stephen Adkins
Hi, It seems like what you are trying to do is select all messages that have child messages and display the results sorted by the parent message ID. How about... select messages.message_id, messages_1.message_id from messages, connections, messages messages_1

Please help with syntax !!!

2001-07-25 Thread Zbigniew Szczesny
Hello ! This is a syntax taken from MS Access: SELECT messages.message_id, messages_1.message_id FROM messages AS messages_1 INNER JOIN (messages INNER JOIN connections ON messages.message_id = connections.parent) ON messages_1.message_id = connections.child ORDER BY messages.message_id, messag