how to create password field in table?
Results 1 to 3 of 3

Thread: how to create password field in table?

  1. #1
    Senior Member
    Join Date
    Jun 2000
    Posts
    65,357

    how to create password field in table?

    Hi..

    This is my first time to create table in mysql database. I need the help to solve the mysql database problem. This is my first time to use mysql and I want to create a table called "login"

    the command should be like the following:

    create table login (
    ....

    please tell me how to create the password field?? the following is sample:

    create table login (
    user_id int(4) unsigned zerofill not null,
    user_pwd "...................................................................."
    primary key(user_id)
    );

    please help me how to create column type of password

    thank you..

    joseph


  2. #2
    Senior Member
    Join Date
    Jun 2000
    Posts
    65,357

    RE: how to create password field in table?

    uhm, try the following query:

    create table login (
    user_id int(4) unsigned zerofill not null,
    user_pwd varchar(100) not null,
    primary key(user_id)
    );


    the password is now a varchar that is 100 long...

    but you won't really need the unsigned and zerofill stuff... it's not useful, especially not for a login.

    if you don't want to use it, do this query:

    create table login (
    user_id int not null,
    user_pwd varchar(100) not null,
    primary key(user_id)
    );

  3. #3
    Senior Member
    Join Date
    Jun 2000
    Posts
    65,357

    RE: how to create password field in table?

    Thank you so much for your solution. It's really help... ^o^

    I got another problem.. I can get the whole row of data, how can I get one field data and make it as session??

    for example:
    table field --> logid, password

    then I want to get logid and make it as session and showing on the screen...

    thank you again...

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •