Posts tagged with mysql:

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

Incorrect integer value '' for column 'user_id' at row 1 - errorAfter MySQL version upgrade, I receive an error notification: Incorrect integer value '' for column 'user_id' at row 1 There were no modifications in code...

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

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 ?

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 ?

Error: User has exceeded the 'max_queries_per_hour' resourceSometimes I am getting an error notification: User has exceeded the 'max_queries_per_hour' resource (current value: 15000) I am using a PHP and MySQL database. How...

Mysql, Mysqli, PDO - difference, procedural or object oriented ?What is the difference between Mysql, Mysqli and PDO ? Is each of them procedural and object oriented ?

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

Is faster InnoDB or MyISAM MySQL engine ? What's the difference ?What is the difference between InnoDB and MyISAM engine in MySQL table ? Which one is faster ?