Top "Mysql" questions

SQL Query Where Field DOES NOT Contain $x

I want to find an SQL query to find rows where field1 does not contain $x. How can I do …

sql mysql

Change MySQL default character set to UTF-8 in my.cnf?

Currently we are using the following commands in PHP to set the character set to UTF-8 in our application. Since …

mysql character-encoding

How to retrieve the current version of a MySQL database management system (DBMS)?

What command returns the current version of a MySQL database?

mysql

How do I select an entire row which has the largest ID in the table?

How would I do something like this? SQL SELECT row FROM table WHERE id=max(id)

mysql sql

How to fix: "No suitable driver found for jdbc:mysql://localhost/dbname" error when using pools?

I am trying to create a connection to my database, when I put test my code using the main method, …

mysql jdbc tomcat7 apache-commons-dbcp

Find and Replace text in the entire table using a MySQL query

Usually I use manual find to replace text in a MySQL database using phpmyadmin. I'm tired of it now, how …

mysql phpmyadmin

How to convert an entire MySQL database characterset and collation to UTF-8?

How can I convert entire MySQL database character-set to UTF-8 and collation to UTF-8?

mysql character-encoding

MySQL Error 1093 - Can't specify target table for update in FROM clause

I have a table story_category in my database with corrupt entries. The next query returns the corrupt entries: SELECT * …

mysql subquery sql-delete mysql-error-1093

Undefined function mysql_connect()

I have ran aptitude install php5-mysql (and restarted MySQL/Apache 2), but I am still getting this error: Fatal error: …

php mysql ubuntu mysql-connect undefined-function

How to see indexes for a database or table in MySQL?

How do I see if my database has any indexes on it? How about for a specific table?

mysql indexing database-schema