query problem

hi everyboby, How to select latest 3 days records from the table according to the latests date. The data is like this:- name date a 02-03-01 b 02-03-15 c 02-03-20 d 02-03-20 e 02-04-28 f 02-04-28 g 02-04-30 The result should be like this:- name date g 02-04

Re: MySQL - PHP - Banner ad click through tracker

Check out phpADs http://sourceforge.net/projects/phpadsnew/ olinux --- Craig Westerman <[EMAIL PROTECTED]> wrote: > Does anyone here have a PHP script that will store > banner ad click throughs > in a MySQL database? > > If not, is anyone here interested in doing this > project? > > Thanks >

new

hi im just learning mysql so please go easy on me as iv not been a newbe for a long time i'v just a few questions Can i have pictures in my db or would that be on the php end of things as i need a db for my local karate school any good tutorials out there im not looking for anything much jus

Re: Select Past 7 days

Try this: SELECT a, b FROM tblName WHERE TO_DAYS(NOW()) - TO_DAYS(pubDate) <= 7; Anthony > What is the proper query for slect all from the past > number of days. > > i.e. I would like to return all articles from the past > week. Right now I am using SELECT blah, bla FROM table > WHERE pubDate

MySQL - PHP - Banner ad click through tracker

Does anyone here have a PHP script that will store banner ad click throughs in a MySQL database? If not, is anyone here interested in doing this project? Thanks Craig ><> [EMAIL PROTECTED] - Before posting, please check: h

Re: Select Past 7 days

At 20:52 -0400 5/1/02, Anthony W. Marino wrote: >Try this: > >SELECT a, b FROM tblName WHERE TO_DAYS(NOW()) - TO_DAYS(pubDate) <= 7; > >Anthony SELECT a, b FROM tblName WHERE pubDate >= DATE_SUB(NOW(),INTERVAL 7 DAY); will probably be faster if pubDate is indexed. The first query above puts pub

GUIDELINES for Posting to the MySQL list

NOTE: This message is posted periodically to the MySQL List on behalf of all members of the MySQL mailing list. Please read it carefully before posting. This document can be retrieved from: ftp://ftp.workmate.ca/pub/MySQL/mysql-posting-guidelines.txt The Short Version

Help: SIGSEGV inside mysql_connect to remote server

I am having a really strange problem with a in-house C application that calls mysql_connect() and generates a segfault deep within uname() when I configure it to contact a remote server. Using a local MySQL server works fine as uname is never called. Have any of you ever seen anything like this?

Select Past 7 days

What is the proper query for slect all from the past number of days. i.e. I would like to return all articles from the past week. Right now I am using SELECT blah, bla FROM table WHERE pubDate BETWEEN CURDATE() - 7 AND CURDATE() AND whatever = 'whatever' This worked fine until today. the first o

Help: SIGSEGV inside mysql_connect to remote server

I am having a really strange problem with a in-house C application that calls mysql_connect() and generates a segfault deep within uname() when I configure it to contact a remote server. Using a local MySQL server works fine as uname is never called. Have any of you ever seen anything like this?

Re: [thelist] MySQL to Excel Problem Pivot Table SOLVED!

> Nothing needs to be done in PHP > except run this query and place the results. > > I feel like rudy today! :) thanks, i'm honoured especially since your comment comes right after "nothing needs to be done except run this query" that is indeed the holy grail of web development -- ask the dat

Re: Good color coded SQL editor for MySQL?

> > GNU Emacs and sql-mode. :-) > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> Jeremy I'm a big fan of sql-mode with Emacs for accessing Sybase servers at work, how do I config it to point to MySQL on my local machine (Win2K PC) - adding a new association doesn't work as the sql mode tries t

Re: [thelist] MySQL to Excel Problem Pivot Table SOLVED!

