Re: MySQL 4.1 replication relay log control

At 13:26 -0500 10/11/03, Christopher L. Everett wrote: Victoria Reznichenko wrote: relay-log-purge is available from 4.1.1. Do you use 4.1.1 or 4.1.0? Is it in the manual because relay-log-purge is available in 4.0.x? Sorry, what? AFAICT, 4.1.1 isn't available for download from the mysql.com sit

Using both embedded and 'normal' server in a client

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi; I've been using the libmysqlclient library for a while now, and developing some client application which are using MySQL server as DB backend. Now I'd like to use the libmysqld, so that I can have a an embedded server, still this same applicatio

load data infile skips records, corrected

I have to correct my previos mail: using load data infile, all rows are correctly loaded into the table. Yet, the control center displays a smaller number of total records than the true number, which is correctly displayed by count(*). What does the display in the control center mean? Wolfgang

mysql development tools

Hi, I'm just starting out with mysql and would like to know if there are any good database diagramming and development tools for mysql. Something that would allow me to create a db and all the relationships graphically and then have the sql code automatically produced. Ideally I'm looking for so

Re: load data infile skips records

Wolfgang - > I have a text file with 120'000 lines. When I do a > load data local infile > only 85'416 records are loaded. There is no message of the sort > Query OK, X rows affected > just the next prompt is displayed. > > I'll be glad for any hint what could cause this behavior.

Re: MySQL 4.1 replication relay log control

Victoria Reznichenko wrote: relay-log-purge is available from 4.1.1. Do you use 4.1.1 or 4.1.0? Is it in the manual because relay-log-purge is available in 4.0.x? AFAICT, 4.1.1 isn't available for download from the mysql.com site. 4.1.0-alpha is. How would one obtain 4.1.1? Would this work to m

load data infile skips records

Hi, I have a text file with 120'000 lines. When I do a load data local infile only 85'416 records are loaded. There is no message of the sort Query OK, X rows affected just the next prompt is displayed. I'll be glad for any hint what could cause this behavior. I'm using versi

RE: How to search by groups efficiently with MySql 4.0.15?

- Original Message - From: "Pakó Géza" <[EMAIL PROTECTED]> To: "Jouni Hartikainen" <[EMAIL PROTECTED]> Sent: Saturday, October 11, 2003 7:03 PM Subject: Re: How to search by groups efficiently with MySql 4.0.15? > how about: > > select record.* > from link > where group_id='x' > left joi

developing mysql client on XP with mingw

Hi all, I'd like to write a mysql client with mingw. It compiles without problems but if I try to run the app I get an error message which says somthing like (free translation from german): Entry point for [EMAIL PROTECTED] function not found in libmySQL.dll. What I've done so far: cd into the m

Testbeitrag

Hallo, dies ist nur ein Testbeitrag ob das Abonieren funktioniert hat ... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ANNOUNCING: Rekall V2.0.2 and V2.1.0 beta3 for Linux/UNIX, Windows, and the Sharpe family of Linux PDAs

Hi We are pleased to announce the 2.0.2 release of Rekall, a personal, programmable DBMS system for Linux and Windows. Rekall is the only viable alternative to MS Access for Linux. With Rekall you will be able to quickly and easily build database applications using Rekall forms and reports. A ful

Re: Views in MYSQL

"Timotius" <[EMAIL PROTECTED]> wrote: > > Pls help me, how to create views in mysql. > > there isn't menu for views in mysql such as SQL Server 2000 ? Views currently are not supported in MySQL: http://www.mysql.com/doc/en/ANSI_diff_Views.html -- For technical support contracts, goto

Re: Views in MYSQL

MySQL doesn't support views as of now. It's a feature MySQL is missing for long time. For more information have a look at http://www.mysql.com/doc/en/ANSI_diff_Views.html Nitin - Original Message - From: "Timotius" <[EMAIL PROTECTED]> To: "MYSQL" <[EMAIL PROTECTED]> Sent: Saturday, Octob

Re: Adding space to /var/lib/mysql

I read in the manual that SymLinks should be avoided when not really needed. I might be wrong! Thanks Emery - Original Message - From: "Dathan Vance Pattishall" <[EMAIL PROTECTED]> To: "'Randy Chrismon'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, October 10, 2003 23:01 S

Re: what's the database behind m$ access?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi! On Sat, 11 Oct 2003, Wang Feng wrote: > That works, Emery. Thanks a lot. > > > Dummy me, I was wrong. Seems that Access is just a tool rather than a > Database, then what's the database behind M$ Access? It's the Microsoft Jet engine - a small,

RE: Unusual Date Query

hay ross i had ot pick up data rows for the dates between from-date and to-date user selection u know i went about the problem with a loop . heres the code for($loop_mon=$frm_mon; $loop_mon<=$to_mon ; $loop_mon++){ $ftch_rprt_dta_qry = "select sum($rprt_col) from $rprt_tbl,

what's the database behind m$ access?

That works, Emery. Thanks a lot. Dummy me, I was wrong. Seems that Access is just a tool rather than a Database, then what's the database behind M$ Access? cheers, feng -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Views in MYSQL

Pls help me, how to create views in mysql. there isn't menu for views in mysql such as SQL Server 2000 ? thx Timotius, [EMAIL PROTECTED] +62-31-531-2358 ext. 205 -- MySQL General Mailing List For list

How to search by groups efficiently with MySql 4.0.15?

Hi all. I have this kind of problem setup: 1. I have a bunch of records and I need to store some record specific data about each of them (date, owner etc). 2. I have a list of categories (=groups) in which a record may belong to and I have to be able to store some group specific data (name, co