Top "Mysql" questions

Mapping a JDBC ResultSet to an object

I have a user class that has 16 attributes, things such as firstname, lastname, dob, username, password etc... These are all …

java mysql object jdbc resultset

FORCE INDEX mySQL ...where do I put it?

I have the following mySQL query that works perfectly fine. Except that I need to add a "FORCE INDEX" and …

mysql indexing greatest-n-per-group

How to get the latest record in each group using GROUP BY?

Let's say I have a table called messages with the columns: id | from_id | to_id | subject | message | timestamp I …

mysql sql greatest-n-per-group

SQL UPDATE with sub-query that references the same table in MySQL

I'm trying to update a column's value in a bunch of rows in a table using UPDATE. The problem is …

mysql sql mysql-error-1093

mysql after insert trigger which updates another table's column

i'm trying to write a trigger, I have following tables: BookingRequest: +-----------+---------+------+-----+---------+----------------+ | Field | Type | Null | …

mysql sql-update triggers

MySQL: can't access root account

I'm running MySQL 5.x on my local Windows box and, using MySQL administrator, I can't connect to the databases I …

mysql mysql-error-1045

Library not loaded: libmysqlclient.16.dylib error when trying to run 'rails server' on OS X 10.6 with mysql2 gem

I've been struggling with this for some time. I've installed Rails 3, gem, mysql on my Snow Leopard machine. All was …

mysql ruby-on-rails rubygems webrick

How to refresh datagrid in WPF

My source is in a MySQL database, I've made an update command and now I need to refresh my DataGrid. …

c# mysql wpf ado.net wpfdatagrid

MySQL Update Column +1?

I was wondering what would be the easiest way to update a column by +1? I will be updating a post …

mysql sql sql-update aggregate-functions

MySQL IFNULL ELSE

I have a select statement where I want to make the select conditional like this: IFNULL(field_a, field_a, …

mysql select ifnull