matrixtlm Posted February 21, 2006 Share Posted February 21, 2006 How do i specified which database to create the table in, using CREATE statement ?Thanks Link to comment Share on other sites More sharing options...
sbrownii Posted February 21, 2006 Share Posted February 21, 2006 The table will be created in the database that is currently selected. If you haven't selected a database, you can't create a table... or do much of anything else for that matter!If you try to execute a CREATE statement without selecting a database... it will fail.By selecting I mean in your code you need to specify which database to use. Not you need to choose a database as in MySQL versus Oracle, but as in You have 3 databases created inside your MySQL server and you need to choose which one to work with. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now