Re: Many to Many: Does this make sense ?

As for the RAD tool I'm open to suggestions, but I think I've read about them all. PHP - MySQL platform. Does it have to be PHP? If a java RAD is ok I would suggest http://jdbforms.sourceforge.net/ It does not allow multiple inserts from one page, BUT you can: 1) tack in some html (text area o

bug report!!

server not starting beginnig two-three days ago. All went well until then, when i had some large queries on server, and i think that was the moment when it crashed. I tried increasing the amount of innodb_buffer_pool_size from 8 to 16M , it started now, but the same list of errors appears in the

Re: c api and creating looped queries

On Sat, 2004-08-28 at 00:48, I wrote: > I know this is more along the lines of a c question; however, I am > trying to write a loop to iterate insertions into a mysql database and > was hoping someone would have a quick fix for this. > > I am used to using php with the luxury of the following synt

c api and creating looped queries

I know this is more along the lines of a c question; however, I am trying to write a loop to iterate insertions into a mysql database and was hoping someone would have a quick fix for this. I am used to using php with the luxury of the following syntax < some loop giving values $column1 and $colu

Prepared statements C API 4.1.3

Is anyone using the new prepared statements C API in MySQL 4.1.3 with success? I see a number of people having issues - I'd like to hear about someone (anyone) actually using them successfully (platforms, compilers, issues, un-documented/mis-documented usage, etc.). I haven't been able to get it

Re: Problems Upgrading from 3.23 to 4.0

At 17:06 -0700 8/27/04, Keith Brownmiller wrote: Greetings, I have a couple of questions that were not covered in the upgrade documentation. 1) The documentation discusses creating the new mysql database with the new privledges incorporated. Not a problem with that concept. You don't need to c

Problems Upgrading from 3.23 to 4.0

Greetings, I have a couple of questions that were not covered in the upgrade documentation. 1) The documentation discusses creating the new mysql database with the new privledges incorporated. Not a problem with that concept. 2) I can move my other database directories to the new data directo

Re: Many to Many: Does this make sense ?

I guess I'll have to wait until you've had a chance to mull the whole note over ;-) I really don't know what you're saying. I can't think of anything I said that would have discouraged you from creating the association table. Certainly the number of columns in the table shouldn't discourage you si

Database connectivity

Hi, I wanted to copy setup some procedure which pickup data from mysql and load into oracle database.How to do this? I would also like to know how to establish a connection between mysql and oracle database? thanks - Do you Yahoo!? Win 1 of 4,00

Connectivity

Hi, I have one mysql database and one oracle database.I want to fetch data from mysql db to oracle db in realtime.How to do this? I also wanted to tarnsfer 14 tables from one mysql database to Oracle how to do this? thanks - Do you Yahoo!? New and

RE: PowerPoint and mysql

