I have a query running for some hours, if I cancel this query what is going to happen to the database?
The query is an ALTER TABLE
that adds a new column.
UPDATE: I executed the script this way
mysql -u username -p database
mysql> ALTER TABLE `table_name` ADD COLUMN `new_column` INT(1);