• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
sharadchhetri

sharadchhetri

Tutorials On Linux, Unix & Open Source

  • Home
  • Linux Commands
  • Resources
    • Learn Linux
  • My WordPress plugins

mysql

How to rename table in mysql using command line

November 12, 2013 by Sharad Chhetri Leave a Comment

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 […]

Filed Under: mysql Tagged With: mysql

How to copy existing table in mysql

November 12, 2013 by Sharad Chhetri Leave a Comment

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 […]

Filed Under: mysql Tagged With: mysql

Install MySQL workbench in Ubuntu

August 14, 2013 by Sharad Chhetri 1 Comment

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 […]

Filed Under: Linux, mysql Tagged With: mysql

See mysql command output vertically

August 10, 2013 by Sharad Chhetri Leave a Comment

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 […]

Filed Under: Linux, mysql Tagged With: mysql

How to set default storage engine to MyISAM to InnoDB vice versa

August 10, 2013 by Sharad Chhetri Leave a Comment

In this tutorial we will learn about how to set default storage engine to MyISAM to InnoDB or vice versa. Since the change in MySQL default storage engine as InnoDB there are many Database Servers which are still running in MyISAM. The change in Default storage engine come after MySQL 5.0 and later versions. In […]

Filed Under: Linux, mysql Tagged With: mysql

How to check default storage engine in MySQL server

August 9, 2013 by Sharad Chhetri Leave a Comment

MySQL server comes with many engines,earlier MyISAM was default storage engine but from MySQL version 5.5 and later InnoDB now become a default storage engine. Yet,you should know what is the default storage engine running in mysql server. It might be possible any database admin has changed to MyISAM or INNODB as default storage engine […]

Filed Under: Linux, mysql Tagged With: mysql

  • « Go to Previous Page
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • Go to Next Page »

Primary Sidebar

Our Social Media Presence

  • Facebook
  • GitHub
  • Twitter

Linux Command

What is Linux Internal And External Command

Linux Basic Commands With Examples For Every Beginner

tr command to convert lines to space , tab and vertical tab

smbpasswd command not found on CentOS 7 and RHEL 7

Solution : semanage command not found

Unix / Linux : How to print duplicate lines from file

More Posts from this Category

You Might Like These Articles!

simplecodesyntax wordpress plugin

SimpleCodeSyntax : My Another WordPress Plugin

Install Nginx

How To Install Nginx On Ubuntu 22.04 LTS

Install Latest Git package in Ubuntu Operating System

How To Always Install Latest Git Package In Ubuntu Operating System

Bash script for installing VirtualBox on Ubuntu 22.04 LTS Desktop

Install VirtualBox On Ubuntu 22.04 LTS Desktop (Bash Script)

libfuse

dlopen(): error loading libfuse.so.2 – Got Error On Ubuntu

Failed to open/create the internal network

VirtualBox Error: Failed to open/create the internal network

Always Useful Tips And Tricks

How to zip directory in linux explained with examples

How to empty Trash through command line in Ubuntu

Edit the crontab without using crontab -e

How to find swap partition or file in linux

Keep logs of user after sudo su – : Secondary Logging

shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory

New XAMPP security concept

Explore 90+ Article On "Linux Tips And Tricks"

Copyright © 2023 ยท
The material in this site cannot be republished either online or offline, without our permission.
Proudly Blogging From Bharat.

  • Contact
  • About Me
  • My WordPress plugins
  • Privacy Policy