Mysql default character set utf8mb4 : Use the. CHARACTER SET as well as option when creating your database, like so: CREATE DATABASE dbname CHARACTER SET…
Mysqli
mysql like case sensitive – 4 ways to Use LIKE Comparison Operator in SQL SELECT Statement for MySQL
mysql like case sensitive : MySQL case-sensitive Search with LIKE. The LIKE statement is used for searching records with partial strings in MySQL. mysql like…
mysql get table size – 2 ways to Get the Size of a Table in MySQL
mysql get table size : To get MySQL table size of all tables in a database use: SELECT TABLE_NAME AS `Table`, ROUND((DATA_LENGTH + INDEX_LENGTH) /…
mysql get current datetime – 5 ways to Get Current Date and Time in MySQL
mysql get current datetime : You can also use current_timestamp() to get latest date and time in MySQL. To insert only date value, use curdate()…
mysql get year from date – 5 ways to Get the Year from a Datetime Column in MySQL
mysql get year from date : Use the YEAR() function to retrieve the year value from a date/datetime/timestamp column in MySQL. YEAR() function in MySQL…
mysql delete duplicate rows – 3 ways to Delete Duplicate Rows in MySQL
mysql delete duplicate rows : Delete the duplicate rows but keep latest : using GROUP BY and MAX. he go to solution for removing duplicate…
mysql check if database exists – 2 ways to check if mysql database exists
mysql check if database exists: SHOW DATABASES LIKE ‘dbname’; If you have database with the name ‘dbname’ doesn’t exist, you get an empty collumn set.…
mysql where multiple values – 2 ways to use multiple values in WHERE clauses
mysql where multiple values To fetch fields with multiple values, use WHERE, IN(), LIKE with OR in MySQL. mysql where multiple values To select multiple…
mysql search all tables for string – 2 ways to search whole MySQL database for a particular string
mysql search all tables for string : Search / find through all databases, tables, columns in MySQL: Q – How to search for a string…
upload csv file in php – Read CSV file & Import data into MySQL with PHP
In this “upload csv file in php” tutorial, I will explain to you how to read CSV files with the help of PHP. And how…
create table in laravel using Migration and Manage Database
create table in laravel – Run Migration: Using bellow command we can run our migration and create database table. I want to create the in…
tree structure in php with mysql example – Best Way To Create PHP Dynamic Treeview Menu Using bootstrap 3 | 4
tree structure in php with mysql example: CREATE DYNAMIC TREE VIEW MENU WITH PHP, MYSQL, CSS Steps to generate tree view menu: create a table…