MYSQL

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

Simulating a Voice Aided Automated Teller Machine for the Blind

Submitted by Walterjnr1 on
This is system that simulate an automated teller machine with a voice aided feature for a blind customer in a bank. On the click of a button number , a corresponding number sound is produce to assist the blind customer. Key Features of the system include login system, checking balance , setting atm pin, withdrawal. What you will learn from this project include text to speech,login system,select

Online Music Publishing and Audio Playing system Updated

Submitted by nexus_00 on
This is a simple music publishing and audio player system which is intended only for playing and publishing music online.. This system also enables voting for your favorite music type. The votes are displayed in graph. How to run: Create database named dbmis to phpmyadmin and import the dbmis.sql You need a Wamp or Xampp Server,and a PHP IDE Editor. Additional Information: If you want to be the

Electronic Voting System

Submitted by Walterjnr1 on
AN ELECTRONIC VOTING SYSTEM This is an electronic voting system developed using php as the front-end and Mysql as the back-end. It is developed to eliminate the conventional paper ballot system being practice in some countries . Features: 1.) It is Secured. 2.) It is fast and confident. 3.) Result are accurate. 4.) Reduce crowd at polling unit. 5.) Instant result are release immediately after each
Subscribe to MYSQL