Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
mysql database
#1
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
Reply
#2
Use phpMyAdmin?? Very simple user interface to make one, just fill in a form.
MyBB Support Team Lead
Reply
#3
(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.
Reply
#4
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.
Reply
#5
i use my php admin it helps out alot
Reply
#6
I could help you, if still needed.

Pm me.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  database problem danjohnson 0 1,152 11-13-2012, 10:56 PM
Last Post: danjohnson
  vb6.0 + mysql Anurag.91 1 1,646 09-08-2012, 04:19 PM
Last Post: spesificrelax
  Database accessing in .NET MikeHenery9 1 1,436 07-14-2012, 06:37 PM
Last Post: 'Snorlax
  Creating and inserting data into a PHP and MySQL Database Peter L 9 4,020 03-24-2012, 10:49 AM
Last Post: Haxalot
  VB.NET MySql , Help please booterphhp 2 1,685 03-19-2012, 11:13 AM
Last Post: RainbowDashFTW

Forum Jump:


Users browsing this thread: 1 Guest(s)