Recent questions and answers in Databases

+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 (20k 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 (20k points)

+3 votes

1 answer

How to access a specific database from the MySQL command line

answered Jan 16 in Databases by pkumar81 (20k points)

+3 votes

1 answer

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

answered Jan 14 in Databases by pkumar81 (20k points)

+2 votes

1 answer

How to install the latest MariaDB on CentOS

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

+2 votes

1 answer

How to install the latest MariaDB on Ubuntu

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

+2 votes

1 answer

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

answered Sep 14, 2019 in Databases by pkumar81 (20k points)

+2 votes

1 answer

Centos Web Panel (CWP): How to change the value of innodb_buffer_pool_size in MariaDB/MySQL

answered Sep 9, 2019 in Databases by pkumar81 (20k points)

+2 votes

1 answer

How to convert floats to ints in Pandas DataFrame?

answered Sep 5, 2019 in Databases by pkumar81 (20k points)

+2 votes

1 answer

How to connect to a database in PostgreSQL

answered Aug 14, 2019 in Databases by pkumar81 (20k points)

+2 votes

1 answer

How to change the password of a PostgreSQL user

answered Jul 20, 2019 in Databases by pkumar81 (20k points)

+2 votes

1 answer

PostgreSQL: how to keep duplicate records in the query result of UNION operator

answered Jul 2, 2019 in Databases by pkumar81 (20k points)

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

Recent questions and answers in Databases

...