phpMyAdmin-4.0.10 got released

http://www.phpmyadmin.net

O'Reilly Media book: PHP & MySQL: The Missing Manual, 2nd Edition

PHP & MySQL: The Missing Manual, 2nd Edition - O'Reilly Media

O'Reilly Open Books Project

O'Reilly Open Books Project

Various o'Reilly books are listed and linked on that page:

• DocBook …
• Mason …
• mod_perl …
• Version Control with Subversion, 2nd Edition
• …

Also a lengthy list of out-of-print books.

• PNG: The Definitive Guide
• …

O'Reilly Media book: MySQL Troubleshooting

MySQL Troubleshooting:
Sometimes applications can go mad: tables contain wrong data, users get random replies, server stop working, and so on. Several easy methods allow users to often find the problems quickly. This book, based on successful conference presentations by the author, cover SQL problems, memory and other server problems, replication, and problems related to particular storage engines.

Oracle adds commercial extensions to MySQL - The H Open Source: News and Features

Oracle adds commercial extensions to MySQL - The H Open Source: News and Features: New extensions for MySQL improve performance, scalability, availability and authentication, but will only be part of the commercial Enterprise Edition

Oracle announces MySQL Installer for Windows - The H Open Source: News and Features

Oracle announces MySQL Installer for Windows - The H Open Source: News and Features

Oracle previews MySQL 5.6 features - The H Open Source: News and Features

Oracle previews MySQL 5.6 features - The H Open Source: News and Features

SQL: Limiting the Number of Rows Returned

SQL Cookbook - O'Reilly Media

Chapter 1 Retrieving Records: Limiting the Number of Rows Returned.

Problem

You want to limit the number of rows returned in your query. You are not concerned with the order; any n rows will do.

Solution

Use the built-in function provided by your database to control the number of rows returned.

DB2

…

MySQL and PostgreSQL

Do the same thing in MySQL and PostgreSQL using LIMIT:

select * from emp limit 5

Oracle

…

SQL Server

…

Discussion

…

how to connect iReport to the database, that comes with a JasperServer (installation)?

This is the JDBC-URL (replace "JASPERSERVER" appropriately!):


jdbc:mysql://JASPERSERVER/sugarcrm


And the default credentials are: jasperdb/password.

Next issue: dealing with "repo:", a reference to the resource repository on the JasperServer …

MySQL :: the Sakila sample database

MySQL :: the Sakila sample database

That documentation includes a nice diagram, and that diagram led me to MySQL Workbench, now I have an idea of how to create nice database diagrams.

MySQL Workbench - a general database GUI application

MySQL Workbench - Wikipedia, the free encyclopedia