+- Support Forums (https://www.supportforums.net)
+-- Forum: Categories (https://www.supportforums.net/forumdisplay.php?fid=87)
+--- Forum: Coding Support Forums (https://www.supportforums.net/forumdisplay.php?fid=18)
+---- Forum: Database Programming (https://www.supportforums.net/forumdisplay.php?fid=28)
+---- Thread: mysql database (/showthread.php?tid=4641)
mysql database - andrewjs18 - 02-02-2010
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
RE: mysql database - MattR - 02-02-2010
Use phpMyAdmin?? Very simple user interface to make one, just fill in a form.
RE: mysql database - andrewjs18 - 02-02-2010
(02-02-2010, 11:09 AM)MattR Wrote: 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.
RE: mysql database - ndee - 04-20-2010
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.
RE: mysql database - myfudbot - 04-11-2011
i use my php admin it helps out alot
RE: mysql database - The Don Killuminati - 04-12-2011
I could help you, if still needed.
Pm me.