Using Notepad for MySQL

[Anon]

Is there any possibility to use notepad to enter the SQL commands for MySQL ?

[gio2k]

As far as I know, there's no problem with using Notepad.
I've used it some times to edit my DB creation scripts.

-Gio-

[[deleted]]

No. Notepad cannot send queries to MySQL.
Use the msql commandline tool, or install myphpadmin.

[gio2k]

I think she wants to use Notepad for editing the SQL commands, not for executing them.
You can edit your script in Notepad and then use the command line tool to execute the script:
c:\mysql\bin> mysql -u user -p pwd <mysql.txt

-Gio-

[[deleted]]

Somehow I doubt that somebody would as wether he/she can use a text editor to edit some text....

[Anon]

Well,

It's possible she might be worried about newline handling if she's going from a .txt document on windows to running the script on mysql command line in *nix.

Either way, I would recommend some other replacements for Notepad.

Look into TexEdit, Ultra-Edit32, and others. If you're a windows user, look for them at www.download.com. Both offer syntax highlighting that you can download and install into the editor, making SQL highlighting (and PHP, C++, Perl, Python and many others!) very easy.

Reuben Stump

[Anon]

what is msql commandline tool and myphpadmin ? can you tell me where to find more about these tools ? Thanx

[[deleted]]

It's called phpmyadmin. It's an web interface to mysql. You can download it from www.sourceforge.net

the mysql commandline tool was installed on your system when you installed mysql.

[Anon]

can you elaborate further more about the command ? when should I use this command ?