Skip to main content

MySQL Password field

Creating a table with password field in mysql database.


mysql>create table contact
(Name varchar(20),
password char(41));

mysql>insert into contact values('john',password('12345'));

mysql>select * from contact;


you will get this result

john *23AE809DDACAF96AF0FD78ED04B6A265E05AA257
Password is encrypted now no user can see it.

Comments

Post a Comment

Popular posts from this blog

Web Designer

If you want to be a web designer. Skills Should have worked on and have a good understanding of the following packages and areas: HTML Javascript / VBscript JSP ASP Photoshop Flash Dream Weaver Frontpage Should have aesthetic picture and designing abilities (including usage of color combinations, CSS files, etc). Should have the ability to understand client requirements; and translate into appropriate web interface. Should be comfortable in working with Windows/ Java environment Work Experience At least 2 to 3 years of good web designing experience Web pages should be bug free and clean/ simple and light Should have managed/ maintained websites that are currently hosted and running Key Responsibilities Testing and implementation Analysis and design of solutions at both onsite and client sites to integrate the company's product Interaction with clients to implement solutions Interaction with third party solution providers for project i...
Post a Comment
Read more

Try CSS

open notepad type the following and save the file with name testcss.html on desktop and then open this file in internet explorer : <html> <head> <title>css tutoriaL</title> <style type="text/css">  body {  background: #006699;  font-family: "Trebuchet MS", Verdana, Arial, serif;  } </style> </head> <body> <p style ="font-size:20px"> This text is written in <br>color code #006699 font size 20 </p> </body> </html> output :
Post a Comment
Read more

MYSQL JDBC Connectivity Example

1. create a table in mysql name contact with columns name,mobile,email,password 2.open bluej add reference library mysql-connector-java-5.1.13-  bin.jar file if not available download from internet. 3.type the code given below. compile it and execute. Success. import java.sql.DriverManager; import com.mysql.jdbc.Driver; import com.mysql.jdbc.Connection; import com.mysql.jdbc.Statement; public class test {     public static void main(String args[])     {         String Name="SHIV SINGH";         String Mobile="9929760942";         String Email=" s@gmail.com ";         try                {         Class.forName("java.sql.DriverManager");         Connection con = (Connecti...
Post a Comment
Read more