Run SQL query/queries on server

[tinkertron]

I don't know much about MySQL. I do know how to create a db, but not tables. The whole VARCHAR and DATE and all that mobojambo has given me a headache. So i'm asking for help. Not sure is this is some quick and easy, or if I should be paying someone to do it, but I'll ask nicely, please. Here's what i'm looking for.

 

Officer Name  > 15 Characters

AssignmentDate  > MM/DD/YY

LastName > 15 Characters

FirstName > 15 Characters

StateID > 0#######

TDCJID > 0#######

InstantOffense > 40 Characters

DischargeDate > MM/DD/YY

ArrestDate > MM/DD/YY

BookingNumber > ########

Allegation1 > 40 Characters

Allegation2 > 40 Characters

Allegation3 > 40 Characters

Allegation4 > 40 Characters

Allegation5 > 40 Characters

Allegation6 > 40 Characters

Allegation7 > 40 Characters

Allegation8 > 40 Characters

Allegation9 > 40 Characters

OffenseType > 5 Characters

CourtDate > MM/DD/YY

InterviewDate > MM/DD/YY

HearingDate > MM/DD/YY

HearingType > 14 Characters

BoardDate > MM/DD/YY

BoardDecision > 11 Characters

Status > 30 Characters

 

Thank you...

[kickstart]

Hi

 

Most of that would either be VARCHAR (you already have the max lengths) or INTEGER (just validate them before inserting them to check they are in the range you accept). Do not store the dates in MMDDYY format as it is pretty useless for anything except display to some people (at least if it is stored in YYYYMMDD format it can easily be sorted). Store it as a date field in the database and convert it to the format you want to display in your script to read the database.

 

All the best

 

Keith