Posts Tagged ‘MySQL’

Rename table in MySQL

RENAME TABLE is used to change the name of table. We must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table.

Copy a table structure in MySQL

We can clone or copy a table structure in MySQL using LIKE or AS operators. Using LIKE: We can use CREATE TABLE … LIKE to create an empty table based on the definition of another table, including any column fields and indexes defined in the original table: Syntax: CREATE TABLE new_table LIKE original_table;

Change USER password in MySQL

We can the user password in MySQL, using UPDATE, SET, ALTER command. To change password, current login user must have granted permissions on user table of mysql database and must have UPDATE, SET and ALTER permissions on user table. To reset password in MySQL 5.6 or older versions(This statement not works in MySQL 5.7 or […]

emp table script MySQL

Standard emp table script for MySQL Server 1) Create table structure 2) Insert data into emp table

How to install MySQL on Linux

In this article, we are going to install MySQL on Ubuntu Linux Distribution. 1) Log on to Ubuntu Server and open Terminal 2) Type the following command in terminal sudo apt-get instal mysql-server

Install xampp on windows

XAMPP stands for Cross-Platform (X), Apache (A), MariaDB (M), PHP (P) and Perl (P). It is a simple, lightweight Apache distribution that makes it extremely easy for developers to create a local web server for testing and deployment purposes. XAMPP is an easy to install Apache distribution containing MariaDB, PHP, and Perl. Just download and […]

Powered by k2schools