Since you are using a hosted database you probably can't change any of the
security. What I would do is create a table of usernames and passwords
(and any other releveant user data). When your users login, check their
password and proceed accordingly.
Craig
At 02:44 AM 4/8/2002, you wrote:
You could do that, but if you want to keep it simple, I would download some
gui tools like mysql-front (mysqlfront.de) and do all of your development
work remotely.
Craig
At 05:16 PM 4/7/2002, you wrote:
>Hi
>
>I'm new to sql but am familiar with Access \ SQL 7 \ ASP.
>
>My ISP offers MySql Su
I am running Windows XP with MySQL running as a service. When I want to
run MySQL with the option for logging (--log -bin), I have to start the
service MANUALLY and type the --log -bin in the parameters box each time I
restart the server. Is there an easier way to do this?
Thx,
Craig
Not yet, but hopefully in 4.1.
Check out http://www.mysql.com/doc/N/u/Nutshell_4.1_development_release.html.
Craig
sql,query
At 06:07 PM 4/2/2002, you wrote:
>Does any know if mysql has any kind of stored procedures?
>If not, is there any plans on including them?
>
>-matt
---
The queries will be a little complicated using a self join, but the table
is simple should include:
CUSTOMERID
REFERRERID (Which is the CUSTOMERID of their referrer)
CUSTOMERFIRSTNAME
CUSTOMERLASTNAME
ETC!
The queries will then use a self join and table aliases to determine the
commissions for
I am working with a low-load, mission-critical database. Although I have
yet to have a corrupted table, I seem to read about it a lot on the
list. This is a scary thought for me, considering the importance of the
data I manage. Can anyone tell me if this is a rare occurrence? Is it
even r
Absolutely. I must tell you that we have MUCH fewer problems using VB with
MySQL than we do VB with Oracle. And it is obviously much faster, leaner,
and easier to maintain. I find that my biggest headache is convincing IT
people that open source products are worthy of their attention. Your
Hi Ben:
Performance would definitely be better if you store the data in the
database as opposed to simply storing references to files. Sounds like you
could solve this with 2 tables with one for the actual lists (assuming the
structure of all your list is the same) and the other for the list
Probably Linux, but it is also pretty spunky on my WinXP machine.
Craig
At 08:30 PM 3/20/2002 -0800, you wrote:
>Is MySQL 3.23/4.01 faster on Linux (RH 7.2) or Windows XP/2000 with the same
>hardware? Thanks.
>
>David
>
>
>-
>B
Hello:
I never received an answer to the first try, so I thought I might try again.
Has anyone out there been able to successfully compile a UDF for Win32 and
if so, do they have a simple example? I looked in the archives and there
are plenty of questions, but no answers to this.
Thanks,
Cra
OK. So I just read in CHANGES FOR 3.23.37 (patch by Ralph Mason) that
there is now support for UDFs in Windows . So anyone know where I might
find some Windows specific examples (or info) on them?
Thanks,
Craig
At 09:47 AM 3/14/2002 -0600, you wrote:
>Perhaps this is common knowledge, but is
Perhaps this is common knowledge, but is there still no support for UDFs in
Windows. If not, are there any work arounds for trying to perform
complicated calculations on the server?]
Thanks,
Craig
mysql, query
-
Before post
How about trying to avoid using ODBC? Check out:
http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=22472&lngWId=1
or
http://www.icarz.com/mysql/
Craig
At 10:53 AM 3/12/2002 +0100, you wrote:
>Hi there,
>
>I have a problem with MySQL and the connection to it.
>
>What I want is
I just got it to work in VB.NET. I played with the connection string. In
fact, I took everything out except the DSN. Here is the code
(VB.net). For the most part it is exactly like VB6 except no SET commands
and no default properties. Try making your connection string minimal in C#.
Hi Zengfa:
No. The operating system has nothing to do with it BUT there are
requirements for buying a license.
Visit http://www.mysql.com/support/arrangements.html for more details.
Thx,
Craig
At 12:17 3/6/02 -0800, you wrote:
>Hi,:
>
>I heard that when we use MySQL on windows, we need to
>p
If I create a temporary heap table from a select statement, does the new
table also inherit the indexes (indices?) from the original table. Or will
I have to add an index to the temporary table after it is created?
For example, if I use:
CREATE TEMPORARY TABLE tempstudents TYPE=HEAP SELECT s
In an effort to encrypt private data in my database (national id numbers,
credit card numbers, passwords) I have had to resort to writing code in my
application using the Blowfish algorithm. Is there any facility for doing
this within MySQL (on Windows)? Any third party tools out there? For
Hi Big Al:
Here is an example:
INSERT INTO friends_table(first_name,last_name) VALUES('John','Johnson');
Check out: http://www.mysql.com/doc/I/N/INSERT.html
At 15:36 3/1/02 -0600, you wrote:
>Hey All,
>
>I recently got back into mysql again and haven't programmed for it in almost
>a year and
I am curious about the geographical usage of MySQL. Judging from the users
on this list it seems like it is used more heavily in Europe than in Asia
and the Americas. To date, has there been any formal studies or polls taken?
Craig
---
I asked this question as well some time back and got the standard answer
'READ THE MANUAL'. However, I still never found the answer to my question,
so when I get closer to deployment, I am going to experiment. I am
thinking that only MyODBC installation is required on the client and
possibly
I am a new MySQL user, so forgive my stupidity for asking the following
question (perhaps taboo). What is the latest on NuSphere vs MySQL
AB? What about Gemini. I have searched everywhere for info, but can't
seem to find anything after November of last year.
I have serious needs for transac
I am trying to run multiple versions of MySQL (not simultaneously) on my
Windows box.
One is NuSphere's 3.23.44 with Gemini tables and the other is Max 3.23.49.
Do I only need to put the base files into two separate directories and then
modify the my.ini to point to the version I want to use a
At 04:08 2/19/02 +0100, you wrote:
>Your message cannot be posted because it appears to be either spam or
>simply off topic to our filter. To bypass the filter you must include
>one of the following words in your message:
>
>sql,query
>
>If you just reply to this message, and include the entire te
The VB front end I built using MySQL with MyODBC works great on my local
machine after performing the binary installations. If I move the front end
to remote machine, what files are required for successful connecting? Just
those bundled with MyODBC? I am attempting to keep the install as lean as
p
24 matches
Mail list logo
