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
_id
-> group 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: MySQ
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)
tabl
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 c
how can I calculate the difference between two dates in days? I'd like to
get the days to go between and a job-deadline in the future.
thank)s to MySQL
--
Kai Vermehr
eBoy Graphics
http://www.eboy.com
-
Before po
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),