I am new to mysql and have read much of the docs and have
learned a good deal in a short time. Now I need to put some
of the knowlege into practise.
I have manged to create a database and table yet I am unable to
give the records a default value.
Also the information I recieve that the db must read from is in the form of
01199707070912RSTEW
So the needs to be able to take the information from this string and
place it in the table below
CREATE TABLE HeaderRecord (
RecordType char(2),
FileCreationDate timestamp(8),
FileSequenceNo int(4) unsigned zerofill DEFAULT '0000' NOT NULL,
FileIdentifier char(5),
Filler char(171)
);
How do I get mysql to load the string into the database?
How can I assign a default value to a RecordType eg Value="01"
Kind regards
Kevin
