Top "Mysql" questions

MySQL, Check if a column exists in a table with SQL

I am trying to write a query that will check if a specific table in MySQL has a specific column, …

mysql

Is there an SQLite equivalent to MySQL's DESCRIBE [table]?

I'm just getting started learning SQLite. It would be nice to be able to see the details for a table, …

mysql sqlite

I can not find my.cnf on my windows computer

My computer is Windows XP. I need to find my.cnf to get all privileges back to the root user. …

mysql configuration privileges

How to remove unique key from mysql table

I need to remove a unique key from my mysql table. How can remove that using mysql query. I tried …

mysql sql unique-key

How to get UTF-8 working in Java webapps?

I need to get UTF-8 working in my Java webapp (servlets + JSP, no framework used) to support äöå etc. for regular …

java mysql tomcat encoding utf-8

Cloning a MySQL database on the same MySql instance

I would like to write a script which copies my current database sitedb1 to sitedb2 on the same mysql database …

mysql database copy clone mysqldump

Create boolean column in MySQL with false as default value?

I want to create a table in MySQL with a boolean column whose default value is false. But it's accepting …

mysql

How to delete duplicates on a MySQL table?

I need to DELETE duplicated rows for specified sid on a MySQL table. How can I do this with an …

mysql duplicates

#1064 -You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

I'm new to PHP and MySQL and ran into a little trouble with a learning project I'm working on. Whenever …

mysql error-handling create-table

How to annotate MYSQL autoincrement field with JPA annotations

Straight to the point, problem is saving the object Operator into MySQL DB. Prior to save, I try to select …

java mysql orm jpa annotations