print only part of string in a column – Mysql
I wanted to print only one part of string in column and ignore the remaining stuff including special characters, how can i acheive it | A | B | | -------- | -------------- | | abc | zet=kadala; | |…
how to query current week and month data with `SQL` in MySQL?
Supposed I have data as below: id cnt insert_time 1 234 1679131273 2 12 1679131273 3 80 1679131514 4 30 1679131514 5 124 1679131605 6 4.3 1679131605 7 4 1679131935 8 1.5 1679131935 9 5 1679292635 10 56 1679292635 I…
How to set default DATE when creating table in mysql 8.0.32?
I am trying to create a table with a column with a DATE type. I would like to set the default value for this field to be CURRENT_DATE. This does not work as expected, especially when compared to doing the…
How Can SUM data in Multi columns from multi tables in mysql?
I have 4 Tables : 1- Suppliers ID_A Supplier_name 1 Apple 2 Xiaomi 3 Nokia 4 Oppo 2- Start Balance ID_B Start Balance 1 1000 2 1000 3 1000 4 Null 3- Invoices ID_C Invoice_value 1 200 1 500 2…
MySQL 8: Query Performance between subquery with GROUP BY and INNER JOIN with GROUP BY
I have to retrieve a list of postings, by one or more category IDs. I do not want to have duplicate postings in my results. I'm only interested in responses that directly relate, or can draw relations with MySQL 8…
Extracting python list values in MYSQL
I have a column in MySQL database which contains a python list of json formatted values like below: Column [{"name":"me","color":"red"} , {"name":"you","color":"blue"}] I could not use json_extract() function because it's not formatted exactly as a json I want to extract…
Else statement's code is also printing even though if statement is true – Mysql
This is the code: <% try { String enteredOtp = request.getParameter("otps"); String actualOtp = (String) session.getAttribute("OTP"); if (enteredOtp.equals(actualOtp)) { String eemail = (String)session.getAttribute("eemail"); Connection con; Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql","root","12345"); Statement stm = con.createStatement(); String m = "select * from empinfo…
How to get the name of the parent_id of a category table from post table – Laravel
I have the following table in "Category" table. id name parent_id 1 student NULL 2 teacher NULL 3 math_student 1 4 science_student 1 I have the following table in "Post" table. id name category_id 1 Ajay 3 2 Mohan 3…
Using mySQL how to write query on "show the group(s) with maximum/minimum employees in it"?
So I can't remember how exactly I can show all groups with MAX/MIN ppl in them. Say there is a table with columns Id, name, role(employee, employer), groupName(a1, b2, c3...) and I need to list MAX/MIN number of the employees…
Retrieve latest few records from the table based on one column – Mysql
I am trying to retrieve the latest few records from the table based on grouping one of the column values which is not a primary key. This means there will be more than one row for a specific column value…