Recent questions and answers in Databases

+3 votes

1 answer

MySQL/MariaDB: How to improve the execution time of SELECT queries with LIKE condition

answered Sep 10 in Databases by pkumar81 (25.6k points)

+4 votes

1 answer

MySQL: how to find the value with max length in a column

answered Aug 30 in Databases by pkumar81 (25.6k points)

+4 votes

1 answer

Debian : Cannot set LC_CTYPE, LC_MESSAGES, LC_ALL to default locale

answered Aug 26 in Databases by pkumar81 (25.6k points)

+4 votes

1 answer

Mysql : SELECT with WHERE BINARY is very slow

answered Jun 26 in Databases by praveen (15.2k points)

+4 votes

1 answer

MySQL error 2006: mysql server has gone away

answered May 24 in Databases by pkumar81 (25.6k points)

+2 votes

1 answer

SQL - fetching a column that is not present in the table using SELECT clause

answered Mar 10 in Databases by pkumar81 (25.6k points)

+2 votes

1 answer

MySQL - how to reset auto_increment column to the latest value after deleting rows

answered Feb 22 in Databases by pkumar81 (25.6k points)

+3 votes

1 answer

How to access a specific database from the MySQL command line

answered Jan 15 in Databases by pkumar81 (25.6k points)

+3 votes

1 answer

MySQL: how to import data from an SQL file to a database using the command line

answered Jan 13 in Databases by pkumar81 (25.6k points)

+2 votes

1 answer

How to install the latest MariaDB on CentOS

answered Nov 9, 2019 in Databases by pkumar81 (25.6k points)

+2 votes

1 answer

How to install the latest MariaDB on Ubuntu

answered Nov 9, 2019 in Databases by pkumar81 (25.6k points)

+2 votes

1 answer

How to use a Python list in the WHERE clause of SQL

answered Sep 26, 2019 in Databases by pkumar81 (25.6k points)

+2 votes

1 answer

SQL : how to replace consecutive multiple spaces in a string with a single space

answered Sep 23, 2019 in Databases by pkumar81 (25.6k points)

+2 votes

1 answer

SQL : how to check if a string/substring is present in a column of a MySQL table

answered Sep 23, 2019 in Databases by pkumar81 (25.6k points)

+2 votes

1 answer

How to get the datatype of all columns of a PostgreSQL table

answered Sep 13, 2019 in Databases by pkumar81 (25.6k points)

To see more, click for all the questions in this category.

Recent questions and answers in Databases

...