Skip to main content
Rohit Gupta's user avatar
Rohit Gupta's user avatar
Rohit Gupta's user avatar
Rohit Gupta
  • Member for 9 years
  • Last seen this week
33 votes
Accepted

Is there an alternative to "Create or replace procedure" in MySQL?

4 votes

Why are unquoted identifiers upper-cased per SQL-92?

3 votes

using ON UPDATE for non-timestamp columns

3 votes

Why do we keep insert statement in logical backup?

2 votes
Accepted

Changing data type of an existing column of SQL database

2 votes

How to manage mysql database table index

1 vote

Does the Size of Unselected Columns Impact Performance of SELECT Queries in MySQL?

1 vote

select user with least amount of tiquets between all other users

1 vote

Table partitioning for data pruning purposes

1 vote
Accepted

How can i solve Statement failed problem?

1 vote

How to interpret "transactions per second"?

1 vote

Dates - start and end vs only start

1 vote
Accepted

Hotel booking database design

1 vote
Accepted

MariaDB Power Outage Issue

0 votes
Accepted

Importing CSV File into MySQL gives UnicodeDecodeError

0 votes

Auto-increment text primary key in postgres

0 votes

Table aliasing to a column allows direct access to the column with same name?

0 votes
Accepted

one table or different tables for different transactions?

0 votes

Postgres long transaction holding advisory lock

0 votes

Window function with subquery results to unexpectedly slow query plan

0 votes

Equality Range Query in MySQL runs very slowly

0 votes

SQL query using MAX with multiple table joins

0 votes
Accepted

AUTO_INCREMENT is not working in mysql8 :(

0 votes

When performing a migration, how do you handle a new column needing a value but not being able to provide one for the migration?

0 votes

MySQL is pretty slow after 50-100k rows whats happen?

0 votes

How to store historical correlation matrices?

0 votes

problem of correspondence between scheduled shifts and actual shifts

0 votes

unknown database backup file extension *.gbk

0 votes

Sudden huge RAM usages with FireBird 4.0

0 votes

Xamarin.Forms Working with Data