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
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
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
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,
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
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:
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
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
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
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
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
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
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]
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 query
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
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
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
17 matches
Mail list logo