I have a problem. I have a table with 6 million records in it. Every record has a column dateTime, and for my code I need the most recent 16 records in ascending order. This took too long to query directly out of the original table, so I created a view using the following query: This means that the view
Tag: mariadb-10.3
MYSQL codes not being read
When I input a code or anything into MySQL and hit “enter” it moves down and “->” appears. It is as if the code is not going through or the code is not being read. I have attempted to download “add-ons” but I am really not sure what I am doing. This is for school and I am having trouble
Mysql Employee break time history with time difference
I have employee biometric log data with inoutmode flag. I am trying to get detail break time list and with time difference. inoutmode 4 as break-out and 5 as break-in. INSERT INTO `tbl_downloadentry`…
SQL Group rows in left join into one
i try create query with left join when i combine multiple rows into one. I try with GROUP_CONTENT function but when i try use it my db server is going down. I use MariaDB 10.3.17. I have tables like: …
How chceck is id is used in other column in same table
I’m using MariaDB 10.3 and I have table like: post_id post_content post_user_id post_shared 1 Test1 1 0 2 Test2 2 0 3 Test2 1 …