Re: Inserting Data into MySQL database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> Hi All,
> I have a table in MySQL database 5.0 the structure of which is as follows
>         ssno INT 9,
>         lname VARCHAR(15) NOT NULL,
>         fname VARCHAR(15) NOT NULL,
>
>        I am inserting the values using
>       $query = "insert into student (ssno,lname,fname) VALUES
> ('".$student['ssno']."','".$student['lname']."','".$student
['fname']."')";
> This Query is working Fine but the only Problem I have is that if the
> lname and fname values are NULL then how come it does not return an
> error but instead adds the record into the database. Is it because I
> am not passing the values properly. Please Help
>
> Thanks,
> Girish

>> TYPOS, SORRY - DPG

Try:

mysql> show create table  _tablename_;

from inside the mysql client. It will display what values are being
inserted as a default.

Remember: null and an empty string are not the same thing.

David

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux