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
- MySql dump using java
- Show engine innodb status
- Finding all column name of table
- Date and time functions