Top "Mysql" questions

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

How do you use MySQL's source command to import large files in windows

I have a large (~150mb) sql file that I am trying to import. It is too large to do it …

mysql import xampp
ERROR 1115 (42000): Unknown character set: 'utf8mb4'

I have a MySQL dump, which I tried to restore with: mysql -u"username" -p"password" --host="127.0.0.1" mysql_db < …

mysql sql character-encoding utf8mb4
failed to open stream: No such file or directory in

> Warning: include_once(/PoliticalForum/headerSite.php) [function.include-once]: failed to open stream: No such file or > directory in …

php mysql dreamweaver
MySql: Tinyint (2) vs tinyint(1) - what is the difference?

I knew boolean in mysql as tinyint (1). Today I see a table with defined an integer like tinyint(2), and also …

mysql sqldatatypes
How to drop unique in MySQL?

Create Table: CREATE TABLE `fuinfo` ( `fid` int(10) unsigned NOT NULL, `name` varchar(40) NOT NULL, `email` varchar(128) NOT NULL, UNIQUE KEY `…

mysql indexing sql-drop
Error: select command denied to user '<userid>'@'<ip-address>' for table '<table-name>'

In my website, I am using MySQL database. I am using a webservice where in I do all my database …

mysql mysqldatareader mysql-error-1142
PDO get the last ID inserted

I have a query, and I want to get the last ID inserted. The field ID is the primary key …

php mysql database pdo
Return 0 if field is null in MySQL

In MySQL, is there a way to set the "total" fields to zero if they are NULL? Here is what …

sql mysql
Search for string within text column in MySQL

I have mysql table that has a column that stores xml as a string. I need to find all tuples …

mysql search sql-like
Laravel migration: unique key is too long, even if specified

I am trying to migrate a users table in Laravel. When I run my migration I get this error: [Illuminate\…

php mysql laravel