question

salman4u avatar image
salman4u asked

how to search by query where table ID, Date and Time is based on dynamic table names

I have one table (Check) in my database and table fields are followed

ID   Start         End 1    2021-02-07    2021-02-15 2    2021-02-15    2021-02-24 3    2021-02-24    2021-02-30 4    2021-02-30    2021-03-07 5    2021-03-07    2021-03-14 6    2021-03-14    2021-03-19 7    2021-03-19    2021-03-27 8    2021-03-27    2021-04-03 9    2021-04-03    2021-04-11

and second, the dynamic table which is created dynamically when table rows reach 100000 records
table names are (Logs_1),(Logs_2),(Logs_3),(Logs_4),(Logs_5),(Logs_6),(Logs_7),(Logs_8),(Logs_9)
and soo on...these tables' first name is same but after underscore the numbers are generated from (check table) ID
logs_ fields are
Localtimestamp and Timestamp
Now I wanna do is to write a search query to get date and time data reports from logs_.
Can anybody help me?

sql querysearchdynamic-partitioning
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.