Re: Query error

The comma at the end of the SELECT statement needs to be removed Naz Gassiep wrote: Hi, I'm trying to execute this query: SELECT group_post.group_thread_id, FROM group_post LEFT OUTER JOIN group_post_moderation ON (group_post.group_post_id = group_post_moderation

How to limit word result by query

Hi all, Is it possible to do query which limiting the result into some words only? i.e the complete sentence is "I am able to login with the account" and I just want to view "I am able to login..." Many thanks for any reply. Regards, Willy -- www.sangprabv.web.id www.binbit.co.id -- MySQL Ge

Query error

Hi, I'm trying to execute this query: SELECT group_post.group_thread_id, FROM group_post LEFT OUTER JOIN group_post_moderation ON (group_post.group_post_id = group_post_moderation.group_post_id) LEFT OUTER JOIN group_post_mod_option ON (group_post_moderati

Re: Why is the average of an int column returned as a string

At 8:25 PM -0400 8/21/07, Baron Schwartz wrote: Eric Lommatsch wrote: Hello, I am working with a query that calculates the averages of survey answers. The survey answers are stored in the database as int(11) fields. When I run the query the results that I am getting are being returned as st

Re: Why is the average of an int column returned as a string

In the last episode (Aug 21), Eric Lommatsch said: > I am working with a query that calculates the averages of survey > answers. > > The survey answers are stored in the database as int(11) fields. When > I run the query the results that I am getting are being returned as > string data. > > The

Re: Access denied for user on Windows Server

More info... I am able to login with the account via phpMyAdmin on the server. Also, I am trying to use phpMyAdmin to change the permissions, but I cannot figure out the syntax: GRANT ON ppsntracker.* TO [EMAIL PROTECTED] WITH GRANT OPTION; Cartoper On 8/21/07, Car Toper <[EMAIL PROTECTED]> wro

Access denied for user on Windows Server

I have a MySql server running on a Windows box that I cannot connect to from another machine. I first checked to make sure the user has the correct permissions, which the user does, it has the %. I did read something that gave me the impression the user needs to have a tranditional windows accoun

Re: Why is the average of an int column returned as a string

Eric Lommatsch wrote: Hello, I am working with a query that calculates the averages of survey answers. The survey answers are stored in the database as int(11) fields. When I run the query the results that I am getting are being returned as string data. The query that I am working with is

Why is the average of an int column returned as a string

Hello, I am working with a query that calculates the averages of survey answers. The survey answers are stored in the database as int(11) fields. When I run the query the results that I am getting are being returned as string data. The query that I am working with is a data source for a Cry

Stored proc question

Hi all, My basic question is, is there a simple way of finding out if a select statement executed within a stored proc returns something. I could go ahead, do the fetch (the query is done with a cursor) and count how many records were returned but looping over the result. In below proc the variabl

Re: A select for a game ranking page.

Hi, Critters wrote: Hi I have a table with: player_name, top_score, number_of_plays When I list them out I "ORDER BY top_score DESC, number_of_plays DESC, player_name" to help give some sort of order to the people with the same scores. What I would like to do is find out a players position

A select for a game ranking page.

Hi I have a table with: player_name, top_score, number_of_plays When I list them out I "ORDER BY top_score DESC, number_of_plays DESC, player_name" to help give some sort of order to the people with the same scores. What I would like to do is find out a players position without looping throu

RE: Replication problem

I'm sorry. I have posted a wrong example. Here you have a better one: update table_1 \n set field_1 = 'xx', \n field_2 = 'yy'; \n > Date: Tue, 21 Aug 2007 11:16:50 -0400> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]> CC: mysql@lists.mysql.com> Subject: Re: Replic

Re: Replication problem

Hi, Jorge Martínez wrote: We have a windows server running our main database and an IIS server. We also have a linux box with apache/php that uses the same database server. We have configured a replication from that host to another windows server. Then we verified that not all the queries wer

Re: user permissions to all DB

solidzh wrote: 2007/8/21, Jay Pipes <[EMAIL PROTECTED]>: Terry wrote: Hello, I want to grant a user all permissions to all DBs on the system as well as any new DBs that show up. I want to avoid having to modify permissions everytime a new DB is added. Is there a way to do this? GRANT SELECT

Replication problem

We have a windows server running our main database and an IIS server. We also have a linux box with apache/php that uses the same database server. We have configured a replication from that host to another windows server. Then we verified that not all the queries were replicated properly. We f

Using mysqlbinlog with tables with binary data (blobs)

We have had some cases where we wanted to recover data using the binlogs from some days ago. The database has a lot of binary objects (blobs). The normal way to recover are to restore database files from a consistant point, and then use mysqlbinlog to spool from that point till where we want to en

Improvement of load_file() function.

MySQL provides an internal function named load_file(). It reads the file saved on the host server and returns the contents of the file as a string. This is an appoach to make users can read the file on the host server directly by using database. But I think this function can be improved further