Skip to main content
Saeed Neamati's user avatar
Saeed Neamati's user avatar
Saeed Neamati's user avatar
Saeed Neamati
  • Member for 11 years, 9 months
  • Last seen this week
  • Tehran, Iran
0 votes
0 answers
33 views

Is using a unique string as key a common practice in databases?

0 votes
1 answer
19 views

Stuck at finding the syntax error in group_concat and prepare in MariaDB

1 vote
1 answer
53 views

How can I get duplicate entry error on a table that only has one record?

0 votes
0 answers
39 views

How to create all-valid UUIDs from a given text for MariaDB?

0 votes
1 answer
23 views

How can I sort from the least dependent view to the most dependent view?

4 votes
4 answers
15k views

SQL Server Management Studio (SSMS) is way too slow in its GUI

0 votes
1 answer
70 views

Stuck for errno: 150 "Foreign key constraint is incorrectly formed" in MariaDB

0 votes
0 answers
184 views

ERROR 4078 (HY000) at line 167956: Illegal parameter data types uuid and int for operation '='

0 votes
1 answer
2k views

Is it possible to select all columns but one column using SQL syntax?

0 votes
0 answers
28 views

Update parent table, based on one record from children table (one-to-many)

0 votes
0 answers
112 views

How can I optimize the view in MariaDB for Order By?

0 votes
0 answers
33 views

Enumeration table, separate databases, readability and performance

0 votes
1 answer
77 views

Considering that we don't want logs, what files should I put into my MariaDB's file-based backup plan?

1 vote
1 answer
948 views

What cons should I consider if I put index on every UUID column in my database

10 votes
2 answers
19k views

How to free the unused space for a table

1 vote
1 answer
48 views

How to solve this problem for hierarchical data structure?

0 votes
0 answers
70 views

Stuck at making a recursive query work in MariaDB

0 votes
1 answer
445 views

Unable to translate Unicode character \\uDCC9 at index 5 to specified code page

0 votes
1 answer
144 views

Stuck at importing data directly from the staging machine to the development machine in MySQL/MariaDB

0 votes
0 answers
456 views

How to check a value is UUID in MariaDB?

0 votes
1 answer
893 views

Delete all data of all tables of all user databases in MariaDB

1 vote
0 answers
79 views

Why on the VPS, uuid() is wrapped in a single quote?

0 votes
1 answer
169 views

Stuck at inserting records into MariaDB conditionally

0 votes
0 answers
169 views

Letting MariaDB infer the data type of the generated column

0 votes
0 answers
2k views

MariaDB Access denied for user 'root'@'192.168.80.4' (using password: YES) for some databases

0 votes
1 answer
2k views

Why SQL Server docker image uses high CPU all the time, and how to fix it?

6 votes
1 answer
1k views

Equivalent of a SQL Server schema in MySQL?

4 votes
2 answers
357 views

Why is the result of a totally deterministic and all-encompassing "case" in select query in view nullable?

0 votes
2 answers
1k views

How to drop a procedure across a lot of databases (SQL Server 2016)

0 votes
1 answer
167 views

quotename(object_schema_name(@objectId)) returns null when called as a synonym