mySQL
No Need For a SQL Tutorial Or to Learn SQL
Many proprietary database systems come with a report writer but are too difficult to use. They need a knowledge of SQL or they need an expensive expert to prepare the report. Sometimes there is no report writer available at all. Here is a solution.
Some of MySQL Key area of performance tuning
6 general issues to consider when optimizing the performance of mySQL
Import Excel Data Into MySQL Using phpMyAdmin
So you have a bunch of data in Excel that you want to create a database from. But how do you import the Excel data in MySQL? With phpMyAdmin, the process is painless and easy. This tutorial will explain this process step by step.
SQL Server Triggers
Triggers are stored procedures which are fired when data is modified in an underlying table. They can evaluate data being added to a table for validation purposes, or can make changes in that or other fields depending on the value of that data. You can use them even to execute a separate stored procedure, or to roll back a data modification or an entire transaction.
MySQL and BLOBs
One of MySQL's strengths is its use of Binary Large Object (BLOB) columns. These columns store unprocessed binary data, typically files, that can be retrieved and manipulated like the other common datatypes. The difficulty comes in accessing the BLOB column in VB. Prior to ADO 2.5, the only way to move data in and out of a MySQL BLOB column using Visual Basic was to use the appendchunk and getchunk methods. With ADO 2.5, the stream object has been added, greatly simplifying the process of working with MySQL BLOBs. In this article, I will focus entirely on using the stream object.
| Related News: |
