MySQL - Problems

• MySQL - Create or replace view
• MySQL - Create table if not exists
• MySQL - Create table with AUTO_INCREMENT field
• MySQL - Create table with FOREIGN KEY
• MySQL - Create table with JSON field
• MySQL - Create view if not exist
• MySQL - Drop table if exists
• MySQL - Drop view if exists
• MySQL - GROUP BY multiple columns
• MySQL - Insert JSON type value to the table
• MySQL - Insert NULL values
• MySQL - Select from multiple tables (using JOIN)
• MySQL - Select from view
• MySQL - UPDATE query with LIMIT
• MySQL - Update all rows
• MySQL - Update multiple rows at once
• MySQL - add FOREIGN KEY to existing table
• MySQL - add column to existing table
• MySQL - average value for grouped rows
• MySQL - boolean data type
• MySQL - calculate average of column values and display the result with no decimals
• MySQL - check version from command line
• MySQL - concatenate multiple columns into one
• MySQL - concatenate multiple rows into one field
• MySQL - convert value to CHAR (using CAST() function)
• MySQL - convert value to CHAR (using CONVERT() function)
• MySQL - count characters in string (CHAR_LENGTH())
• MySQL - count distinct values
• MySQL - count duplicated rows
• MySQL - count rows with NULL values
• MySQL - database backup using Linux Command Line
• MySQL - delete all duplicated rows except one
• MySQL - delete row where column is empty string (blank)
• MySQL - delete row where column is null
• MySQL - duplicate table
• MySQL - find all tables with specific column names
• MySQL - find duplicated values
• MySQL - find duplicated values in multiple columns
• MySQL - find first row
• MySQL - find row with null value in column
• MySQL - find row with null value in one of many columns
• MySQL - find rows where column is empty string (blank)
• MySQL - get difference between two columns
• MySQL - get size of every table in database (in MB)
• MySQL - get table size (in MB)
• MySQL - how to check database size?
• MySQL - how to check existing table engine? (HeidiSQL example)
• MySQL - make column values unique
• MySQL - max value for grouped rows
• MySQL - minimum value for grouped rows
• MySQL - numeric data types
• MySQL - restore database from backup using Linux Command Line
• MySQL - search for NULL values in multiple columns
• MySQL - select first N rows
• MySQL - select last N rows
• MySQL - select last row
• MySQL - select rows with max value of column
• MySQL - set root password
• MySQL - sort in ascending or descending order
• MySQL - sum value for grouped rows
• MySql - get row position with SELECT query
• MySql - insert data from one table to another
• Mysql - create new column with index on existing database table with data