Mysql Helps & Tutorials

Collections of short guide for everyone on how to manage their MySQL database tables efficiently and easily

December 15, 2016

Step by Step Installing Linux, Apache, MySQL, PHP (LAMP) on Ubuntu 16.04

A Linux, Apache, MySQL, PHP (LAMP) stack is a combination of open source software that is typically installed together to enable a server to host dynamic […]
December 15, 2016

Easy Guidance How To Install MySQL on Ubuntu 14.04

MySQL is an the most popular open-source database management system, in most of hosting company its has been bundle by LAMP(Linux, Apache, MySQL, PHP/Python/Perl) stack. Another alternative […]
December 15, 2016

MySQL Getting Started

MySQL is the world’s most popular open-source database. Despite its powerful features, MySQL is simple to set up and easy to use. Below are some instructions […]

How to find duplicate rows with similar part of string

How to properly use transactions and locks to ensure database integrity?

How do you configure PHP to use mysql instead of sqlite

How to avoid and log down some unexpected thing for db?

how to link 2 rows in same table mysql database? [closed] MySQL How to put two tables in a listview

How to create unique index for each player MySQL?

How to use foreign keys and a spatial index inside a MySQL table?

How to make MySQL handle UTF-8 properly

How to run mysql command on bash?

How do I make search results for a PHP / MySQL query link to data in a single row?

How to handle game scores of last week in MySQL Table

How to use MySQL join/count correctly

How to Pass input parameters to Spring restful web service method using model class as inputs & execute MySql stored procedure

Login authorization, how to check if the password matches a SALT + HASH - PHP + MySQL

How to Encrypt Stored Procedures in MySQL?

All fields are showing in one column when exporting mysql data to excel using php

How to restrict user from modifying data in mysql data base?

How to make sub delete queries faster?

Why results of PDO are two nested arrays and how to use them

How to fetch data between weeks in different year in Mysql [duplicate]

MySQL trigger. How to store each row of data in table for a limited time?

How to update from select with a Join

How to design an index/query to avoid filesort in a simple MySQL query?

How to get MySQL Stopwords with SQL

How to create a ssh tunnel in ruby and then connect to mysql server on the remote host

mysql like groupby in oracle how to

Mysql to JSON, how to get a nested array?

how to use “IN” in node-mysql

How do I convert an Access 2007 DateTime to mysql datetime format?