script for complete Database dump?

is there any single MySQL script that would backup my complete database? thanks! Kai - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Re: job database with invoicing

by invoices.job_id thanks again!! -- K:) on 28/8/02 11:47 Uhr, Amer Neely at [EMAIL PROTECTED] wrote: Subject: job database with invoicing Date: Tue, 27 Aug 2002 22:05:43 +0200 From: Kai Vermehr [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] I'm building a job database

job database with invoicing

I'm building a job database with simple invoicing. I have one table called JOBS and one called INVOICES. In INVOICES there's a foreign key column called job_id referencing INVOICES to JOBS.job_id. in a simplified way it looks like this: (there are a lot of other columns of course)

Re: calculating date difference in days

Hi Neil, after some help from Aron Pilhofer and the online manual I got this statement select (to_days(deadline)) - (to_days(current_date)) thanks!! K:) on 21/8/02 7:58 Uhr, Neil Mansilla at [EMAIL PROTECTED] wrote: On Wed, 21 Aug 2002, Kai Vermehr wrote: how can I calculate

calculating date difference in days

how can I calculate the difference between two dates in days? I'd like to get the days to go between current_date and a job-deadline in the future. thank)s to MySQL -- Kai Vermehr eBoy Graphics http://www.eboy.com - Before

how should I enter data into foreign key fields?

Just created a table with a column named client_nr that is a foreign key referencing to my Clients table: CREATE TABLE Contacts ( contact_nrint not null auto_increment, first_namechar(30), last_namechar(30), client_nr char (30), emailchar(30), tel_1char(5), tel_2char(30),