need help creating relation

Hi there, I would like to create a table that optionally links to an other table. The field company_id in the following table should be either Null or link to the table tblCompany (`id` ). How do I do that. The way I it now, I can not enter records where the field company_id is null. Thanks

Re: looking for "ready made" address management

Jerry Schwartz schrieb: I strongly advise you to use an off-the-shelf solution. In fact, if you can afford it you should go with a CRM vendor. They will have all kinds of features, such as address duplication detection, that you will need. you are of course perfectly right, however I need it as

Re: looking for "ready made" address management

Jason Pruim schrieb: On Aug 12, 2008, at 2:30 AM, robert rottermann wrote: Hi there, I am about to create tools to maintain addresses (companies, persons, groups) As this is probably done allredy a million times over I would like to ask if somebody could point me from where I migth download

looking for "ready made" address management

Hi there, I am about to create tools to maintain addresses (companies, persons, groups) As this is probably done allredy a million times over I would like to ask if somebody could point me from where I migth download the database structure for such a feat or whether someone of you could provide

design question

hi there, I am a casual database tinkerer that has to build a new database. so please do not fall down laughing if I ask stupid questions .. the problem at hand is that I want to create tables with the following structure: - suppliers they produce/deal-with 0 to n products - products a prod

trigger that calls a webservice??

Hi there, is it possible to define an update trigger that calls a webservice (or just some external method that would do it). we have a web frontent, that does the indexing of data in its own catalog (zope/plone). so I would like to be able to "push" an update to the frontend. thanks robert

what codepage /colation to use?

hi there, I am usin mysql workbench to edit tables now I wonder what codepage I shoud use. what I want is to use utfo input and output. now ther is "utf8 - utf8_bin", "utf8 - utf8_unicode_ci" and about 7 million of others. which one do I use. thanks very much robert -- MySQL General Mailing Li

mysql claims table does not exist. but it does

Hi there, I have a strange problem. I am using Server version: 5.0.45 SUSE MySQL RPM I made a backup of a database by copying its directory like so: mv urulu urulu_X then I recreateded the database, played a little with it and then dropped it again. the I moved the old database in place again. no

Re: creating buddy list. request for help

Martijn Tonies schrieb: > Hi, > >> I have a rather basic problem I would be glad to get some help: >> What I intend to do is: >> - create a person-list >> - create a buddy-list >> each entry in the person-list can have 0 to many buddies >> - when an entry in the person-list is deleted, I would

creating buddy list. request for help

hi there, I have a rather basic problem I would be glad to get some help: What I intend to do is: - create a person-list - create a buddy-list each entry in the person-list can have 0 to many buddies - when an entry in the person-list is deleted, I would like to have correspnding entries in

encoding blues

Hi there, it seems that I managed to put data into a MySQL Database utf8-encoded altough the database is set to use latin1. My question now is, how can I change the records to either latin1 or the db to "accept" them as utf8. HUGE thanks for any hints robert -- MySQL General Mailing List