Really stupid mysql question(to you)

Easter_Bunny

How do you create a database in MySQL called, lets say "mydb"?😃

Is that the right way to ask the question?:o

jonsof

CREATE DATABASE mydb;
i think!

Easter_Bunny

OK, still with stupid questions:

Where do I type that?:o

jonsof

Into PhpMyAdmin, in the window called SQL!

Easter_Bunny

Thanks for the help! Once again a friend(my boss)helped me on this one. Didn't have MySQL on. :o

Please don't pick on me! I've only been at this for almost 8 days now!😃

Thanks.

rIkLuNd

if you want to create a table, and doesn't have for example, phpMyAdmin, then you just do like this:

<?php

$con = mysql_connect("localhost","YourUser","YourPassword");
if(!$con)
die(mysql_error());

$sel = mysql_select_db("YourDatabase");
if(!$sel)
die(mysql_error());

$create = mysql_query("CREATE TABLE yourname(
id int not null auto_increment,
primary key(id),
yourfield VARCHAR(100),
anotherfield CHAR(32))");
if(!$create)
die(mysql_error());

echo "Table has been created!";

mysql_close();

?>