Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
mysql database
#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


Messages In This Thread
mysql database - by andrewjs18 - 02-02-2010, 10:36 AM
RE: mysql database - by MattR - 02-02-2010, 11:09 AM
RE: mysql database - by andrewjs18 - 02-02-2010, 11:53 AM
RE: mysql database - by ndee - 04-20-2010, 10:17 AM
RE: mysql database - by myfudbot - 04-11-2011, 11:38 AM
RE: mysql database - by The Don Killuminati - 04-12-2011, 05:22 PM

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

Forum Jump:


Users browsing this thread: 1 Guest(s)