Re: Use MySQL with Microsoft Office
Does Open Office have a MSPublisher like program? On Tue, 8 Mar 2005 12:43:01 +0100, Jigal van Hemert [EMAIL PROTECTED] wrote: From: Tom Crimmins On Monday, March 07, 2005 23:03, GH wrote: Greetings, I would like to know if it is possible to do a mail merge in Microsoft Office with a mySql database as the source? Thanks You can use install MyODBC, set up a DSN, and then use this in Office. http://dev.mysql.com/downloads/connector/odbc/3.51.html This article may also be useful for you to setup the MS Office side: http://support.microsoft.com/default.aspx?scid=kb;en-us;181926 Alternatively you could use OpenOffice.org (http://www.openoffice.org/) which has built in MySQL support. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Use MySQL with Microsoft Office
Thank you all for your responses. The reason that I am currently asking about Publisher is that i do certificates for programs that my organization runs and I am able to in publisher mail merge the Proper Names of both the recipients and signatories onto the certificate plus print the wording, graphics and other content all at once. with out having to do 2-3 passes through the printer ... a great time saver when doing 200 certificates I have the myODBC installed but can not get Publisher XP's mail merge to get the data. On Tue, 08 Mar 2005 10:11:03 -0500, J.R. Bullington [EMAIL PROTECTED] wrote: I know that this is a little off topic, but if you want a real Desktop Publishing Suite, try Adobe (InDesign, specifically). They cannot do MailMerges like in OpenOffice or M$, but it's much easier to use than M$ and looks a lot more professional. As a side note, OpenOffice, as of 1.1.2, does not have a Publisher type equivalent. It also does not have an Access equivalent, hence MySQL interoperability. J.R. -Original Message- From: Jigal van Hemert [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 9:59 AM To: GH Cc: mysql@lists.mysql.com Subject: Re: Use MySQL with Microsoft Office From: GH Does Open Office have a MSPublisher like program? I'm not familiar with Publisher, but I gues that it is supposed to help you make publications in a kind of desktop pulishing way. In the article at http://www.newsforge.com/article.pl?sid=04/10/04/150207 the author compares Writer (the wordprocessing part of OpenOffice.org) with Adobe's Framemaker. Maybe that will help you a bit. It's worth mentioning that the current version OpenOffice.org 1.1.4 will soon be replaced by a major upgrade as the 2.0 beta has recently become available. On http://www.openoffice.org you can read all about the new features in this release. I use both OpenOffice.org and MS Office and both have their pros and cons. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Use MySQL with Microsoft Office
I think I got it working I am printing out the records that I need... a bit of a 2 stepper but nice since I can store the queriy since that can not be done just yet in MySql On Tue, 08 Mar 2005 23:47:09 +0100, dixie [EMAIL PROTECTED] wrote: Il giorno mar, 08-03-2005 alle 13:46 +0100, Martijn Tonies ha scritto: Alternatively you could use OpenOffice.org (http://www.openoffice.org/) which has built in MySQL support. Alternatively, you could switch to MS Access, which is very well supported by Microsoft Office. :-) mmhhh MySQL Vs. Access MS... just a little be different :-))) Regards Paolo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Use MySQL with Microsoft Office
Greetings, I would like to know if it is possible to do a mail merge in Microsoft Office with a mySql database as the source? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Error 1251 / phpMyAdmin
I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Error 1251 / phpMyAdmin
I am still new to the PHP scene could you tell me how I rebuild the PHP with the client library... On Mon, 07 Feb 2005 12:20:26 -0500, Michael Stassen [EMAIL PROTECTED] wrote: You have mysql 4.1.8, but your php was built with the library for an earlier version, which, as the error message says, doesn't support the new, more secure authentication protocol. Your choices are to tell mysql to use the older, less-secure protocol, or build a copy of php using your current mysql client library. See the manual for more http://dev.mysql.com/doc/mysql/en/old-client.html. Michael GH wrote: I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [PHP] phpMyAdmin w/ winXP - IIS w/PHP 4.3 w/mysql 4.1.8
It would be nice if phpMyAdmin would kindly note that on their website... Also, when I run a phpInfo()... it says i have the 3.23.49 could this be a contributing factor? On Sat, 1 Jan 2005 15:55:27 +0700, Willy Sudiarto Raharjo [EMAIL PROTECTED] wrote: Has anyone had any problems installing phpMyAdmin with the above configuration? I get an error about the mySql client and authentication methods? MySQL Error: 1251 : Client does not support authentication protocol requested by server MySQL 4.1.x is using a different authentication protocols so it may break phpmyadmin functionality. Use 4.0.x if you want to use phpmyadmin clearly or maybe you should wait for the next release -- Willy Sudiarto Raharjo Registered Linux User : 336579 Public-key : http://www.informatix.or.id/willy/public-key.txt Blog : http://willysr.blogspot.com OOo Documentation Project (ID) : http://project.informatix.or.id -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
phpMyAdmin w/ winXP - IIS w/PHP 4.3 w/mysql 4.1.8
Has anyone had any problems installing phpMyAdmin with the above configuration? I get an error about the mySql client and authentication methods? MySQL Error: 1251 : Client does not support authentication protocol requested by server Please assist Happy New Year Gary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL and PHP
On Windows... Which do i install first? PHP or MySQL? Thanks Gary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL and PHP
I am using IIS :( On Wed, 29 Dec 2004 10:03:11 -0600, Josh Trutwin [EMAIL PROTECTED] wrote: On Wed, 29 Dec 2004 10:42:45 -0500 GH [EMAIL PROTECTED] wrote: On Windows... Which do i install first? PHP or MySQL? Apache. :) It doesn't really matter but I'd suggest MySQL first as I think there is one file you need to copy from the MySQL installation to the C:\Windows (or whatever systemroot directory you use) before the PhP MySQL extension will work. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Copying users?
I would like to know if it is possible and how to copy my users (passwords priviledges etc...) from my Mandrake 10.0 / MySql 4.0 machine to my Win XP Pro/MySql 4.1 machine? I would like to keep being able to develop the project that I am working on while I will be away from my main computer? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Iteration Possible? 4.0.18
Hi. Is there a way to in the mysql client (4.0.18) to for a list of IDs execute 2 queries with each ID... I.e. : I have a list of IDs 1,2,3,24,19,4,5 ... and would like to loop through them to execute 2 queries for each one so that I can pull the proper records out and print out the results I do not have PHP or such currenlty working on this system and do not wish to have to code two additioanl queries each time I need to add an ID or hunt for the 2 queries when I am deleting them ? Thanks Gary/KC2NPU -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Update Query with special conditions.
I am curious about doing something simular to this... does anyone have an idea On Wed, 24 Nov 2004 00:43:32 -0500, list 123. list wrote: Using mySQL 4.0, I would like to know how I can code a query that will change the value of Participants.Active from Y to N is for three or more CONSECUTIVE sessions they have Attendance.Present = 'No'? The Attendance Table has Attendance.Session which coresponds to Sessions.SessionID and Attendance.Participant coresponds to Participants.Part_ID; To assist, I have shown you the data of the Sessions and the descriptions of Attendance, Participants, Attendance Thanks G mysql describe Participants; +---+---+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-++ | Part_ID | smallint(10) unsigned | | PRI | NULL| auto_increment | | LastName | varchar(30) | | PRI | || | FirstName | varchar(30) | | PRI | || | DOB | date | YES | | NULL|| | Sex | enum('M','F') | | | M || | Phone1| varchar(12) | | MUL | || | Phone2| varchar(12) | YES | | NULL|| | Notes | text | | | || | Facesheet | enum('Have','Need') | | | Need|| | Active| set('Y','N') | | | Y || +---+---+--+-+-++ 10 rows in set (0.00 sec) mysql describe Attendance; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | AttID | int(4) | | PRI | NULL| auto_increment | | Session | int(2) | | MUL | 0 || | Participant | int(2) | | | 0 || | Present | enum('Yes','No') | | | Yes || +-+--+--+-+-++ 4 rows in set (0.00 sec) mysql describe Sessions; +-+-+--+-+++ | Field | Type| Null | Key | Default| Extra | +-+-+--+-+++ | SessionID | int(2) unsigned | | PRI | NULL | auto_increment | | SessionDate | date| | PRI | -00-00 || +-+-+--+-+++ 2 rows in set (0.03 sec) mysql select * from Sessions; +---+-+ | SessionID | SessionDate | +---+-+ | 1 | 2004-10-30 | | 2 | 2004-11-06 | | 3 | 2004-11-13 | | 4 | 2004-11-20 | | 5 | 2004-12-04 | | 6 | 2004-12-11 | | 7 | 2005-01-08 | | 8 | -00-00 | | 9 | 2005-01-29 | |10 | 2005-02-05 | |11 | 2005-02-12 | |12 | 2005-02-26 | |13 | 2005-03-05 | |14 | 2005-03-12 | |15 | 2005-03-19 | |16 | 2005-04-02 | |17 | 2005-04-09 | |18 | 2005-04-16 | |19 | 2005-04-23 | |20 | 2005-05-07 | |21 | 2005-05-14 | |22 | 2005-05-21 | +---+-+ 22 rows in set (0.05 sec) +-+ | Tables_in_AHRC | +-+ | Attendance | | Participants| | ProgressNotes | | Sessions| | Staff | | StaffAttendance | +-+ 6 rows in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [PHP-DB] Upgrading mySQL
What I have been asking for... is that the upgrade does not tell me *HOW* to install this upgrade. WHich file I should download etc I do not see this under the UPGRADE section... That is what I have been asking Also, it says on the manual (section 2.10) It is a good idea to rebuild and reinstall the Perl DBD::mysql module whenever you install a new release of MySQL. The same applies to other MySQL interfaces as well, such as the PHP mysql extension and the Python MySQLdb module. However I do not know how to do this and was asking how to for PHP 4. On Mon, 22 Nov 2004 15:55:25 +0100, Ingo Strüwing [EMAIL PROTECTED] wrote: Hi GH, apart of the contents of the mentioned documents and hints, there is nothing else. Just start the new server in place of the old server with the same options unless told otherwise in the mentioned documents. Am Mo, den 15.11.2004 schrieb GH um 15:06: when I go to both 2.10 Upgrading MySQL (http://dev.mysql.com/doc/mysql/en/Upgrade.html) and 2.10.2 Upgrading from Version 4.0 to 4.1 (http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html) it does not tell me how to upgrade it only tells me about important changes and recomendation. I am looking for a guide of what commands I need to use and so forth. As I said in the inital mailing I made, I am a newbie to Linux. It also says that It is a good idea to rebuild and reinstall the Perl DBD::mysql module whenever you install a new release of MySQL. The same applies to other MySQL interfaces as well, such as the PHP mysql extension and the Python MySQLdb module. [But now how to] Regards, Ingo -- Ingo Strüwing, Senior Software Developer MySQL AB, www.mysql.com Office: +49 30 43672407 Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Optimize Query Output
I have the following query: SELECT A.`AttID` , S.`SessionDate` , P.LastName, P.FirstName, A.`Present` FROM `Attendance` A, Sessions S, Participants P WHERE S.SessionID = A.`Session` AND P.Part_ID = A.`Participant` GROUP BY P.LastName, P.FirstName, A.Present, A.AttID I would like to have the output to have the P.LastName and P.FirstName values only shown once and the rest of the output printed... So instead of something like: +---+-+-+---+-+ | AttID | SessionDate | LastName| FirstName | Present | +---+-+-+---+-+ | 1 | 2004-10-30 | Apple | Robert | Yes | |11 | 2004-11-06 | Apple | Robert | Yes | |31 | 2004-11-13 | Apple | Robert | Yes | | 2 | 2004-10-30 | Bravo | Lisa | Yes | |32 | 2004-11-13 | Bravo | Lisa | Yes | |12 | 2004-11-06 | Bravo | Lisa | No | | 3 | 2004-10-30 | Beta | Elaine| Yes | |13 | 2004-11-06 | Beta | Elaine| Yes | |14 | 2004-11-06 | Delta | Alexander | Yes | |35 | 2004-11-13 | Delta | Alexander | Yes | To have it look like: +-+---+---+-+-+ | LastName| FirstName | AttID | SessionDate | Present | +-+---+---+-+-+ | Apple | Robert S. | 1 | 2004-10-30 | Yes | | | |11| 2004-11-06 | Yes | | | |31| 2004-11-13 | Yes | | Bravo | Luz | 2 | 2004-10-30 | Yes | | | |32| 2004-11-06 | No | | | |12| 2004-11-13 | Yes | | Beta | Elaine| 3 | 2004-10-30 | Yes | | | |13| 2004-11-06 | Yes | | Delta | Alexander |14 | 2004-11-06 | Yes | | | |35| 2004-11-13 | Yes | . Please advise I am running on mySql 4.0 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [PHP-DB] Upgrading mySQL
when I go to both 2.10 Upgrading MySQL (http://dev.mysql.com/doc/mysql/en/Upgrade.html) and 2.10.2 Upgrading from Version 4.0 to 4.1 (http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html) it does not tell me how to upgrade it only tells me about important changes and recomendation. I am looking for a guide of what commands I need to use and so forth. As I said in the inital mailing I made, I am a newbie to Linux. It also says that It is a good idea to rebuild and reinstall the Perl DBD::mysql module whenever you install a new release of MySQL. The same applies to other MySQL interfaces as well, such as the PHP mysql extension and the Python MySQLdb module. [But now how to] Please Assist... Thank You. On Sun, 14 Nov 2004 19:55:52 -0800, Ardilla Roja [EMAIL PROTECTED] wrote: this one will be usefull ... 2.10.2 Upgrading from Version 4.0 to 4.1 - http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html On Sun, 14 Nov 2004 09:30:49 -0500, GH [EMAIL PROTECTED] wrote: I would like to know how to upgrade mySql from 4.0 to 4.1? I am running mandrake 10 I am using the preinstalled versions of both mySQL and PHP (php4). I am a newbie to Linux and am a bit nervous. Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Upgrading mySQL
I would like to know how to upgrade mySql from 4.0 to 4.1? I am running mandrake 10 I am using the preinstalled versions of both mySQL and PHP (php4). I am a newbie to Linux and am a bit nervous. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Concatinating Two Columns
I would like to know how I can make two columns out put as one? For Example I have +---+-+--+---+-+ | AttID | SessionDate | LastName | FirstName | Present | +---+-+--+---+-+ | 2 | 2004-10-30 | Smith | Dale | Yes | +---+-+--+---+-+ I would like to have it output as +---+-+--+-+ | AttID | SessionDate | Name| Present | +---+-+--+-+ | 2 | 2004-10-30 | Dale Smith | Yes | +---+-+--+---+-+ I have the following: mysql \s -- mysql Ver 12.22 Distrib 4.0.18, for mandrake-linux-gnu (i586) Server version: 4.0.18 Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/var/lib/mysql/mysql.sock Uptime: 2 days 8 hours 8 min 48 sec Threads: 2 Questions: 10654 Slow queries: 0 Opens: 123 Flush tables: 1 Open tables: 30 Queries per second avg: 0.053 -- Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with an insert query
In my database I have the following tables: +-+ | Tables_in_AHRC | +-+ | Attendance | | Participants| | ProgressNotes | | Sessions| | Staff | | StaffAttendance | +-+ I am trying to insert data in the ProgressNotes Table using the following query but it does not work. Can someone please assist? Thank You. INSERT INTO ProgressNotes ( DateOfReport, NumPartReg, NumPartPresent, NumStaffPresent, NumVolPresent, TodaysActivities, DescribeSession, Interactions, Comments, Plans, Signed ) VALUES ( '1', Select Count(*) From Attendance WHERE Session = 1, Select Count(*) From Attendance WHERE Session = 1 AND Present = 'Yes', Select Count(*) From StaffAttendance WHERE Session = 1 AND Present = 'Yes', '0', 'Attempt to start program', 'Due to the lack of completed paperwork between and SITE, we were unable to complete the program as schedule. We informed the consumers of the situation.', 'Understandably, the consumers were upset. The Dean (SR) was kind enough to try and help explain to our members that there was a communications problem that caused the paperwork not to be completely in place before we started the program. LL and I got the members' phone numbers so that we can advise them if we are canceled next week. One consumer, DSL, was being uncooperative with us through out the time we were in session. She was pouting and having an attitude with all who were there including: the parents of another consumer, Dean SR and staff. I attempted to calm Ms. L down and stated that I was informed by MR that there might be a problem at 6:45PM on Friday. After the close of business hours on Friday. Ms. L stated on many occasions that M should of told her that we were not having class today. She called a couple of persons including a counselor at ZZZ, to which I was able to speak and explain the situation. I attempted to explain the entire situation and that we did not definitely know that they were not going to let us in to the room until today. The counselor seemed to be understanding. I told her that we are expecting to run the program next week and that we would contact Ms. L if we are told that we can not.', 'Everyone (Consumers, Parents and Staff) wishes to have the program by next week please help us get up and running.', 'Attempt to start up the program next session.', 'GMH, PgmLdr' ); mysql describe ProgressNotes; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | DateOfReport | int(2) | | PRI | 0 | | | NumPartReg | int(2) | | | 0 | | | NumPartPresent | int(2) | | | 0 | | | NumStaffPresent | int(1) | | | 0 | | | NumVolPresent| int(2) | | | 0 | | | TodaysActivities | varchar(255) | | MUL | | | | DescribeSession | text | | | | | | Interactions | text | | | | | | Comments | text | | | | | | Plans| text | | | | | | Signed | text | | | | | +--+--+--+-+-+---+ 11 rows in set (0.00 sec) [QUOTE PHPMYADMIN RESULTS] Database AHRC - Table Participants running on localhost Error There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem ERROR: Unclosed quote @ 2040 STR: ' SQL: INSERT INTO ProgressNotes ( DateOfReport, NumPartReg, NumPartPresent, NumStaffPresent, NumVolPresent, TodaysActivities, DescribeSession, Interactions, Comments, Plans, Signed ) VALUES ( '1', Select Count(*) From Attendance WHERE Session = 1, Select Count(*) From Attendance WHERE Session = 1 AND Present = 'Yes', Select Count(*) From StaffAttendance WHERE Session = 1 AND Present = 'Yes', '0', 'Attempt to start program', 'Due to the lack of completed paperwork between and SITE, we were unable to complete the program as schedule. We informed the consumers of the situation.', 'Understandably, the consumers were upset. The Dean (SR) was kind enough to try and help explain to our members that there was a communications problem that caused the paperwork not to be completely in place before we started the program. LL and I got the members' phone numbers so that we can advise them if we
Diffrences in Table Types
Greetings: -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Diffrences in table types
(SORRY FOR THE BLANK MESSAGE WRONG BUTTON PUSHED) Greetings: I am trying to create referential intergrity... I was reading that mySql does not support that on the Database Level and that you have to do it manually. However i am now seeing some posts that talk about it... i.e. Foreign Keys and such... with INNODB can someone please fill me in Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How would you make a smarter Search?
I am interested in this too... Dan if you figure out a way I would be most interested... On Fri, 8 Oct 2004 14:50:49 -0400 (EDT), Dan Venturini [EMAIL PROTECTED] wrote: Hello all Here is my problem. I am searching titles in an article database. I have two titles: mouse cleaning and cleaning your computer Now If I do a search for cleaning mouse I get 0 results. If I do cleaning computer' I get 0 results. But If I do mouse cleaning, mouse, cleaning your,I get the articles. This is my query from a simple form input. The form value is called search_value $query = SELECT id,title, post, DATE_FORMAT(date,'%M %D, %Y') AS date FROM article WHERE title LIKE '%. $search_value .%' ORDER BY id DESC LIMIT $offset, $limit; My question is am I doing something wrong here? Do you have anytips on making a smart search work? This is the only way I was taught where you match the user input to something in the database. Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Meaning of 1:1, 1:1 generalization, 1:n, 1:n non identifying, n:m
weird... about 1:! generalization and 1:m non identifying... I think that these examples can make it better to understand some of those terms... I am quoting from Database Systems -- Design, Implementation Management fouth edition by Rob Coronel (page 23) Conceptual Modules use three types of relationships to descrive associates amond data: one-to-many, many-to-many, and one-to-one. Database designers usually use shorthand notations 1:M, M:N, and 1:1 for them, respectfully. The following examples illustrate the distinctions among the three. 1. *ONE-TO-MANY Relationships* A painter pains many diffrent paintings, but each one of hem is painted by only that painter. Thus the painter (the one) is related to the paintings (the many). Therefore, database designers lable the relationship PAINTER paints PAINTINGS as 1:M. Simillarly, a customer account (the one) might contain many invoices, but those invoices (the many) are related to only a singe customer account. The CUSTOMER generates INVOICE relationship would also be labled 1:M 2 *MANY-TO-MANY Relationship* An employee might learn many job skills, ans each job skill might be learned by many employees. Database designers label the relationship EMPLOYEE learns SKILL as M:N. Similarly, a student can take many courses, and each course can be taken by many students, thus yielding the M:N relationship label for the relationship for the relationship expressed by STUDENT takes COURSE 3 *ONE-TO-ONE Relationship* A retail company's management structure may require that eaco one of its stores be managed by a single employee. In turn, each store manager -- who is an employee -- only manages a single store. Therefore the relationship EMPLOYEE manages STORE is labled 1:1 Hope that this helps... as per the non identifying and the generalizations... DUNNO On Thu, 30 Sep 2004 13:14:03 -0400, Joshua Beall [EMAIL PROTECTED] wrote: Hi All, I've been taking a look at DB Designer 4, and looking through the documentation (http://www.fabforce.net/dbdesigner4/doc/index.html) I am a little unclear on some of their nomenclature: '1:1' - Ok, one to one. Got it. '1:1' generalization - Don't know this. Obviously different somehow from one to one, but how? '1:n' - One to many, I assume. '1:n non identifying' - Nonidentifying? What does this mean? 'n:m' - Many to many? Again, not sure. Can anyone help clarify? Thanks! -Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Telephone number column not working
One issue could be that an int column unsigned can only hold up to 4294967295 a ten digit number. Plus if you put it in a context of a phone number... only area codes 428 or lower will have ALL THE EXCHANGES and ALL THE UNIQUE NUMBERS in the range... with part of area code 429 A bigint will hold the complete range you are looking for However, I would sugest that since you mostlikely are not going to be doing mathematical operations on a phone number that you use a varchar or char field. Maybe someone could correct me but aren't regex for strings only? Gary On Sat, 2 Oct 2004 04:59:45 -0700 (PDT), Stuart Felenstein [EMAIL PROTECTED] wrote: I have a field telephone. Set to type :int: Length: 11 It's not working correctly, and not sure if it's my application or something I have wrongly set up for the database. We are talking about U.S. Telephone numbers here, so 7 digits (area code, exchange, unique number) Now it seems everything works up to the storing of 6 numbers. Once I add the 7th number, everything goes haywire. The number gets transformed to some totally different number and / or 0 (zero). Now I had set up a validation , which I think would be correct for a U.S. number: [0-9\+\-\/ \(\)\.]+ Yet, even if I remove that regexp and let it validate solely on integers: -{0,1}\d+ Nothing. I thought perhaps enforcing the field to unsigned might help, but no change. One last note, I've now added some javascript to enforce format. This hasn't changed anything , better or worse. Same behaviour. This is solely for making sure client enters 111-111- format. Just wanted to include this in my information. Well if anyone has a clue appreicate the help. Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: full text search question
Laura did this work... inquiring minds want to know :) On Wed, 29 Sep 2004 13:36:40 -0400, Wesley Furgiuele [EMAIL PROTECTED] wrote: Laura: Perhaps the - is acting like a Boolean operator. What if you put double quotes around your search phrase: SELECT * FROM metadata WHERE MATCH( type ) AGAINST ( '+XY-11443' IN BOOLEAN MODE ); Wes On Wed, 29 Sep 2004 13:22:54 -0400, Laura Scott [EMAIL PROTECTED] wrote: Hello, I have a questions with limitations/restrictions that are around for full text search. I have a field with data like XY-11443;. and I need to find the record. The original developer was using full text search and says that all was working before the task switched hands. The basic query is select * from metadata where match(type) against ('+XY-11443' in boolean mode); This query spins through all of my records and gives no results. However, if I remove the XY- and just do ('+11443' in boolean mode) I get an immediate and correct result. I believe there is something going on with the '-' in the string that is causing trouble - like maybe a stop word or something - but can't find exactly what is going on and more importantly HOW TO FIX IT Any help would be awesome! Laura -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Using Visio to diagram MySQL db, export SQL
Is there a version or a product available for LINUX? On Tue, 28 Sep 2004 13:55:19 -0500, Tim Hayes [EMAIL PROTECTED] wrote: ari MYdbAL which you can download at www.it-map.com is completely FREE and includes data modeling, DDL generation or whatever you need to create your MYSQL database. Tim -Original Message- From: Ari Davidow [mailto:[EMAIL PROTECTED] Sent: 28 September 2004 12:59 To: [EMAIL PROTECTED] Subject: Using Visio to diagram MySQL db, export SQL Hi, I have Visio 2002. I am trying to set it up to use MySQL-specific datatypes (e.g., ENUM) and have some success using the User-Defined Types. But what I really want is something that I can export from Visio to actual SQL statements, and I am not succeeding in finding that at all. If Visio is total toast for this purpose, is there a comfortable open source tool that works under windows that will let me/help me visually set up my entity diagrams as I work out my database schema? ari Ari Davidow [EMAIL PROTECTED] http://www.ivritype.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Images
Is there anything special in your setup that you did to have such good performance? On Tue, 28 Sep 2004 11:47:26 -0400, DreamWerx [EMAIL PROTECTED] wrote: It's an argument that can go on forever... We have 10's of thousands of images in mysql databases.. very fast/reliable.. easy to replicate, stream, etc.. On Tue, 28 Sep 2004 08:42:13 +0200, Jigal van Hemert [EMAIL PROTECTED] wrote: From: GH [EMAIL PROTECTED] I was wondering how to get images into and out of a Mysql database was told it was possible. I have mysql 4.0.18 The general opinion is that files should be stored in a file system and not a database. There are circumstances that you might want to store binary data in a database. Take a look at the BLOB column types (http://dev.mysql.com/doc/mysql/en/BLOB.html). Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Images
I thank you all for this discussion... and for the great information that everyone has provideded. Next question (which is part of my original) how do I actually get the images into the Blobs... Additionally, the what are the names and capacities of the datatypes that I could use? I have been hearing Blob but are there others? On Tue, 28 Sep 2004 13:39:20 -0400, DreamWerx [EMAIL PROTECTED] wrote: It would be quite easy to drop a squid or similar proxy infront to cache the db images in memory and deliver them for a set cache-time or something.. That would be 1 way to boost performance.. On Tue, 28 Sep 2004 09:55:54 -0700, Ed Lazor [EMAIL PROTECTED] wrote: -Original Message- I have heard also that it helps to keep the table with the blobs having a low number of fields. Like just a primary key and the blob field. Have all your other metadata in a seperate table. Especially if you are going to be occasionally doing queries of just the metadata and don't want to always retrieve the image. Comments? I agree. That's the approach I used. Data on products are stored in a products table, while images are stored in a table called images. The images table has the following fields: ID, ProductID, SizeID, Image. There are 4 images of different resolutions for each product. The SizeID is used to tell which resolution is being requested. For example: Select Image from images where ProductID='8443' AND SizeID='1' ProductID is an int. SizeID is a small int. The Image field is largeblob, because some images are as large as 300k. However, images are generally 15k, 45k, 90k, and 180k, so perhaps largeblob is causing a performance loss? I also plan on using caching tools, so maybe performance tuning on the backend isn't as significant? What do you think? -Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Images
Ed brings up a great point... i would rather not have anyone 'searching' for images in directories and such... On Tue, 28 Sep 2004 10:53:01 -0700, Ed Lazor [EMAIL PROTECTED] wrote: Ok... I have some more test results. After optimizing as much as I can think of, without using caching, I've gotten things down to a 13x difference. Using Apache's ab performance test, the image comes from a file at an average of 2ms and from the database (using PHP4) at an average of 28ms. I know... it just reiterates what you were already saying, but it sure is great to see actual numbers measuring the difference. Maybe the difference could be even less if I were properly optimizing MySQL. The big question still outstanding, for me at least, is whether web page caching makes the performance difference a mute point. If caching is storing everything as files, we get the best of both worlds. Plus, I think there may be a little bit of a security benefit. A directory has to be marked as writeable so that scripts can store image files. This isn't necessary when using MySQL. Do you agree with the security benefit? Does webpage caching negate the performance difference? -Ed -Original Message- Grabbing the file was 38 times faster because MySQL was not designed to be a filesystem. There are filesystems out there specifically designed to handle hundreds of thousands of small files. One of the best is ReiserFS http://www.namesys.com If you record the filename in mysql tracking becomes a non issue. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Multiple Insert Statement?
I know that this is off topic and such... but can you explain the Match / Against that you used in your query? i have never seen syntax like that in SQL On Tue, 28 Sep 2004 14:16:56 -0400, Eve Atley [EMAIL PROTECTED] wrote: My query: SELECT * FROM wow.resume r INNER JOIN wow.candidate c WHERE r.Section_ID = '1' AND MATCH (r.Section_Value) AGAINST ('+baan' IN BOOLEAN MODE) AND c.Candidate_ID = r.Candidate_ID; Is it possible to do a multiple insert statement like so? INSERT INTO wow.candidate_erp (Candidate_ID, Section_ID, Section_Value) INSERT INTO wow.resume_erp (Candidate_ID, Vendor_ID, etc.) SELECT SQL_CALC_FOUND_ROWS * FROM wow.resume r INNER JOIN wow.candidate c; Or do I have to break out the INSERT statements seperately? Thanks! - Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Images
I was wondering how to get images into and out of a Mysql database was told it was possible. I have mysql 4.0.18 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unable to download MySQL
I would right click on the link and choose to save target... do not left click such that it would try to open it. as rpm could also be used by RealPlayer/RealOne for their media files. On Wed, 15 Sep 2004 01:21:55 +0800, Bret Busby [EMAIL PROTECTED] wrote: In trying to download the mysql Linux x86 RPM server rpm download from http://mysql.mirrors.ilisys.com.au/Downloads/MySQL-4.0/MySQL-server-4.0.21-0.i386.rpm after an hour or so downloading it, I ended up with an error message; Plugger: no approperiate (sic) application for type audio/x-pn-realaudio-plugin found! Is that really a valid MySQL download web site, as listed on the web page at http://dev.mysql.com/get/Downloads/MySQL-4.0/MySQL-server-4.0.21-0.i386.rpm/from/pick ? Why does MySQL need a realaudio plugin? -- Bret Busby Armadale West Australia .. So once you do know what the question actually is, you'll know what the answer means. - Deep Thought, Chapter 28 of The Hitchhiker's Guide to the Galaxy: A Trilogy In Four Parts, written by Douglas Adams, published by Pan Books, 1992 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: AutoResponders (was: Unable to download MySQL (fwd))
If you are going to be out of the office... suspend you subscription to the mailing list... so that everyone does not recieve these notices please On Tue, 14 Sep 2004 19:43:29 +0200, Martijn Tonies [EMAIL PROTECTED] wrote: Does the message below, mean that everyone who posts a message to this list, will receive a message such as the one below, from the person below, for the next week? Yes. Great isn't it. Those people should be smacked in the head. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com Subject: Re: Unable to download MySQL Sorry, but I am out of the office on Monday 13th September until Monday 20th September 2004. I will respond to your e-mail when I return If you need technical support please contact [EMAIL PROTECTED] or [EMAIL PROTECTED] For any other enquiries please call the office on (0113) 272 3191 Thanks for your e-mail. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fwd: Best way to get Access DB structures into MySQL ??
-- Forwarded message -- From: GH [EMAIL PROTECTED] Date: Sun, 12 Sep 2004 02:49:02 -0400 Subject: Re: Best way to get Access DB structures into MySQL ?? To: Chris Martin [EMAIL PROTECTED] Does this also allow for the importation of the data as well? On Sat, 11 Sep 2004 21:34:33 -0700, Chris Martin [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: What is the best way to take the structure of multiple tables in Access and get them re-created in MySQL without doing that all by hand? Is there a way to do the equivalent of a Show Create Table in Access, that I could then use in MySQL ?? Chris Hood Investigator Verizon Global Security Operations Center Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Desk: 972.399.5900 Verizon Proprietary MySQL-Front has an ODBC import feature. The old 2.5 version was free (looks like it still is) http://www.bumpersoft.com/Programming/Databases_and_Networks/Review_982_index.htm It's since been taken over by new developers, and newer versions are available for a reasonable fee at http://www.mysqlfront.de/download.html -- Chris Martin Web Developer Open Source Web Standards Advocate http://www.chriscodes.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Please Disregard This Message
Please disregard. Attempting to verify that I can send and receive messages -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading mySQL 3.23 to 4.0
Can you give me a bit more detailed instructions on what i am uninstalling and what I should back up? Thanks Wolfgang Riedel wrote: [EMAIL PROTECTED] schrieb: I am trying to upgrade to the new version of mySQL on Fedora Core 2 Linux. I have mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386) some days ago, I had the same problem. Redhat's rpm packages mysql-3* and MySQL's new packages MySQL-4.0.20* are not compatible, because the are build in different ways - different nameing scheme and different content. Thatswhy this is no good idea to try rpm -Uvh I've deinstalled the old packages by rpm -e ... (save /etc/my.cnf and /var/lib/mysql before) and installed the new one on a 'mysql-clean' base. Bye, Wolfgang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]