Hello Noli, when using SQL you can specify in the CREATE statement, if a column can be NULL. If you don't want a null you can use a create statement like:
CREATE TABLE example( id INT NOT NULL AUTO_INCREMENT, col INT NOT NULL DEFAULT 13, lin INT NOT NULL DEFAULT -47, PRIMARY KEY(id)); You can use a SELECT statement like the following to replace null be a value: SELECT val from example WHERE not val = null UNION SELECT 0 val from example WHERE col = null; Best regards Xypron Noli Sicad wrote: > > Hello Xypron, > > Would it be possible to put 0 for this NULL rather terminating the > mathprog, just to process this query or reading table. > > -- View this message in context: http://old.nabble.com/Assertion-failed%3A-str2num%28buf%2C--num%29-%3D%3D-0-Error-detected-in-file-..%5Csrc%5Cglpsql.c-at-line-900-tp27559656p27585990.html Sent from the Gnu - GLPK - Bugs mailing list archive at Nabble.com. _______________________________________________ Bug-glpk mailing list [email protected] http://lists.gnu.org/mailman/listinfo/bug-glpk