One way to get started on this is to record a macro in PowerPoint where you are adding a textbox with some text in it to a slide I tried this and this was the code (VBA) ActiveWindow.Selection.SlideRange.Shapes.AddTextbox(msoTextOrientationHorizo ntal, 72#, 120#, 540#, 36#).Select ActiveWi

Re: 1 day 28 min insert

> If that were a valid SQL statement, I would agree with you. What you wrote **only** functions through > a MySQL-specific SQL extension that permits non-aggregated, non-grouped columns to exist in the SELECT clause. He is working with MySQL and that query is working in MySQL. So everything should

RE: PowerPoint and mysql

I didn't look on the net, I used PowerPoint, to come to this conclusion: Now, I'm not sure of your office install, so let me summarize what I have installed: Office XP fully patched, when I installed it, I installed everything except ms office toolbar and the stupid paperclip ;^D Ok, inside PowerPo

Re: Many to Many: Does this make sense ?

Let me answer the first part now and then continue reading. You absolutely gave me some great ideas / examples. I understand it very well now. I'm abandoning it solely because creating that association list -1) may take forever and still come up way short 2)I see how others have implemented t

Re: 1 day 28 min insert

If that were a valid SQL statement, I would agree with you. What you wrote **only** functions through a MySQL-specific SQL extension that permits non-aggregated, non-grouped columns to exist in the SELECT clause. I do not understand why you believe that a GROUP BY test will prove any sort of p

Re: 1 day 28 min insert

> You _could_ try adding an identical primary key to the stat_in table as > you have on the 321st_stat table. However, since we need all of the rows > from stat_in in the results, I am not sure that it will help speed up the > join (because it's a left join). Even though I think the index would be

RE: PowerPoint and mysql

On Fri, 2004-08-27 at 15:06, James wrote: > Looking quickly at PowerPoint, you *can* do what you want to do, > however, here's the catch, there is no quick way to pull from a file or > data source and have it write to the field in pp. You can do some VB > trickery with the built in VBA in it, where

Re: Many to Many: Does this make sense ?

My replies are interspersed below. Rhino - Original Message - From: "Stuart Felenstein" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; "Stuart Felenstein" <[EMAIL PROTECTED]> Sent: Friday, August 27, 2004 3:05 PM Subject: Re: Many to Man

Re: 1 day 28 min insert

First of all, IMHO index 321st_stat.dic is useless since you have dic as the first field in 321st_stat.PRIMARY KEY. Second, I would recommend add KEY (`dic`,`niin`,`fr_ric`,`don`,`suf`,`dte_txn`,`sta`) on stat_in table and set PACK_KEYS=0 for stat_in table. Then measure execution time of select

mysql c-api 1064 mysql_real_query: issue with upgrade to 4.1.3

Hi, For some reason, all my sql queries fail with a 1064; These were all working under mysql-4.0 but had to upgrade to 4.1 so i could use nested subqueries i have attached a simple 10 line c-code as proof of concept. Obviously there is nothing wrong with the query... #include #include #

RE: PowerPoint and mysql

Looking quickly at PowerPoint, you *can* do what you want to do, however, here's the catch, there is no quick way to pull from a file or data source and have it write to the field in pp. You can do some VB trickery with the built in VBA in it, where you can use the MySQL ODBC driver and could read

Re: 1 day 28 min insert

I see two things I would change: First, the column 321st_stat.dic is the first column of your primary key and has a second index on just it. That second index is redundant and could be deleted. Second, in your WHERE clause you say : WHERE isnull(b.don) . That forces the engine to run a functi

RE: powerpoint and mysql

On Fri, 2004-08-27 at 14:30, Victor Pendleton wrote: > How did you plan on using the information pulled from the database? If you > are currently using MS Query or a DSN you can modify the current connection > information to point to your MySQL database. > > -Original Message- > From: redh

mysqlimport - HP-UX 11.11 bus error (coredump)

Subject: HP-UX 11.11/4.0.20 mysqlimport BUS ERROR >Description: Installed mysql from the binary download on mysql.com according to the INSTALL-BINARY instructions. Attempted to use mysqlimport as described in the online documentation (http://dev.mysql.com/doc/m

RE: powerpoint and mysql

How did you plan on using the information pulled from the database? If you are currently using MS Query or a DSN you can modify the current connection information to point to your MySQL database. -Original Message- From: redhat To: mysql Sent: 8/27/04 2:21 PM Subject: powerpoint and mysql

Re: 1 day 28 min insert

Mikhail Entaltsev wrote: Could you execute "show create table 321st_stat" and "show create table stat_in" and send results back? I have no key's on the temp table, stat_in, do you think adding keys on the whole primary key would be faster? I wasnt sure if you could join mysql keys, the key is

powerpoint and mysql

Greetings, I'm new to the list. I was wondering if it is possible to user mysql and powerpoint? I have a small database of simple text entries that I want to create whereby I can pull a title up and have the rest of the slide dynamically generated. The reason for this is that the presentation da

Re: Many to Many: Does this make sense ?

Now I am totally clear on it! Took a few reiterations but I'm there. Even more I'm going to abandon the idea of titles. To implement it correctly, per the examples, you provided is an impossibility. At least something when weighed out doesn't mean enough to the effort it would take. Plus the la

Re: huge innodb data files

We had a similar problem (though not quite as bad). I re-organized the datafiles (and fixed some indexes, etc) and we got a vast speed improvement. I'd suggest you shutdown the database, use mysqldump to take a dump of the database, move the old datafiles out of the way, fix your my.cnf to crea

Clarifying the MySQL Licensing Policy Documents Pt. II

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Greetings All, Sorry for the long delay in following up! First, I have resigned from my position as MySQL AB Community Advocate for personal reasons. If you have concerns regarding licensing and community issues that you wish to directly engage MySQL

Re: Many to Many: Does this make sense ?

Shawn, Yes, we *are* on the same page, now that I understand that you didn't mean to implement the many-to-many relationship in a single table. Stuart, Read what Stuart has described in this note. The association table is the one he calls TItle_Member. This table is *crucial* to the design, n

Re: Many to Many: Does this make sense ?

Rhino, You and I are on the same page. I also never seen a "true many-to-many" relationship in database design. The closest approximation I have seen is the 3 table design like you and I have both proposed. It's the only way I have ever seen to model a many-to-many design, that's why I called

RE: Good book

I suggest: For PHP and MySQL: PHP and MySQL Web Development (Sams Publishing) by Luke Welling and Laura Thomson For MySQL: MySQL (second edition) by Paul Dubois -Mensaje original- De: Scott Hamm [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 27 de Agosto de 2004 11:16 a.m. Para: 'My

Re: AVG Function

Craig Hoffman wrote: Mark, Yes its close and thank you. The problem I am having is I am able to generate the correct ranking.id for that particular user but I can't seem to make it equal the ranking.rating. ID ranking.rating 9 = 5.6 (example) Here's my query: SELECT routes.user_id, ran

RE: Moving MySQL data from Windows 4.0.12 to Linux 4.0.18

I had a situation you are seeing, what I ended up doing was create the db's in the new mysql server, setup replication, do LOAD DATA FROM MASTER let that run for a bit (while the first server is not in production of course) then after it synched up, shut down them both, removed the replication info

Good book

Since I'm new with MySQL, I want to apologize for asking questions that should've been answered by googling, RTFM and such. However, I'm looking for a good book that deals with MySQL and PHP whether it be single book (combined with PHP and MySQL) or separate books for each. I am intensive in Linux

Re: Many to Many: Does this make sense ?

I don't see the bigger picture yet. I'm 3 weeks in database design :). What I understand and perceive to be of value in this design is the reinforcement of the foreign keys. Related to that, the control over record deletion, cascading, etc. I mentioned earlier that the "interim" table that must

Re: Many to Many: Does this make sense ?

My remarks are interspersed below for reasons which will probably be obvious. Rhino - Original Message - From: [EMAIL PROTECTED] To: Stuart Felenstein Cc: [EMAIL PROTECTED] ; Peter Brawley ; Rhino Sent: Friday, August 27, 2004 12:33 PM Subject: Re: Many to Many: Does this m

Re: huge innodb data files

Hmm, well... It really shouldn't take 2 min to select from an empty table, no matter what you have in my.cnf. So, something else is happening. One way that InnoDB can take forever to read from an empty table is if there's a transaction still in progress that was started some time ago. Perhaps th

Re: Many to Many: Does this make sense ?

As I said in my reply, if you go with the association table design, you will likely write your code so that the movie information will be prompted 5 times if the member chooses 5 movies (or 3 times if they choose 3 movies, etc.). However, you don't HAVE to do it that way. You could always create a

Re: Many to Many: Does this make sense ?

Stuart, Both Rhino and I have suggested the same basic data storage structure to you. What you need to understand is that your RAD tool is not supporting your application design. You can use a form with 5 or 10 blanks on it where the user can list all of their choices. Then when the user submit

RE: Moving MySQL data from Windows 4.0.12 to Linux 4.0.18

I should have added what I was using to do the transfer. I am using phpmyadmin to do a dump to a gzipped file and then I am importing. Thanks for the info. -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED] Sent: Friday, August 27, 2004 12:29 PM To: Lehman, Jason (Registrar's

Re: Moving MySQL data from Windows 4.0.12 to Linux 4.0.18

On Fri, 27 Aug 2004, Lehman, Jason (Registrar's Office) wrote: > I am switching from a Windows computer to a Linux computer and when I > dump the data from Windows to Linux I have no problem except for the > fact that some of my characters have been converted to strange > characters and when the d

Re: Add new database into existing MYSQL database

I could write the statement for you if you could answer these three things: 1) which user account would you like to modify the permissions of. 2) which database are you granting access to 3) what permissions do you want the user account of 1) to have on the database of 2) Respectfully, Shawn Gr

