All Sql related Questions

What is Concatenation Operator in SQL?

Read more

what is Structured Query Language? how to use Structured Query Language?

Read more

so in above query if some input " ''; truncate table anytable name " as username so if that so it will empty table anytable

Read more

how to apply group by multiple columns in a select query? I have table orders where restaurants place orders for recipes, so I want to know the count of orders or specific recipes for each restaurant.

Read more

I am working on search-related code to find products from the table in the database but I want to print the query to debug it properly. i am trying to print query but not sure getting error .

Read more

Is SQL injection possible with mysqli_real_escape_string?

Read more

What are the join types in join condition?

Read more

I want to calculate time between 2 Dates of a day with multiple rows

Read more

find record which one day before from now MySQL ?

Read more

How does database indexing work?

Read more

i want to list course name form the table course with student info. student_id is foreign key at course table , id is primary key at student table. i did it with join in "where clause" i got same result for both query. so what is difference between where clause and on clause in SQL join , whats is pros and cons of " where clause" vs "on clause" in SQL join currently dealing with MySQL but SQL , PostgreSQL all have same story i think,

Read more

i am managing to code a delete query so i can delete some selected entries form table which got from another select query . situation like this i want to delete all the common value contained row for a particular field . so i asked for and i got that i can write it by a query where i can compare same field 's value to same field's other value in same table . query is as below it give me all rows which have same value for users(tablename) 's name (field) now i want to delete it which most recent . want to keep old one . i know i can do it with separate query but i want to do it with single query where delete + above select query is that possible to join delete and other select so that we can use select query 's result to delete row ?

Read more