Jump to content

Wanted: Someone to set up a MySQL Database using phpmyadmin

Guest MerryChristmas

Recommended Posts

This will create a database:


This will create a table with 9 fields. One for integers, one for floating point numbers and seven for text of up to 100 characters:

CREATE TABLE mytable (
intField INT,
fltField FLOAT,
txtField1 VARCHAR(100),
txtField2 VARCHAR(100),
txtField3 VARCHAR(100),
txtField4 VARCHAR(100),
txtField5 VARCHAR(100),
txtField6 VARCHAR(100),
txtField7 VARCHAR(100)

This is just from memory so don't blame me if it doesn't work. It is even easier to do this through phpMyAdmin though. It certainly isn't worth paying someone to do it - that's just lazy.

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Create New...