mysql database

[andrewjs18]

can someone write me a database with the following tables:
date, price, condition, year, silver, gold, weight

I think that's it. this will greatly help me as I don't know much mysql.

thanks,
Andrew

[MattR]

Use phpMyAdmin?? Very simple user interface to make one, just fill in a form.

[andrewjs18]

Use phpMyAdmin?? Very simple user interface to make one, just fill in a form.

yes, I do use phpmyadmin. I'll give it a try.

[ndee]

Hey there,

If you still did not add a database and still looking for a way to do so, then login to your PHPMyAdmin and switch to the SQL tab. Run this query:

CREATE DATABASE `DbNameHere` ;

That will create a database, make sure you change the name to anything you'd like. Then run this query to create the tables:

CREATE TABLE `DbNameHere`.`DbTableNameHere` (
`date` VARCHAR(20) NOT NULL ,
`price` VARCHAR(20) NOT NULL ,
`condition` VARCHAR(20) NOT NULL ,
`year` VARCHAR(20) NOT NULL ,
`silver` VARCHAR(20) NOT NULL ,
`gold` VARCHAR(20) NOT NULL ,
`weight` VARCHAR(20) NOT NULL
)

There you go, I set them as VARCHAR (aka a text field) and set the maximum length for them as 20. You can edit the number, of course.

Good luck.

[myfudbot]

i use my php admin it helps out alot

[The Don Killuminati]

I could help you, if still needed.

Pm me.