PHPADMIN creates rows with no data....
I am trying to add data to the following table:
What I do is to go to the table, chose SQL, then chose "Import data from textfile", I browse for the textfile which I for simplicity only have added one row of data (just one word per line, no spaces whatsoever). I then put the name of the column and press "send".
uniID below works without any problems, ever field is filled out fine. However when I try with programID och any of the other rows no data or wrong data is stored, i.e. the fields are empty, named NULL or "weird" data is stored.
Why is my MySQL database behaving like this?
create table tblbooks
( bokID INT NULL AUTO_INCREMENT PRIMARY KEY,
uniID CHAR(4),
programID CHAR(5) NOT NULL,
termID CHAR(7) NOT NULL,
kursID INT NOT NULL,
title VARCHAR(200) NOT NULL,
author1 VARCHAR(50) NULL,
author2 VARCHAR(50) NULL,
author3 VARCHAR(50) NULL,
author4 VARCHAR(50) NULL,
year CHAR(4) NULL,
edition CHAR(3) NULL,
isbn CHAR(13) NULL,
publisher CHAR(60) NULL,
status VARCHAR(5) NULL
);