Barbara,
Can't you use the ADDDATE function ?
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
Freddie
> -Ursprüngliche Nachricht-
> Von: Barbara Deaton [mailto:[EMAIL PROTECTED]
> Gesendet: Dienstag, 23. August 2005 21:37
> An: mysql@lists.mysql.com
> Betreff: Date arit
Shawn,
Check out dbManager dbTools Professional :
http://www.dbtools.com.br/EN/downloads.php
It is free and has an MS Access import wizard
Freddie
> -Ursprüngliche Nachricht-
> Von: nephish [mailto:[EMAIL PROTECTED]
> Gesendet: Dienstag, 12. Juli 2005 04:28
> An: mysql@lists.mysql.com
Ahhh, you guys are sooo funny - you all know what I mean
> -Ursprüngliche Nachricht-
> Von: Jay Blanchard [mailto:[EMAIL PROTECTED]
> Gesendet: Montag, 3. Januar 2005 14:36
> An: Freddie Sorensen; [EMAIL PROTECTED]
> Cc: mail.pmpa; mysql@lists.mysql.com
> Betreff: RE
4 15:26
An: Freddie Sorensen
Cc: 'mail.pmpa'; mysql@lists.mysql.com
Betreff: Re: AW: [PHP] How to argue with ASP people...
Have you actually LOOKED at the code (global.asp, *.asp, *.aspx, etc... )
that VS produces to make an ASP.NET application? Have you EVER had to be in
the position to d
Tony,
Check out ASP.NET and you will want to forget everything about PHP ;-)
Freddie
> -Ursprüngliche Nachricht-
> Von: mail.pmpa [mailto:[EMAIL PROTECTED]
> Gesendet: Freitag, 31. Dezember 2004 03:27
> An: mysql@lists.mysql.com
> Betreff: RE: [PHP] How to argue with ASP people...
>
>
Scott,
ASP.NET would be just fine !
Freddie
> -Ursprüngliche Nachricht-
> Von: Scott Hamm [mailto:[EMAIL PROTECTED]
> Gesendet: Freitag, 20. August 2004 20:40
> An: 'Mysql ' (E-mail)
> Betreff: Brainstorming' time!
>
> Looks like I will need more than just MySQL and Php/ASP.net.
> I
Rhino
Get the free DBTools DBManager Pro from
http://www.dbtools.com.br/EN/dbmanagerpro.php - there is a cool CSV export
function there
Or get MyODBC and connect from Excel to your MySQL database
Or as Scott said, roll your own exporter if you have programming skills
Freddie
> -Ursprüngli
Kirti
Have a look at the free DBManager Pro from DBTools :
http://www.dbtools.com.br/EN/dbmanagerpro.php
Freddie
> -Ursprüngliche Nachricht-
> Von: Kirti S. Bajwa [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 12. August 2004 20:09
> An: '[EMAIL PROTECTED]'
> Betreff: GUI for MySQL
>
Check out the LIMIT function in the documentation
> -Ursprüngliche Nachricht-
> Von: Kamal Ahmed [mailto:[EMAIL PROTECTED]
> Gesendet: Mittwoch, 28. Juli 2004 20:39
> An: [EMAIL PROTECTED]
> Betreff: TOP
>
> Hi,
> Does anyone know how to do a TOP function in MySQL ?
>
> Thanks,
>
> -Ka
Aaron,
How about something like :
SELECT CONCAT(UCASE(LEFT(FieldName, 1)),
LCASE(RIGHT(FieldName,LENGTH(FieldName)-1)))
Right out of my head, I didn't count all the parantheses :-)
Freddie
> -Ursprüngliche Nachricht-
> Von: Aaron Wolski [mailto:[EMAIL PROTECTED]
> Gesendet: Mittwoch,
David,
Maybe the CONCAT() function is what you are looking for ?
Freddie
> -Ursprüngliche Nachricht-
> Von: David Blomstrom [mailto:[EMAIL PROTECTED]
> Gesendet: Sonntag, 27. Juni 2004 08:07
> An: [EMAIL PROTECTED]
> Betreff: Merging 2 Fields
>
> I think I recall a thread where someone
Karsten,
I wouln't worry about this - There are plenty of examples where people are
running tables with millions of records without significant performance
problems.
Of course it all depends on the complexity - will you have many tables and
many joins in your queries ?
Just make sure to index yo
That's a lot of stuff to ignore but I managed to do so successfully
> -Ursprüngliche Nachricht-
> Von: Victor Medina [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 15. April 2004 13:39
> An: [EMAIL PROTECTED] Mysql. Com
> Betreff: please ignore
>
> -BEGIN PGP SIGNED MESSAGE-
What is the connection type ? ODBC ?
> -Ursprüngliche Nachricht-
> Von: Shrikrishna Sathe [mailto:[EMAIL PROTECTED]
> Gesendet: Mittwoch, 31. März 2004 12:53
> An: [EMAIL PROTECTED]
> Betreff: DB Connection
>
> The following .asp code sinppet gives error.
>
> Dim rs
> Set rs
Thorsten
Which programming language are you using ?
I believe that for VB it is cbokundenr.value for a combobox
Maybe it would help if you post more code, but I don't know if this is the
correct list to do that
You can write me off list if you want so I can try to help you
Freddie
> -Ursp
Arjun
The free DBTools DBManager can import Access databases directly to MySQL :
http://www.dbtools.com.br/EN/dbmanagerpro.php
Freddie
-Ursprüngliche Nachricht-
Von: Arjun Subramanian [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 19. März 2004 02:56
An: [EMAIL PROTECTED]
Betreff: Migrat
Successfully disregarded !
-Ursprüngliche Nachricht-
Von: Kevin Carpenter [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 15. März 2004 19:33
An: [EMAIL PROTECTED]
Betreff: Test Email - Please Disregard
Test Email - Please Disregard
-:>Kevin Carpenter
CHOP - Biomedical Engineering
Dean
It is the number of concurrent connections
They disappear either when they are closed by the application which has
opened them, or when wait_timeout expires for inactive connections
The wait_timeout is by default at 28800 seconds, so it will take quite a
long time before they disappear (did
Walt
You can also use VB with MySQL without problems. There are several
connectors available at the MySQL site
Freddie
-Ursprüngliche Nachricht-
Von: Walt [mailto:[EMAIL PROTECTED]
Gesendet: Sonntag, 7. März 2004 18:01
An: [EMAIL PROTECTED]
Betreff: VB and mySql
I used to program with
e Nachricht-
Von: Randy Clamons [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 3. März 2004 22:05
An: Freddie Sorensen; [EMAIL PROTECTED]
Betreff: Re: Too many connections
Freddie,
Try tuning startup parameters in my.ini or my.cnf. The default value for
max_connections is 100. That's a
Gilbert
You might want to look at the ByteFX provider
Freddie
-Ursprüngliche Nachricht-
Von: Gilbert Wu [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 4. März 2004 18:28
An: [EMAIL PROTECTED]
Betreff: OLEDB Provider for Mysql
Hi,
We are developing in Microsoft's C++.NET with MS SQL
Ed
The MS Access SQL syntax for if() is iif(condition, then stuff, else stuff)
Maybe that's the problem, I am not sure - try it
Freddie
-Ursprüngliche Nachricht-
Von: Ed Reed [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 26. Februar 2004 02:09
An: [EMAIL PROTECTED]
Betreff: Query err
Jonas
Check out the free DBManager at http://www.dbtools.com.br/EN/dbmanager.php
It can not only import directly from Access but might be very handy later in
your every day work with MySQL as a front-end
Couldn't live without it !
Freddie
-Ursprüngliche Nachricht-
Von: Jonas Lindén [ma
Try :
SELECT * From table WHERE `address` = ''
Or
SELECT * From table WHERE `address` IS NULL
-Ursprüngliche Nachricht-
Von: Caroline Jen [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 17. Februar 2004 20:17
An: [EMAIL PROTECTED]
Betreff: How To Write This SQL Statement
Please help.
Check out GROUP BY
-Ursprüngliche Nachricht-
Von: Scott Haneda [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 6. Februar 2004 23:34
An: MySql
Betreff: iterating through a month
In MySql is it possible to repeat through a month, for example I would like
to
Select count(user) from table w
of that
or any explanation. I would really like to know what causes this so that I
know how to react next time
Freddie
-Ursprüngliche Nachricht-
Von: Stephen Brownlow [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 16. Januar 2004 02:44
An: Freddie Sorensen; 'MySQL List'
Betreff: Re:
Ian
Check the documentation for the correct SELECT SYNTAX :
http://www.mysql.com/doc/en/SELECT.html
Your WHERE clause should be before ORDER BY
Freddie
-Ursprüngliche Nachricht-
Von: Ian O'Rourke [mailto:[EMAIL PROTECTED]
Gesendet: Sonntag, 18. Januar 2004 12:22
An: [EMAIL PROTECTED]
B
I have not received any emails from this list since last Sunday - if this
post comes through and anybody has an idea what is wrong please reply to me
off list
Thanks
Freddie
Well, I am using MySQL with ASP.NET, using the managed provider from ByteFX
Works like a dream !
Freddie
-Ursprüngliche Nachricht-
Von: Donald Henson [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 5. Januar 2004 16:34
An: MySQL List
Betreff: Re: The Future of MySQL with .NET Plataform
On
Arthur
Get DBManager Professional (for free) here :
http://www.dbtools.com.br/EN/dbmanagerpro.php
There is a wizard which can do this conversion for you
Freddie
> -Ursprüngliche Nachricht-
> Von: Arthur Klimowicz [mailto:[EMAIL PROTECTED]
> Gesendet: Sonntag, 21. Dezember 2003 19:00
>
I'm using DBTools DBManager Professional - it's free :
http://www.dbtools.com.br/EN/dbmanagerpro.php
Freddie
> -Ursprüngliche Nachricht-
> Von: Amanullah [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 18. Dezember 2003 03:57
> An: [EMAIL PROTECTED]
> Cc: MySQL List
> Betreff: Re: MyS
Karl
I have quite a lot of experience with MS Access - write to me off list if
you want me to help you
Freddie
> -Ursprüngliche Nachricht-
> Von: karl james [mailto:[EMAIL PROTECTED]
> Gesendet: Dienstag, 2. Dezember 2003 15:16
> An: [EMAIL PROTECTED]
> Betreff: read (Off subject Help)
Eduardo
Use the format '-mm-dd' instead
By the way, there is an excellent manual on http://www.mysql.com including
all the field types and formats
Freddie
-Original Message-
From: Eduardo Melo [mailto:[EMAIL PROTECTED]
Sent: Sonntag, 26. Oktober 2003 16:15
To: [EMAIL PROTECTED]
Victor
How about generating a temporary table with the results of both queries ?
Or open two recordsete and merge them in your code ?
Freddie
-Original Message-
From: Victor Spång Arthursson [mailto:[EMAIL PROTECTED]
Sent: Sonntag, 26. Oktober 2003 16:56
To: [EMAIL PROTECTED]
Desper
Eduardo
MySQL does not use the square brackets [] as field delimiters. Try to use
`Clientes of Supermarkets` instead
Note, these are not single quotes (') but ASCII 96
Freddie
-Original Message-
From: Eduardo Melo [mailto:[EMAIL PROTECTED]
Sent: Sonntag, 26. Oktober 2003 14:40
To: [EM
Ratmil
Check out the free dbTools at http://www.dbtools.com.br/EN/
Freddie
-Original Message-
From: Ratmil Torres [mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 23. Juli 2003 14:22
To: [EMAIL PROTECTED]
Hi, I just installed MySQL.
Does anybody know where to manage the databases, create, e
test failed
-Original Message-
From: Neeraj Vasudeva [mailto:[EMAIL PROTECTED]
Sent: Samstag, 19. Juli 2003 11:28
To: [EMAIL PROTECTED]
this is a test message
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EM
4 5 6
-Original Message-
From: Tom Roos [mailto:[EMAIL PROTECTED]
Sent: Montag, 14. Juli 2003 11:48
To: [EMAIL PROTECTED]
_ ___ _ __
/______/ / ___/ / \ //
/ / / // / / ^ v /
/ / / /__/ / /
'"
If it is numeric it should be
"...WHERE ID = " & ID
Hth
Freddie
-Ursprüngliche Nachricht-
Von: Michael She [mailto:[EMAIL PROTECTED]]
Gesendet: Sonntag, 29. Dezember 2002 17:39
An: Gelu Gogancea
Cc: Freddie Sorensen; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Betreff: Re: AD
quot;...WHERE ID = " & ID
Hth
Freddie
-Ursprüngliche Nachricht-
Von: Michael She [mailto:[EMAIL PROTECTED]]
Gesendet: Sonntag, 29. Dezember 2002 17:39
An: Gelu Gogancea
Cc: Freddie Sorensen; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Betreff: Re: ADO Error '800a01fb'
Line 45
I don't think so since there is no other way to create an object in ASP
VBScript
Which line is line 45 ? objConn.open or rs.open ?
Freddie
-Ursprüngliche Nachricht-
Von: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Gesendet: Sonntag, 29. Dezember 2002 12:02
An: [EMAIL PROTECTED]; Michael Sh
41 matches
Mail list logo