Recent questions and answers in Databases

+4 votes

1 answer

How to use SQL LIKE statement to find substring with "/"(forward slash) and "\"(backslash)

answered Dec 18, 2021 in Databases by pkumar81 (42.1k points)

+3 votes

1 answer

How to install and access PostgreSQL on Ubuntu 20

answered Apr 6, 2021 in Databases by pkumar81 (42.1k 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 (42.1k 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 (42.1k 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 (42.1k points)

+4 votes

1 answer

Mysql : SELECT with WHERE BINARY is very slow

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

+4 votes

1 answer

MySQL error 2006: mysql server has gone away

answered May 24, 2020 in Databases by pkumar81 (42.1k 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 (42.1k 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 (42.1k points)

+3 votes

1 answer

How to access a specific database from the MySQL command line

answered Jan 15, 2020 in Databases by pkumar81 (42.1k 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 (42.1k points)

+2 votes

1 answer

How to install the latest MariaDB on CentOS

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

+2 votes

1 answer

How to install the latest MariaDB on Ubuntu

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

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

Recent questions and answers in Databases

...