HubsInfo Network
Login or Register to remove ads! You're browsing our forum and website as a Guest meaning you can only see a portion of the forum in read-only mode.
  1. HubsInfo Network
  2. General discussions
  3. Servers and Networking [IT & Datacenter]
  4. MySQL
  5. Overriding strict mode with the IGNORE keyword
PHP MySQL Linux Material Design Web Hosting Online Games SimCity BuildIt

Pages: [1]

Overriding strict mode with the IGNORE keyword

  •   0 Replies
  •   562 Views

Overriding strict mode with the IGNORE keyword
« on: April 17, 2022, 09:22:15 AM »

Overriding strict mode with the IGNORE keyword


Code: [Select]
SET sql_mode='STRICT_TRANS_TABLES';

INSERT INTO strict VALUES ('MariaDB', '128');
ERROR 1406 (22001): Data too long for column 's' at row 1


Code: [Select]
INSERT IGNORE INTO strict VALUES ('MariaDB', '128');
Query OK, 1 row affected, 2 warnings (0.15 sec)
Pages: [1]
  1. HubsInfo Network
  2. General discussions
  3. Servers and Networking [IT & Datacenter]
  4. MySQL
  5. Overriding strict mode with the IGNORE keyword
 



Linux Ubuntu Guides Linux games - Lutris.net

Follow us on 𝕏
YouTube

Partners
Web Design and SEO SimCity BuildIt Database Gaming Sites, Private Servers Lineage 2 servers | L2 Scarlet Lineage 2 Fafurion server WoW Database and Guides