NEWBIE!! need help with nested select query

Hi- I have 2 queries that I know work in SQL Server, but I can't figure out why they won't work with mySQL. SELECT email, comments, (select count(*) from guests where decision=3) as total, (select count(*) from guests where decision=2) as secondtotal FROM guests AND SELECT email, comments,

Re: NEWBIE!! need help with nested select query

Subqueries aren't supported in MySql prior to ver 4.1. - Original Message - From: Becky OGrady [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 15, 2003 12:28 PM Subject: NEWBIE!! need help with nested select query Hi- I have 2 queries that I know work in SQL

mysqld crashes with certain SSL connections

Description: mysqld (4.0.16) built with SSL support (--with-vio --with-openssl) crashes if both of the following conditions are met: 1. Permissions for a user have been set with GRANT...REQUIRE SUBJECT or GRANT...REQUIRE ISSUER. 2. A client program attempts to connect to the server by calling

Re: Some help with a complex query

Roger, * Elisenda [...] The explain select says as follows: [...] I re-formatted the query and the EXPLAIN output for readability: Sorry for not re-formatted the query, I've learn it for next time. Well, I've learn a lot with your lessons. Select FASE.PR_Date_Visita_2, CE.CE_Centro,

Database Dump

Hi All I have just started working on MYSQL. Can ne one help on How to take a database Backup? and how does one transfer the MYSQL database from one Comp to another one? Regards Swati kalia http://www.mecklai.com where risk meets its match *** This message

Re: Database Dump

Hi From: Swati K [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 15, 2003 1:40 PM I have just started working on MYSQL. Can ne one help on How to take a database Backup? Backup; shell # mysqldump table table.sql for details; http://www.mysql.com/doc/en/Backup.html Best

Depth-first-traversal order?

I have the following columns in a table: posts.id posts.parentId REFERENCES posts.id This represents a tree that has a single root node, and each node can have 0 or more children. posts.id is the id number of a node, and posts.parentId is the id number of that node's parent (is NULL for the root

Grant privilege removed from root

Dear all Getting confused in the mysqlcc as a [EMAIL PROTECTED], I managed that I cannot grant privileges any more. Any hint how I can undo that? Thanks, W. Bauer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Index Question

John Berman [EMAIL PROTECTED] wrote: Hi. using MYSql 3.28 There is no such version of MySQL :) I have a surname column with a standard index and this is the column were search are performed on, currently the filed only has the one name i.e.: Surname: smith I want to include other

Re: Database Dump

At 14:13 +0200 15-11-2003, Davut Topcan wrote: I have just started working on MYSQL. Can ne one help on How to take a database Backup? Backup; shell # mysqldump table table.sql I use a command-line PHP script (-rwx--, owned by root, executed with a cron job) to backup MySQL databases.

MySQLCC - Garbage Display

Hello: I'm using mysqlcc version 0.9.3 on RH 9.0. When I upgraded from RH 7.2, the application seems to have changed into a bizarre, unreadable font. Does anyone know what could be the problem? Obviously, this renders the application entirely unusable. I suspect a QT problem, will look for

Depth-first-traversal order?

I don't think you can do what you want in one query if you use the adjacency list tree model (i.e. a self join to the parent node). See the article below comparing the adjacency list and the modified preorder tree traversal: http://www.sitepoint.com/article/1105 I'm not sure if that is what

Client library

Hi all, I have already asked it a few days ago, but I got no answer. Does anyone know how to obtain the newest version of libmysql.dll and the header file(s) for it? Thanks, niel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: max_user_connections problem after upgrading

Hi Joe, No, I don't know exactly. Releases usually come out at about the same interval. So going by previous releases, I would say 4.0.17 should be released within 2-4 weeks -- probably shortly after 4.1.1. Matt - Original Message - From: Joe Lewis Sent: Friday, November 14, 2003

Re: Backslash and full text searches

Hi Jason, Sorry for the late reply. If all of the 100,000 entries have extra backslashes, that can be fixed with a query. But then you have all your code. :-( Speaking of code, what language are you using? I always assume PHP, but with 500k lines I'm thinking you're using C? Is somebody\'s the

SQL: forbidden syntax search

Hi, I need a little help on my SQL syntax. I want to store forbidden inputs from the GUI in a table and query it on input from the user; simple layout: CREATE TABLE `forbidden_input` (`lfdnr` TINYINT (3) UNSIGNED DEFAULT '0' AUTO_INCREMENT, `input` VARCHAR (255) NOT NULL, PRIMARY KEY(`lfdnr`),