User SignUp and SignIn process through mysql.

Question

Suppose we create a table after that if user wants to insert the data he has to sign up first to insert data and after saving a data if he wants to view all data he have to sign in first. So, I want the code of sign in and sign up process in mysql.

Answer 1

first when user want to sign. search the table. SELECT * FROM `user`
if the return no result then procees to sign up. INSERT INTO `user`
if the password isnt match, notify the user
if everything is fine, show all the data. SELECT * FROM `data`

Answer 2

I'm new in database programming can you post some code.

Answer 3

you cant use mysql as programming language. it simply a database, not a language.
i already shown all sql query that you'll needed

you'll need other programming language to do that.