mysql

How to rename table in mysql using command line

by

In this post we will know how to rename table in mysql using command line. It is basic and important command for MySQL database administration. We are doing this practical in MySQL server version 5.5.29. Syntax: Replace the table_name and NEW_TABLE_NAME as per your requirement. ALTER TABLE table_name RENAME NEW_TABLE_NAME Example: See the below given … Read more

How to copy existing table in mysql

by

In this post we will learn about how to copy the existing table in mysql. The newly copied table does not have data means it will be blank but it has similar rows information from its parent table. After copying the table you have to insert the data by using INSERT command. Follow the given … Read more

Install MySQL workbench in Ubuntu

by

MySQL Workbench is a integrated tool for MySQL. The MySQL workbench gives a graphical interface to user through which user can easily manage many MySQL Administration task.The tool can be install in Windows,MacOSX and Linux. As well as its source code is also available. The MySQL Workbench is easy to install in Windows,MacOSX and Linux … Read more

See mysql command output vertically

by

When you work on mysql server and hit some command in mysql prompt,you get the output in horizontal way. For eg. I hit the command, select emailid from linuxtable where user = ‘sharad’; and this table has lots of fields . In that case the output looks weird. Rather than seeing the output Horizontally in … Read more