Top "Mysql" questions

Remove DEFINER clause from MySQL Dumps

I have a MySQL dump of one of my databases. In it, there are DEFINER clauses which look like, "DEFINER=`…

mysql

MySQL Install: ERROR: Failed to build gem native extension

I'm trying to get MySQL installed to the latest version due to some installation going wrong somewhere along the line. …

mysql ruby-on-rails macos rubygems

Delete multiple rows by selecting checkboxes using PHP

I want to delete multiple rows from MYSQL database. I have created this delete.php file to select various links …

php html mysql checkbox isset

MySQL Join Where Not Exists

I have a MySQL query that joins two tables Voters Households They join on voters.household_id and household.id. …

mysql join not-exists

How to remove all non-alpha numeric characters from a string in MySQL?

I'm working on a routine that compares strings, but for better efficiency I need to remove all characters that are …

mysql regex string alphanumeric

Incorrect string value: '\xF0\x9F\x8E\xB6\xF0\x9F...' MySQL

I am trying to store a tweet in my MYSQL table. The tweet is: quiero que me escuches, no te …

mysql twitter utf-8 emoticons

JPA mapping: "QuerySyntaxException: foobar is not mapped..."

I've been playing around with a very simple JPA example and am trying to tweak it to an existing database. …

java mysql hibernate jpa

Can I use VARCHAR as the PRIMARY KEY?

I have a table for storing coupons/discounts, and I want to use the coupon_code column as the primary …

mysql sql primary-key unique varchar

Access denied; you need (at least one of) the SUPER privilege(s) for this operation

So I try to import sql file into rds (1G MEM, 1 CPU). The sql file is like 1.4G mysql -h …

mysql amazon-web-services amazon-rds

Boolean vs tinyint(1) for boolean values in MySQL

What column type is best to use in a MySQL database for boolean values? I use boolean but my colleague …

sql mysql