Recent questions in Databases

+2 votes

1 answer

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

asked Mar 10 in Databases by praveen (13.1k points)

+2 votes

1 answer

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

asked Feb 22 in Databases by praveen (13.1k points)

+3 votes

1 answer

How to access a specific database from the MySQL command line

asked Jan 16 in Databases by phpuser (4.5k points)

+3 votes

1 answer

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

asked Jan 14 in Databases by phpuser (4.5k points)

+2 votes

1 answer

How to install the latest MariaDB on Ubuntu

asked Nov 8, 2019 in Databases by praveen (13.1k points)

+2 votes

1 answer

How to install the latest MariaDB on CentOS

asked Nov 8, 2019 in Databases by praveen (13.1k points)

+2 votes

1 answer

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

asked Sep 26, 2019 in Databases by praveen (13.1k points)

+2 votes

1 answer

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

asked Sep 23, 2019 in Databases by praveen (13.1k points)

+2 votes

1 answer

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

asked Sep 23, 2019 in Databases by praveen (13.1k points)

+2 votes

1 answer

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

asked Sep 14, 2019 in Databases by praveen (13.1k points)

+2 votes

1 answer

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

asked Sep 9, 2019 in Databases by praveen (13.1k points)

+2 votes

1 answer

How to convert floats to ints in Pandas DataFrame?

asked Sep 5, 2019 in Databases by pythonuser (11.5k points)

+2 votes

1 answer

How to connect to a database in PostgreSQL

asked Aug 14, 2019 in Databases by pythonuser (11.5k points)

+2 votes

1 answer

How to change the password of a PostgreSQL user

asked Jul 19, 2019 in Databases by pythonuser (11.5k points)

+2 votes

1 answer

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

asked Jul 2, 2019 in Databases by praveen (13.1k points)

Categories

Most popular tags