Generate a Composite ID for an entity – Mysql
I have an entity where I want to generate value like this. like this id tenant 1 1 2 1 3 1 1 2 2 2 3 2 1 3 2 3 3 3 Keep in mind that multiple instances…
Retrieving latest dates grouped by a key column value (MySql)
Given the following table with purchase data. CREATE TABLE myTable ( id INT NOT NULL AUTO_INCREMENT, date DATETIME NOT NULL, subNo SMALLINT NOT NULL, poNo INT NOT NULL, PRIMARY KEY (id)) INSERT INTO myTable VALUES (0, '2022-11-01 12:43', 1, 800),…
how to run two statements in one funcation – Mysql
I'm trying to delete from two tables using one function. Controller code: public function userdelete() { $u_id = $this->uri->segment(3); $lr_id = $this->uri->segment(3); $returndata = $this->user_model->user_delete($u_id, $lr_id); if($returndata) { $this->session->set_flashdata('successmessage', 'user deleted successfully..'); redirect('users'); } else { $this->session->set_flashdata('warningmessage', 'Something went wrong..Try…
How can i change SQL date format to: 12th Jun 2021. (as example) – Mysql
So, I'm trying to insert data from .csv file, but because of the date format I'm using - import causes it to set to 00-00-0000 import settings: format - CSV using load data (otherwise it causing errors and failing to…
How to connect Azure Database for MySQL flexible server in Azure SQL Server Database
I am trying to set up a connection between Azure MySQL flexible server and Azure SQL database mainly to read data from MySQL and store it in the SQL Server periodically (multiple times a day). I was thinking of creating…
inserting multiple values into one row mySQL
How can i insert multiple values into one row? My query insert into table_RekamMedis values ('RM001', '1999-05-01', 'D01', 'Dr Zurmaini', 'S11', 'Tropicana', 'B01', 'Sulfa', '3dd1'); i cant insert two values into one row. is there another way to do it?
which MySQL function can be use to have the count of Orders and shipments with respect to Month?
I have Data which indicates month of Order date and month of Shipment date. I want to convert the records which will show, in each month, what is the count of orders and in same month what is the count…
Get only users that do not have the id equal to a condition and are admin(SQL) – Mysql
I have two tables, user: id full_name is_admin 1 jane 0 2 Helio 0 3 fran 0 4 mila 0 5 admin 1 approver : id subordinate_id approver_id 1 1 2 2 3 4 and I would like to perform…
What is stored in index leaf nodes when a table has only secondary index? – Mysql
If a table has a clustered index and a secondary index, the leaf nodes in secondary index contain the attribute value of the clustered index. But what if a table only has non-clustered index? How can a non-clustered index retrieve…
MySQL – Show the restaurant name and items where price is over a certain value
I have two tables: restaurant | id | name | | -------- | -------- | | | | food_item | restaurant_id | name | price | | -------- | -------- | ----- | | | | | | | |…