Category: Mysql

how to insert json data into mysql using php : PHP Script read JSON file contents and Insert into MySQL.

mysql return id after insert : Get ID of The Last Inserted Record. The best WAY to get the id

Mysql default character set utf8mb4 : Use the. CHARACTER SET as well as option when creating your database, like so:

mysql like case sensitive : MySQL case-sensitive Search with LIKE. The LIKE statement is used for searching records with partial

mysql get table size : To get MySQL table size of all tables in a database use: SELECT TABLE_NAME AS

mysql get current datetime : You can also use current_timestamp() to get latest date and time in MySQL. To insert

mysql get year from date : Use the YEAR() function to retrieve the year value from a date/datetime/timestamp column in

mysql delete duplicate rows : Delete the duplicate rows but keep latest : using GROUP BY and MAX. he go

mysql check if database exists: SHOW DATABASES LIKE ‘dbname’; If you have database with the name ‘dbname’ doesn’t exist, you

mysql where multiple values To fetch fields with multiple values, use WHERE, IN(), LIKE with OR in MySQL. mysql where

mysql search all tables for string : Search / find through all databases, tables, columns in MySQL: Q – How