Ergest Basha's user avatar
Ergest Basha's user avatar
Ergest Basha's user avatar
Ergest Basha
  • Member for 2 years, 6 months
  • Last seen this week
2 votes

Skip views when using mysqldump

2 votes

How to exceed max_execution_time when running a mysqldump?

2 votes

What are the possible downsides or consequences of using ALGORITHM=INPLACE, LOCK=NONE when running alters on a table?

2 votes
Accepted

MySQL 8 trailing spaces being evaluated in equals comparison

2 votes

Can Somebody help me understand this query

2 votes
Accepted

Presto/Mysql join validation

2 votes
Accepted

Getting how many days users have logged in during a month (same day counts as 1 log in)

2 votes

SQLite: concatenate multiple columns across multiple tables

2 votes
Accepted

Postgresql explain alter table add column doesn't work

2 votes
Accepted

Column isn't in GROUP BY error on join query

2 votes
Accepted

DBMI-SQLite driver error: Error in sqlite3_prepare(): near ".": syntax error in db.execute command

2 votes

In GRASS GIS db.execute IN statement works, but NOT IN doesn't

2 votes
Accepted

UPDATE & SELECT & INNER JOIN combined (SQL92) — How?

2 votes
Accepted

Load file shows insert statements in MySQL Table

2 votes

MySQL: How to make Trigger to insert row in another table?

2 votes
Accepted

Oracle SQL: Create a new field based on multiplying 2 columns

2 votes
Accepted

This query gives error. right syntax to use near 'on vehicles.school_id = schools.id left join drivers on drivers.school_id = ...' at line 8

2 votes
Accepted

In the MySQL host-name does the '%' in '%.exemple.com' covers the main domain 'exemple.com' as well or only its subdomains?

2 votes
Accepted

What is best practice on creating an index?

2 votes
Accepted

MySQL InnoDB foreign key requirements (index/unique/primary)

2 votes

SQL multiple condition case when

2 votes
Accepted

How can I subtract or get compare difference in values within the same column from the top result column result as the base?

2 votes
Accepted

Creating a Trigger in MySQL that has a JOIN

2 votes

MySQL optimize query against table containing 13M records

1 vote

DB2 query not working

1 vote
Accepted

MySql count using and still show all data even using where clause

1 vote
Accepted

Should a frequently-growing log file be stored as a table or a blob in the database?

1 vote

MySQL query optimisation

1 vote
Accepted

Can I update multiple columns at once with multiple conditionals?

1 vote

can be NULL same as 0000-00-00 in a nullable DATETIME column while selecting rows?