$ head update.sql
|
UPDATE tempfeatures SET feadeb=1, feafin=18113, location='1..18113' WHERE numacc='IMGT000171' AND feanum=1;
|
UPDATE tempfeatures SET feadeb=18114, feafin=27543, location='18114..27543' WHERE numacc='IMGT000171' AND feanum=9;
|
UPDATE tempfeatures SET feadeb=27544, feafin=34020, location='27544..34020' WHERE numacc='IMGT000171' AND feanum=16;
|
UPDATE tempfeatures SET feadeb=34021, feafin=40209, location='34021..40209' WHERE numacc='IMGT000171' AND feanum=26;
|
UPDATE tempfeatures SET feadeb=40210, feafin=42557, location='40210..42557' WHERE numacc='IMGT000171' AND feanum=33;
|
UPDATE tempfeatures SET feadeb=42558, feafin=49034, location='42558..49034' WHERE numacc='IMGT000171' AND feanum=37;
|
UPDATE tempfeatures SET feadeb=49035, feafin=55774, location='49035..55774' WHERE numacc='IMGT000171' AND feanum=64;
|
UPDATE tempfeatures SET feadeb=55775, feafin=58605, location='55775..58605' WHERE numacc='IMGT000171' AND feanum=71;
|
UPDATE tempfeatures SET feadeb=58606, feafin=61350, location='58606..61350' WHERE numacc='IMGT000171' AND feanum=79;
|
UPDATE tempfeatures SET feadeb=61351, feafin=66917, location='61351..66917' WHERE numacc='IMGT000171' AND feanum=83;
|
|
$ mariadb-show -t ligmdb_v12 tempfeatures
|
Database: ligmdb_v12 Table: tempfeatures
|
+------------+----------------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
|
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
+------------+----------------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
|
| numacc | varchar(20) | utf8mb3_bin | NO | PRI | | | select,insert,update,references | |
|
| feanum | smallint(5) unsigned | | NO | PRI | | | select,insert,update,references | |
|
| labcode | int(10) unsigned | | NO | MUL | | | select,insert,update,references | |
|
| feadeb | int(11) unsigned | | NO | | | | select,insert,update,references | |
|
| feafin | int(11) unsigned | | NO | | | | select,insert,update,references | |
|
| partial | tinyint(3) unsigned | | NO | | | | select,insert,update,references | |
|
| phase | tinyint(3) unsigned | | YES | | | | select,insert,update,references | |
|
| complement | tinyint(4) | | YES | | | | select,insert,update,references | |
|
| location | varchar(80) | utf8mb4_general_ci | NO | | | | select,insert,update,references | |
|
+------------+----------------------+--------------------+------+-----+---------+-------+---------------------------------+---------+
|
|
$ mariadb-show -i ligmdb_v12 tempfeatures
|
Database: ligmdb_v12 Wildcard: tempfeatures
|
+--------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+------------------+-----------+
|
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | Max_index_length | Temporary |
|
+--------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+------------------+-----------+
|
| tempfeatures | InnoDB | 10 | Dynamic | 94169 | 82 | 7798784 | 0 | 4276224 | 4194304 | | 2023-08-11 08:35:25 | 2023-10-20 09:36:34 | | utf8mb4_general_ci | | | | 0 | N |
|
+--------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+--------------------+----------+----------------+---------+------------------+-----------+
|
|
$ mariadb-repair -a ligmdb_v12 tempfeatures
|
ligmdb_v12.tempfeatures OK
|
|
$ cat update.sql | mariadb ligmdb_v12
|
ERROR 1048 (23000) at line 138: Column 'message' cannot be null
|
|
$ sed -n 138p update.sql
|
UPDATE tempfeatures SET feadeb=1116194, feafin=1115690, location='1116194..-1115690' WHERE numacc='IMGT000171' AND feanum=1542;
|