drop table if exists tmpusers
create table `web2code_db`.`tmpusers` (
`user` varchar( 25 ) not null ,
`pwd` varchar( 25 ) not null ,
`lastlog` date not null default '0000-00-00',
`email` varchar( 40 ) not null
) ENGINE = MYISAM
alter table `tmpusers` add index (`user`)
Table tmpusers created.
insert into `tmpusers` (`user`,`pwd`,`lastlog`,`email`)
values ('JeanRay','pwdpwd','0000-00-00','jr@web2coders.com')
User JeanRay has been created.
insert into `tmpusers` (`user`,`pwd`,`lastlog`,`email`)
values ('Gabrielle','pwdpwd','0000-00-00','jr@web2coders.com')
User Gabrielle has been created.
| User | Password | LastLogged | Email |
| JeanRay | pwdpwd | 0000-00-00 | jr@web2coders.com |
| Gabrielle | pwdpwd | 0000-00-00 | jr@web2coders.com |