I have 2 tables: users and users_arrivals, I need to create a list of users who was in work in specific ranges of dates. Users table looks like: | id | firstName | lastName | | — | ——— | ——– | | 1 | John 1 | Test 1 | | 2 | John… Read More MySQL get all users who was in work in exact week
I’m trying to update all child objects to match their parents metadata value, but this query doesn’t seem to update anything? It reports 10 rows affected, but when I query for them they aren’t found. Update Query: UPDATE worker_items SET metadata = (SELECT metadata FROM worker_items WHERE id = worker_items.origin_id) WHERE depth != 0 AND… Read More MySQL: Update with sub query?
I have a mysql database called employee. I want to connect to this database using netbeans. I get the following exception: ava.sql.SQLNonTransientConnectionException: Cannot load connection class because of underlying exception: com.mysql.cj.exceptions.WrongArgumentException: Failed to parse the host:port pair ‘localhost:3306:employee’. My code is: try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException ex) { ex.printStackTrace(); } try { String dbURL… Read More Why netbenas cannot connect to mysql?
i have a following mysql table, where multiple user has accepted a lead (lead_id). here i want to stop updating table column ‘Value’ when ‘status’ is ‘settled <?php $sql = "SELECT `status`,`email_id` FROM `deal_request` WHERE `client_id` = ‘$client_id’"; $query = mysqli_query($connection, $sql); if ($query->num_rows > 0) { while ($row = mysqli_fetch_assoc($query)) { $status = $row[‘status’];… Read More stop updating column value when status is settled for similar lead id using PHP, MYSQL
When using a SET clause in a MySQL statement, mysqli->prepare returns false. This MySQL statement will "prepare" okay: $query = " INSERT INTO log (channel, message, context, datetime) VALUES (?, ‘testmsg’, ‘{}’, CURRENT_TIMESTAMP); "; $stmt = $mysqli->prepare($query); // $stmt will be true This statement will cause "prepare" to return false. $query = " SET @Channel… Read More Using MySQL variable in PHP Prepared Statement
I have 2 tables that I’m importing from CSV files, companies (8000 records) and contacts (11000 records). The contacts have company names which match the names in the company table. After I’ve inserted the records I need to add the companyID to the contacts table. a_test_company +—————+—————+ | companyID | companyName | +—————+—————+ | 1… Read More MySQL – compare 2 tables and update the 2nd from the 1st
I have the following mysql query which works as expected. SELECT DISTINCT u.id, CASE WHEN a.result IS NULL THEN 0 ELSE a.result END ‘result’, RANK() OVER(ORDER BY result DESC) as ‘rank’ FROM wp_users u, wp_usermeta um, (SELECT pm.meta_value, COUNT(*) result FROM wp_postmeta pm, wp_posts p where p.id = pm.post_id and p.post_status = ‘publish’ and pm.meta_key… Read More MySQL Add string "T" for when there are ties using RANK
Frist I have table of general notifications this table have three field ID+Body+Date and from my app flutter any message send to users save this message in this table. Now the problem is, the message goes to all users, so I’m trying to make a way to find out which users have seen this message… Read More How to verify of notifications data before showing them to user PHP MySQL
Frist I have table of general notifications this table have three field ID+Body+Date and from my app flutter any message send to users save this message in this table. Now the problem is, the message goes to all users, so I’m trying to make a way to find out which users have seen this message… Read More How to verify of notifications data before showing them to user PHP MySQL
My database has a layout like this: StudentID ActivityNumber Payed 1 1 1 2 1 0 3 1 1 4 2 0 The Payed column is a boolean to look if a perseon has payed yes or no and not to look how much he/she payed now as you see nobody payed for activity 2… Read More Count boolean in mysql