We need to rename the column in mysql with long,
alter table table_name change old_name new_name column_def.
alter table table_name change old_name new_name column_def
Why not follow the syntax
alter table table_name rename old_name new-name?
alter table table_name rename old_name new-name
I would say that the reason is that when renaming you also effectively change the type of attribute. Therefore, the change is more accurate :)
Source: https://habr.com/ru/post/1787866/More articles:Parse SQLite ALTER, CREATE & UPDATE - javascriptParsing SQL CREATE TABLE using jQuery? - javascripthttps://translate.googleusercontent.com/translate_c?depth=1&pto=aue&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=https://fooobar.com/questions/1787863/when-my-project-is-released-should-i-commit-outputs-to-svn&usg=ALkJrhigukB-_9Qrug0t-X10tagk1jRNzQArithmetic rules of data type in language c - cControlling the rotation of a 3D object using the touch screen in openGL - androidAdd a cart link (indicating the number of items) to the sidebar in Magento - hyperlinkCall function in VB.Net DLL without registering DLL - vb.netHow to sort a dict by values ββand return a list of formatted strings? - pythonWhy doesn't the JVM support forced unloading of a class / class? - javaZero-error prototype replacement method - javascriptAll Articles