Recent questions and answers in Databases

+1 vote

1 answer

How to install and access PostgreSQL on Ubuntu 20

answered Apr 6 in Databases by pkumar81 (29.3k points)

+3 votes

1 answer

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

answered Sep 10, 2020 in Databases by pkumar81 (29.3k points)

+4 votes

1 answer

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

answered Aug 30, 2020 in Databases by pkumar81 (29.3k points)

+4 votes

1 answer

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

answered Aug 26, 2020 in Databases by pkumar81 (29.3k points)

+4 votes

1 answer

Mysql : SELECT with WHERE BINARY is very slow

answered Jun 26, 2020 in Databases by praveen (15.3k points)

+4 votes

1 answer

MySQL error 2006: mysql server has gone away

answered May 24, 2020 in Databases by pkumar81 (29.3k points)

+2 votes

1 answer

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

answered Mar 10, 2020 in Databases by pkumar81 (29.3k points)

+2 votes

1 answer

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

answered Feb 22, 2020 in Databases by pkumar81 (29.3k points)

+3 votes

1 answer

How to access a specific database from the MySQL command line

answered Jan 15, 2020 in Databases by pkumar81 (29.3k points)

+3 votes

1 answer

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

answered Jan 13, 2020 in Databases by pkumar81 (29.3k points)

+2 votes

1 answer

How to install the latest MariaDB on CentOS

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

+2 votes

1 answer

How to install the latest MariaDB on Ubuntu

answered Nov 9, 2019 in Databases by pkumar81 (29.3k 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 (29.3k 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 (29.3k 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 (29.3k points)

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

Recent questions and answers in Databases

...