Martin91/mysql examples.md

## mysql examples.md

      
    Raw
  

              mysql examples.md
            
          
    If not any statement, all the following commands running in the mysql console or a query string.
# Alter table syntax: http://dev.mysql.com/doc/refman/5.6/en/alter-table.html
#   ALTER [IGNORE] TABLE tbl_name
#     [alter_specification [, alter_specification] ...]
#     [partition_options]
ALTER TABLE users ADD username CHAR(30), ADD email CHAR(30);

# Even more, if the name of your column includes a blank space, you should use a pair of ` symbol:
ALTER TABLE users ADD `home address` VARCHAR(255);