Greetings
On my SQL Script to import to MySQL, I want to verify if the database already exists. If so I want to drop it so the script can create a new clean database. On SQL Server I can do this by doing
use master
go
if exists (select name from master.dbo.userdatabases where name =
'mydatabase')
drop database mydatabase
go
create database mydatabase
go
use mydatabase
go
create table xpto
..
Is possible to do something like this using MySQL? If so, how?
Thank you very much for your help.
Sérgio
