Skip to main content
Database Administrators

Questions tagged [row]

Ask Question

The tag has no summary.

71 questions
Newest Active Bountied Unanswered
-1 votes
1 answer
149 views

Environment We run three Jira Service Management DC clusters that all share the same topology: MySQL 8.0.36 on Ubuntu 22.04 – 32 vCPU, 100 GB RAM, buffer-pool now 80 GB (only ~33 GB in use), NVMe ...
user340962's user avatar
  • 1
2 votes
1 answer
272 views

I have the following query SELECT u.update_time, about_me FROM users u ORDER BY date_bin('14 days', u.update_time, '2023-04-07 23:11:56.471560Z') DESC, LENGTH(u.about_me) DESC, u.user_id; I get the ...
DanMossa's user avatar
  • 145
1 vote
3 answers
3k views

I have a PostgreSQL trigger that is not firing sometimes, even though the status is always shown as "enabled". My trigger code is as follows: CREATE OR REPLACE FUNCTION audit_src_exhibit() ...
Arun's user avatar
  • 23
0 votes
1 answer
687 views

I have a PostgreSQL trigger that is not firing sometimes, even though the status is always shown as "enabled". My trigger code is as follows: CREATE OR REPLACE FUNCTION audit_src_exhibit() ...
Arun's user avatar
  • 23
1 vote
1 answer
707 views

I have a table with an index and a row-level security policy. Due to this problem (more details: 1, 2, 3, 4, 5), the index is not used when the policy applies, which makes my queries unbearably slow. ...
Bergi's user avatar
  • 604
1 vote
2 answers
1k views

I want to explore (=looking at the first 100 rows) databases using the Informix SQL dialect. In Oracle SQL I would use SELCT* FROM table_name WHERE ROWNUM < 100 In Postgress SQL I would use SELCT* ...
Qaswed's user avatar
  • 121
2 votes
1 answer
99 views

I've got a table Schedule Id unserId Sunday Monday Tuesday Wednesday Thursday Friday Saturday 0 10 0 1 1 1 1 0 0 1 20 1 0 0 0 0 0 0 I need to insert lines from one row in table Schedule into seven ...
TAHER El Mehdi's user avatar
  • 292
4 votes
5 answers
6k views

I've a table Student Id Name Mark 1 Medi 10 2 Ibra 15 3 Simo 20 and I want to update it, where I want to reverse it in descending order only Name and Mark and keep Id in its order: ...
TAHER El Mehdi's user avatar
  • 292
0 votes
2 answers
4k views

How can I set a limit of rows to a mysql table? (I am using php) POSSIBLE METHOD-1: When the user tries to SIGN-UP I can select everything from the TABLE and get the number of ROWS in the TABLE and ...
user avatar
-2 votes
1 answer
1k views

I have total value in table A and need to get row value in table B until reached value in table A. Table A ID Available 1 99 2 0 Table B ID Rack RequiredQty 1 A 60 1 B 102 1 C 8 2 A 10 Expected ...
Alice's user avatar
  • 1
-2 votes
1 answer
1k views

I want to have 2 columns: Table Name and Row Count When I run this, I get 12 table names in my database. How do I then count the rows in each one without having to union 12 count queries together: ...
OPJayhawk's user avatar
  • 1
0 votes
1 answer
84 views

I'm a novice who is starting to learn about Oracle analytic functions (window functions). I know from experience that it's important to fully understand how SQL mechanisms work when using them in ...
User1974's user avatar
  • 1,527
0 votes
1 answer
240 views

This threads follows a previous one, given at this URL: MySQL 8.0.20 - Master Replica scheme, increasing delay between Source and Replica Replica Server has been configured this way, which ensures a ...
user1458792's user avatar
  • 13
3 votes
1 answer
6k views

Related to previous question here From the pg_locks documentation, row level lock information is not available when FOR UPDATE is used in a SELECT statement. Is there any way to check for row level ...
hunterex's user avatar
  • 147
1 vote
2 answers
385 views

I have a products table which contains all my products. Those products table gets filled permanently with new products. However, I want to have the possibility to "hold up"/"pin" ...
Jan's user avatar
  • 113

15 30 50 per page
1
2 3 4 5