Related Articles
How to take Backup of MYSQL database sql file using MYSQLDUMP Command
For a single database: mysqldump –opt –user=root –password database1 > singledb.sql For multiple Backup of databases: mysqldump –opt –user=root –password –databases database1 database2 > multipledb.sql To import a MYSQL .sql file from one location to particular location : source /home/SSI/process_databases_backup.sql
fixed share buttons
Floating Share Buttons
General
sidebar buttons
sidebar fixed share buttons
SideBar Floating Share Buttons
SideBar share buttons
Tips&Tricks
Sidebar Floating Share Buttons
SideBar Floating Share Buttons Code Start Below Tweet SideBar Floating Share Buttons Code End
How to Add Column to Mysql Table and Auto Increment with Primary Key
Check below on How to Add a Column to Mysql Table with Auto Increment and Primary Key You can achieve it by doing Alter Command: Add Column to Mysql To Modify Column and add Auto Increment with Primary Key Query: ALTER TABLE test MODIFY COLUMN ID INT(10) PRIMARY KEY auto_increment; ALTER TABLE users ADD id […]