pwnedbyjosh Posted September 1, 2003 Share Posted September 1, 2003 i already have a database which i want to delete but i also want to make 2 more databases. how do i do it Quote Link to comment Share on other sites More sharing options...
nysebamse Posted September 1, 2003 Share Posted September 1, 2003 To delete an entire database: DROP DATABASE IF EXISTS db_name To create a new database: CREATE DATABASE IF NOT EXISTS db_name See also www.mysql.com for documentation on MySQL. Quote Link to comment Share on other sites More sharing options...
pwnedbyjosh Posted September 1, 2003 Author Share Posted September 1, 2003 where do i enter that? Quote Link to comment Share on other sites More sharing options...
nysebamse Posted September 1, 2003 Share Posted September 1, 2003 How do you access your mysql database? With PHPMyAdmin? Quote Link to comment Share on other sites More sharing options...
pwnedbyjosh Posted September 1, 2003 Author Share Posted September 1, 2003 are u saying i use phpmyadmin to gewt to it? where do i d/l it? Quote Link to comment Share on other sites More sharing options...
Barand Posted September 9, 2003 Share Posted September 9, 2003 where do i enter that? You can do it from php [php:1:af123983bd]<?php mysql_query (\"DROP DATABASE IF EXISTS db_name\"); mysql_query (\"CREATE DATABASE IF NOT EXISTS db_name\"); ?>[/php:1:af123983bd] hth Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.