Moving MySQL data from Windows 4.0.12 to Linux 4.0.18

I am switching from a Windows computer to a Linux computer and when I dump the data from Windows to Linux I have no problem except for the fact that some of my characters have been converted to strange characters and when the data is displayed on a web page they show up as ?. I am sure that it has

Re: Many to Many: Does this make sense ?

I think this design is a better approach but only if it's based on human tendencies (aka max 2 movies at a clip) Othewise (and if I'm missing something tell me please) if they should decide to enter 5 or 10 then the form comes at them 5 or 10 times. Your right though my RAD will allow it. Right n

Re: Many to Many: Does this make sense ?

- Original Message - From: "Stuart Felenstein" <[EMAIL PROTECTED]> To: "Peter Brawley" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, August 27, 2004 10:06 AM Subject: Re: Many to Many: Does this make sense ? > Thank you for the "stop" sign. > As for the RAD tool I'm open to sug

Re: 1 day 28 min insert

Could you execute "show create table 321st_stat" and "show create table stat_in" and send results back? Best regards, Mikhail. - Original Message - From: "matt ryan" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, August 27, 2004 4:45 PM Subject: Re: 1 day 28 min insert > Mi

Re: 1 day 28 min insert

Mikhail Entaltsev wrote: Hi, insert into 321st_stat select * from stat_in group by ; did you try to use this query? Best regards, Mikhail. Ran it, it took at least 24 hours, it finished but never gave me the total time, when I checked the server mysql dropped me back to the command prompt, wit

