MySQL is the world’s most popular open source database. With its proven performance, reliability and ease-of-use, MySQL has become the leading database choice for web-based applications, used by high profile web properties including Facebook, Twitter, YouTube, Yahoo! and many more.

Content

• mysql create table statement
• Show mysql create table query
• Insertion of a new record into a table
• Show records of a table
• Update table
• Changing the default value for column
• Updating the column size
• Changing primary key of table
• Alter table command to add foreign key
• Drop foreign key constraints
• Show mysql create table query
• Give initial auto increment value while table creation
• Reset auto increment in a table
• Set time zone in mysql
• Granting Privileges to users
• Creating user in mysql
• Drop command To remove existing column
• Drop command: To eliminate a column
• Add new column in a table
• Select database
• To create new database
• Show all databases
• MySql dump using java
• Show engine innodb status
• Showing process list in mysql
• Finding all column name of table
• Date and time functions