mysql - Modify the isbn data of the database so that if the isbn encoding is normal, it will not change. If it exceeds 13 digits, the first 13 digits will be taken directly. How should I write the sql statement?

Question

(www.sf.gg) is China's leading developer technology community. We hope to provide a pure, high-quality technical exchange platform for programming enthusiasts, learn, communicate and grow with developers, and create an era for developers!

淡淡烟草味 · Answer

Query: select substr(isbn,0,13) from table

Modification: update table set isbn = substr(isbn,0,13)

mysql - Modify the isbn data of the database so that if the isbn encoding is normal, it will not change. If it exceeds 13 digits, the first 13 digits will be taken directly. How should I write the sql statement?

reply all(1)I'll reply