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
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
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
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
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
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
-
Before
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,
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
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
How about trying to avoid using ODBC? Check out:
http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=22472lngWId=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 to
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
pay
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
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
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
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 text of
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
21 matches
Mail list logo