I'm trying to extract values from a text file. The content of the file is as follows: Cliente 1, 'Aarón', 'Rivero', 'Gómez', 'Almería', 100 2, 'Adela', 'Salas', 'Díaz', 'Granada', 200 3, 'Adolfo', 'Rubio', 'Flores', 'Sevilla', NULL 4, 'Adrián', 'Suárez', NULL,…
Our company has a pretty old app built on php 5.6 and mysql. We recently decided to make some changes and change where its hosted. Though migration process with a tad bit of a pain, it went well for the…
This is my User Model module.exports = (sequelize, DataTypes) => { const User = sequelize.define("User", { email: { type: DataTypes.STRING, allowNull: false, unique: true }, password: { type: DataTypes.STRING, allowNull: false } }) return User } and i am try…
this is my login.php <?php session_start(); require_once('db_connection.php'); if ($_SERVER['REQUEST_METHOD'] === 'POST') { $username = $_POST['username']; $password = $_POST['password']; $sql = "SELECT id, username, full_name FROM users WHERE username = ? AND password = ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("ss", $username, $password);…
Iam trying build a query to get latest purchase date for given product id but for now still having errors. function check_date_purchased($product_id){ $args = array( "posts_per_page" => -1, "product_id" => $product_id, "orderby" => 'date', "order" => 'DESC', "status" => "completed",…
I'm trying to create a query where if customers took 1 trip that day, then they would have to pay the price of a single ticket (200). If they took 2 trips on the day, then they would have to…
I have an SQL script, which returns the data from a Clickhouse table in amount of ~23k rows. I want to insert that exact data into a table in MySQL. Since they're two different DBs and there's no proxy to…
I have an exercise where I have to rewrite a query without using the NOT EXISTS. For example, I can have this query that is for getting all the employees older than 30 that are not managers: SELECT * FROM…
I have the following table called account_refunds: id | referrals(type json) | accountID ___________________________ 123 | [1,2] | 001 124 | [3] | 001 125 | [4] | 001 126 | [5,6,7] | 001 127 | [4] | 001 In…
There is a jobs table, jobID state timestamp 1 inProgress 2023-11-02 10:39:37 1 some random log 2023-11-02 10:40:37 2 inProgress 2023-11-02 10:43:37 1 inProgress 2023-11-02 10:44:37 1 inProgress 2023-11-02 10:45:37 1 inProgress 2023-11-02 10:50:00 1 end 2023-11-02 11:40:37 1 inProgress…