I’ve next database structure: friends: id, first_name, last_name, friends_activities: friend_id, user_id, type (enum), created_at, friends_reactions: friend_id, user_id, type (enum), And I need to count all friends_reactions and friends_activity together as e.g. engagements_count. So far I’ve created eloquent relationship in the…
what does means ref=const,const in mysql explain statment? i add index for the table and the index contains tow columns where statment contains two index columns and some not in index columns why does the explain statment extra column show…
I have an inventory system with bins, lots, and transactions. Bin: has many lots Lot: belongs to a bin belongs to many transactions transaction_lot (pivot) - quantity Transaction: belongs to many lots Right now I have an attribute on Transaction…
My table structure is following : CREATE TABLE `tbl_erp_invoice_lines` ( `ID` INT(11) NOT NULL AUTO_INCREMENT, `INVOICE_ID` INT(11) NULL DEFAULT NULL, `PRODUCT_ID` INT(11) NULL DEFAULT NULL, `LINE_UNIT` VARCHAR(10) NULL DEFAULT 'KG' COLLATE 'utf8_bin', `LINE_PRICE` DECIMAL(7,3) NULL DEFAULT NULL, `LINE_QUANTITY` INT(11) NULL…
I have three models: Product Review Score They are linked like this: Product (hasMany) -> Review (hasOne) -> Score Review model: text product_id score_id Score model: value (number) My relation in Product model: public function reviews () { return $this->hasMany(Review::class,…
I have some calculation and want to do this in the query. There is parent and children tables with one-to-many relationship: CREATE TABLE `parent` ( `id` int NOT NULL AUTO_INCREMENT, `value` decimal(10,2) DEFAULT NULL, PRIMARY KEY (`id`) ); CREATE TABLE…
I am using the Sakila Database for practice. I am calculating - Sales by Store. It provides a list of total sales, broken down by store. It incorporates data from the city, country, payment, rental, inventory, store, address, and staff…
I have this data in mysql 5.7 drop table if exists t_test; create table t_test ( dates date, num int ); insert into t_test values('2022-02-01', 10), ('2022-02-10', 20); How to get this data with sql? date_add('2022-02-01', interval 30 day) =…
With spring boot, I want to delete data greater than 48 hours in the database with a sql query. I want to delete data in database more than 48 hours. DELETE FROM schedule WHERE date_time < NOW() - INTERVAL 48…
String valChecker = "SELECT * FROM `committee_memba` where (Rank= 'Chairperson' or Rank='Vice-Chair') and committee_name='" + jComboBox1.getSelectedItem().toString() + "'"; System.out.println(valChecker); PreparedStatement stmt = conn.prepareStatement(valChecker); rs = stmt.executeQuery(); while (rs.next()){ String rnk = rs.getString("Rank"); System.err.println(rnk); if ((rnk.equals("Chairperson") && rank.equals("Chairperson")) || (rnk.equals("Vice-Chair") &&…