(Subha Subramanian) If you have avoided using MySQL in the past due to its lack of support for stored procedures, here’s good news. The latest developer release of MySQL (MySQL 5.0) supports stored procedures. Drum roll, please! If you want to jog your memory before you begin to create those cretins
Tag: Open Source
Troubleshooting Problems with MySQL Programs
This appendix from MySQL Administrator’s Guide (by MySQL AB, Sams, ISBN: 0672326345) lists some common problems and error messages that you may encounter when running MySQL programs. It describes how to determine the causes of the problems and what to do to solve them.
Data Conversion between Microsoft Access and MySQL
The importance and widespread use of the Internet has changed the information-processing world. Many enterprises in the world publish their information on-line as they need to access, process and exchange large amounts of information primarily through the World Wide Web. Surely the way your dat
Migrating to MySQL – Eliminating Risks and Hidden Costs Using Specialized Migration Software
(Dmitry Tolpeko) The latest versions of MySQL largely extend the range of enterprise applications that can benefit from the high performance, reliability, scalability and cost reduction offered by this database server. That is why more and more companies today consider switching their mission-critic
Using MySQL Programs (Sample Chapter)
This chapter provides a brief overview of the programs provided by MySQL AB and discusses how to specify options when you run these programs. Most programs have options that are specific to their own operation, but the syntax for specifying options is similar for all of them. Later chapters provide
MySQL backups
(Ian Gilfillan) One of the most frequently requested topics for this column is, not surprisingly, backups. Not surprising because disks still fail, and developers still forget WHERE clauses and nuke entire tables. I am not ashamed to admit that I did just that a few days ago. Everyone destroys s
MySQL Transactions, Part III – BDB Tables, Table locking and Savepoints
(Ian Gilfillan) The previous two columns in this series have covered general transactions with InnoDB tables and transaction isolation levels. This month, we look at transactions with other table types, specifically BDB tables, and all other table types, including the default MyISAM table type.
MySQL Transactions, Part II – Transaction Isolation Levels
(Ian Gilfillan) Last month we started looking at transactions in MySQL, in particular with InnoDB tables. This month we look at the four transaction isolation levels, again with InnoDB tables, and see how they affect the usual locking transactional behavior.
Transactions in MySQL
(Ian Gilfillan) What is a transaction? If you are asking this question, you are probably used to website databases, where most often it does not matter in which order you run transactions, and if one query fails, it has no impact on others. If you are updating some sort of content, often you will
Talking to MySQL: Your First Look at JDBC
(Kevin Yank) To build the To-Do List application we will use to explore the myriad Java Web development technologies that are available, we’ll begin with the backbone of the application: a set of classes that connect to a MySQL database to retrieve, model, and update a to-do list.