user avatar
user avatar
user avatar
ReynierPM
  • Member for 10 years, 2 months
  • Last seen more than a month ago
13 votes
4 answers
106k views

Datatype for phone number: VARCHAR, INT or BIGINT?

10 votes
3 answers
2k views

Integrity constraints in a relational database - should we overlook them?

6 votes
2 answers
27k views

How to enable queries logs in MariaDB

5 votes
1 answer
98 views

Will these queries return the same results?

5 votes
3 answers
37k views

How to update column value by adding "1" based on a condition?

4 votes
1 answer
469 views

Can a database be created with no user and/or owner?

4 votes
4 answers
20k views

Views with parameters, is it possible?

4 votes
3 answers
2k views

INSERT/UPDATE in same query from previous SELECT with some singularities

4 votes
2 answers
12k views

Select rows where value of second column is not present in first column

4 votes
3 answers
49k views

How to select/count rows where the same value exists in a column but not in other column all at the same table

4 votes
1 answer
4k views

How to enable implicit casts in PostgreSQL >=9.2?

3 votes
4 answers
6k views

One table with many rows or many tables with a few rows

3 votes
1 answer
246 views

Get profiles values where message.sender_user_id = profile.user_id

3 votes
2 answers
16k views

Error: This version of MariaDB doesn't yet support 'multiple triggers with the same action time and event for one table

3 votes
1 answer
1k views

Update columns values using select from external database and table in MariaDB trigger

3 votes
2 answers
67 views

What's the best way to diagram this "relation" looking for performance and|or disk space savings

3 votes
3 answers
88k views

The user specified as a definer ('root'@'%') does not exist

3 votes
0 answers
3k views

Which is the right way to fix "Error: 1205 Lock wait timeout exceeded; try restarting transaction"

2 votes
1 answer
2k views

INSERT don't work with NOT NULL but UPDATE does, why?

2 votes
1 answer
146 views

Rock-Paper-Scissors-Spock-Lizard statistics DB design, is there a better way to achieve this?

2 votes
1 answer
26 views

How to get a list of restricted_components with it's related information?

2 votes
1 answer
12k views

Extract some columns data from one table and insert into multiple tables

2 votes
1 answer
2k views

How to set unique columns combination

2 votes
0 answers
229 views

Get all comment.message, status.message, users.* and profiles.* where users.user_id exists in friend.friend_id or friend.user_id

2 votes
1 answer
159 views

Several values from different tables

2 votes
1 answer
192 views

Need some help with this query get all status and their associated comments of me and all my friends

2 votes
1 answer
116 views

Get the id_user_app if not exists in id_user_rq

2 votes
1 answer
39 views

Get the rows where id_user_rq exists in id_user_ap and viceversa

2 votes
1 answer
515 views

SELECT for values in a table

2 votes
3 answers
1k views

How to get all non deleted messages from one user