how to run mysql server 2005??

[rounit]

I have installed mysql server 2005.
How can i use DDL and DML query commands in MS mysql server 2005

you advice will be of great help to me

 

[victor_rambo]

Hmmmm...I have no idea about using MS-SQL server, but I am hearing for the first time "MS MySQL server 2005". Are you sure about it?

 

[thedragonrocks]

If you are talking about MS SQL Server, Why execute DML / DLL commands when it provides awesome front end GUI tool? But yes for practise, you can write the SQL in a .sql file and execute it. Google it for details... i've only used the GUI.

 

[rounit]

correct: MS sql server 2005 express edition.

actually i want to use the command line interface to run the query statement. And i dont know how to configure it on my PC to run the command line interface. I googled it but all in vain.


please guide!

 

[FilledVoid]

When you deal with MS Products the first place you want to look is technet.

*technet.microsoft.com/en-us/library/bb418498.aspx

There documentation is quite comprehensive and should have any information you are looking for.

 

[linus_77]

Open "SQL Server Management Studio", there you can type in the queries after connecting to DB and execute them.