Sunday, June 15, 2008

MYSQL VISUAL WEB APPLICATION WITH NETBEANS 6.1



START MYSQL SERVER IN COMMAND LINE AND FOLLOW THESE STEP

step 1: create database mail;

step 2:use mail;

step 3 :CREATE TABLE user (username VARCHAR(64) NOT NULL, pwd VARCHAR(50),PRIMARY KEY(username));

step 5 :INSERT INTO user (username, pwdHash) VALUES ('VIVEK KUMAR','123456');

U CAN INSERT MORE THAN ONE RECORD IN YOUR DB BUT DONT REPEAT USERNAME AGAIN.

Thursday, June 12, 2008

Enhanced DataBase Managment System in Netbeans 6.1 with Mysql

You can explore your database application with my Sql Db support in Netbeans 6.1 IDE you can down load mysql from www.mysql.com or www.sun.com ,bcoz mysql database is now part of SunMicrosystems .MYsql DB tools and java (j connector also availabele on www.mysql.com MySql Db tools also available on above site