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: …
Tag: mariadb
How to know if an uncommitted transaction tries to insert a specific unique key into SQL
I’m writing a programm which inserts data to a MariaDB-Server and can be used by different people on the same time. The transactions take some time, so the following problem might occur: Person A …
Sql select from a table but use another table value as where clause [closed]
How can I select * from table posts but using table network_follow.follower as where condition? I have table posts, column by_user and table network_follow column follower I don’t know if that’s …
Why does my data from SQL table delete after I run this code?
I have this code that I want to run and it’s connected to my database and it uses to show the values on the table but every time I do an UPDATE query. It updates the rest of the row with zeros except …
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 …
How to calculate hours that a clinic is open taking into account break times
I am using MariaDB 10.3. I am attempting to derive how many hours a clinic is actually open for a given weekday from an provider schedule table. The clinic is considered “closed” if (1) all …
Specified Twice Table for ‘DELETE’ in MariaDB
I created a query to delete some record in MariaDB Query : Result : Table ‘HrAttLogsFormatted’ is specified twice, both as a target for ‘DELETE’ and as a separate surce for data But with the query I made unsuccessfully, is there a way to solve it? Thank you in advance [EDIT-SOLVED] It’s Solved with simply apply and query Answer I
SQL set value for case depending on whether or not value exists
I am looking up addresses from one table from a user based on the user’s email from another table, then take the resulting list of addresses and check if the address has an attribute that is stored on …
Using CASE WHEN DATE Statement in MariaDB 10.2.15
I created a query to display the ScanIn Field in one month on each date Code : SELECT Employee.Name, CASE WHEN DAY(LogsFormatted.DateIn) = 1 THEN LogsFormatted.ScanIn ELSE ‘-‘ END AS ‘1’, …
sql – Is there a way to filter through the results of a SELECT query, with another SELECT query?
Specifically, what I am trying to do is rank a table by a column value, referred here as power, and then take that ranked table and find a specific row, or a user in this case. Much like what would be …