Re: Security
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: Hi Still fairly new to this and I'm using mysql-front for administration which makes life really easy. Anyway as I'm now adding tables etc should I be creating a new user to access them, I'm thinking of the web users, or can I use the default user set-up by my ISP Regards John Berman [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New to MySQL
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 Support so I need to get up to speed. I can now using Myodbc and access or excel connect to the sample database they put online for me. OF course I have my own tables etc that I want to upload. I get the feeling that I install mysql on my own PC create the database structure etc and simply upload to my ISP after which I can get data into the structure via ASP \ Access \ Excel. Am I on the right lines ? Regards John Berman [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Binary Log and WinXP Services
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table Question.
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 each of the six levels. Using two levels would look something like this: SELECT CUSTOMERS.CustID, LEVEL1REFERRERS.CustID AS LEVEL1REFERREES, 1 AS LEVEL1COMMISSION, LEVEL2REFERRERS.CustID AS LEVEL2REFERREES, 1 AS LEVEL2COMMISSION FROM (CUSTOMERS INNER JOIN CUSTOMERS AS LEVEL1REFERRERS ON CUSTOMERS.CustID = LEVEL1REFERRERS.ReferrerID) INNER JOIN CUSTOMERS AS LEVEL2REFERRERS ON LEVEL1REFERRERS.CustID = LEVEL2REFERRERS.ReferrerID; If all you care about are the total commissions then again for two levels you would use: SELECT CUSTOMERS.CustID, Sum(1) AS LEVEL1COMMISSION, Sum(1) AS LEVEL2COMMISSION FROM (CUSTOMERS INNER JOIN CUSTOMERS AS LEVEL1REFERRERS ON CUSTOMERS.CustID = LEVEL1REFERRERS.ReferrerID) INNER JOIN CUSTOMERS AS LEVEL2REFERRERS ON LEVEL1REFERRERS.CustID = LEVEL2REFERRERS.ReferrerID GROUP BY CUSTOMERS.CustID; Obviously you would need to expand these to include the full six levels (whew!), but you could always create temporary heap tables to break this down into smaller manageable task. NOTE: I have not tested these queries so they may need some tweaking, but hopefully you get the general idea. Let me know if you want clarification. Craig sql,query At 07:46 PM 4/2/2002, you wrote: Hi, I just now signed up for this list a second ago and thought I'd say howdy to everyone. I'm not sure what the typical discussions are like on this list, so I'll go ahead and ask anyhow. If there is another list that would be better suited to this type of question, please let me know. A friend of mine who runs a small company has recently decided he's going to award his customers based on a 'referral' type program where, if I refer somebody to him, I get a recurring check for say $1 a month. If the person I referred refers somebody, that person get's $1 a month, and then I get say $0.50 a month on top of my $1 a month. People can refer as many people as they'd like, but for the 'sub-referrers' (i can't think of a better term to call them), I would only get paid up to six degrees of the original referrer. Hope that makes since... Anyhow, my friend has asked me to build a database where all of this information could be stored, and then I would have a script determine what is owed to who at the end of each month. The problem I'm having is that... I just can't think of a table structure to even begin with. I can do a simple table where I would have the customer_id, and then referrer_id, but the script would have to do a massive amount of queries and this just wouldn't be efficient at all. Can someone point me in the right direction as to how I should maybe set up these tables? Thanks! P.S. - This message originally was returned to me because I didn't have the words sql or query in them. Well, it does now :) What a weird filter. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Procedures
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB and Table Corruption
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 rarer if I choose to use InnoDB tables? Are there any statistics on corruption? There seems to be plenty of material on MySQL and InnoDB and speed vs the other major dbs, but what about stability and safety of data? Craig query,sql,mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database Design Question
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 header info (like owner and creation date). Craig At 07:39 AM 3/28/2002, you wrote: Hi all, I am in the process of designing a MySQL database that will run on Redhat 7.1, but I am fairly sketchy on MySQL and performance. What I want to do is have a database that keeps track of large distribution lists. Each list has a unique ID, an owner (which is a reference to an ID in another table) and a creation date. My question is this: Would it be more efficient to have each entry in the list stored in this table in the database, or would I be better off having a reference to a file that is stored on the hard disk? Users must be able to view, add, modify and delete entire lists and single entries in the lists. I am using MySQL, PHP and Perl with an Apache Webserver. Cheers, Ben - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQLl performance on Linux versus XP/W2K
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 posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
UDFs (2nd Try)
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, Craig mysql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
UDF's and Windows
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 posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: UDF's and Windows
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 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 posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL database; MS SQLserver connection;
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 connect a Visual Basic application with a MySQL database with ADO. The only problem (and maybe more) is that there isn't a ODBC driver available to connect to the database. For company security it is not possible to install or modify system configuration. So the problem must be solved server sided. It is possible to connect with MS SQL server ODBC driver to the MySQL database by installing a conversiontool on the MySQL server? Or is there an other solution for my problem? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC and .NET (C#)
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#. Dim c As New ADODB.Connection() Dim r As New ADODB.Recordset() c.Open(DSN=SchoolStuff) r = c.Execute(SELECT * FROM classtitles) While Not r.EOF MsgBox(r.Fields(classtitle).Value) r.MoveNext() End While r.Close() r = Nothing c.Close() c = Nothing At 06:01 PM 3/11/2002 -0800, you wrote: Hi All, I'm having problems connecting to MySQL with C# via MyODBC 3.51.02; the DSN I created is called 'MySQL1'. The error I am receiving is: The 'MySQL1' provider is not registered on the local machine. This is what my connection string looks like: string strConn = Provider=MySQL1;DNS=MySQL1; Has anyone faced similar issues? Any advice? Thanks in advance, Jes __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL license problem on Windows
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 fees. But I can't find anything on MySQL document to talk about this. Do you know this problem? Thanks a lot! Zengfa __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: dumb (re)newbie question...
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 have a really dumb newbie question. I need to add another row of data to an existing table what is the command to do so? Not like an UPDATE command where you input data into the table, but rather a whole new row (or maybe column) or the table. like if you have 7 values for the table, I want to be able to add an 8th value. Please advise... Thanks! -Alex Big Al Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Geographical MySQL Usage
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Client installation by itself?
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 one or more of the following files: libmysql.dll libmysql.lib mysqlclient.lib Perhaps someone can shed some light on this? Otherwise, I am going to have to just do some trial and error. Let me know, Carl, if you find out. Craig O. At 08:16 2/27/02 -0600, you wrote: Is it possible to install just the mysql client software for NT? The only client distributions I can find include the mysql server as well. Carl McNamee Systems Administrator Billing Concepts (210) 949-7282 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php query,sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Gemini Tables and NuSphere Update
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 transaction processing, but don't know which way to turn. Should I undertake using NuSphere's (supposedly stable) Gemini tables. There seems to be a lack of info on these tables now. I am trying to get a grasp on what happened to this MYSQL AB vs NuSphere deal, but all of the posts about it seem to have vanished. In addition, my first impression of Gemini was not good as I did some simulated crash test and corrupted the tables without much trouble. Perhaps it was unrelated. But it is worth further investigation. Or should I look at the InnoDB tables (which are still considered beta). Any opinions? Craig sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HELP! How to run multiple versions of MySQL on Windows
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 that point in time? Aside from my.ini, are there any other external (outside the base directory) files that I need to worry about. Any other alternative solutions or am I missing the boat here. Thanks in advance, Craig sql,query,tables - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL TEXT datatypes and multiple tables
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 it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I have a table that has a field with a TEXT datatype. Because of this all my CHAR fields had to become VARCHAR. Is it common practice to move the TEXT field to a separate table in order to preserve the CHAR fields in the original table. Bear in mind I am primarily concerned with speed. Are there any other tips someone can offer for using the TEXT datatype? Craig - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Required files on client machine?
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 possible. --Craig - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php