Ancestry program

Hi all, I'm developing a web based ancestry program. The user wants it to be static, that means, it isn't for all to use, but his family. Better to say, it'll contain only his family tree. Now, I cant think of the proper db design, which will help any user to find his or her relationship with

repercussions of "reserved words"

Hi, I installed an app which used option as a field. It worked fine in version 3.23 on my play box. I then moved the app to another box (4.0.15) and when I tried to dump it in (mysql -u x -px database http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Hanging processes in MySQL 3.23.53

Haven't looked at InnoDB, but might have to take a look at it... Up until recently we haven't had any reason to doubt MyISAM, and it's served us well, in fact better than we need. As for syslog - our MySQL logs to a .err file (nothing in syslog), and there's nothing in that file at all. It does

Binary column index

Hi. all I got some problem with index (version 4.0.15) alway corrupt when I try to delete some row my table have 3 index one key make for varchar column the data of this column come from date+number like this 2003-10-28/1/4 2003-10-28/2/4 2003-10-28/3/4 2003-10-28/4/4 ... that mean in th

Re: why can't innodb_log_file_size change

You should be able to do this by: 1) Stopping the server cleanly 2) Removing the log files 3) Restarting the server with the new log file sizes set in your .cnf Chris Dathan Vance Pattishall wrote: Trying to increase my innodb_log_file_size I get this message 031027 16:01:02 InnoDB: Data file .

Re: Hanging processes in MySQL 3.23.53

Get it fixed??!?!? And surrender? No, you can't do that! :-) Out of curiosity, have you guys looked at InnoDB for this purpose, given it won't serialise writes? I take it you've seen MyISAM allowing readers to continue while writes happen as adequate for what you need though? Additionally, and

auto_increment with FOREIGN KEY UPDATE CASCADE courses Lost connection to MySQL server

Hello, I'm using ver 4.0.12, checked for bugs in ver 4.0.12(http://bugs.mysql.com/search.php) but couldn't find this one. CREATE TABLE software ( softwareID VARCHAR(20) NOT NULL, softwareName VARCHAR(100), softwareVers VARCHAR(20), installedDate DATE, s

Re: Limit Optimization??

good job!! it short my query time from 30 sec to 0.6 sec. IOW,now i can not use the 'where' & 'order by' clause in the SELECT . can i need more indexs ? thx Matt. ""Matt W"" <[EMAIL PROTECTED]> wrote [EMAIL PROTECTED] > Hi, > > Yes, MySQL stops searching for rows once the LIMIT is satisfied, as

Re: Hanging processes in MySQL 3.23.53

I just saw your mail address - you're one of the gurus who runs PlanetMirror, aren't you? All hail he who provides my Mandrake ISOs! Huzzah! :-) Hmmpersonally, I don't see how you can do "something wrong" during a DELETE. This is one of those non-descript problems that give me sleepless nig

Re: interpreting extended statistics

Hi Mark, I say PHP below because I'm just assuming that's what's connecting to MySQL. :-) - Original Message - From: "Mark Teehan" Sent: Monday, October 27, 2003 2:42 AM Subject: interpreting extended statistics > Hi > I am a new MySQL dba tuning a busy Apache/MySQL installation. I cou

No Suitable Driver

This is the SQLException that I get when I try to run my Java code. Since this is a program that has worked in the past, I think that problem is how I'm linked to MYSQL. Any ideas on what could be wrong? Candy _ Surf and talk on

Re: Partial replicate InnoDB -> MyISAM

see below... - Original Message - From: "Chris Nolan" <[EMAIL PROTECTED]> To: "Jon Hancock" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, October 28, 2003 10:49 AM Subject: Re: Partial replicate InnoDB -> MyISAM > Hmm > > How much lag time can you afford between the master

Re: Hanging processes in MySQL 3.23.53

Using Redhat linux 7.3 with an ext3 FS. Incidentally, I've just manually restarted mysql (which drops all in-progress processes), and it seems that the problem "takes a while to show" (i.e. there's a period after a restart that things seem to go along fine, then it all comes undone). I also should

Re: Hanging processes in MySQL 3.23.53