Re: Many to Many: Does this make sense ?

Thank you for the "stop" sign. As for the RAD tool I'm open to suggestions, but I think I've read about them all. PHP - MySQL platform. Stuart --- Peter Brawley <[EMAIL PROTECTED]> wrote: > Stuart, > > >I'm using a RAD > >tool. Meaning it's point and click on fields and > >tables and the c

Re: Slow Queries on Fast Server?

If you are sorting the result, setting a limit only speeds things up for data transfer of the result set since MySQL still has to find all the records, sort them, then deliver only the first X records. You can usually tell how much time is spent on the transfer of the result set vs. finding the

Re: Many to Many: Does this make sense ?

Stuart, >I'm using a RAD >tool. Meaning it's point and click on fields and >tables and the code is generated automagically. The >one problem I've run into is the RAD tool doesn't have >the auto capabilities to allow multiple insert >transactions into the same table on one "page". To >allow 5 tit

Re: One form multiple inserts

I did that as a convenience. Basically it provided me two ways of uniquely identifying any row in a table(an auto_inc integer, and some unique text column). The autoincremented values should never repeat. HOWEVER because I did not put a UNIQUE constraint on them, it is possible for someone to c

RE: Sort by COUNT(field_name) ?

Try: SELECT string, COUNT(string) AS length FROM searchstat GROUP BY string ORDER BY length You can DESC at the end if you want the longest string first. Cheers, Paul [EMAIL PROTECTED] tel: 020 7446 7536 fax: 0207 833 4289 - The UK's ultimate DVD library :-Orig

