MySQL get all column names


This command will get all column names in one table SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA`='insertdatabasename' AND `TABLE_NAME`='inserttablename'; This will get columns from

Laravel Database Cheatsheet

 Laravel, MySQL

Laravel Database Eloquent DB::connection('connection_name'); DB::statement('drop table users'); DB::listen(function($sql, $bindings, $time){ code_here; }); DB::transaction(function(){ transaction_code_here; }); Cache a query for

Import a Large File MySQL


Every once in a while I have to import a large SQL file and have to look up the best way to do it. This method has worked for me