Re: 4.1.4-gamma cannot compile

2004-09-05 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Sat, 4 Sep 2004, Paul DuBois wrote: > > Yes, it works for me, but we shouldn't have to do that, right? > > Right. I'm trying to gather information about the problem so it can be > fixed. Sorry about that - I uploaded mysql-4.1.4a-gamma.tar.

Re: 1 database; 2 scripts; different results

2004-09-05 Thread Michael Stassen
Amer Neely wrote: Both scripts, which reside in the same directory on the server, are run through the web browser. And they do access the same database, and the same tables. So, same web server, same mysql server, same connection settings. Good. Does phpmyadmin connect to mysql as the same user

Migration to Mysql

2004-09-05 Thread vivek khurana
Hello all, I am going to migrate a MsAccess database to MySQL. I wanted to know if somebody ahs doen it and what problems you might face and workaround them if possible. Also, do let me know if my query is broad?? Reagrds VK ___

Full Text Stopwords

2004-09-05 Thread Ari Denison
Hello list - I'm trying to do a full text search for the the string "May" using the following query: SELECT * FROM students WHERE MATCH(first_name) AGAINST("May"); There are a number of students in that table wit the first_name of May. And, yes, I've removed may from the stopwords list and ha

FK reference PK in same table

2004-09-05 Thread julien-martin
Hello, I have two questions: 1. I have a table defined as follows * create table MATABLE ( ID INTEGER not null, FK INTEGERnot null, constraint PK_MATABLE prima

Re: Storing foreign characters in DB

2004-09-05 Thread valentin_nils
Hello Rhino, I am not sure how familiar you are with the character set settings. I am not using 3.xx versions anymore, but if I remember correctly they only allow a limited control for setting character sets. Your best guess might be the documentation that comes with your in

Selecting Data From two tables

2004-09-05 Thread John Nichel
Hi, I'm trying to select data from a couple of tables with the same query. Easy right? Well it's driving me crazy. I'm passing an integer via an html form, using php to grab it, and insert it into the query (albumSongs.albumID = 1), to where I want to grab all the data from the first table w

Re: strmov

2004-09-05 Thread Michael Bacarella
> What is the definition of strmov in C? It seems to be a > MYSQL library sprecific function in m_string.h and is used > in some of the documentations examples. In MySQL 3.23.x, it's defined in strings/strmov.c #if !defined(MC68000) && !defined(DS90) char *strmov(register char *dst, register c

strmov

2004-09-05 Thread Ruben Safir Secretary NYLXS
What is the definition of strmov in C? It seems to be a MYSQL library sprecific function in m_string.h and is used in some of the documentations examples. ruben -- __ Brooklyn Linux Solutions So many immigrant groups have swept through our town that Brooklyn, like Atl

Re: Remote Connecting

2004-09-05 Thread Wesley Furgiuele
It might just be that your connect line isn't working properly. Try this form instead: mysql -u root -h MyLinuxSystem -p You want to connect as user "root" to host "MyLinuxSystem" using a password for which you will be prompted. If that doesn't wok, you need to make sure that on your server, on y

Re: Help needed with MySQL C API-based client (segfault)

2004-09-05 Thread Aftab Jahan Subedar
have you tried ? http://www.geocities.com/jahan.geo/mysql_c_by_example.html Ruben Safir Secretary NYLXS wrote: On Fri, Sep 19, 2003 at 09:18:22AM +0500, Vikram Vaswani wrote: Hello, I need to write a simple C client for a project. I am using the MySQL C API. Attached is the code. It occassionally s

Re: Making database backup

2004-09-05 Thread Rhino
- Original Message - From: "Leandro Melo" <[EMAIL PROTECTED]> To: "lista mysql" <[EMAIL PROTECTED]> Sent: Sunday, September 05, 2004 12:44 PM Subject: Making database backup > Hi, > how can i make a back of the data in my database? > > I don't want the backup of the database itself, i o

Re: Query Question

2004-09-05 Thread Stuart Felenstein
Well I feel like maybe I wasted some bandwidth here. I think what I'm looking for is a square peg in a round hole. That won't work. More to the point :) , I do not having a problem with the AND / OR / IN / NOT / etc. What I think I was attempting was to come up with a SQL statement that will work

Re: Query Question

2004-09-05 Thread Michael Stassen
Stuart Felenstein wrote: I'm hoping I can present this correctly. I'm trying to determine how to set up my where condition as, 1 way has already failed me. While I continue to figure this out (i'm a noob), I hope asking for some advice here won't be too awful. There is one main table where data

db design - keyword fields

2004-09-05 Thread leegold
I'm sure this is a common and simple situation: say I have a title, url, description fields, assume they makeup a record in one table named book_info. Say for each of this table's records I also need a keywords field (of type text) and I'll use a fulltext index on this field. Great, now the user do

Re: Understanding Joins : Baffled

2004-09-05 Thread zzapper
On Fri, 3 Sep 2004 15:47:26 -0400, wrote: >A. Any record in tbl_development can be associated with up to 8 URLs that >represent virtual tours of the dwelling types in that particular >development. >B. tbl_urldetails is a table acting as a "master list" of the virtual >tours you have ready to

Re: MySQL 4.1.4 RPM Distribution startup problem

2004-09-05 Thread Igor Zinkovsky
- Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: "Igor Zinkovsky" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, September 03, 2004 10:50 PM Subject: Re: MySQL 4.1.4 RPM Distribution startup problem > Igor Zinkovsky wrote: > > > After upgrade from 4.1.2 to 4.

Re: Making database backup

2004-09-05 Thread Jeff Smelser
On Sunday 05 September 2004 11:44 am, Leandro Melo wrote: > Hi, > how can i make a back of the data in my database? check out mysqldump -- === Jabber: tradergt@(smelser.org|jabber.org) Quote: "Nothing fails like prayer." -- Ann

Remote Connecting

2004-09-05 Thread Danesh Daroui
Hi all, I have installed Mysql-4.1 successfully on a Fedora Core 2 Linux system. Now, I like to connect to my Linux system from my other system which as Windows XP and of course Mysql 4.1 installed too. In fact, I like to connect to my Linux system as root and do all console tasks just like I a

Making database backup

2004-09-05 Thread Leandro Melo
Hi, how can i make a back of the data in my database? I don't want the backup of the database itself, i only want a backup that will give a script to insert all the data i currenlty have (only the inserts). I'm also using mysqlcc, if there's any facility. Thanks, Leandro.

Re: Query Question

2004-09-05 Thread Stuart Felenstein
I think I'm on the right track but still in question After all the joins I added a "and LocationState = x". I'm not totally sure, because I want to search for records based on (for now)3 conditions (state, city, industry). Two things I should mention , the somewhat strange notation is becaue I'm

Query Question

2004-09-05 Thread Stuart Felenstein
I'm hoping I can present this correctly. I'm trying to determine how to set up my where condition as, 1 way has already failed me. While I continue to figure this out (i'm a noob), I hope asking for some advice here won't be too awful. There is one main table where data is inserted and that I'm

Re: Storing foreign characters in DB

2004-09-05 Thread Rhino
- Original Message - From: "MySQL" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Sunday, September 05, 2004 2:05 AM Subject: Storing foreign characters in DB I'm having a problem figuring out how to deal with foreign characters in text that was copied from an MS Word documen