Hasan Try typing your select statement in a text editor. Open a mysql client connection and copy paste. This gets around the problem.
For multiple sql statements, put them in a file and redirect it to the mysql client: shell> mysql -u hasan -p < file.sql David > -----Original Message----- > From: Hasan / Impex Holidays Maldives [mailto:hasan@;impex.com.mv] > Sent: Thursday, October 17, 2002 4:22 AM > To: [EMAIL PROTECTED] > Subject: retyping data > > > hi, > > I am using win-xp and command prompt to access mysql. > I try to retype a very long insert line into the command > prompt, but the > command prompt would not allow me to type all my insert > query. There seems > to be a limit to the characters I can insert when in mysql. > I can type any amount of characters when in C: prompt. > > Does anyone know a solution, I have tried changing the properties but > nothing seems to help. > > Thanks, > Hasan > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php