Which platform are you using? Which FS? Regards, Chris On Tue, 28 Oct 2003 01:14 pm, Dan Goodes wrote: > Hi folks, > > I have a bit of a problem. I'm running 3.23.53 which I've compiled up from > source (because the RPMs are not an option for me). > > I have a process that does a fairly large se

Re: Partial replicate InnoDB -> MyISAM

Hmm How much lag time can you afford between the master's contents being updated and the slave being updated? Taking advantage of MyISAM's compressed table features might help performance if that is an issue. Every independant test out there shows that in the cases where InnoDB is slower for

Partial replicate InnoDB -> MyISAM

This thread started as "Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1". I may want to have one MySQL server as the Read only "Search" server. If I did this and I have all InnoDB table on my Master, then could I replicate only certain columns into the MyISAM slave ? Any other efficien

Re: cause of table crash

Hi, What version of MySQL are you using? Maybe it's because of a corruption bug in versions 4.0.3 - 4.0.14. Try upgrading to the latest version. Hope that helps. Matt - Original Message - From: "Datatal AB - Gauffin, Jonas" Sent: Monday, October 27, 2003 6:40 AM Subject: cause of tab

Re: Limit Optimization??

Hi, Yes, MySQL stops searching for rows once the LIMIT is satisfied, as long as filesort isn't used for an ORDER BY. But your LIMIT 150, 20 will take much longer (assuming filesort isn't used) than, say, LIMIT 1000, 20. This is because it has to scan over 1.5M rows first. It's not really possi

Hanging processes in MySQL 3.23.53

Hi folks, I have a bit of a problem. I'm running 3.23.53 which I've compiled up from source (because the RPMs are not an option for me). I have a process that does a fairly large select statement every 10 minutes - up until a few days ago it was all find and dandy. A few days ago I did a massi

Re: CREATE FUNCTION problem

Hi George, I think the MySQL-Max RPM is dynamically linked (all -max binaries actually) if you want to give it a try. Hope that helps. Matt - Original Message - From: "George Chelidze" Sent: Monday, October 27, 2003 9:18 AM Subject: CREATE FUNCTION problem > Hello, I have created n

Re: Corruption and weird service terminations

Hi Mike, For the corruption, upgrade to 4.0.16, since it may be caused by a corruption bug in versions before 4.0.15. Matt - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 27, 2003 12:07 PM Subject: RE: Corruption and weird service terminatio

Limit Optimization??

Does mysql do any optimization for then one use `select ... limit x,y`? For example, I have table with 200 records and want to do page web interface to this table. When i use `select ... from table limit 150, 20 `, it will need more and more times (on my here is more than 60 sec). well,

Re: I can't figure out what I thought would be a simple query..

Hi guys, Have you seen the manual page for "The Rows Holding the Group-wise Maximum of a Certain Field": http://www.mysql.com/doc/en/example-Maximum-column-group-row.html I think that's what you want to do. You can either use another temporay table, the MAX-CONCAT trick, or the "LEFT JOIN ... IS

Re: Unusual date storage requirement

On Mon, 27 Oct 2003 19:11:53 -0600, Paul DuBois <[EMAIL PROTECTED]> wrote: For future reference, does this effect order by clauses in the way one would expect? (ie., 00 precedes 01). The docs make it seem as though use of invalid dates results in undefined behavior. Can you indicate which part of

Re: DB not restoring from dump file

Hi, Well, UNIQUE is a reserved word in all versions of MySQL... As to why mysqldump would "create a dump file with a syntax error in it," that's because *you* (or the application creator) used a reserved word for a column/index name (bad idea) and mysqldump, by default, does not put backticks aro

Re: Unusual date storage requirement

At 4:41 PM -0800 10/27/03, bluejack wrote: On Mon, 27 Oct 2003 18:34:34 -0600, Paul DuBois <[EMAIL PROTECTED]> wrote: At 5:32 PM -0500 10/27/03, sean peters wrote: Hi all, I have run into a date storage problem that i don't like. A am storing historic house sales, and some of the old data i have r

Re: Unusual date storage requirement

On Mon, 27 Oct 2003 18:34:34 -0600, Paul DuBois <[EMAIL PROTECTED]> wrote: At 5:32 PM -0500 10/27/03, sean peters wrote: Hi all, I have run into a date storage problem that i don't like. A am storing historic house sales, and some of the old data i have received only contains the month and year, b

