|
|
| Executing |
2.1 [Re]Create Fresh CONJHISTORY Table |
| Description |
[Re]Create Fresh CONJHISTORY Table |
| Executing SQL | DROP TABLE IF EXISTS ntconjectures.CONJHISTORY; | | Result | Exception |
| Exception |
DROP command denied to user 'coptot'@'localhost' for table `ntconjectures`.`CONJHISTORY` Error Code: 1142 SQL State: 42000
|
| Executing SQL | CREATE TABLE ntconjectures.CONJHISTORY (CONJHISTID int(11) NOT NULL,CONJID int(11) NOT NULL,AUTHOR varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,AUTHORID int(11) NOT NULL,BIBLIOSHORT varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,BIBLIOLONG varchar(1023) COLLATE utf8mb4_unicode_ci DEFAULT NULL,BIBLIORANGE varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,BIBLIOID int(11) NOT NULL,REMARKS varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,YEAR int(11) NOT NULL,KIND varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,CITATION text(18000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,PRIMARY KEY (CONJHISTID),KEY CID (CONJID)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | | Result | Exception |
| Exception |
CREATE command denied to user 'coptot'@'localhost' for table `ntconjectures`.`CONJHISTORY` Error Code: 1142 SQL State: 42000
|
| Executing SQL | NA | | Result | Exception |
| Exception |
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NA' at line 1 Error Code: 1064 SQL State: 42000
|
|