lucifer writes:
> Hi,
>
> Please help/advise.
>
> I have a table called Program with following description;
> program VARCHAR(35) NOT NULL PRIMARY KEY
> description VARCHAR(60) NOT NULL
> level SET('frontdesk,administrator,accounting,reporting')
> NOT NULL DEFAULT 'frontdesk'
>
> AND Yesterday I inserted 3 records as shown in isamchk --analyze
> /usr/local/var/customer/Program.ISM (and the odd is isamchk not
> reporting any error, same with isamchk -o
> /usr/local/var/customer/Program.ISM)
> BUT Today when i do
> SELECT * FROM Program
> it shows only ONE record
> AND when i do
> SELECT * FROM Program WHERE program='adduser.form'
> empty set is returned
>
> but WHEN I do
> INSERT INTO Program VALUES ('adduser.form','Create New User',
> 'frontdesk,administrator')
> it complain about error 1062: Duplicate entry ...
> (BUT I can't see this record by doing SELECT * FROM Program both by
> using mysql-client or thru PERL DBI/DBD)
>
> ## THE samething happened to table Admin which only show 1 record while
> actualy it has 5 record
>
>
> Any suggestion? Thanks in advance for anykind of help
>
> [EMAIL PROTECTED]
Hi!
If you get one row in "select * from table" query, than there is one
row. When inserts are done, info messages are displayed. Sometimes it
is not possible to insert a row.
So try again and if rows are not inserted report what info have you
got !!!
Sinisa
+---------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == [EMAIL PROTECTED] |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Belgrade |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Serbia |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+---------------------------------------------------------------------+
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
