bewareofdoug Posted December 11, 2008 Share Posted December 11, 2008 I thought that I could type my code in notepad, do a copy, and than do a paste at the mysql prompt on my server. Well this doesn't work because I have to use the {crtl}{v} that doesn't work on my server. Is there a way to type the mysql code in something like notepad, do a copy and paste so that when I miss a comma or something I don't have to retype the whole thing. Mysql version: Ver 12.22 Distrib 4.0.25, for pc-linux-gnu (i686) Thank you, Doug Quote Link to comment Share on other sites More sharing options...
trq Posted December 11, 2008 Share Posted December 11, 2008 You can simply write your queries to a file (eg; queries.sql) then execute it using.... mysql -uYOURUSERNAME -pYOURPASSWORD YOURDATABASE < queries.sql Quote Link to comment Share on other sites More sharing options...
fenway Posted December 12, 2008 Share Posted December 12, 2008 And assuming you're the only one with access to the box, you won't care that your user/pass will show up in logs / top / etc. Quote Link to comment Share on other sites More sharing options...
bewareofdoug Posted December 12, 2008 Author Share Posted December 12, 2008 Thanks that helps a lot. Doug Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.