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”
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 …
Create migration file with make:model command
How to create migration file with Make:model command Recently I’ve found out a nice little way to speed up generating of database stuff. I used to use make:migration and make:model …
Create database table when plugin is activated.
Creating Custom Database Tables for Your WordPress Plugins Using custom database tables for your WordPress plugins is one of the way that you can greatly improve the kind of plugins …
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”
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 …