Timeline for How to write Procedure to fetch data from other table?
Current License: CC BY-SA 4.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 5, 2020 at 15:09 | history | undeleted | Nurav | ||
| Jun 29, 2020 at 3:46 | history | deleted | Nurav | via Vote | |
| Jun 28, 2020 at 9:59 | comment | added | Nurav | Let us continue this discussion in chat. | |
| Jun 28, 2020 at 9:58 | comment | added | Akina | my task is like when i hit a disabled button i want to find the buttons ??? What buttons - in MySQL??? It seems that you have a list of tasks: in some client - detect what button is disabled, get its index (?) and transter it to MySQL as a parameter of a query or SP; in MySQL - receive some value (index), find and return the rows in logs table which matches the condition for received index value: in client - receive found rows (theis index values?) and do somethind with according rows on the screen. Extract the task dealed with MySQL only from your global task,, and solve it there. | |
| Jun 28, 2020 at 9:40 | comment | added | Akina | I don't understand your task. And you hide it carefully, showing the way which you decide to use for the task solving only. And it seems that this way is not correct. For example, if you need to get all rows from t1 table, and each row must be accompanied by all rows from logs table which belongs in a minute range, then SP not needed, one simple query may solve it. | |
| Jun 28, 2020 at 9:36 | history | edited | Akina |
edited tags
|
|
| Jun 28, 2020 at 9:33 | comment | added | Nurav | @Akina It will be great help if you can solve my problem!! | |
| Jun 28, 2020 at 9:29 | comment | added | Nurav | @Akina I have made edits ,the logs and t1 table is not populated completely I want to do that when table is completely populated.I am using MySQL version 8.0. | |
| Jun 28, 2020 at 9:26 | history | edited | Nurav | CC BY-SA 4.0 |
added 415 characters in body
|
| Jun 28, 2020 at 9:18 | comment | added | Akina | Please 1) Replace table-formatted example data with its CREATE TABE + INSERT INTO scripts 2) Show desired output for this sample data with explainatons why so 3) Select ONLY ONE DBMS (looking on the code - this will be MySQL), specify its version, remove excess DBMS tags. fetch data which occur one minute before The distance between max time in logs table and min time in t1 table is over 1 min - the output will be empty. | |
| Jun 28, 2020 at 5:43 | review | First posts | |||
| Jun 28, 2020 at 8:33 | |||||
| Jun 28, 2020 at 5:39 | history | asked | Nurav | CC BY-SA 4.0 |