Re: Ancestry program

Thanks for all your help, but my main problem now is, how to show the relationships. I mean, OK, I trace the names in my database, but how to show the relationship to the user, searching for it? Should I draw a complete tree that means all the people involved between the actual two, or I

Re: Ancestry program

On Tuesday 28 October 2003 11:24 am, Dathan Vance Pattishall wrote: > Think of a binary tree. > > Parent_id auto increment > Child_id > > Details of the famly > > The head of the family has a child_id == parent_id > > All members of the family have different child_ids but the same > parent_id > > T

MySQL Package Install for Mac OS X 10.3 (Panther)

I am upgrading to Panther and I need to install MySQL. Does anybody know if the Mac OS X Installer Package v10.2 (Standard) works with 10.3? If it doesn't then what would be the best installation method on a clean 10.3 installation? Thanks, -Sam Carpenter -- MySQL General Mailing List For

Re: How to define a required field in a table?

mos wrote: At 04:00 PM 10/28/2003, you wrote: That's not how it works. The following demonstrates the feature I think you want. >mysql test test> create table testnull ( X varchar(10) not null ); Query OK, 0 rows affected (0.11 sec) test> insert into testnull values ( null ); ERROR 1048: Column '

Re: How to define a required field in a table?

bluejack wrote: On Tue, 28 Oct 2003 14:00:02 -0800, Kevin Fries <[EMAIL PROTECTED]> wrote: That's not how it works. The following demonstrates the feature I think you want. mysql test test> create table testnull ( X varchar(10) not null ); Query OK, 0 rows affected (0.11 sec) test> insert into

Error 1148 and 1045

I have upgraded my mysql version to 3.23.58 and am coming up with a couple of errors using phpmyadmin to "Insert data from a textfile into table" I didn't get this on the previous versions of mysql. Here are the errors: SQL-query : LOAD DATA INFILE '/tmp/phpKFlQ2b' INTO TABLE `annsubscribers

<    1   2