Re: Unusual date storage requirement

At 5:32 PM -0500 10/27/03, sean peters wrote: Hi all, I have run into a date storage problem that i don't like. A am storing historic house sales, and some of the old data i have received only contains the month and year, but not the date of the sale. Of course we want to store this information, bu

why can't innodb_log_file_size change

Trying to increase my innodb_log_file_size I get this message 031027 16:01:02 InnoDB: Data file ./ibdata2 did not exist: new to be created 031027 16:01:02 InnoDB: Setting file ./ibdata2 size to 2000 MB InnoDB: Database physically writes the file full: wait... InnoDB: Progress in MB: 100 200 300

Re: Unusual date storage requirement

On Mon, 27 Oct 2003 17:58:38 -0500, sean peters <[EMAIL PROTECTED]> wrote: Well, thats actually what i am going to do. A date column won't take anything but a valid date (sort of - feb. 30 is "valid"). But i still need to know whether the day of month is meaningful or not, for various search / dis

Re: Unusual date storage requirement

On Mon, Oct 27, 2003 at 05:32:34PM -0500, sean peters wrote: > Hi all, > I have run into a date storage problem that i don't like. A am storing > historic house sales, and some of the old data i have received only contains > the month and year, but not the date of the sale. Of course we want to

Re: Unusual date storage requirement

Sorry, i wasn't completely clear. Well, thats actually what i am going to do. A date column won't take anything but a valid date (sort of - feb. 30 is "valid"). But i still need to know whether the day of month is meaningful or not, for various search / display purposes. My users will raise a m

RE: Unusual date storage requirement

what about forcing the date to the first of whatever month the sale was in? if it's got a valid date, put that, otherwise, put the first. -Original Message- From: sean peters [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 4:33 PM To: [EMAIL PROTECTED] Subject: Unusual date stor

Unusual date storage requirement

Hi all, I have run into a date storage problem that i don't like. A am storing historic house sales, and some of the old data i have received only contains the month and year, but not the date of the sale. Of course we want to store this information, but a DATE column won't quite do the job, be

RE: I can't figure out what I thought would be a simple query..

I'm interested to see what kind of solution is offered for this as I could use it myself. I'm having to do this programatically on an expternal script that selects distinct non_unique_id and the takes the result and loops through each one with sort by endtime desc limit 1 and then either do someth

RE: reproducible error 17

On Mon, 2003-10-27 at 22:01, Dathan Vance Pattishall wrote: > -->-Original Message- > -->From: Guilhem Bichot [mailto:[EMAIL PROTECTED] > -->Sent: Monday, October 27, 2003 10:55 AM > -->To: [EMAIL PROTECTED] > -->Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] > -->Subject: RE:

RE: DB not restoring from dump file

It dumps the contents of the db table in its original form. If you upgrade to a new version-mysql will respect the old table format even if some of the column / table / key names are reserved names in the new mysql version. BUT if you try to add back to the mysql server a dump table that has this r

RE: New Article on SSH Port Forwarding of MyODBC

That is a pretty fair take on network traffic. SSH has strong enough encryption to make the decryption effort not worth it to all but those with supercomputers. As for the internal mail, I think we can agree that some mail would be critical enough to warrant encryption even on an internal networ

RE: php temp table question

