Jump to content
aberdeen-music

Wanted: Someone to set up a MySQL Database using phpmyadmin


Guest MerryChristmas

Recommended Posts

This will create a database:


CREATE DATABASE my_db;

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

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