How do i build this table in phpmyadmin?

I've got a script that I want to install on my site and the instructions are clear apart from this bit:


3. Create a table in your database named weather_xml with the following structure:

CREATE TABLE `weather_xml` (
`xml_url` varchar(150) NOT NULL default '',
`xml_data` text NOT NULL,
`last_updated` datetime NOT NULL default '0000-00-00 00:00:00',
KEY `xml_url` (`xml_url`)
) TYPE=MyISAM;


How do I build this table in phpmyadmin?

Thanks

 

Try pasting that piece of code in the query box and click "go".
Click the "sql" tab to see the query box.
Bye

 

that's exactly it. Just make sure you're viewing the DB you want to add the table to, click the SQL tab, paste that in the box click go and you should be good to go.

 

first you must create a database and then press the SQL tab and then paste this in the text area and then run it. I can do it for you If you want.

 

1st create database, then user name and password for that DB. then login to phpmyadmin area, select that database. and paste above query there and click go, then u will see table on left side "weather_xml".

 

Hi pedigreechump6,

if you want to install that script for table creation on your local server then just open your mysql and create a database of any name then open that database and click on "SQL" tab and paste that code and its done. you will see a table with named "weather_xml" under your created database.

but if you want to install that script for table creation on your hosting server then first click on "My SQL databases" create database now open that database and do as i mentioned above, or if you have already your database then just open that database and install there.

Have a Nice Day..

.....Nadeem A.

 

Try to paste that code snippet in the query box and click "then go".
Click the "sql" tab to see a box that question first try
thank you ^ _ ^