sweetpax.blogg.se

I hope this makes sense, and someone can shed some light on this issue - it's driving me crazy.MySQL database includes the following two tasks: (1) Insert the data in the two files in the MySQL database ( List_Class1.txt, List_Class1_Submit.xls, click download).

That is, the final query UPDATE Students SET 3uth1='true' WHERE idStudents='1' UPDATE Students SET 3uth1='true' WHERE idStudents='1' UPDATE Students SET 3uphH2='true' WHERE idStudents='1'ĪLTER TABLE Students ADD 3uth1 VARCHAR(20)

UPDATE Students SET 3umaHL4='true' WHERE idStudents='1'ĪLTER TABLE Students ADD 3uphH2 VARCHAR(20) UPDATE Students SET 3uenA1H1='true' WHERE idStudents='1'ĪLTER TABLE Students ADD 3umaHL4 VARCHAR(20) UPDATE Students SET 3udaBH3='true' WHERE idStudents='1'ĪLTER TABLE Students ADD 3uenA1H1 VARCHAR(20) UPDATE Students SET 3uchS元='true' WHERE idStudents='1'ĪLTER TABLE Students ADD 3udaBH3 VARCHAR(20) UPDATE Students SET 3ubmSL5='true' WHERE idStudents='1'ĪLTER TABLE Students ADD 3uchS元 VARCHAR(20) SELECT column_name FROM information_lumns WHERE table_name='Students'ĪLTER TABLE Students ADD 3ubmSL5 VARCHAR(20) INSERT INTO Students (idStudents, Name) VALUES ('1', 'Bror Tao Sjørslev Bojlen') When I run these queries: CREATE TABLE Students (idStudents INT NOT NULL, Name VARCHAR(255) NOT NULL, PRIMARY KEY (idStudents)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 Here's my problem: from the log file I can see that every single query is sent to the database correctly, but some don't show up in the table. Then it writes 'true' under that column for the current student. The script checks to see if the class it's adding already exists as a column, and if not it creates it. The table is structured so that there is a primary key column, a student name column, and then a column for each class. I've written a python script that adds student data (name and classes) to a table one at a time.