Posts tagged with sql:

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...

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 ?

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 ?

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...

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...

Is faster one big SQL query or multiple small SQL queries ?I need to optimize the SQL queries to make them faster. Is it better to run one big query or more small queries ?

Fix SQL error Index for table 'user_db' is corrupted, try to repair itI am receiving an SQL error: Index for table 'user_db' is corrupted, try to repair it. I am not sure what went wrong. How can I fix this ?

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...

Characters with accents and diacritics showing incorrect - MySQLSome characters with accents and diacritics, that are loaded from MySQL database are not showing correctly on the website. I am using UTF-8 encoding in the meta tag. Could...