I need to insert values into multiple table. Please correct my code because it just double the inserted value on table_attendace if(isset($_POST['text'])) { $text =$_POST['text']; // insert query $sql = "INSERT INTO table_attendance(NAME,TIMEIN) VALUES('$text',NOW())"; $query =mysqli_query($conn,$sql) or die(mysqli_error($conn)); if($query==1) {…
I have this table that lists which months each product is available on the market. For example product 1 is available from Mar to Dec and product 2 is available from Jan to Feb. product_id start_month end_month 1 3 12…
I have a scenario: I have like 5 Boolean fields in a table, I need to set an option set value based on the number of true values of those 5 Boolean Fields: Field1 Field2 Field3 Field4 Field5 ENUMField1 values…
I'm trying to make queries to the database through goroutines, but I constantly run into limits on the number of queries and I can't solve this problem in any way :( But everytime i have "read: connection reset by peer"…
`HTTP Status 500 – Internal Server Error Type Exception Report Message Request processing failed: java.lang.NullPointerException: Cannot invoke "com.example.repository.StudentRepository.save(Object)" because "this.studentRepository" is null Description The server encountered an unexpected condition that prevented it from fulfilling the request. Exception jakarta.servlet.ServletException: Request processing…
this is myTable clientId, itemId, sellId primary is on clientId and there is also btree index no uniqe on sellId now i have part of very slow query LEFT OUTER JOIN myTable wl ON wl.itemId= ld.itemId and wl.clientId= @clientId question…
I have a quick question in relation to windowing in MySQL SELECT Client, User, Date, Flag, lag(Date) over (partition by Client,User order by Date asc) as last_date, lag(Flag) over (partition by Client,User order by Date asc) as last_flag, case when…
The scenario is a set of tables that contain data related to markets and goods produced at those markets. In the basic example below, you have Ice and this produces water. I have a SQL query which works well and…
What does this asterisk(*) mean? select employee_id, salary * (employee_id % 2) * (name not like "M%") as bonus from Employees order by employee_id;
I have 3 tables dogs, breeds and entries. I need to get AVG(score) from entries, Name from dogs and name from breeds. I have managed to connect 2 tables together and I'm struggle to get the last thing (breeds.name) attached…