Thanks, I got the answer from a php developer. In case anyone is wondering, according to him the table is dropped at the end of the script execution regardless of whether you use persistent connections or not. -Original Message- From: Larry Brown [mailto:[EMAIL PROTECTED] Sent: Monday, Oc

Optimizing GROUP BY

Hi! I've found this in: http://www.mysql.com/information/presentations/presentation-oscon2000-2719/ "Instead of doing a lot of |GROUP BY|s on a big table, create summary tables of the big table and query this instead." Would you please tell me how to create "summary tables" that can help me

I can't figure out what I thought would be a simple query..

All; I am having tremendous trouble attempting to do the following query; and any help would be appreciated. I am using Mysql 4.0.15a; and I cannot upgrade. Given the following TEMPORARY table (it's a table I have created from a whole host of sources): table: endtime_table +

RE: DB not restoring from dump file

Dathan Vance Pattishall on Monday, October 27, 2003 11:28 AM said: > Try changing the keyname unique to email. > > UNIQUE KEY email (email) Thanks, this worked. I ended up having to change two more instances of the same error in different tables. Why would the m

DB2 express

I'm resending this, since I never saw it come through the first time around... Does anyone have much experience with this? How does it stack up to MySQL? I ask because I'm in the middle of preparing a presentation to get MySQL on the 'approved' software list at my workplace, and I will have t

php temp table question (for mysql)

Does anyone know whether the use of persistent connections with php will allow a temp table created by a script to linger around and cause a problem with the next execution of the script when it tries to create the temp table again? Also if it does present a problem with the next script execution

RE: New Article on SSH Port Forwarding of MyODBC

Think of your information like a letter in the mail. Well, for this example, think of it even more as a post-card. Your message is written on the outside where the anyone that touches it can read it. This post-card is going through the post office. It is going through mail centers, hubs, etc. Wha

php temp table question

Does anyone know whether the use of persistent connections with php will allow a temp table created by a script to linger around and cause a problem with the next execution of the script when it tries to create the temp table again? Also if it does present a problem with the next script execution

RE: reproducible error 17

-->-Original Message- -->From: Guilhem Bichot [mailto:[EMAIL PROTECTED] -->Sent: Monday, October 27, 2003 10:55 AM -->To: [EMAIL PROTECTED] -->Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] -->Subject: RE: reproducible error 17 --> -->Hi, --> -->Are the master and slave located

Re: updating records without changing timestamp fields

On 27-Oct-2003 Henning Heil wrote: > hi there, > > the subject tells almost everything, I try to update records in a table > and everytime I do this, the timestamp field ist set to now(). > > how can I keep the previously stored value for this field (there are > values created before)? > UPD

Re: My Company DB Wars

> Hi, > > You could bring the attention to www.mysql.com - probably German > software company SAP would not integrate with MySQL, if there were any > kind of problems. > Sorry a bit off topic, speaking of the germans, it seems that PHP and MYsql is prolific in germany, as a widely used choice. I

RE: updating records without changing timestamp fields

Add Two Time stamps. Only one will get update. Mat -Original Message- From: Keith C. Ivey [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 1:31 PM To: MySQL List Cc: Henning Heil Subject: Re: updating records without changing timestamp fields On 27 Oct 2003 at 21:21, Henning He

Re: Auto increment sequence

On Mon, 27 Oct 2003 15:24:37 -0500, Priyanka Gupta <[EMAIL PROTECTED]> wrote: Is there a way in mYSQL to just define an auto increment sequence rather than defining a field inside a table which is an auto increment. Bsically I need some functionality similarto that in ORACLE where CREATE SEQUENC

Re: updating records without changing timestamp fields

[EMAIL PROTECTED] wrote on 27.10.2003 21:31 use timestamp_col = timestamp_col in your query, to override the NOW() affect. I just passed by this comment this morning http://www.mysql.com/doc/en/DATETIME.html -- user comments at bottom of page hth Jeff all, thanks for your help!

Re: InnoDB on Raw partitions in OSX (was Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1)

Gabriel, - Original Message - From: "Gabriel Ricard" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, October 27, 2003 6:46 PM Subject: InnoDB on Raw partitions in OSX (was Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1) > On Monday, October 27, 2003, at 0

Re: updating records without changing timestamp fields

* Henning Heil > the subject tells almost everything, I try to update records in a table > and everytime I do this, the timestamp field ist set to now(). > > how can I keep the previously stored value for this field (there are > values created before)? You can assign the current value to it:

Re: updating records without changing timestamp fields

use timestamp_col = timestamp_col in your query, to override the NOW() affect. I just passed by this comment this morning http://www.mysql.com/doc/en/DATETIME.html -- user comments at bottom of page hth Jeff

Re: updating records without changing timestamp fields

On 27 Oct 2003 at 21:21, Henning Heil wrote: > how can I keep the previously stored value for this field (there are > values created before)? Explicitly SET timestamp_column = timestamp_column. See here: http://www.mysql.com/doc/en/DATETIME.html But if you never want the TIMESTAMP column t

Re: updating records without changing timestamp fields

That is the purpose of timestamp. Henning Heil wrote: hi there, the subject tells almost everything, I try to update records in a table and everytime I do this, the timestamp field ist set to now(). how can I keep the previously stored value for this field (there are values created before)?

Re: My Company DB Wars

Hi, You could bring the attention to www.mysql.com - probably German software company SAP would not integrate with MySQL, if there were any kind of problems. Further You could look at the success stories ( http://www.mysql.com/press/user_stories/index.html ), and You will find NASA, Yahoo! Finan

Auto increment sequence

Is there a way in mYSQL to just define an auto increment sequence rather than defining a field inside a table which is an auto increment. Bsically I need some functionality similarto that in ORACLE where CREATE SEQUENCE seq INCREMENT BY 1 START WITH 1 MINVALUE 1; basically creates a seq that inc

RE: New Article on SSH Port Forwarding of MyODBC

Hi Mike I have to ask this without wanting a howto explanation but at least a basic understanding What this means is that if an unscrupulous individual gets between your client and the server, they can have full access to all information transmitted. how can someone do this? without it being kn

updating records without changing timestamp fields

hi there, the subject tells almost everything, I try to update records in a table and everytime I do this, the timestamp field ist set to now(). how can I keep the previously stored value for this field (there are values created before)? thanks for your help, henning -- MySQL General Mailing

RE: My Company DB Wars

It's because you forgot to put the new cover sheet on your TPS (transaction per second, in this case) report Did you get the memo? Similar thing happened to my college... they doubled their tuition over 5 years because as the president of the univeristy put it, 'good colleges are expensive

RE: My Company DB Wars

Tell them Yahoo, Google and others use mysql in the order of power > 50 servers. 50-1000 servers actually. So, with all the great talent @ Yahoo / Google as well as these 2 companies being profitable maybe some things in life are really 2 good to be true. Usually no brain-er debates are the best

Re: My Company DB Wars

> > My old Micro-Economics professor must be chortling in his grave... > > The bosses told me a few minutes ago to quit pusing MySQL for an > internal project and to move my proof-of-concept tables from MySQL > running on a Linux desktop with 512mb of ram and the bloody DB on an > external USB to a

RE: bind params and default values

- Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message- -->From: sean peters [mailto:[EMAIL PROTECTED] -->Sent: Monday, October 27, 2003 11:54 AM -->To: Dathan Vance Pattishall -->Subject: Re: bind para

My Company DB Wars

My old Micro-Economics professor must be chortling in his grave... The bosses told me a few minutes ago to quit pusing MySQL for an internal project and to move my proof-of-concept tables from MySQL running on a Linux desktop with 512mb of ram and the bloody DB on an external USB to a DB2 databas

RE: illusive query

-->-Original Message- -->From: Larry Brown [mailto:[EMAIL PROTECTED] -->Sent: Monday, October 27, 2003 11:32 AM -->To: MySQL List -->Subject: illusive query --> -->Earlier I was given help understanding the need for using a left join. -->This -->was a precursory query to arrive at my final

illusive query

Earlier I was given help understanding the need for using a left join. This was a precursory query to arrive at my final solution which I had not touched on since I believed that by getting the join correct I could get the result. It seems to be evading me though. Still using the following examp

RE: DB not restoring from dump file

Try changing the keyname unique to email. SO: UNIQUE KEY email (email) -->-Original Message- -->From: Chris W. Parker [mailto:[EMAIL PROTECTED] -->Sent: Monday, October 27, 2003 11:04 AM -->To: [EMAIL PROTECTED] -->Cc: [EMAIL PROTECTED] -->Subject: RE: DB not restoring from dump file -

RE: DB not restoring from dump file

[EMAIL PROTECTED] on Monday, October 27, 2003 10:52 AM said: > can you send the contents of your dumpfile up to this point. > assuming its line 118 of hte dumpfile and 21 of this build table query Line 118 is the beginning of the 'customers' table definition and l

RE: Conversion

-->-Original Message- -->From: Charles Cary [mailto:[EMAIL PROTECTED] -->Sent: Monday, October 27, 2003 10:10 AM -->To: [EMAIL PROTECTED] -->Subject: Conversion --> -->My commercial online web application currently handles 1 users with -->peak -->loadings of 100-500 concurrent hits.

RE: DB not restoring from dump file

-->-Original Message- -->From: Chris W. Parker [mailto:[EMAIL PROTECTED] -->Sent: Monday, October 27, 2003 10:46 AM -->To: [EMAIL PROTECTED] -->Subject: DB not restoring from dump file --> -->Hey everyone, --> -->First post to the MySQL list so please be gentle. --> --> -->I recently emp

Re: DB not restoring from dump file

can you send the contents of your dumpfile up to this point. assuming its line 118 of hte dumpfile and 21 of this build table query Jeff

RE: bind params and default values

-->-Original Message- -->From: sean peters [mailto:[EMAIL PROTECTED] -->Sent: Monday, October 27, 2003 10:17 AM -->To: [EMAIL PROTECTED] -->Subject: bind params and default values --> -->Hi all, i've been having an issue with binding params. If i have created -->an -->INSERT query with a

Re: Really slow query (compared with Visual FoxPro)

Mojtaba Faridzad wrote: BUT my experience: try to change the logic of your report not to retrieve large number of records. user LIMIT to create the reports page by page. this is the best and even better for the user. Ok thanks, but how exactly do I change-the-logic of this query: mysql> select te

DB not restoring from dump file

Hey everyone, First post to the MySQL list so please be gentle. I recently emptied some tables I shouldn't have in a db of mine and I want to restore the data from a dump file made a few days ago. MySQL version is 3.23. This is the command I used to create the dump: mysqldump --opt -u root --

DB2 express

Does anyone have much experience with this? How does it stack up to MySQL? I ask because I'm in the middle of preparing a presentation to get MySQL on the 'approved' software list at my workplace, and I will have to address MySQL versus this product (as well as Oracle Express, though it seems

RE: reproducible error 17

Hi, > *** 1. row *** > Master_Host: 10.2.12.224 > Master_User: rep > Master_Port: 3306 > Connect_retry: 60 > Master_Log_File: ef224-bin.020 > Read_Master_Log_Pos: 409223612 >Relay_Log_File: ef242-

bind params and default values

Hi all, i've been having an issue with binding params. If i have created an INSERT query with a param binding to a particular column, call it column "A", is there any way that i can use that (prepared) query to get the db defined default value into column A? Im at a loss! thanks much, sean pe

Conversion

My commercial online web application currently handles 1 users with peak loadings of 100-500 concurrent hits. Windows 2000 Server, IIS 5.0, JRun 4.0 and Enterprise Database Engine. There is a considerable amount of write activity to 10 of the 60 tables. The total size of the data is 5-10GB

Question about compability of clients and the deamon

Hi all, I am investigating upgrading from our current release of MySql. (We use Red-Hat 7.2 and it ships with 3.23.41). Anyway, I am interested in upgrading to either the latest 3.23 release or the latest stable 4.0 release. My concerns are which is an easier and/or less risky upgrade? We h

InnoDB on Raw partitions in OSX (was Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1)

On Monday, October 27, 2003, at 07:45 AM, Chris Nolan wrote: 2. I personally use ReiserFS for all of my stuff, most of which is based upon InnoDB. One thing you have to remember is that InnoDB treats the space inside the tablespace as a Berkeley Fast Filesystem-style space, using the underlayin

RE: unexpected results from query between tables

Thank you all. The world makes sense again. :) Larry S. Brown Dimension Networks, Inc. (727) 723-8388 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 10:54 AM To: [EMAIL PROTECTED] Cc: MySQL List Subject: Re: unexpected results from que

Re: Really slow query (compared with Visual FoxPro)

Chris wrote: Hmm It's just occured to me that you're basically copying and entire table from one place to another. If I recall correctly, FoxPro cheats somewhat in this situation - it just copies the concerned files! Which table type are you using (something I should have asked in the begi

Re: unexpected results from query between tables

You are using the wrong syntax, try SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id WHERE table2.id IS NULL; The query, you are using produces cross join while you need to implement left join for your problem. Enjoy Nitin - Original Message - From: "Larry Brown" <[E

Re: unexpected results from query between tables

The simple JOIN (which is what you have requested with the A, B syntax) builds a conceptual table in which every row in A is paired with every row in B, then passes the result on to the WHERE filter. Of course, it doesn't actually do that, because it would take an enormous time, but it mimics that

Re: unexpected results from query between tables

You need a LEFT JOIN "select f.controlnum,f.referencenum,f.fname,f.lname from first f, left join second s on f.controlnum = s.controlnum where s.controlnum IS NULL and f.inputtime > '07:00:00'" Larry Brown wrote: ok, now I want to run a query that results in all of the controlnum's in table on

Ann: New Article on SSH Port Forwarding of MyODBC

Hi Everyone; I have published a new article covering SSH port forwarding of MySQL sessions, which can be viewed at http://www.vbmysql.com/articles/sshtunnel.html The article covers connecting a Windows client to a *NIX based server. Anyone with previous experience will probably find the article

RE: Changing rpm installation to binary version

I have successfully done this when both versions have been rpm files but how do I upgrade from an rpm to a binary. I have unpacked the binary file & installed it but the previous version keeps being started. And when I try to erase the previous version it says it is not installed! -Origi

RE: Insert ... Select question

Nikos, Yes. Use the following syntax: INSERT INTO db_name.tbl_name (col, col, col) SELECT col, col, col FROM db_name.tbl_name; Regards, Adam -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 9:58 AM To: [EMAIL PROTECTED] Subject: Insert

unexpected results from query between tables

I apparently am misunderstanding how the select works by referencing data in two different tables. I have used a similar statement to the one that follows with success, but there must be something different here that reveals a lack of fundamental understanding as to how it works. If someone could

Re: Changing table properties

u mean, in MySQLFront or other program - Original Message - From: "Krystan Daxner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 27, 2003 8:46 PM Subject: Changing table properties > I have a program running with MySQL as the database. I have MySQLFront > running as

CREATE FUNCTION problem

Hello, I have created new udf function which converts time from NTP format to timestamp. I compile it with the following command: gcc -Wall -shared -o ntp2timestamp.so ntp2timestamp.cc with no errors. Then I copy this file to /usr/local/mysql (libmysql* files are located here and /etc/ld.so.co

Changing table properties

I have a program running with MySQL as the database. I have MySQLFront running as my viewer and I want to change something in the database that will allow me to view more items in a drop down table within my program. Not having created this program but being a user on this system, I am not sur

Re: Insert ... Select question

of course, the syntax is: insert into db3.table2 (column list) select from db1.table1 for more information have a look at http://www.mysql.com/doc/en/INSERT_SELECT.html Enjoy Nitin - Original Message - From: "ΝΙΚΟΣ ΓΑΤΣΗΣ" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, Octo

Re: Changing rpm installation to binary version

you can either erase the previous installation and then install the newer one or simply upgrade the previous one. - Original Message - From: "Manjit Patel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 27, 2003 8:02 PM Subject: Changing rpm installation to binary versi

Insert ... Select question

Hello list I want to insert ... select data from table1 of db1 to table2 of db3. Is that possible? Thank in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: C API first row not being returned from a query

* Santino ([EMAIL PROTECTED]) wrote: > I use : > >numRows = mysql_num_rows( Result); > numFields = mysql_num_fields( Result); > >for( j=0; j < numRows; j++) { > mysql_data_seek( Result, j); > CurrentRow = mysql_fetch_row( Result); >

Re: User and permissions/grants - HELP!

i dont think there's any privilege called "ALL PRIVILEGES". You need to say just "ALL", like: GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY '12345678' WITH GRANT OPTION; GRANT ALL ON *.* TO newuser@"%" IDENTIFIED BY '12345678' WITH GRANT OPTION; Enjoy Nitin - Original Message - Fr

Changing rpm installation to binary version

Hello, I have been testing with an RPM distribution of MySQL version 4.0.15. Now that I have bought a licenced version how do I change over to use the binary (version 4.0.16) instead of the previously installed rpm version? Operating system: Linux Red Hat 7.3 Thanks Manjit This message is co

  1   2   >