Posts tagged with sql:

Difference between Fetch_assoc, Fetch_array, Fetch_row - MySQLWhat is the difference between Fetch_assoc, Fetch_array and Fetch_row in MySQL. When is it effective to use each of them ?

Error: Illegal parameter data types INT and row for operation '='I am trying to use SELECT in SELECT in SQL query, to count the matches, but I am getting SQL error: Illegal parameter data types INT and row for operation '=' What...

Fix error: mysqli_select_db / query expects 2 arguments, 1 givenI have upgraded MySQL to a higher version, but I am getting an error: Fatal error: Uncaught ArgumentCountError: mysqli_select_db() expects exactly 2 arguments, 1 given How...

MySQL, MariaDB, SQLite, PostgreSQL, Oracle, MS SQL, DB2 - differenceWhat is the difference between MySQL, MariaDB, SQLite, PostgreSQL, Oracle, MS SQL and IBM DB2 ? Which one is better than the other ? Do they work with regular SQL language ?

SQL to calculate total balance amount of each owner - debit/creditHow should the SQL Select look like, if I need to get the total account balance for each customer, from debit and credit transactions ? Table looks like: Transaction ID,...

Advantage of PL/SQL procedure and function - when to use ?What is the difference between PL/SQL procedure and function ? When is better to use procedure and function ?

SQL Select rows using LEFT JOIN - where count is 0 matchesI need to get rows from one SQL table when there are zero matches for a specific condition in the second table. I am using SQL SELECT with LEFT JOIN. How can I create a...

Insert or update current date in DATETIME format - SQLWhat SQL function should I use to insert or update current date in DATETIME format in table cell ? I tried to use GETDATE() but it is not working.

Copy and update rows in the same table with autoincrement - SQLI need to copy the specific range of rows into the same table with autoincrement and update them. How can I do it by using SQL INSERT INTO function, without creating of the...

Fatal error: Call to undefined function mysql_query() - PHPOn my new hosting, when I try to get the data from MySQL database with SELECT statement, the following error notification appears: Fatal error: Uncaught Error: Call to...