Composite serial column in mysql
Is it possible to create a serial column based on another column in MySql? Example table reg val serialval 1 a 1 1 b 2 2 z 1 2 x 2 2 y 3 If I insert another reg 2…
MySQL Authentication Plugin Issues on macOS
I’m working on a blog project using Python and Flask, and I’m using the MySQL database from XAMPP for user registration. The project worked perfectly on my Windows machine, but after switching to macOS, I’ve been encountering various issues with…
Mysql – SQL query within the same table
I'm use to simple SQL queries and can't get this one. I have a members table that is set like so: member_id | member_number | member_fname | member_name | member_parent_id | member_status member_parent_id is a reference to member_id I need…
Mysql – Merge several tables into one where tables have the same columns but only add rows where unique values exist on one column
The below code works to insert rows into table_main on an mySQL database where table_A contains unique values from the column primary_isbn13 INSERT INTO `table_main` SELECT * FROM `table_A` A WHERE NOT EXISTS (SELECT 1 FROM `table_main` X WHERE A.`primary_isbn13`…
Mysql – Query answer column derived from a combination from columns in another table
TNM Staging I am doing my first project. I have some data t_stage is from t0 to t4, n_stage n0 to n3 and m_stage is m0 and m1. Different combos of these give different results. So t1,n2,m0 is Stage3a, t4,n1,m1…
Mysql – Update multiple column of a SQL table based on another table
I have two tables, TableA & TableB All tables data are available here: db<>fiddle TableA as follows: TableB contains the passed/failed scenario as follows: I want to updating tableA with data of tableB for particular A_id. I'm expecting tableA output…
Mysql – Need a solution to add a numeric value in the database
The actual form : <div class="form-input"> <label for=""><?php esc_html_e( 'NAME', 'daily-attendance' ); ?></label> <input type="text" required readonly value="<?php echo esc_attr( $current_user->display_name ); ?>"> </div> <div class="form-input"> <label for=""><?php esc_html_e( 'DATE', 'daily-attendance' ); ?></label> <input type="text" required readonly value="<?php echo esc_attr(…
Can I change type column in Laravel polymorphic relation?
I have three different model in my Laravel project; Convoy, User, Driver. Driver is a different model than User because of they can not authenticate. Whatever, there is also one more model: Address. I am storing address values on the…
Mysql – Check if a record from one table exists in another and disable option
Attempt - which returns all registrations that has reportDate = CURRENT WEEK. SELECT * FROM registrations LEFT JOIN reports on registrations.registration=reports.registration WHERE reports.reportDate between cast(timestampadd(SQL_TSI_DAY, -(dayofweek(curdate())-2), curdate()) as date) and cast(timestampadd(SQL_TSI_DAY, 7-(dayofweek(curdate())-1), curdate()) as date) I want to achieve the…
Insert to mysql table with a column automatically has same value as another column
I has a mysql table with 2 int columns. The first column is auto_increment. Then, I want to insert whether a certain value or the value of the first column to the 2rd column. For example insert into tab(id,keyy) values…