I’m learning Mysql, a newbie. First I wrote: Select name, count(*) From Emp Group By name; and the code was successful. After that, I added to the code it became: Select * From Emp Where (Select name, count(*) From Emp Group By name) > 1; and I get an error message too many values. How… Read More How to solve errors in MySql subquery
I am trying to execute a loop while in Dbeaver with SQL Server, but the statement keeps loading and does not execute it. I just want to print the word ‘ok!’ 3 times. I’m not sure if it’s a loop problem, a Dbeaver problem, or another. Can anyone help please? My code: DECLARE @cnt INT… Read More Can't execute a while clause in SQL Server with Dbeaver
I have a question regarding Mongo indexes for a $or request on two ObjectID fields. How can I make sure a search will first look at the first argument of the $or expression and only then if no match looks at the second or should we split it into two requests and add this logic… Read More How to add index weight on two id fields on MongoDB?
My aim is to create triggers to few tables upon updation or deletion of entries from these tables. The trigger should enter the name and columns of the corresponding updated/deleted table to another user table. Instead of writing individual triggers for each table is it possible to write a single trigger ? >Solution : Instead… Read More How to write a generalized trigger for a set of tables?
I’m fiddling with sqlmap and it gives a working injected (My)SQL query: SELECT * FROM `news` WHERE ( content LIKE ? ) ORDER BY id AND (SELECT 8183 FROM (SELECT( Sleep(1) )) dyYQ) But I fail to understand what this query means, mainly the ORDER BY id AND (SELECT part. I understand both parts before… Read More what is the meaning of this injected sql?
I have a table employees ———————————————— | name | email | date_employment | |——-+——————–|—————–| | MAX | qwerty@gmail.com | 2021-08-18 | | ALEX | qwerty2@gmail.com | 1998-07-10 | | ROBERT| qwerty3@gmail.com | 2016-08-23 | | JOHN | qwerty4@gmail.com | 2001-03-09 | ———————————————— and I want to write a subquery that will display employees who have… Read More Subquery implementation
I am trying to use the receivedDateTime filter clause when calling the Graph API, but I’m running into issues when I use the exact datetime. For example, when I try running this API call: GET https://graph.microsoft.com/v1.0/me/mailFolders/Inbox/messages?$filter=receivedDateTime ge ‘2022-05-23T12:29:00’&$orderby=receivedDateTime%20ASC&$top=100&$skip=0 I get a 400 bad request (the specific error mentions "bad filter clause"). But it works when… Read More How to use receivedDateTime in Graph API Request?
$SQL = "SELECT * FROM note_list JOIN `notemaker_tables` ON note_list.notemaker_id=notemaker_tables.notemaker_id WHERE notemaker_id = ‘$notemaker_id’;"; $result = $con->query($SQL); ?> <?php <!– Featured Project Row–> <h1 class="text-white">Notes By <?php echo $notemaker_id; ?></h1><br> <?php foreach ($result as $r) { ?> <div class="row align-items-center no-gutters mb-4 mb-lg-5"> <div class="col-xl-8 col-lg-7"> <iframe id="pdf-js-viewer" src="dashboard/note-pdf/<?php echo $r[‘note’]; ?>" title="webviewer" frameborder="0" width="500"… Read More foreach() argument must be of type array|object, bool given. How can i join another table where a where clause also must be there.?
I have a question regarding SQL syntax and how my query should be done. I have atm conquered my problem using two querys and some PHP. However, let me present my DB and problem. Table structure With the unique ID of the print table i want to be able to get: dex number from prints… Read More SQL multiple joins while dealing with null values
In my Oracle database, I have two tables T1 with primary key k1, and T2 with a composite primary key k1, k2. I would like to select all columns in T1 along with the number of lines in T2 such as T1.k1 = T2.k1. It seems simple, but I can’t figure how to use the… Read More SQL subquery COUNT for Oracle