Is my logic wrong here?

I am using the following C++ (Visual Studio .Net 2002) code to determine whether or not a given object exists in a table.If it DOES exist, it adds it. snip query.Format(SELECT catID FROM Categories WHERE category=\%s\ AND subcategory=\%s\, currentObject-category, currentObject-subcategory);

need deb for msyslog ..

Hi all. Has anyone got a deb for woody for msyslog . I have looked on www.apt-get.org but didn't come up with anything .. Or if anyone could sugest an opensource replacement for syslogd that logs to mysql that is better then that would be grate .. Many thanks Gregory Machin 072 5248 096 [EMAIL

Change storage location

Hi All, I have newly installed mysql 3.23.54 in Red Hat 9 (The one which was bundled with the OS). And default the data storage file location went to /var/lib/mysql, how do I change the location to /mysql, I have also tried modifying my.cnf it didn't help. Any suggestion. -mysql

Re: How to Uninstall Mysql

Well, I've never used rpm, only apt. In apt, to get the list of mysql installed packages I do # dpkg -l | grep -i mysql you should find the equivalent command on rpm; maybe rpm -l but I'm not sure. Then, when I have the list, I can remove each package with #apt-get remove --purge -u

Re: Change storage location

Mysql Mysql wrote: Hi All, I have newly installed mysql 3.23.54 in Red Hat 9 (The one which was bundled with the OS). And default the data storage file location went to /var/lib/mysql, how do I change the location to /mysql, I have also tried modifying my.cnf it didn't help. Any suggestion.

Re: Any one can drop a table or database

I am new to mysql. I have installed, created a database and also some created tables. Now any one who can login to the host are able to drop the table or also the database. How do I protect it? You should read this: http://www.mysql.com/doc/en/User_Account_Management.html or maybe install

Re: Question DB

* [EMAIL PROTECTED] aka Delmar I am using mysql 3.23.58-max. Want to create database Entered mysqlCREATE DATABASE[IF NOT EXISTS] db_anyname -- - it gives me response of too many paramaters. Can anyone

date conversion

found out that 4.0 has a date format converter thanks for the Perl actually I wrote a Qt/C++ program to convert the date _ Worried about inbox overload? Get MSN Extra Storage now! http://join.msn.com/?PAGE=features/es -- MySQL

from my rdb review (get ready for that RDB interview) avail upon request

(2) What normal form is violated here? A telephone call is uniquely identified by telephone number and time of call. These* candidate keys compose the primary key. There is an attribute/column “telephone location”. * * telephone number|time of call | telephone

Re: Auto_increment question

* Chris W I have two tables with a one to many relationship: boys and their toys. I want to know if there are any advantages or disadvantages for each of the following two ways to create the tables. I am mainly interested in performance. Either way the insert and select queries aren't any

Convert MS Access to MySql

I need to convert an MS Access database to MySql. I would like to know the best way to do this. I was going to write an asp or php script that would read the MS Access db row by row and insert into the MySql db row by row. Is that the only way to move the data from the one db to the other? Many

Re: Convert MS Access to MySql

