I want to select all package_id that contain product_id 2. In this case, package_id 1,3,5 has product_id 2 Table: product_package package_id package_name product_id --------------------------------------------- 1 Gold 1,2,3 2 Platinum 4,5,12 3 Diamond 2,11,5 4 Titanium 3,5 5 Basic 2 I…
i tried to use subquery to show JOB_TITLE in the result this code work , but i can't add JOB_TITLE 'Jr. Designer' in the result select EMP_ID,F_NAME,L_NAME from employees where job_id in (select job_ident from jobs where JOB_TITLE= 'Jr. Designer');
I was trying to insert values to MySQL database with following code: $pdo = new PDO('mysql:host=localhost;dbname=project;charset=utf8;, 'admin', 'password'); $stmt = $pdo->prepare('INSERT INTO userdata values(?, ?, ?, ?, ?)'); if ($stmt->execute(null, '"'.$_REQUEST['username'].'"', '"'.$_REQUEST['password'].'"', '"'.$file.'"', null)) { echo 'Inserted' } else {…
I want to calculate average customers will order but when i calculate there's have a problem, mine is: SELECT CustomerID, (MAX(SalesDate) - MIN(SalesDate)) / (COUNT(*) - 1) FROM TrSalesHeader GROUP BY CustomerID HAVING COUNT(*) > 1 and i've message "Operand…
SQL query for extracting last entered number field(if we enter 11 in 3 rows take last row) from a table.Consider the following table I want to show result like this
I read Syntax for Persisting System Variables in MySQL documentation about PERSIST and PERSIST_ONLY as shown below: To persist a global system variable to the mysqld-auto.cnf option file in the data directory, precede the variable name by the PERSIST keyword…
I have the following talbes: CREATE TABLE topics ( id INT, text VARCHAR(100), parent VARCHAR(1) ); CREATE TABLE sentiment ( id INT, grade INT, parent VARCHAR(1) ); And the following data: INSERT INTO topics (id, text, parent) VALUES (1, 'Cryptocurrency',…
Here is the code, and when I run it, it only executes once... export const postStock = (body) => { for (let val of body.order.values()) { let sql = ` INSERT INTO stockmaster (stocknum, cat_id, user_id, dyenumber, stockQty) VALUES ('${body.stocknum}',…
I am trying to query the code, name, and the number of rentals of customers who have made at least ten rentals. My query: Select client.ClientCode, client.ClientNom, (location.LocationRef) FROM client INNER JOIN location ON client.ClientCode = location.ClientCode WHERE location.LocationRef >…
what happens here is we find referral ids from database by step by step here is the database this is how i call my function referralincome($uid, [], 1); And here is the output. You can add pre tag to check…