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 …
By Nikunj Joshi
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 …
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”
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 …
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 …
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 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”
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 …