I'm new to MySql as well but the LOAD DATA statement is probably what your looking for. It's a bulk loader and dumps the data from a flat file into a designated table for you. You could easily automate this by writing a simple perl script(probably php also but im not to familiar with that

Newbie: Design question

I have a contract that has about 6 fields that need to be filled out each time it is signed. My goal is to have a form that only asks for the missing information then includes that into the contract which is then printed and then stored in a database completed. There would be 3 unique things

Re: Convert MS Access to MySql

Arthur On converting data from MS Access. I've done this several times myself, and found the easiest way is to: 1. Create your mySQL database tables 2. Define a DSN (ODBC Connection) from your workstation to the mySQL database 3. Link the mySQL tables into your MS Access database 4. Copy the

Quering user privileges

Is there a way to query the privileges of current user if he hasn't the rights to read the mysql system tables (user, db, hosts, etc..) I mean, I CAN'T give a standard user the chance of read system tables! But my client app wants to know if the current user has (for example) the rights to

Re: Quering user privileges

What about creating a flat file on the middle tier from the database system tables that the clients can view with your gui or web page. Only things is keeping the file in sync with the system tables. But access will be faster to the flat file and no security risks because there won't even be a

Deleted all users from MYSQL. What to do now?

By mistake I deleted all users in MYSQL. So, how can I login to the mysql? Is it possible to add a user to my.cnf file? Thanks _ Grab our best dial-up Internet access offer: 6 months @$9.95/month.

Re: Deleted all users from MYSQL. What to do now?

If it includes root, you will need to run the mysql_install_db script again then set a pass with mysqladmin By mistake I deleted all users in MYSQL. So, how can I login to the mysql? Is it possible to add a user to my.cnf file? Thanks

Very Slow GROUP BY Query

I have been trying to understand why this query is taking over 60 seconds to complete SOMETIMES...its not that complicated and the server (4.0.17) is under very little load. Any help would be appreciated. They Query: SELECT Realm, COUNT(*) AS CallCount, SUM(AcctSessionTime) AS RealmTime FROM

Getting a particular row from GROUP BY

Hello, I have the next table (the primary key is id+language): || id || language ||title|| --- 1 de{some_text} 1 en{some_text} 1 fr{some_text} 2 fr{some_text} 2

date and not null

why did this date work: insert into log_book values ('08-12-1973','C150','N5787G',1,1.8); date looks good in table...has been rearranged to std format and this didn't insert into salesreps values (109,'Mary Jones',31,11,'Sales Rep','10-12-1989',106,30.00,392725.00); date is -00-00 in

RE: Getting a particular row from GROUP BY

What would be the rules for deciding if id 3 should be fr or de? Michael Shuler, C.E.O. BitWise Systems, Inc. 1301 W. Pioneer Parkway Peoria, IL 61615 Office: (217) 585-0357 Cell: (309) 657-6365 Fax: (309) 213-3500 E-Mail: [EMAIL PROTECTED] Customer

RE: Very Slow GROUP BY Query

A little extra info... MySQL's process list says: Command Time Status SQL-Query (which looks like it abbreviates) Query 67 Sending data SELECT Realm, COUNT( * ) AS CallCount, SUM( AcctSessionTime ) AS RealmTime FROM ServiceRADIUSAccounting Thinking this could be a

Re: Getting a particular row from GROUP BY

Michael Shuler [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] What would be the rules for deciding if id 3 should be fr or de? if 'en' does not exist, then it does not matter which language is returned (even be the first available language in the rows order in the DB). But would be

RE: Getting a particular row from GROUP BY

Try: SELECT * FROM table GROUP BY id ORDER BY language=en DESC, language DESC (I didn't set up your table on my sever to test this but this should work) See http://www.mysql.com/doc/en/Sorting_rows.html down at the bottom near the user comments someone is doing the same kind of thing. Hope

RE: date and not null

Not sure how the first insert worked - couldn't test it as the create table syntax is not valid - nlandings number and nhours number - not sure how they produced the schema: | nlandings | int(11) | YES | | NULL| | | nhours| double(8,2) | YES | | NULL| | In

Re: Getting a particular row from GROUP BY

Thanks for your help, but it is not giving the result. The problem is that when you make GROUP BY id then the row representing the group is the first row in the group, and adding ORDER BY ... after the group by part just orders the grouped rows, but the grouped rows are in the wrong languages,

RE: Very Slow GROUP BY Query

Well, without investigating it too deeply, if you have: SELECT Realm, COUNT(*) AS CallCount, SUM(AcctSessionTime) AS RealmTime FROM ServiceRADIUSAccounting WHERE AcctStartTime '2003-12-12 16:00:00' AND AcctStopTime '2003-12-12 15:00:00' AND (Realm = 'bwsys.net') GROUP BY Realm If you are using

setup.exe

I downloaded MySQL but is unable to find the setup.exe file so that I can install it on my computer. Where can I locate this file? Jenice Lynch MSc Mobile Computing This mail sent through IMP: http://webmail.brad.ac.uk To report

mysql config

Hi... I'm new to configure mysql. I have read all pages on mysql.com ablut the subject, and have figured out that some numbers are a bit to high. As config file Have I used my-huge.cnf. here are some numbers: | Open_tables | 512| | Open_files | 618|

Connector/ODBC with Protel DXP.

Hi, Has anyone every connected MySQL with Protel DXP via Connector/ODBC on Windows 2000? I can't browse tables, but I can view a list of tables and databases, authenticate/connect correctly etc... so I am not sure what is happening. Anyone ever had this problem with other annoying

where is mysql.server???

landon (root) /usr [632]find / -name mysql.server -print find: /proc/1437/fd: No such file or directory _ Working moms: Find helpful tips here on managing kids, home, work — and yourself.

RE: setup.exe

I assume you're trying to install it on windows? If so you need to download the MySQL binary (with installer) ( http://www.mysql.com/get/Downloads/MySQL-4.0/mysql-4.0.17-win.zip/from/pick ) not the source ditribution. http://www.mysql.com/doc/en/Installing.html has all the necessary info.

Error: 127

Hi All, I have a MySQL4.0 installation on NT server with VB and crystal reports. The database has around 15 tables with about 15K - 150k record. One of the tables, 'tblselect' has more 15 columns. There are 5 medium text fields, one auto increment field and all rest are varchars. This

Re: Error: 127

Just do a check and repair: (or just repair to fix it) CHECK TABLE your_table REPAIR TABLE your_table - Original Message - From: Jacob Joseph [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 22, 2003 12:36 PM Subject: Error: 127 Hi All, I have a MySQL4.0 installation

Re: where is mysql.server???

try find / -name mysqld landon kelsey wrote: landon (root) /usr [632]find / -name mysql.server -print find: /proc/1437/fd: No such file or directory _ Working moms: Find helpful tips here on managing kids, home, work ? and

Re: where is mysql.server???

landon kelsey wrote: landon (root) /usr [632]find / -name mysql.server -print find: /proc/1437/fd: No such file or directory If I recall correctly, you are working on Redhat Linux. From the manual, ...if you use the Linux RPM package (MySQL-server-VERSION.rpm), the mysql.server script

Re: How to Uninstall Mysql

Do I have to uninstall OS to reinstall mysql for my problem.? Please guide me. Thanks for support. ads mysql [EMAIL PROTECTED] wrote: Yes I could uninstall mysql with rpm -qa | grep MySQL (MYSQL should be in Uppercase. I tried same with lower case earlier) Therefore has not worked.