RE: I thought MySQL Supported Relationships
http://www.google.com/search?hl=enq=Views+Mysql ... MySQL Manual | 1.7.4.6 Views ... It is planned to implement views in MySQL Server around Version 4.1. Views are mostly useful for letting users access a set of relations as one table (in read ... www.mysql.com/doc/A/N/ANSI_diff_Views.html - 17k - Cached - Similar pages MySQL Manual | 1.7.3.7 Views ... One doesn't need views in MySQL to restrict access to columns as MySQL has a very sophisticated privilege system. See section 4.2 General Security Issues and ... www.mysql.com/doc/M/i/Missing_Views.html - 9k - Cached - Similar pages [ More results from www.mysql.com ] ... C:~ -Original Message- From: Arthur Fuller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 5:57 PM To: Jonathan Hilgeman; [EMAIL PROTECTED] Subject: Re: I thought MySQL Supported Relationships Perhaps I fail to catch the humour in your response, or the flavour of this newsgroup, but I find your answer in no way helpful, and beyond that quite insulting to Access. 1. I have developed applications in Access comprising over 1000 tables, some of which contain millions of rows, with numerous complex relationships and C++ components that interfaced to instruments such as scales, scanners, etc. I am not the only one to push Access that far. 2. To answer Andrew's question, the answer is No. MySQL does not support defined relationships. The InnoDB extension provides this support. 3. Unfortunately, as of this writing neither MySQL nor InnoDB supports defined queries (Oracle and SQL Server call them Views). Allegedly, MySQL 4.1 will support stored procedures (and I for one hope that views make it into the build). Arthur - Original Message - From: Jonathan Hilgeman [EMAIL PROTECTED] To: 'Andrew Kuebler' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 2:43 PM Subject: RE: I thought MySQL Supported Relationships Actually, no. The addiction to MySQL has caused many relationship break-ups. There's probably even a database with that information out there somewhere. Probably a MySQL database, too. Meanwhile Access supports relationships because it blows so hard that people can't wait to get away from it and home to their families. - Jonathan -Original Message- From: Andrew Kuebler [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 11:35 AM To: [EMAIL PROTECTED] Subject: I thought MySQL Supported Relationships Hello Everyone. I'm still fairly a newbie to MySQL, but I could have sworn I read somewhere that MySQL supported relationships just like Access. I've searched the entire manual, and cannot find anything on the subject. Does MySQL support relationships, and if so does anyone know where I can find any info on the topic? Thanks! Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysqld
http://www.mysql.com/udmsearch/index.php?ps=10q=safe_mysqldps=20m=and 1. MySQL Manual | 4.7.2 safe_mysqld, the Wrapper Around mysqld MySQL Manual [2162694] MySQL Manual Search: Up Previous Next Chapters Sections Functions Concepts 4.7.2 safe_mysqld, the Wrapper Around mysqld safe_mysqld is the recommended way to start a mysqld daemon on Unix. safe_mysqld adds some safety features such a... http://www.mysql.com/doc/s/a/safe_mysqld.html C:~ -Original Message- From: Ian Phillips [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 6:40 PM To: [EMAIL PROTECTED] Subject: mysqld I have run mysqld - and it tells me it is ready for connections - what syntax is it looking for? (is it the same as mysql ie commands and then a ';' to finish? Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC arrrgghh!
The mysql.user table requires an entry corresponding to user@IP/hostname corresponding to the XPwkst w/ODBC. -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:02 AM To: [EMAIL PROTECTED] Subject: MyODBC arrrgghh! Alright, I'm feeling pretty clueless on this one. I've downloaded and installed MyODBC. I am trying to go from my local WinXP to my database on a unix/apache webserver. (I want to use CodeCharge to build a site). I have asked my ISP to grant remote access and he says he has. I can access from a phpMyAdmin on one webserver to a db on the other webserver fine. But when I try to access with ODBC, using the same username/password it's no go. mysql;mysql; Andrew Hazen, O.C.P. E-Commerce Developer Jatech Solutions Inc. www.jatech.ca Specializing in OSCOMMERCE applications and PHP/MySQL programming. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC arrrgghh!
Here's the basics for MySQL database access (seven lines total: use mysql; create database myDB; insert into db values ('myHOST.myDOMAIN.com', 'myDB', 'myUSER', 'Y','Y','Y','Y','N','N','N','N','N','N'); insert into user values ('localhost','myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'); insert into user values ('myHOST.myDOMAIN.com', 'myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); insert into user values ('myIP', 'myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); quit -Original Message- From: Land, Christopher [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:26 AM To: Andrew Hazen; [EMAIL PROTECTED] Subject: RE: MyODBC arrrgghh! The mysql.user table requires an entry corresponding to user@IP/hostname corresponding to the XPwkst w/ODBC. -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:02 AM To: [EMAIL PROTECTED] Subject: MyODBC arrrgghh! Alright, I'm feeling pretty clueless on this one. I've downloaded and installed MyODBC. I am trying to go from my local WinXP to my database on a unix/apache webserver. (I want to use CodeCharge to build a site). I have asked my ISP to grant remote access and he says he has. I can access from a phpMyAdmin on one webserver to a db on the other webserver fine. But when I try to access with ODBC, using the same username/password it's no go. mysql;mysql; Andrew Hazen, O.C.P. E-Commerce Developer Jatech Solutions Inc. www.jatech.ca Specializing in OSCOMMERCE applications and PHP/MySQL programming. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC arrrgghh!
Your workstation is 192.168.1.101: insert into user values ('192.168.1.101', 'myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); Allow class C network access with: insert into user values ('192.168.1.%', 'netUSER', Password ('netPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); OR insert into user values ('%.indominion.com', 'hostUSER', Password ('hostPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); C:~ -Original Message- From: Land, Christopher [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 12:01 PM To: [EMAIL PROTECTED] Subject: RE: MyODBC arrrgghh! Here's the basics for MySQL database access (seven lines total: use mysql; create database myDB; insert into db values ('myHOST.myDOMAIN.com', 'myDB', 'myUSER', 'Y','Y','Y','Y','N','N','N','N','N','N'); insert into user values ('localhost','myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'); insert into user values ('myHOST.myDOMAIN.com', 'myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); insert into user values ('myIP', 'myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); quit -Original Message- From: Land, Christopher [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:26 AM To: Andrew Hazen; [EMAIL PROTECTED] Subject: RE: MyODBC arrrgghh! The mysql.user table requires an entry corresponding to user@IP/hostname corresponding to the XPwkst w/ODBC. -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:02 AM To: [EMAIL PROTECTED] Subject: MyODBC arrrgghh! Alright, I'm feeling pretty clueless on this one. I've downloaded and installed MyODBC. I am trying to go from my local WinXP to my database on a unix/apache webserver. (I want to use CodeCharge to build a site). I have asked my ISP to grant remote access and he says he has. I can access from a phpMyAdmin on one webserver to a db on the other webserver fine. But when I try to access with ODBC, using the same username/password it's no go. mysql;mysql; Andrew Hazen, O.C.P. E-Commerce Developer Jatech Solutions Inc. www.jatech.ca Specializing in OSCOMMERCE applications and PHP/MySQL programming. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL and stored procedures - v4.1 :(
5.2.12 Other Optimisation Tips http://www.mysql.com/doc/T/i/Tips.html ... - Normally you should try to keep all data non-redundant (what is called 3rd normal form in database theory), but you should not be afraid of duplicating things or creating summary tables if you need these to gain more speed. - Stored procedures or UDF (user-defined functions) may be a good way to get more performance. In this case you should, however, always have a way to do this some other (slower) way if you use some database that doesn't support this. - You can always gain something by caching queries/answers in your application and trying to do many inserts/updates at the same time. If your database supports lock tables (like MySQL and Oracle), this should help to ensure that the index cache is only flushed once after all updates. ... C:~ -Original Message- From: Jon Frisby [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 11:43 AM To: Mysql List Subject: RE: MySQL and stored procedures - v4.1 :( Checked my own version and found it to be Ver 11.16 Distrib 3.23.49. He, version 11??? Quit confused, but after a sanity check with reality I realized I must be using version 3.23. Anyhow, check the status of next version and found out that version 4.0 is in alpha mode... The Ver 11.16 refers to the version of the MySQL *client* utility. Distrib 3.23.49, as you figured out is which version of MySQL it was distributed with. Geeeze - not even beta. So I guess even an estimate when the first alpha of version 4.1 is virtually impossible to give right now, or? I'll trust a MySQL alpha release before the final production releases of most vendors. In fact, we're using 4.0.1 in our production environment with great success. From the manual: *alpha indicates that the release contains some large section of new code that hasn't been 100% tested. Known bugs (usually there are none) should be documented in the News section. See section D MySQL change history. There are also new commands and extensions in most alpha releases. Active development that may involve major code changes can occur on an alpha release, but everything will be tested before doing a release. There should be no known bugs in any MySQL release. *beta means that all new code has been tested. No major new features that could cause corruption on old code are added. There should be no known bugs. A version changes from alpha to beta when there haven't been any reported fatal bugs within an alpha version for at least a month and we don't plan to add any features that could make any old command more unreliable. *gamma is a beta that has been around a while and seems to work fine. Only minor fixes are added. This is what many other companies call a release. *If there is no suffix, it means that the version has been run for a while at many different sites with no reports of bugs other than platform-specific bugs. Only critical bug fixes are applied to the release. This is what we call a stable release. But anyway. When could one expect to find a first alpha version of 4.1? Sometimes during 2003? Or? The manual makes allusions to an early 2002 release for 4.1, but I think that's probably slipped somewhat. Late 2002/early 2003 seems more likely. However, be aware that the fact that they plan on having stored procedures in 4.1, does not guarantee that they actually will have stored procedures. Often times, a feature cannot be implemented as efficiently as Monty et al would like, or other features become a higher priority and things get put off for a while. (*ahem* sub-selects -- when I started using 3.20.x they were supposed to be in 3.21.x, then 3.22.x, then...) -JF - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Another question of Date.
About midway down the page...: http://www.mysql.com/doc/S/t/String_functions.html SUBSTRING(str,pos) SUBSTRING(str FROM pos) Returns a substring from string str starting at position pos: mysql select SUBSTRING('Quadratically',5); - 'ratically' mysql select SUBSTRING('foobarbar' FROM 4); - 'barbar' This function is multi-byte safe. C:~ -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 5:10 AM To: Mike; [EMAIL PROTECTED] Subject: Re: Another question of Date. Mike and the mysql list, This is the SQL statement I am using now; SELECT DATE_FORMAT(DOB, '%M %D, %Y') as DOB, Fname, Lname, Email FROM emply_info WHERE (TO_DAYS(DOB) - TO_DAYS(NOW())) =7 AND (TO_DAYS(D\ OB) = TO_DAYS(NOW())) and Tdate is NULL and DOB is not null ORDER BY DOB, Lname But it only works because I had to change the year to 2002, I don't want to change 2002. That was my question I want to read the field but only the month and the date. NOT FORMAT. I also like to read that field but only the year and take this year to get how old a person is. I hope that clears it up. Chuck on 4/11/02 8:02 AM, Mike at [EMAIL PROTECTED] wrote: Sorry, Do you mean to use the date in a WHERE clause? I've use php's date function to supply a date for a WHERE clause in a sql statement. Mike - Original Message - From: Chuck PUP Payne [EMAIL PROTECTED] To: Mike [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 7:53 AM Subject: Re: Another question of Date. Thanks but I want to be able able to use this in SQL statement not format the output. Chuck on 4/11/02 7:46 AM, Mike at [EMAIL PROTECTED] wrote: http://www.mysql.com/doc/D/a/Date_and_time_functions.html mysql select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y'); - 'Saturday October 1997' mysql select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s'); - '22:23:00' mysql select DATE_FORMAT('1997-10-04 22:23:00', '%D %y %a %d %m %b %j'); - '4th 97 Sat 04 10 Oct 277' mysql select DATE_FORMAT('1997-10-04 22:23:00', '%H %k %I %r %T %S %w'); - '22 22 10 10:23:00 PM 22:23:00 00 6' mysql select DATE_FORMAT('1999-01-01', '%X %V'); - '1998 52' Mike - Original Message - From: Chuck PUP Payne [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 7:42 AM Subject: Another question of Date. Hi, I got a small problem I like to be able to read a DATE but I don't want to read the Year. I only want to read the month and the date. For example, I like to read the a Birthday Field to see who Bithday is today. Also like to be later be able to read that same field but this time the year so that I can see how old a person is. Is there any example on the net of this? Chuck Sql and MySql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connection -- Can't open named pipe error
http://www.mysql.com/doc/W/i/Windows_vs_Unix.html Can't open named pipe error If you use a MySQL 3.22 version on NT with the newest mysql-clients you will get the following error: error 2017: can't open named pipe to host: . pipe... This is because the release version of MySQL uses named pipes on NT by default. You can avoid this error by using the --host=localhost option to the new MySQL clients or create an option file `C:\my.cnf' that contains the following information: [client] host = localhost Starting from 3.23.50, named pipes are only enabled if mysqld is started with --enable-named-pipe. -Original Message- From: Frederic Cormann [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 5:28 AM To: [EMAIL PROTECTED] Subject: Connection Importance: High I have the following message: Microsoft OLE DB Provider for ODBC Drivers- Fehler '80004005' [TCX][MyODBC]Can't open named pipe to host: 192.168.97.2 pipe: MySQL (5) /hopital/Web/De/TMP20w8iuel5u.asp, line 5 can anybody help me? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: how do I give permissions to a web browser
The web application is running in an environment *outside* of the server, compared to your context, which may be 'root@localhost', for instance. The browser's context, then, might be '[EMAIL PROTECTED]'; thus, you will need to add an entry to m,ysql.user table. C:~ -Original Message- From: Henry de Jong [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 7:41 PM To: [EMAIL PROTECTED] Subject: how do I give permissions to a web browser It seems that an internet connection from a browser to my unix/apache hosted mysql database presents itself as some user to whom I haven't yet given permissions because the calling web page gives up without a whimper. I have generous permissions for 'root', 'nobody' and 'localhost'. The perl script works fine from my shell acount (through a socket) and works up till the connect statement in the browser. How can I 'identify' the browser or change the script to accomodate a browser connection. thanks, Henry de Jong - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Manual | 6.2.6.1: Range of MEDIUMINT, and BIGINT of mySQL type ? (sql query)
Check the documentation: 6.2.6.1 Storage requirements for numeric types http://www.mysql.com/doc/n/o/node_365.html C:~ -Original Message- From: Son Nguyen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 6:30 PM To: [EMAIL PROTECTED] Subject: Range of MEDIUMINT, and BIGINT of mySQL type ? (sql query) Do anybody knows the range of MEDIUMINT, and BIGINT type to use when I do the create table in mySQL ? Son Nguyen sql, query __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: I have multiple servers in a machine.
To start MySQL, are you using, minimum, the following? ./safe_mysqld 2.4.2 Problems Starting the MySQL Server http://www.mysql.com/doc/S/t/Starting_server.html 2.4.3 Starting and Stopping MySQL Automatically http://www.mysql.com/doc/A/u/Automatic_start.html C:~ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 6:56 PM To: [EMAIL PROTECTED] Subject: I have multiple servers in a machine. I have two mysql servers in a machine. OS is linux and system is dell. I ran the servers in a separate datadir, socket and port yesterday. But after six hours from the start two of them corrupted accidently. I ran two servers from remote terminal. And there was no problem until I exited from the terminal. But... as soon as I typed exit to exit from terminal, some error messages appeared on my screen. And two servers stopped. After corruption one of them restarted automatically but the other couldn't restart automatically. This is error message from the server FIRST ONE 020409 04:03:03 mysqld started /usr/local/libexec/mysqld: ready for connections Number of processes running now: 20 mysqld process hanging, pid 18761 - killed mysqld process hanging, pid 18811 - killed mysqld process hanging, pid 18832 - killed 020409 14:34:04 mysqld restarted /usr/local/libexec/mysqld: ready for connections ~ ~ SECOND ONE 020409 04:03:03 mysqld started /usr/local/libexec/mysqld: ready for connections Number of processes running now: 94 mysqld process hanging, pid 18762 - killed 020409 14:34:03 mysqld restarted Number of processes running now: 0 020409 14:34:03 mysqld restarted 020409 14:34:03 mysqld ended 020409 14:34:04 mysqld ended The accident occured at 14:34 2002/04/09. Do you have any idea why the server corrupted? I can show you my mysql.server script. Here is this. $bindir/safe_mysqld --datadir=$datadir \ --pid-file=$pid_file \ -O max_heap_table_size=512M \ -O key_buffer=256M \ -O table_cache=256 \ -O sort_buffer=4M -O record_buffer=1M \ -O max_allowed_packet=1M \ -O max_connections=400 \ -O back_log=100 \ $bindir/safe_mysqld --datadir=/usr/local/mysql/other \ --socket=/usr/local/mysql/other/mysql.sock \ --port=3307 \ -O max_heap_table_size=512M \ -O key_buffer=256M \ -O table_cache=256 \ -O sort_buffer=4M -O record_buffer=1M \ -O max_allowed_packet=1M \ -O max_connections=400 \ -O back_log=100 \ Any answer will be appreciated. Thank you for reading. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: database - er diagram
Check the Contributed Software page: Contributed software - http://www.mysql.com/downloads/contrib.html APIs Clients Web Tools Performance Benchmarking Tools Authentication Tools Converters Using MySQL with Other Products Utilities RPMs for Common Tools (Most Are for RedHat 6.1) Useful Functions Windows Programs Uncategorised C:~ -Original Message- From: Mr Hai Luong [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 8:11 PM To: [EMAIL PROTECTED] Subject: database - er diagram i got a MySQL database that my supervisor wats me to do an ER diagram for. The problem is that there is no/not much documentation on this database. Also one cannot draw an ER-Diagram by looking at the mySQL- Database, since there is no way (i know of) i can defining logical relationships especially when a column names for the same attribute are different between the tables. Is there some Tutorials/fact sheets/program/information to do this? Cheers Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: show to fields from a table
6.6.2 DESCRIBE Syntax (Get Information About Columns) http://www.mysql.com/doc/D/E/DESCRIBE.html ... aka MySQL(homePage)-Search::subject. C:~ -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 9:04 AM To: 'Chuck PUP Payne'; MySQL Mailing List (E-mail) Subject: RE: no subject SELECT name,birthday FROM mytable -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 10:49 AM To: MySQL Mailing List (E-mail) Subject: no subject Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a table. For example I only like to see the names and birthday? Or will as so all fields for a given table. Chuck Payne - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SQL Script stopping
ERROR 1064 at line 1: You have an error in your SQL syntax near ' ' at line 1 - perhaps you'd prefer the semicolon to complete your query - C:~ -Original Message- From: Jim Swanson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 9:07 AM To: [EMAIL PROTECTED] Subject: SQL Script stopping I have a script I'm trying to run through the mysql command. When I run the script, I get a 1064 error, specifically CREATE TABLE 185_s_Prices\g PriceID INT NOT NULL DEFAULT 0, Service CHAR (80); Category CHAR (20),--- here Can anyone tell me what's wrong with this line? I dumped the tables, changed Category to ctg, still the same error. I'm running a fresh install of Mandrake 8.2. Thanks in advance. Jim Swanson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MY.INI: Binary Log and WinXP Services
MySQL Manual | 4.1.2 my.cnf Option Files MySQL Manual [2621454] MySQL Manual Search: Up Previous Next Chapters Sections Functions Concepts 4.1.2 my.cnf Option Files MySQL can, since Version 3.22, read default startup options for the server and for clients from option files. MySQL reads default o... http://www.mysql.com/doc/O/p/Option_files.html -Original Message- From: Scalper [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 7:10 AM To: [EMAIL PROTECTED] Subject: Binary Log and WinXP Services I am running Windows XP with MySQL running as a service. When I want to run MySQL with the option for logging (--log -bin), I have to start the service MANUALLY and type the --log -bin in the parameters box each time I restart the server. Is there an easier way to do this? Thx, Craig - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: PigeonRank?
How about using the state transitions, i.e. 0 - 1 state changed, no error 0/1 - 0/1 state unchanged, no error 1 - 0 state changed, overflow C:~ -Original Message- From: Michael Zimmermann [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 12:07 PM To: Colin Faber; [EMAIL PROTECTED] Subject: Re: PigeonRank? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 At Montag, 1. April 2002 21:38 Colin Faber wrote: Is it true that mysql is planing to implement google's famous PigeonRank system in it's FTS word weighting schema??? I allready have a simple quick-n-dirty implementation running on our local mysql servers (using spades instead of pigeons), so it shouldn't be too difficult to phase this development into the main cvs-trunk later. The only problem I wasn't yet able to resolve reliably is to store the three possible values into one bit, hence I'm using two bits for the decision logic and call this three-valued boolean storage unit a 'peck'. But it's my feeling, that there must be better a solution; after all if a qbit can hold 4 values (as modern physics says), why shouldn't a peck be able to mark 3 possibilities (or even 4 if you count 'not-yet-pecked' as the fourth). Working on it. Michael - -- Michael Zimmermann (Vegaa Safety and Security for Internet Services) [EMAIL PROTECTED] phone +49 89 6283 7632hotline +49 163 823 1195 Key fingerprint = 1E47 7B99 A9D3 698D 7E35 9BB5 EF6B EEDB 696D 5811 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE8qL3g72vu22ltWBERAj4nAJ43ozoANVzaNc7sFhEi4TQSLikp0QCfYYa8 DxDIMKhmecG7gx6BmxKZxnE= =GEhN -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: anyone here take the MySQL training classes?
How precise a location were you seeking? That * is San Francisco, CA. http://www.mysql.com/training/index.html Scheduled Courses Using and Managing MySQL Hamburg 15-19 Apr 2002 2450 EUR Register now! Questions? *San Francisco 15-19 Apr 2002 2450 USD Register now! Questions? Washington DC 06-10 May 2002 2450 USD Register now! Questions? London 13-17 May 2002 1650 GBP Register now! Questions? Amsterdam 27-31 May 2002 2450 EUR Register now! Questions? Houston 10-14 Jun 2002 2450 USD Register now! Questions? Paris 10-14 Jun 2002 2450 EUR Register now! Questions? The 5-day intensive course was awesome; I highly recommend to any who can avail oneself thereof. C:~ -Original Message- From: Daniel Smith [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 1:08 PM To: [EMAIL PROTECTED] Subject: anyone here take the MySQL training classes? I am considering the intensive 1 week MySQL class coming up in SF. Has anyone here been through one of their classes? How did it go? The web site doesn't list a location, and they don't answer the phone (strikes 1 2...) Off-list responses are fine. I'd just like to know that someone found their classes to be well worth it. http://www.mysql.com/training/index.html -- Daniel L. Smith - Sonoma County, CA http://resume.daniel.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Select data from local database into another host over
4.8.5 mysqldump, Dumping Table Structure and Data Utility to dump a database or a collection of database for backup or for transferring the data to another SQL server (not necessarily a MySQL server). The dump will contain SQL statements to create the table and/or populate the table. If you are doing a backup on the server, you should consider using the mysqlhotcopy instead. See section 4.8.6 mysqlhotcopy, Copying MySQL Databases and Tables. ... However, it's also very useful to populate another MySQL server with information from a database: mysqldump --opt database | mysql --host=remote-host -C database http://www.mysql.com/doc/m/y/mysqldump.html C:~ -Original Message- From: erich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 7:22 AM To: [EMAIL PROTECTED] Subject: Select data from local database into another host over Does anybody have an idea how to select data from a local database into another host server ? For information, I'm currently using mySQL 3.23. Eric Huwaert Kind regards - Bien cordialement - Vriendelijke groeten - Mit freundlichen Grüßen , - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: 1 table many fields/several tables less fields?
Here are the 5 Rules of Data Normalization -- http://www.datamodel.org/NormalizationRules.html Eliminate Repeating Groups - Make a separate table for each set of related attributes, and give each table a primary key. Eliminate Redundant Data - If an attribute depends on only part of a multi-valued key, remove it to a separate table. Eliminate Columns Not Dependent On Key - If attributes do not contribute to a description of the key, remove them to a separate table. Isolate Independent Multiple Relationships - No table may contain two or more 1:n or n:m relationships that are not directly related. Isolate Semantically Related Multiple Relationships - There may be practical constrains on information that justify separating logically related many-to-many relationships. C:- -Original Message- From: Gath [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 1:35 PM To: [EMAIL PROTECTED] Subject: 1 table many fields/several tables less fields? Greetings. I would thank some feedback on this issue. The doubt is: Should i create a table, with about 40-65 fields (ID, 3 or 4 of text, the reamining of small/tiny int), or should i split it in about 4-6 tables, dividing the fields between them? Info: The database would be read/write by PHP, and it would have around 1500-2500 users (distributed by the day), with about 150 queries each user. In each query, around 10-20 fields values would be needed. The queries would mainly be SELECT and UPDATE... I did read the optimisation part in the manual, particularly: It's not normally useful to split a table into different tables just because the rows gets 'big'. From http://www.mysql.com/doc/T/i/Tips.html , Other Optimisation Tips. http://www.mysql.com/doc/C/r/Creating_many_tables.html, Drawbacks to Creating Large Numbers of Tables in the Same Database but still didnt got an straight answer for my precise case. Unfortunally i'm new at this (both MySQL and PHP), so i apolozige for any mistake/stupidity presented in the question... :) I will, in lack of contrary info, use 1 table with many fields... Thank you for any comments. Gath - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Myths Debunked Revision 5
Perhaps, you could add the Free Oracle database myth, as well? C:- -Original Message- From: Michael Bacarella [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 3:28 PM To: [EMAIL PROTECTED] Subject: MySQL Myths Debunked Revision 5 A new revision of MySQL Myths Debunked is now available. http://m.bacarella.com/projects/mysqlmyths/ MySQL Myths Debunked was originally my attempt to provide a solid document to help me silence naysayers who would harass my decision to use MySQL instead of the big and stupid alternatives. Seems like I wasn't the only one who needed it. The response to this article has been overall very positive. More MySQL success stories would be much appreciated. -- Michael Bacarella | Netgraft Corporation | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | [EMAIL PROTECTED] query,table,sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Error 1067: the process terminated unexpectedly
Try a C:\my.cnf with just the following: [mysqld] datadir = C:/mysql/ tmpdir = C:/temp/ -Original Message- From: Gregory Junker [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 2:25 PM To: Simon Tienery; [EMAIL PROTECTED] Subject: RE: Error 1067: the process terminated unexpectedly have you tried running the server in standalone from the command prompt, to get some more output from the startup sequence? -Original Message- From: Simon Tienery [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 4:40 PM To: [EMAIL PROTECTED] Subject: Error 1067: the process terminated unexpectedly Can anyone help please! I am unable to start the service on WIN2K since I installed version MySQL-3.23.38. I have tried altering the my.cnf and my.ini files and I have tried running the service as the administrator user. But I am getting the same error message above each time. Any suggestions would be very welcome. ST - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql from windows to linux
You should use mysqldump[.exe] to export/import, on the respective systems: 4.8.5 mysqldump, Dumping Table Structure and Data http://www.mysql.com/doc/m/y/mysqldump.html C:1 -Original Message- From: David yahoo [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 09, 2002 2:22 PM To: [EMAIL PROTECTED] Subject: mysql from windows to linux Hi all, I developp a site with some mysql table which are files myd myi n frm under windows x86 arch. I copy my table into a liinux box x86 arch too. Bu when trying to modidy tables I get an Error: 1036 - Table country is read only I manage the rigth of new created tables. I get things like that that I report to my read only tables : 12 -rw-rw1 mysqlmysql8674 jui 15 2001 country.frm 24 -rw-rw1 mysqlmysql 20516 jui 15 2001 country.MYD 4 -rw-rw1 mysqlmysql1024 jui 15 2001 country.MYI 12 -rw-rw1 mysqlmysql8564 mar 9 23:18 TableName.frm 0 -rw-rw1 mysqlmysql 0 mar 9 23:18 TableName.MYD 4 -rw-rw1 mysqlmysql1024 mar 9 23:18 TableName.MYI I make a chown -R mysql.mysql * n chmod 660 * Nothing change. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySql 4.01 and libmysqlclient.so.10 - TEMP FIX
Perhaps the rpm expects to perform a (forced) upgrade Ç: -Original Message- ... Your problem is because your new compile (or binary install) is expecting the layout previously used by mySQL v3. ... If anyone can offer us more, please do! LP I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql 3.23.49) I get a Php-mysql.4.xx requires libmysqlclient.so.10. My attempt to install MySql 4.01 ends there. I did some reading and found that libmysqlclient.so.10 comes with MySql 3.23.xx. I surfed my directories to find that MySql 4.01 installs libmysqlclient.so.11 I installed theses packages using the RH RPM Manager. Am I missing something? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: select count distinct
The following may assist: (three-fifths down) http://www.mysql.com/doc/G/r/Group_by_functions.html Note that if you are using MySQL Version 3.22 (or earlier) or if you are trying to follow ANSI SQL, you can't use expressions in GROUP BY or ORDER BY clauses. You can work around this limitation by using an alias for the expression: mysql SELECT id,FLOOR(value/100) AS val FROM tbl_name GROUP BY id,val ORDER BY val; C: -Original Message- From: Brian Warn [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 4:31 PM To: MySQL List Subject: select count distinct I'm stuck right now with using v. 3.22.32. Yes, I know I need to upgrade, but I can't for various reasons. Anyway, I need to do a select count(distinct column) from table query, but can't since this version doesn't support it. How can I do this? Thanks, Brian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Obtaining GMT time in mySQL
MySQL: DATETIME vs. INT http://forums.devshed.com/showthread.php?s=threadid=29754forumid=4 C:heers! -Original Message- From: DL Neil -- Sent: Tuesday, February 05, 2002 1:28 AM Checking the MySQL manual (6.3.4 Date and Time Functions) UNIX_TIMESTAMP() UNIX_TIMESTAMP(date) ...returns a Unix timestamp (seconds since '1970-01-01 00:00:00' GMT) ...in local time: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Obtaining GMT time in mySQL
MySQL: DATETIME vs. INT http://forums.devshed.com/showthread.php?s=threadid=29754forumid=4 C:heers! -Original Message- From: DL Neil -- Sent: Tuesday, February 05, 2002 1:28 AM Checking the MySQL manual (6.3.4 Date and Time Functions) UNIX_TIMESTAMP() UNIX_TIMESTAMP(date) ...returns a Unix timestamp (seconds since '1970-01-01 00:00:00' GMT) ...in local time: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql.sock
Try: ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock C:heers! -Original Message- From: Cindy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 1:59 PM To: [EMAIL PROTECTED] Subject: mysql.sock Sorry, I know this is documented somewhere, because I've seen it, but I can't find it now, nor remember exactly what it said. When I try to connect to the mysql server (mysql -u root -p table), I get an error about /tmp/mysql.sock. I've searched both http://lists.mysql.com/ and http://www.mysql.com/manual.php using the available search functions, and leafed through Paul's mysql book and can't find it, which drives me bats because I KNOW I've seen it somewhere Anyway, what is the problem here? Do I have to take it down and start it up again? I'm pretty sure the problem is that the file has been deleted, probably a cron job, but I can't remember the fix. Tried touching it to make it exist again, but of course no go. (And a pointer to the documentation would be welcomed, too...) Thanks, --Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: triggers, stored procedures, and views
Sounds like we just need a table to keep track of LAST_INSERT_ID per table. C:heers -Original Message- From: jds [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 7:05 AM To: [EMAIL PROTECTED] Cc: David T. Anderson Subject: triggers, stored procedures, and views I am building a database system and have been, like many before me, quite surprised that MySQL doesn't support triggers, sp's, and views. I can see how one can get around not having views with advanced permissions, as stated in the manual, although as I understand it this is no substitue for views- it is simply a workaround. I want to be very clear in explicating my understanding that MysQL is an open source technology, and putting it next to MS sQL Server 7 is not a fair comparison, as MS has invested many millions in that product over the years developing features...as has Oracle. It's kind of like putting AbiWord next to MS Word...apples to oranges... But not having triggers DOES make implementation of a transactional layer very difficult. I'm wondering if anyone that has encountered this problem and found a suitable solution would be so kind as to share his/her experience with myself and the rest of the list? Or do the developers have any suggestions? Perhaps a collection of Perl scripts sending records to a transactional table as well as the main data tables??? but then I would have to code this for all the different operations that take place when one of the data editors touches the database. Thanks in advance to anyone willing to approach this subject and share their experiences. Regards, jd -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 6:26 AM To: [EMAIL PROTECTED] Subject: Is Triggers Possible in MySQL sreedhar, Wednesday, January 30, 2002, 6:02:35 AM, you wrote: s Hi All s Is Triggers Possible in MySQL. If Yes, It is like in other RDBMS. MySQL doesn't support triggers, look at: http://www.mysql.com/doc/A/N/ANSI_diff_Triggers.html s regards, s SREEDHAR -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Change password
update user set Password = PASSWORD('mypassword') where User = 'myuserid'; http://www.mysql.com/doc/P/a/Passwords.html C:ya -Original Message- From: Yuxia Li [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 4:54 PM To: [EMAIL PROTECTED] Subject: Change password Hi: The administor created a mysql database library for me at my home directry. He didn't set a password for me. I don't know how to set my password for my database. I tried using: -mysql library mysql - set PASSWORD=PASSWORD('mypassword'); in the command but it didn't work. I need a help!! Thank you. Helen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to send multiple statements to the server?
You can place your statements into a file, e.g. numuser.sql, and redirect this into mysql client: use mysql; select count(User) from user; F:\MySQL\binmysql -uroot numuser.sql count(User) 4 -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 9:14 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: How to send multiple statements to the server? Can't be done. I know. I tried. I asked the same question several months ago. I wish we could do so. -Original Message- From: root [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:36 AM To: [EMAIL PROTECTED] Subject: How to send multiple statements to the server? Hi! i'm using mysql 3.23.47 and i'm triing to send 2 or more statements in one string separated with ';' but i does not work. some ideas? blestan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: count(distinct
F:\MySQL\binmysql -uroot -e select distinct count(*) from user \G mysql *** 1. row *** count(*): 4 Xi2 ('sE-'tü) -Original Message- From: Ilic [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 5:54 AM To: [EMAIL PROTECTED] Subject: Re: count(distinct Il Tue, 08 Jan 2002 13:23:09 -0500, Stephen Abshire andava dicendo... SELECT count(distinct ip) FROM pole_voti It does'nt work. Why ? PhpMyAdmin says: You have an error in your SQL syntax near 'distinct ip) FROM pole_voti' at line 1 I don't have MySQL on the computer I am on to test this but you might try rewriting it this way: select count(distinct(ip)) from pole_voit Already done. It does'nt work to. Ilic. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: count(distinct
Same here: F:\MySQL\binmysql -uroot -e select count(distinct Host) from user \G mysql *** 1. row *** count(distinct Host): 2 F:\MySQL\binmysql -v Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 to server version: 3.23.39-nt Xi2 -Original Message- From: Stephen Abshire [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 7:21 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: count(distinct I am inclined to think (actually guess) it may be the version of MySQL you are using. I am using MySQL 3.23.39 and I am able to successfully execute: select count(distinct field) or select count(distinct(field)) I tried to make a quick check of the docs to see if a certain version was required but I was unable to find anything. Original Message Follows From: Ilic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: count(distinct Date: Wed, 9 Jan 2002 14:54:12 +0100 Il Tue, 08 Jan 2002 13:23:09 -0500, Stephen Abshire andava dicendo... SELECT count(distinct ip) FROM pole_voti It does'nt work. Why ? PhpMyAdmin says: You have an error in your SQL syntax near 'distinct ip) FROM pole_voti' at line 1 I don't have MySQL on the computer I am on to test this but you might try rewriting it this way: select count(distinct(ip)) from pole_voit Already done. It does'nt work to. Ilic. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql query - SUM(field) iff 600
This will help, it seems: http://www.mysql.com/articles/wizard/page3.html Xi2 -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 10:11 AM To: [EMAIL PROTECTED] Subject: mysql query I am trying to write a query that gets the name of every carrier who has done more than $600 in loads. Can anyone help? SELECT c.name FROM carrier c, loads l WHERE c.CID_NO = l.CID_NO AND SUM(l.amount 600); This, unfortunately does not work. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: count(distinct
The syntax is: SELECT DISTINCT http://www.mysql.com/doc/S/E/SELECT.html Xi2 -Original Message- From: Ilic [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 9:48 AM To: [EMAIL PROTECTED] Subject: count(distinct SELECT count(distinct ip) FROM pole_voti It does'nt work. Why ? PhpMyAdmin says: You have an error in your SQL syntax near 'distinct ip) FROM pole_voti' at line 1 Why ? Where is the error ? Ilic. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Updating tables via cron
Here is a select statement, as example: mysql -e select * from user \G mysql Add user and password as required. Xi2 ('sE-'tü) -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 8:57 AM To: [EMAIL PROTECTED] Subject: Updating tables via cron I tried to search the archives for this but I can't find it. (Not saying it isn't there just I could not find it.) I have a table that tracks events on a monthly and daily basis. Currently I am resetting the appropriate fields to 0 on a daily and monthly basis (not fun). Is there a way to set a command in the cron table to do this for me automatically? Here are the details. db name: activity daily field name: dr (needs to be reset to 0) monthly field name: mr (same as above) I know how to tell cron the date/time I want an event to trigger, but I don't know the syntax of the command to send. Any help would be appreciated. Thanks, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ODBC DRIVERS for MYSQL
PROBLEM there is NO SYSTEM DSN offered to add under the add button under the SYSTEM DSN tab After clicking the Add button under the System DSN tab, you scroll to and select MySQL then continue. Xi2 -Original Message- From: Peter Reck [mailto:[EMAIL PROTECTED]] Sent: Friday, December 28, 2001 3:31 PM To: [EMAIL PROTECTED] Subject: ODBC DRIVERS for MYSQL A newbie question: DESIRED FUNCTION: to import data from MySQL db to MS word through webquery ODBC I was guided to install myODBC by going to http://www.mhysql.com --- downloads -API's --MyODBC myODBC 2.5.39 DOWNLOADED, UNIZPPED AND INSTALLED I was told to add a NEW SYSTEM DSN for MySQL PROBLEM there is NO SYSTEM DSN offered to add under the add button under the SYSTEM DSN tab QUESTION How can I set up the required DSN for my SQL? Any help is greatle appreciated! Aloha, Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php