Re: Sort by COUNT(field_name) ?

You can use a query like this one SELECT string, COUNT(string) as co FROM searchstat GROUP BY string order by co DESC; HTH -- Dobromir Velev [EMAIL PROTECTED] http://www.websitepulse.com/ On Friday 27 August 2004 16:03, Dialogcentret wrote: > Example: I have a search box on my webpage and al

Many to Many: Does this make sense ?

I've hit on this subject before but I want to redefine and get some feedback. Right now I have a table called "Member_Titles" Members having multiple titles can put them in the datbases. I allow up to 5 to be held by the user and have a count() by ID to test before allowing insertion. Here's my

Re: AVG Function

Hi Craig, Sorry this is such a slow response but I have been swamped and I didn't see where anyone else has responded yet. First, we need to calculate the average ID per user but round the average to the nearest whole number. CREATE TEMPORARY TABLE tmpResults SELECT cast((AVG(id)+ .5) as inte

Re: Slow Queries on Fast Server?

Thanks Brent and Donny, hopefully this info will help get to the root of the problem with the fulltext search. The table structure is very, very simple: mysql> describe product_fulltext; +-++--+-+-+---+ | Field | Type | Null | Key | Default | Extra

Sort by COUNT(field_name) ?

Example: I have a search box on my webpage and all searchstring are saved in a database. $foresp = mysql_query("SELECT string, COUNT(string) FROM searchstat GROUP BY string ",$db); while ($data = mysql_fetch_array($foresp)) { echo "($data[1]) " . str_replace('<', '<', $data[string]) . " "; }

Re: huge innodb data files

Mayuran, Well, I´m not a MySQL expert, but I think that a good configuration in the my.cf file can make it better. Ronan - Original Message - From: "Mayuran Yogarajah" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 26, 2004 5:37 PM Subject: huge innodb data files Ou

Trouble with prepared select statements with parameters in where clause

Hi, I'm having serious trouble getting prepared statements with bound parameters in the where clause to work over the C API with MySQL 4.1.3. The Bugtracker on mysql.com has similar bugs for 4.1.2, which are marked as closed and fixed in 4.1.3 so I wanted to make sure that I'm doing things correctl

Need help for error 123

`table` is HEAP type table Sometimes,I do a query of select in `table`,I got the error, mysql error: Record has changed since last read in table 'table' I check the mysql log file, 040827 8:28:06 Got error 123 when reading table './db/table' I need help for this -- MySQL General Mailing List

Re: replication config without stopping master server

The replication slave server has the Physical memory 3.6 GB and the my.cnf file is as below : [client] port= 3306 socket = /var/lib/mysql/mysql.sock [mysqld] datadir = /data1/mysql basedir = / port= 3306 socket = /var/lib/mysql/mysql.sock s

Re: DBI and Mysql error 2006

Le ven 27/08/2004 à 00:37, Yannick Warnier a écrit : > Hi there, > > I'm having a problem with MySQL within a Perl::DBI usage. I've turned it > upside-down and cannot find what it's related to. > > My Perl script creates multiple databases and populates them with > tables. The problem appears whe

Getting rid of duplicates

I read CSV files into a table using mysqlimport --fields-terminated-by=',' --replace . That would work fine and, by using the appropriate unique index, it would deal with the fact that some of the data appears in multiple CSV files. However, though the same data is in several files, the da

replication config without stopping master server

Hi, I have MySQL-4.0.5a-beta installed on my RH9.0 Linux machine. This machine is as a replication master server. I have configured the other machine as replication slave with same version of MySQL and OS. Now, I want to start replication slave server without stopping the master server. Is i