Top "Mysql" questions

How do I set the default schema for a user in MySQL

Is there a way to set a default schema for each user in MySQL and if so how? Where user …

mysql default database-schema

Hibernate Criteria Query to get specific columns

I am using Criteria Query in my code. It always fires select * from ... Instead I want to neglect one column(…

java mysql hibernate hibernate-criteria

MySQL: View with Subquery in the FROM Clause Limitation

In MySQL 5.0 why does the following error occur when trying to create a view with a subquery in the FROM …

mysql sql view mysql-error-1349

What is the difference between MySQL, MySQLi and PDO?

What is the difference between MySQL, MySQLi and PDO? Which one is the best suited to use with PHP-MySQL?

php mysql pdo mysqli

What is the difference between BIT and TINYINT in MySQL?

In which cases would you use which? Is there much of a difference? Which I typically used by persistence engines …

mysql bit tinyint

Laravel Unknown Column 'updated_at'

I've just started with Laravel and I get the following error: Unknown column 'updated_at' insert into gebruikers (naam, wachtwoord, …

php mysql laravel laravel-migrations

MySQL Check if username and password matches in Database

I have a form which has a textbox with the name attribute username and another one with the name attribute …

php mysql authentication hash-function password-storage

How to extract the nth word and count word occurrences in a MySQL string?

I would like to have a mysql query like this: select <second word in text> word, count(*) from …

mysql regex word-count

How to drop all tables from the database with manage.py CLI in Django?

How can I drop all tables from a database using manage.py and command line? Is there any way to …

mysql django django-admin

MySQL ON DUPLICATE KEY UPDATE for multiple rows insert in single query

I have a SQL query where I want to insert multiple rows in single query. so I used something like: $…

sql mysql duplicates