Ahh, the joy of cross-tabulation. Whee. :) Jay Blanchard wrote: > > Sorry for the cross-post, both lists contributed to a solution. Here is a > query (using MySQL 3.23) that will return cross tab, or pivot table > information; > > mysql> select RecordDate, > -> IF(RecordID='100101',count(*

Re: Error repairing: how do you Recreate an Index?

Error 13 is a permission problem. Mysql does not own the file. You probably repaired it while logged on as root, and changed ownership of the file. Make sure it is owned by mysql. MySQL wrote: >Hi all, > >I was trying to repair a table with myisamchk and got the following message: > >"error: 'x

Re: using currentdate in queries

On 1 May 2002, at 13:04, Jeff O'Neal wrote: > select foo from blah where date=(Current_Date)-1; > > Since it was just the end of the month that ended up giving us a blank > result set. WHERE date = CURRENT_DATE - INTERVAL 1 DAY see http://www.mysql.com/doc/D/a/Date_and_time_functions.html [Fi

Re: Using MyODBC with Python

Python has its own MySQL interface module. You don't need MyODBC. Sabine Richter wrote: >Hello, > >I can't think straight today. So please help me: >I downloaded and installed myODBC 3.51. As far as I understand, it is >only the driver, which provides the connection to the database. In my >examp

Re: mysql log rotate

Opening a file access it by its inode. Once it is opened, it can be renamed, or deleted, and this will have no effect for the process that has it open. Flush logs will close the inode, and create a new log, which will assign a new inode to be opened. File names are just handy pointers to inodes

RE: using currentdate in queries

You'll probably want to use SUBDATE instead. http://www.mysql.com/doc/D/a/Date_and_time_functions.html Duncan -- Duncan Salada | Titan | www.titan.com/testeval Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216 > -Original Message- > From: Jeff O'Neal [mailto:[EMAIL P

mysql log rotate

in mysql docs, http://www.mysql.com/doc/L/o/Log_file_maintenance.html : 1) shell> cd mysql-data-directory 2) shell> mv mysql.log mysql.old 3) shell> mysqladmin flush-logs What's happening if there is a query between line 2 and 3, is it logged ? How could I rotate my files without a query not log

Re: Error repairing: how do you Recreate an Index?

Hi, Errcode: 13 means "Permission denied". May be you should check its owner and permission Regards -- Joseph Bueno NetClub/Trader.com MySQL wrote: >Hi all, > >I was trying to repair a table with myisamchk and got the following message: > >"error: 'x.MYD' doesn't have a correct index definiti

Re: mysql speed concerns

Technically speaking, TCP/IP communication *is* a form of IPC. IPC isn't restricted to semaphores or message queues, etc. I think that's what he meant (i.e.: mysql client on one box communicating via TCP/IP to a MySQL server on another box). Michael On Wed, 1 May 2002, Gelu wrote: > Hi, > A

RE: [thelist] MySQL to Excel Problem Pivot Table SOLVED!

[snip] SELECT RecordID, RecordDate, count(*) AS Quantity FROM tblFOO Group By RecordID, RecordDate It returns; +--++--+ | RecordID | RecordDate | Quantity | +--++--+ | 100101 | 2002-03-21 | 6675 | | 100101 | 2002-03-22 | 6794 | |

using currentdate in queries

We run many queries for data for the previous day.. select foo from blah where date=(Current_Date)-1; Since it was just the end of the month that ended up giving us a blank result set. I looked through the manual but I didn't find an answer. (I probably just looked over the right part) Does an

Logging of net_read_timeout and/or net_write_timeout

>Description: I have a program that takes a large select statement via mysql_use_result (programmed in Perl and DBI). It processes a number of records from this result set and then goes off to perform other activities. When it returns to take more records from large resul

Using MyODBC with Python

Hello, I can't think straight today. So please help me: I downloaded and installed myODBC 3.51. As far as I understand, it is only the driver, which provides the connection to the database. In my example, it is MySQL 3.23.49. The manual says that in my application I have to allocate the environme

Re: mysql uses 99% cpu under freebsd 4.3

List, Re: I have this exact problem on a single-CPU P-III 500 running FreeBSD 4.5-RELEASE, generic kernel. MySQL is 4.0.1-alpha. I have tried both the mysql.com-supplied binary package and rolling my own from so

Error repairing: how do you Recreate an Index?

Hi all, I was trying to repair a table with myisamchk and got the following message: "error: 'x.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair" (If I try to access the table from mysql, it tells me that the file x.MYD doesn't exist. It does e

RE: Grants, rights, permissions

[snip] Now, if I understand correctly I might connect to database "duwt" as user "tps" from any host. But trying this I can't connect to database "duwt". Why? [/snip] Did you flush your privileges either using MySQL monitor or mysqladmin? Jay Blanchard ---

RE: mysqlimpor and fixed length files.

Jay Bryan suggested setting the file delimiters in mysqlimport to nothing and it worked gracefully... I am going to read into the other approach that you suggested since it seems more flexible... (mysqlimport --query=...) I haven't done the big file yet... I did a smaller one that was 50 gi

Grants, rights, permissions

Hi! I am having some trubble understanding, how permissions work with MySQL: I've set up user, database, and host permissions: User: Hosts:PW: Permissions: tps Any pwAll Anonymous 192.168.107.204 ''None Database: User: Hosts: Perm

RE: mysqlimpor and fixed length files.

Brian! Using mysqlimport with no delimiters worked fine. Thanks a lot... Ramon -Original Message- From: Brian Ivins [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 12:36 PM To: 'Ramon Arias '; '[EMAIL PROTECTED]' Subject: RE: mysqlimpor and fixed length files. If yo

Re: mysql speed concerns

Hi, About at the same IPC(semaphore,share memory,message) i make references too.Are more ways to made a inter process communication mechanism. For example, in my applications i don't use semaphores and messages.This are system functions available from the Kernel. If you type "ipcs" you can see tha

Re: mysql speed concerns

Hi, We have faced this kind of problem for our main web site. When a single server was not enough any more (2 years ago), we have separated the database from Apache server. Last year, we added 3 more Apache servers with load-balancing and upgraded the database server with a faster machine (2x1

RE: mysqlimpor and fixed length files.

[snip] The way that I have been doing it so far is by coverting the source data into tab delimited format with a 'C' utility that I wrote and then loading it using mysqlimport. However I am looking for a way to streamline that process. I am loading about 100 Gigs of data, so that extra step that I

Runtime mysql_init problem

I recently had to reformat my hard drive and re-install everything. Now when I try to run my C++ developed using Kdeveloper 2.0 the command conn = mysql_init(NULL) causes error "Stopped due to shared library event" This program used to work fine so I realize it's probably an installation probl

RE: mysqlimpor and fixed length files.

If your destination table matches the fixed length record layout exactly, you can import the data using mysqlimport like this: mysqlimport -v --password=yourpasswd yourdb $FULLPATH/yourtablename.yourdatafile --fields-terminated-by= --fields-enclosed-by= I've imported several gigs of data this

RE: mysql speed concerns

With IPC I mean Inter Process Communication - any process that wants to talk with something else than with it self _needs_ necessarily IPC. Particularly an RDBMS needs IPC - otherwise it is useless. Anyhow. one way one might get faster performance could be to (if possible with the OS) move the s

RE: CREATE and DROP Privileges

Hi Chris, I am sorry, it turns out that first idea is not an option.. I don't know what I was thinking, you can't use wildcards on the table/database names except for '*' to indicate ALL table/database names.. I think you are stuck with the second idea.. I checked the TODO list on the manual,

Re: CREATE and DROP Privileges

Chris, Wednesday, May 01, 2002, 5:18:47 PM, you wrote: CA> I have a user account that needs to create and subsequently drop tables (not CA> temporary tables). CA> Is it possible to give permissions to this user to drop just the tables that CA> he creates - without allowing him to drop any other

Re: mysql speed concerns

Hi, MySQL don't seems to use IPC.!?...Strange ..!?...And if Shaun will need "real-time" response from RDBMS,in my opinion, is strongly recomended to set up MySQL on the other host. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address

Re: mysql speed concerns

Hi, MySQL don't seems to use IPC.!?...Strange ..!?...And if Shaun will need "real-time" response from RDBMS,in my opinion, is strongly recomended to set up MySQL on the other host. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address

Runtime mysql_init problem

I recently had to reformat my hard drive and re-install everything. Now when I try to run my C++ developed using Kdeveloper 2.0 the command conn = mysql_init(NULL) causes error "Stopped due to shared library event" This program used to work fine so I realize it's probably an installation probl

RE: CREATE and DROP Privileges

Thanks Gurham, I'd considered your second idea - but I prefer your first idea. So I decided to give the user a table prefix of tbl_R - however, the following throws an error: mysql> GRANT CREATE ON Personnel.tbl_R* TO MyUser IDENTIFIED BY 'a_password'; Error 1064: You have an error in your SQL s

Re: MySQL to Excel ?

At 08:01 01-05-02 -0500, Jay Blanchard wrote: >Howdy, > >I need to write some data out to Excel spreadsheets for some of our managers >to muddle with for projections. The query works fine... If you're into Perl, I believe there are at least a couple of modules that will write out data into Excel

RE: MySQL to Excel ?

[snip] Try adding below the header in a php file & output the query data in HTML table format. [/snip] I am trying this method, and if I use the file with a .xls extension it just shows me the code. If I use the .php extension it opens Excel, and then puts up a file download box. Then I have to

link problem

hi every body i have succeed to compile source examples given with mysql++1.7.9. but i can't link them. i used gcc simple1.cc -c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient -lm -tz ->all rigth but , i didn't succeed to link can you help me -

RE: mysql speed concerns

An webserver uses mostly CPU resources while a DB uses I/O, or? Separation between the webserver and the RDBMS also suggest increased delays with IPC. I think one needs to find a balance somewhere in between, and I guess the only way to tell is to actually measure the performance of the system t

RE: mysql speed concerns

[snip] I'm worried that MySQL on this particular box won't be able to handle the load of around 100-120 queries per second. Not to mention the CGI scripts are also getting run on the same box with apache. The system has 1gb of RAM, 1 Pentium III 700Mhz, and some ultrascsi HDs (no raid), running

Re: mysql speed concerns

Hello, The first thing that I would do would be to separate the DB and apache. Set the DB up so that it is on a box of it's own. The system cannot serve pages if it is crunching through the db tables looking for information (and vice versa). Shaun - Original Message - From: "Jason Yat

mysql speed concerns

Currently our MySQL server runs around 20-30 queries per second. The upper management decided they wanted to add about 4 times the customers in the next two or three weeks. I'm worried that MySQL on this particular box won't be able to handle the load of around 100-120 queries per second. Not t

RE: CREATE and DROP Privileges

I don't think there is a way to do it.. But if you have control on the table names he is creating, you can just have a certain prefix on each table he creates and give appropriate permissions on databasename.prefix* to the user. Or else, you can create a different database exclusively to be used b

RE: MySQL to Excel ?

Hello Jay, I will give you a couple ideas.. I have never tried these options to do this job but they should work. First option is, you can use SELECT ... INTO OUTFILE syntax. Excel uses tab character as the column delimiter and new line character as the row delimiter if you import a txt fil

RE: mysqlimpor and fixed length files.

Jay, The way that I have been doing it so far is by coverting the source data into tab delimited format with a 'C' utility that I wrote and then loading it using mysqlimport. However I am looking for a way to streamline that process. I am loading about 100 Gigs of data, so that extra step that I

CREATE and DROP Privileges

I have a user account that needs to create and subsequently drop tables (not temporary tables). Is it possible to give permissions to this user to drop just the tables that he creates - without allowing him to drop any other table ? Thanks, Chris (MySQL - to satisfy your mail filter)

Re: FW: Select holding up an insert

> I am currently experiencing a problem with MYSQL where critical INSERTs into > my database appear to be held up by reports that are doing SELECTs. Turns > out the particular select uses a LIKE '%value%'. I would think this results > in a sequential search of the entire table (400k records) the

deleted tabels in innodb file

Hi Some how i have manged to delete a database, i'm not quite sure how. When i try to create the table's i get an error : 020501 15:08:38 InnoDB: Error: table noah/user already exists in InnoDB internal InnoDB: data dictionary. Have you deleted the .frm file InnoDB: and not used DROP TABLE?

Re: Mysqldump Problem

Damnish, Wednesday, May 01, 2002, 3:07:52 PM, you wrote: D> I am using mysql 3.23.37 on NT. D> I am getting problem when i am using mysqldump on NT, dumpfile contains all D> table name in lowercase(i was having all tables name in uppercase). D> Now i added D> [mysqldump] D> set-variable = lower_c

Re: _complicated_ isnull(to_days()) problem 3.23.47 and 3.23.49

vrm, Tuesday, April 30, 2002, 4:51:29 PM, you wrote: v> How-To-Repeat: v> vrm@food:~$ mysql v> Welcome to the MySQL monitor. Commands end with ; or \g. v> Your MySQL connection id is 236 to server version: 3.23.47 v> Type 'help;' or '\h' for help. Type '\c' to clear the buffer. v> mysql> use b

Re: Building relationships between tables

Denis, Wednesday, May 01, 2002, 1:09:07 PM, you wrote: DLM> In Access, we build relationships between tables and keys, How do we do this DLM> between keys in mysql? What about foreign keys? Look at the manual, you can find some info about foreign keys in MySQL: http://www.mysql.com/doc/A/N

RE: mysqlimpor and fixed length files.

[snip] I need to break it up into fields [/snip] Just to make sure that I understand...the data currently looks something like; 100101TestFileData1Data2Data3 and you need the columns to be like; 100101 TestFile Data1 Data2 Data3 If you are on *nix you need to write a script to break up the

Re: How do I find duplicate records?

Try: select substring(id,1,8) as pfx from foo group by pfx; or, if the column is numeric: select floor(id/100) as pfx from foo group by pfx; > Date: Tue, 30 Apr 2002 12:59:05 -0700 (PDT) > From: James Dellacova <[EMAIL PROTECTED]> > Subject: How do I find duplicate records? > [...

Re: mysqlimpor and fixed length files.

You need awk. It is tailor-made for this kind of task. There is a Windows version if that's what you're running. It can easily go through the records and insert a delimiter at a certain character position. It shouldn't take more than one line of code to accomplish the task. On Wednesday 01 May

RE: mysqlimpor and fixed length files.

Jay I need to break it up into fields Ramon -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:26 AM To: 'Ramon Arias'; [EMAIL PROTECTED] Subject: RE: mysqlimpor and fixed length files. [snip] Is there a way to import data that is in

FW: Select holding up an insert

I am currently experiencing a problem with MYSQL where critical INSERTs into my database appear to be held up by reports that are doing SELECTs. Turns out the particular select uses a LIKE '%value%'. I would think this results in a sequential search of the entire table (400k records) thereby

RE: mysqlimpor and fixed length files.

[snip] Is there a way to import data that is in fixed length format into MySQL? [/snip] Do you need to break up the data, or can it all just go in one column? Jay Blanchard - Before posting, please check: http://www.mysql.c

RE: MySQL to Excel ?

[snip] Good morning Jay, Try adding below the header in a php file & output the query data in HTML table format. [/snip] Good Morning James, This is a good idea, I could run one query to set the column RecordID, and then a second query to fill in the dates and quantities. Thanks! Jay -

mysqlimpor and fixed length files.

Hello there! Is there a way to import data that is in fixed length format into MySQL? Ramon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archiv

Re: MySQL to Excel ?

It's been awhile since I've done this, but couldn't you build a pivot table in Excel that would bring the data through ODBC? I did this before for a report I needed. You can get very granular about what data goes where in Excel and avoid the need for a bloated macro. Once the data sources and t

Re: MySQL to Excel ?

Good morning Jay, Try adding below the header in a php file & output the query data in HTML table format. Best regards, James --- Jay Blanchard <[EMAIL PROTECTED]> wrote: > Howdy, > > I need to write some data out to Excel spreadsheets > for some of our managers > to muddle with for projec

MySQL to Excel ?

Howdy, I need to write some data out to Excel spreadsheets for some of our managers to muddle with for projections. The query works fine... SELECT RecordID, RecordDate, count(*) AS Quantity FROM tblFOO Group By RecordID, RecordDate It returns; +--++--+ | RecordID | R

Communication failure during handshake - please help

hi, Please help me... I am getting an error "java.sql.SQLException Communication failure during handshake. Is there a server running on localhost:3306?" while connecting to mysql database. This error is rare but it comes after using the connection for some time. I am using Java Web Server 2.

Mysqldump Problem

Hello Members I am using mysql 3.23.37 on NT. I am getting problem when i am using mysqldump on NT, dumpfile contains all table name in lowercase(i was having all tables name in uppercase). Now i added [mysqldump] set-variable = lower_case_table_names= 0 in my.cnf file.(I searched the mail archive

RE: How do I find duplicate records?

[snip] Thank you for the email. Following is the php code but it doesn't work. 1 "; $result1 = mysql_query($query); while ($row = mysql_fetch_array($result1)) { echo "$row[id]"; } } ?> [/snip] Try your $query like this... $query =" SELECT id

Re: basic warning

Stuart: Something is wrong with your query. A little more detail? G Jensen - Original Message - From: "Stuart Elston" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Wednesday, May 01, 2002 5:35 AM Subject: basic warning on a valid dB, I get the following warnings. Warning:

basic warning

on a valid dB, I get the following warnings. Warning: Supplied argument is not a valid MySQL result resource in xx on line 7 First Name: Any ideas where to start debugging? Thanks in advance. Stuart - Before posting, please c

Building relationships between tables

Hello friends, In Access, we build relationships between tables and keys, How do we do this between keys in mysql? Thanks Denis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.

Re: INSERT INTO ..... SELECT

This was resolved by adding an auto-increment column. MySQL does not seem capable of coping with the situation below. - Original Message - From: "Dave" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 5:36 PM Subject: INSERT INTO . SELECT > I am having pro

Re: Unknown column

akul, Wednesday, May 01, 2002, 6:30:06 AM, you wrote: a> SELECT countries.*, lnk0.Value AS fraudIndex, lnk1.Value AS enabled a> FROM o as countries LEFT JOIN l_TINYINT AS lnk0 ON a> lnk0.FID=countries.ID AND lnk0.TID=55 LEFT JOIN l_TINYINT AS lnk1 ON a> lnk1.FID=countries.ID AND lnk1.TID=57 WHERE

Re: Where are binaries for MySQL 3.23.50 pre-release ?

Sanjay, Wednesday, May 01, 2002, 2:33:46 AM, you wrote: SR> I couldn't find binaries for MySQL 3.23.50 pre-release. Can anyone help me SR> with this. See http://www.mysql.com/downloads/mysql-3.23-pre.html SR> Thanks. -- For technical support contracts, goto https://order.mysql.com/ This

Re: Re: GUI managers for Linux

Rance, Wednesday, May 01, 2002, 12:19:42 AM, you wrote: RH> Victoria, sorry it has taken so long to get back to you, Ive had a partition RH> table problem that has taken a couple of days to fix RH> anyway, RH> Using MyCC, in the database connection dialog, I have the host "localhost" RH> a val

Wyniki skanowania antywirusowego

RAV AntiVirus for Linux i686 version: 8.3.2 (snapshot-20020108) Copyright (c) 1996-2001 GeCAD The Software Company. All rights reserved. Running on host: online.pl Skaner antywirusowy ONLINE.PL http://ONLINE.PL - Szybko,wygodnie i stabilnie ! Dome

Communication failure during handshake

hi, Please help me... I am getting an error "java.sql.SQLException Communication failure during handshake. Is there a server running on localhost:3306?" while connecting to mysql database. This error is rare but it comes after using the connection for some time. I am using Java Web Server 2.

Communication failure during handshake

hi, Please help me... I am getting an error "java.sql.SQLException Communication failure during handshake. Is there a server running on localhost:3306?" while connecting to mysql database. This error is rare but it comes after using the connection for some time. I am using Java Web Server 2.

Re: A very humour game

G'day Dave > What was this? I just threw it in the bin without opening, but it looks > very smelly(presumably even more so if you use OE)! Yes it' a virus - one of the klez variants that are rampant at the moment. It exploits a security hole in IE and creates its own smtp server/socket to fu

Replication and firewalls

Hi everyone, While I was reading MySQL manual about replication I came up with some questions. According to the manual, we create a user i.e. repl user on the master and we give him FILE privilege. Isn’t this privilege dangerous enough? I mean if we assume that there is a firewall between master

Re: A very humour game

mysql wrote: > Hello,This is a humour game > This game is my first work. > You're the first player. > I expect you would like it. What was this? I just threw it in the bin without opening, but it looks very smelly(presumably even more so if you use OE)! Isn't there a case for the list softwar

Re: Errors catalog, character-sets-dir .

Frederic Dhorne wanted to know > How do I re-generate the catalog (errmsg.sys)? Well, I had a similar question about the Japanese error messages. It seems the tool mentioned in the manual was not in the binary distribution, and wasn't in the MSWindows source distribution, either. I happened to