Everything from Everywhere - Daily Acquisitions

To change column name in MySQL Table, ALTER TABLE table_name CHANGE old_column_name new_column_name DATA_TYPE; For example,to change misspelled column name 'fist_name', ALTER TABLE users CHANGE fist_name first_name VARCHAR(64); In addition, you can change multiple column names in a query and set languages, default value, etc. ALTER TABLE users CHANGE fist_name first_name VARCHAR( 64 ) NOT NULL,   CHANGE username user_name VARCHAR( 32 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,   CHANGE gend gender TINYINT( 1 ) NOT NULL DEFAULT 0;

Sometimes, it is needed to insert multiple columns at a time. Next MySQL multiple insert queries performs perfect, of course INSERT INTO   table_name (column-1, column-2, ... , column-n)   VALUES (value-1-1, value-1-2, ... , value-1-n); INSERT INTO   table_name (column-1, column-2, ... , column-n)   VALUES (value-2-1, value-2-2, ... , value-2-n);   ... INSERT INTO   table_name (column-1, column-2, ... , column-n)   VALUES (value-m-1, value-m-2, ... , value-m-n); But next single query is easy to use and save memory ant time INSERT INTO   table_name (column-1, column-2, ... , column-n)   VALUES     (value-1-1, value-1-2, ... , value-1-n),     (value-2-1, value-2-2, ... , value-2-n),     ... ,    (value-m-1, value-m-2, ... , value-m-n); But be careful with large data (value). Your server or machine might be stop the execution due to the security or resource issues such as execu...