How can i execute many sqls together???

[-Mr.CuTe-]

i have to many sqls to execute ...its hard to do it one by one....how can i do it??

 

[Commodus]

There isn't such an option in navicat.

 

You have to execute them one by one.

[Nik]

well... you can add all SQLs in 1 file :D

[DrHouse__]

That's why you should not use navicat =)

 

It saves you some work but also it prevents you to know how things really work. So when a problem comes up, like this, you have 0 experience to work it out.

 

I recommend you to read mysql user guide

 

easy fix: do what Nik said

good fix: use a shell script to do it

[WizZy™]

Do a .bat script like l2jserver's and run it..