Top "Mysql" questions

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

Split value from one field to two

I've got a table field membername which contains both the last name and the first name of users. Is it …

Read More
mysql split
Access denied for user 'root'@'localhost' (using password: YES) after new installation on Ubuntu

Today I did a login as root into Ubuntu 14.04.1 LTS ll and then apt-get install mariadb-server (without sudo but as …

Read More
mysql mariadb
MySQL date formats - difficulty Inserting a date

I am trying to further a question I asked yesterday where I wanted to know how to query a date …

Read More
mysql date insert format
Rank function in MySQL

I need to find out rank of customers. Here I am adding the corresponding ANSI standard SQL query for my …

Read More
mysql sql rank
MySQL - ERROR 1045 - Access denied

In some way I have managed to get this error when I try to access into MySQL via the command …

Read More
mysql linux passwords mysql-error-1045
How to escape apostrophe (') in MySql?

The MySQL documentation says that it should be \'. However, both scite and mysql shows that '' works. I saw …

Read More
mysql escaping
On Duplicate Key Update same as insert

I've searched around but didn't find if it's possible. I've this MySQL query: INSERT INTO table (id,a,b,c,…

Read More
mysql on-duplicate-key
Adding a line break in MySQL INSERT INTO text

Could someone tell me how to add a new line in a text that I enter in a MySql table? …

Read More
mysql newline insert-into
MySQL Delete all rows from table and reset ID to zero

I need to delete all rows from a table but when I add a new row, I want the primary …

Read More
mysql
SQL command to display history of queries

I would like to display my executed sql command history in my MYSQL Query Browser. What is the sql statement …

Read More
mysql