here are my tables: products table: CREATE TABLE `products` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `description` text NOT NULL, `price` decimal(15,2) NOT NULL, `total_profit` decimal(15,2) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT…
I have randomize the order of records in a table using SELECT * FROM TableA ORDER BY rand(); How do I seva the result table of this query? When execute the query, I indeed got a shuffle order of the…
I have a MySQL table with two columns, row1 and row2, and theese columns together increased. +------+------+ | row1 | row2 | +------+------+ | 10 | 100 | | 11 | 110 | | 20 | 200 | | 21…
I have db on MySQL - dataset with users actions logs. We have next data collection logic - every user have it own user_id and we record log of event actions during user session. user_id session_id dateTime event 1 aa…
I've deployed my asp.net core 5 web api on IIS on the production server, and i'm getting this error: Microsoft.EntityFrameworkCore.Database.Connection[20004] An error occurred using the connection to database 'myDbName' on server 'my Ip (es. 171.1.1.0)'. fail: Microsoft.EntityFrameworkCore.Query[10100] An exception occurred…
I am using mysql-connector-c++-8.0.33 and C++ code to connect to database. Here is the code, try { sql::Driver *driver; sql::Connection *con; sql::Statement *stmt; sql::ResultSet *res; sql::ConnectOptionsMap connection_properties; driver = get_driver_instance(); connection_properties["hostName"] = "localhost"; connection_properties["userName"] = "correctusername"; connection_properties["password"] = "correctpassword"; connection_properties["schema"]…
I have the following query: SELECT * FROM customers_cards WHERE id NOT IN ( SELECT card_id FROM customers_card_psp) It takes about 2sec to get executed and we need this query to get called on a highly visited page. Any idea…
Lets say I have a table T1. Initially it has ID, Identifier, C1, C2 as columns. As time goes by I will be adding new columns C3, C4 and so on. Will it be better to have the columns as…
I am on laravel mysql and I want a percentage and number of how many new users have been created or left in the past 30 days. For example, if there are 3 users before 30 days and 2 new…
i'm trying to get this code to work but it seems that the post__in condition is not being taken into account by the query: $currentPostID = get_the_ID(); $parentPostID = wp_get_post_parent_id($currentPostID); if ($parentPostID) { $args = array( 'post_type' => 'post', 'post_parent'…