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”
PHP Tutorial for Beginners
PHP Tutorial for Beginners Summary The PHP Hypertext Preprocessor (PHP) is a programming language that allows web developers to create dynamic content that interacts with databases. PHP is a server …
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”
Creating Foreign Keys via Laravel Migration
Adding foreign keys with Migrations Laravel really excels at facilitating deft management and navigation of table relations, but you’ll need to understand how to properly configure these relationships before taking …
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 …
Laravel Basic Configration
Laravel Basic Configration After installing Laravel, the first thing we need to do is to set the write permission for the directory storage and bootstrap/cache. Generate Application key to secure …
Run custom query in Laravel
How to run custom query in laravel $users = \DB::select(“SELECT users.*,products.* FROM `users` LEFT JOIN `products` ON users.`id` = products.`user_id` WHERE 1 ORDER BY users.`id` ASC”); For more information please …