MYSQL

Connecting MySQL Database using Visual Basic.NET

Submitted by joken on
In this tutorial I am going to show you the process on how to connect Basic using MySQL Database. To begin with, you need to download the MySQL Connector/NET first from this link http://dev.mysql.com/downloads/connector/odbc/. After downloading, you need to install it so the connector will now available to use under the Reference. Now let’s begin creating our application using VB.NET (I’m Using VB Express 2008 edition). And this time you need to add a reference using MySQL Connector.

4 Simple Steps to Emulating Real Sequences in MySQL

Submitted by intellicon on
If all you want to do is create a unique ID for a record, the auto_increment feature in MySQL will do the job nicely. Sometimes, however, you need more functionality. Unfortunately, unlike Oracle or PostgreSQL, MySQL doesn't have native support for the nextval() function, so creating real sequences is a little more challenging. First, we need to define what we want the nextval() function to achieve. We want to be able to begin the sequence with any number, and auto increment in multiples of any number, not just 1, including negative integers (-1 for example).

Oracle Released MySQL Cluster 7.3

Submitted by navajocodetalker on
The world's leading software company Oracle has already released version 7.3 of MySQL Cluster as GA (Generally Available), with a NoSQL JavaScript Connector for Node.js and support for Foreign Key Constraints. The latest MySQL Cluster is a clustering add-on for the MySQL database. According to Oracle the addition of the NoSQL JavaScript connector for Node.js means it will be simpler and faster to

Google Launched Cloud SQL API

Submitted by navajocodetalker on
Internet search giant, Google, launched an Application Programming Interface (API) to enable users of its Cloud SQL to manage their databases. The Google Cloud SQL was originally available way back October 2011, but only in limited preview. The program lets you run MySQL databases in Google's cloud. Based upon the description of Google Cloud SQL through its website, it enables you to: "Use a fully

Original MySQL Founder Merged with Monty Program & SkySQL

Submitted by navajocodetalker on
One of the most daring move by the original founders of MySQL, the open-source database program, is the merger between Monty Program and SkySQL. The newly-merged company will operate under the SkySQL name. The company will have the two main co-creators of the original MySQL, Monty Widenius, head of Monty Program AB, and David Axmark of SkySQL. They will pool both Monty Program and SkySQL's

An Interactive Complaint Register and Appraisal Management System

Submitted by josiah_ke on
An interactive complaint register and appraisal management system for a university. Universities have a task to train students to be better people or professionals in the future. In their activities to make this happen they go out of track in some stages or points.

Convert MyISAM to InnoDB

Submitted by admin on
MyISAM and InnoDB is a storage engine of MySQL. If you have large databases and have lots of traffic on your website, you will probably encounter a CPU load problem due to table locking features of MyISAM. I created this article to share my problem on several website that I owned including sourcecodester.com. Almost every day I am worried about the load that MySQL is generating on my server’s CPU
Subscribe to MYSQL