Comments - The table have issue. select is empty but can't insert more data

3 years, 9 months ago Hoang Bang

I have run the query: TRUNCATE TABLE table2;

Then, immediately run the insert statement with another session: INSERT INTO UniversalDatasetTable (DSID, Enabled, PollingPeriod, MinPeriod, SnmpVersionNumber) VALUES (10300, 1, 900, 60, 0); The message returned is DUP PRIMARY KEY.

My mariaDB is: mysql Ver 15.1 Distrib 10.1.22-MariaDB, for Linux (x86_64) using readline 5.1

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.