MySQL Create Table and Data Types
Creating Tables in MySQL Tables can be created using CREATE TABLE statement and it actually has the following syntax. CREATE TABLE [IF NOT EXISTS] `TableName` (`fieldname` dataType [optional parameters]) ENGINE …
Connecting to the Mysql Database Server With SSH Commands
How to Connect to a MySQL Server Remotely with MySQL How to Install MySQL on Ubuntu If you don’t have MySQL installed on your droplet, you can quickly download it. …
Read More “Connecting to the Mysql Database Server With SSH Commands”
Updating multiple rows with different values in one query
MySQL CASE…WHEN…THEN statements FIRST CREATE TABLE OF USERS CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `status` enum(‘0′,’1’) NOT NULL DEFAULT ‘0’, …
Read More “Updating multiple rows with different values in one query”
Split a string and loop through values in MySql Trigger
Split a string and loop through values in MySql Trigger Below example will explain you to get comma separated string and insert rows in second table through MySQL Trigger. First …
Read More “Split a string and loop through values in MySql Trigger”
Difference between InnoDB and MyISAM?
The main differences between INNODB and MYISAM The most commonly used storage engine in MySQL are MyISAM and InnoDB. With these storage engine there are some advantages and disadvantages according …
MySQL Create Trigger
In order to create a new trigger, you use the CREATE TRIGGER statement. You put the trigger name after the CREATE TRIGGER statement. The trigger name should follow the naming …