MYSQL

How to Clear Inactive Memory in Linux

Submitted by admin on
This simple tip is based on my experience on how to tweak MySQL Server for best performance. Just this year, sourcecodester.com has moved again to a new server to served millions of page views every month. Since our new server is unmanaged, I am having a hard time sometimes configuring our new server, especially when tweaking Nginx, PHP-FPM and MySQL. By default, MySQL will give you a sample

Electronic Voting System

Submitted by teejaygenius on
A network based electronic voting System. It was developed with a text editor (macromedia dreamweaver). It has features for adding new contestant together with thier pictures, Deleting unwanted recdords from the database as well as a network based environment for each user to login with the given username and pass word to vote. Each user can only vote once and double voting is prevented.

Part IV: Improving of Code using Modules in Visual Basic.Net

Submitted by joken on
This tutorial is a continuation of Part III: Update and Delete Specific Data in MySQL Database using Visual Basic. Net. But this time we're going to focus on how we can improve the design of our existing code using Code Refactoring. Refactoring is the process of changing a software system in such a way that it hasn't altered the external behavior of the code, yet improves its internal structure.

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