Re: Hanging Database
While I was away from the Internet, it struck me that the problem has to do with a python egg, not, as you mention, with MySQL. Thanks, Pat Baron Schwartz [EMAIL PROTECTED] wrote: Hi, First up, the sites were working fine until the old server went buggy. I hadn't worked on either of the shopping carts, so they should have been fine when I transfered them over. No, I'm confident there is nothing wrong with my code, etc. I suspect it has something to do with copying over the database, which was strange. Certain databases didn't copy over for some reason, and I had to install them manually. Plus, the permissions database (whichever that is, forgive my ignorance) didn't copy and I just recreated it (that is, created the correct user gave the permissions to the proper databases). Now, here's the output from mytop: 2 mysqluser localhost mrtableclo 0 Sleep 14 root localhost test 0 Query show full processlist 4 mysqluser localhost mrtableclo 6154 Sleep 3 mysqluser localhost mrtableclo 9210 Sleep So, apparently it's asleep. How do I wake it up ;) 'Sleep' means the connection is idle, waiting for a query. You have a connection that has been idle, waiting for a query, for 9210 seconds -- that's about 2:30:00. Is your website running a query and then getting into an infinite loop on the result, or do you expect a connection to be held open this long due to connection pooling or for some other reason? If your application closes its connections after rendering the page, you shouldn't be seeing that unless there's a connection pool. You also have a connection that just finished a query and has been idle for 0 seconds. That may or may not mean anything... you know the code. But it doesn't look like anything is wrong with MySQL, so you're probably on the wrong list and need to address it with Zope or whoever else is responsible (sorry, I don't know much about the technologies you're using). Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.
Hanging Database
Hi; I just built out a new server and transfered my databases. I use Zope to server my web sites and ZMySQLDA to interface between the two. Everything seems to be fine. I can see the databases, the tables, the columns in the tables, the permissions are correct, etc. I hook up ZMySQLDA and that seems to be fine. It connects to the database. However, when I go to look at the pages from served the database, the browser hangs. Any ideas how to troubleshoot this? TIA, Pat - Shape Yahoo! in your own image. Join our Network Research Panel today!
Re: Hanging Database
First up, the sites were working fine until the old server went buggy. I hadn't worked on either of the shopping carts, so they should have been fine when I transfered them over. No, I'm confident there is nothing wrong with my code, etc. I suspect it has something to do with copying over the database, which was strange. Certain databases didn't copy over for some reason, and I had to install them manually. Plus, the permissions database (whichever that is, forgive my ignorance) didn't copy and I just recreated it (that is, created the correct user gave the permissions to the proper databases). Now, here's the output from mytop: 2 mysqluser localhost mrtableclo 0 Sleep 14 root localhost test 0 Query show full processlist 4 mysqluser localhost mrtableclo 6154 Sleep 3 mysqluser localhost mrtableclo 9210 Sleep So, apparently it's asleep. How do I wake it up ;) TIA, Pat Baron Schwartz [EMAIL PROTECTED] wrote: Hi, Pat Singer wrote: Hi; I just built out a new server and transfered my databases. I use Zope to server my web sites and ZMySQLDA to interface between the two. Everything seems to be fine. I can see the databases, the tables, the columns in the tables, the permissions are correct, etc. I hook up ZMySQLDA and that seems to be fine. It connects to the database. However, when I go to look at the pages from served the database, the browser hangs. Any ideas how to troubleshoot this? Is it really the database that's hanging? Use innotop or mytop to see if a query is stuck. Maybe the problem is in your code or on the web server, not the database. Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us.
Re: Any explanation for this, please
On Wed, 2006-11-29 at 14:31 -0500, Mikhail Berman wrote: Dear List, Could I get an explanation why 1 fails, but 2 works. 1. Update statement preceded with explain, fails: explain update COMPANY_NUMBERS_tmp_Mikhail c join tmp_HEMSCOTT_MKTVALUES t on c.ticker = t.TickerSymbol and t.InterimEndingDate = replace(left(c.date_qtr,7),'-','/') set c.total_shares_outstanding_market_cap = t.MarketValue; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update COMPANY_NUMBERS_tmp_Mikhail c join tmp_HEMSCOTT_MKTVALUES t on c.ticker =' at line 1 Explain only works with tables and SELECT queries: http://dev.mysql.com/doc/refman/4.1/en/explain.html -- Pat Adams Digital Darkness Promotions Dallas Music Wiki http://digitaldarkness.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql on a NAS
On Tue, 2006-11-28 at 17:58 +0100, Stefan Onken wrote: Can you explain this a little bit more ? I am not the guy who set it up, so I would like to go back them and say Well, You cannot do this, because... :) http://dev.mysql.com/doc/refman/5.1/en/multiple-servers.html describes the pitfalls of running multiple servers on the same machine about halfway down the page in the bold 'Warning' paragraph. -- Pat Adams Digital Darkness Promotions Dallas Music Wiki http://digitaldarkness.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: java mysql alias is being displayed blank?
On Wed, 2006-10-11 at 16:03 -0700, ADAM CZECH wrote: Does anyone know why a mysql alias would not display in the return a result? When I try to access say the first name with it's alias f_name, it is blank? , but it works for its column name first_name? This becomes more of a problem with subselects because how does one alias it? Servlet sql: sql = SELECT + u.id as user_id, + u.first_name as fname, + You're aliasing it as fname, not f_name. -- Pat Adams Digital Darkness Promotions Dallas Music Wiki http://digitaldarkness.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Keys should not both be set for column...
On Sat, 2006-09-30 at 12:51 -0700, Brian Dunning wrote: phpMyAdmin is giving me the following warning: PRIMARY and INDEX keys should not both be set for column `referer` Here is what the table looks like: CREATE TABLE `myspacemap_visitors_2` ( `creation` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `lat` double NOT NULL default '0', `lon` double NOT NULL default '0', `referer` int(12) NOT NULL default '0', PRIMARY KEY (`referer`,`lat`,`lon`), KEY `creation` (`creation`,`referer`), KEY `referer` (`referer`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; What does this warning mean, and should I do anything about it or just ignore it? Everything is working fine. MySQL is trying to tell you that you've got the same index defined twice. Since the leftmost column in your primary key is referer, you do not need it as its own index. -- Pat Adams Digital Darkness Promotions Check out the Dallas Music Wiki http://digitaldarkness.com signature.asc Description: This is a digitally signed message part
Re: How To Pronounce MySQL
On Mon, 2006-06-12 at 13:32 -0400, Jesse wrote: Um, did anyone actually answer Jesse's question? The consensus seems to be that the correct way to pronounce it is My S-Q-L, Not My Sequel. So, that's the way I'm going to pronounce it. Actually, most of the people I say the name to have no idea what I'm talking about anyway. I only rarely have vocal communication with someone who would even know what a database is, let alone what MySQL is. So, I guess in the long run, it doesn't really matter, but just for those rare occassions when I'm talking with someone who knows what it is, I want to pronounce it right. Most of my technical conversations occur through e-mail or newsgroups like this one, in which I spell it MySQL, and the way it's pronounced doesn't matter. :-) According to the manual (http://dev.mysql.com/doc/refman/5.0/en/what-is.html): The official way to pronounce “MySQL” is “My Ess Que Ell” (not “my sequel”), but we don't mind if you pronounce it as “my sequel” or in some other localized way. -- omni Check out the Dallas Music Wiki http://digitaldarkness.com The information contained in this e-mail, if any, is often incorrect and probably plagiarized. It is intended solely for the amusement of the addressee. If you are not the intended recipient, my bad. Any action taken or omitted to be taken in reliance on the information in this message is your problem. Please notify me immediately if you have received it in error by reply e-mail and then delete this message from your system and any files in it's vicinity. I endeavour to ensure that my emails and any attachments are free from viruses, content, value or other contaminants. However, I cannot accept any responsibility might something worthwhile accidentally slip in. I therefore recommend you do not read them at all just to be sure. Please note that the statements and views expressed in this email and any attachments are completely chosen at random by the author and do not necessarily represent anything coherent, relevant or useful. signature.asc Description: This is a digitally signed message part
Re: Quick Linux/MySQL performance questions. (fwd)
On Fri, 2006-05-12 at 10:59 -0400, RV Tec wrote: Yeah, I'm aware of that. Since glibc 2.4 has only NPTL, I was wondering if it is possible to MySQL use a threading system of its own. However, what I want to know, is a way to confirm that it has been compiled against NPTL. This appears on my config.log session: --enable-threads=posix Thread model: posix Is that NPTL? I know NPTL is POSIX, but maybe this should say Thread model: NPTL. NPTL stands for Native POSIX Thread Library, so yeah, it's using NPTL. -- Pat Adams Digital Darkness Promotions Check out the Dallas Music Wiki http://digitaldarkness.com/tiki signature.asc Description: This is a digitally signed message part
RE: Help with subqueries... MAX() and GROUP BY
On Fri, 2006-04-28 at 00:13 -0700, Daevid Vincent wrote: The problem is now that I can't get the right data. mysql select max(created_on), user_id, id from logs group by user_id; +-+-++ | max(created_on) | user_id | id | +-+-++ | 2006-04-25 20:10:59 | NULL| 4 | | 2006-04-27 23:48:27 | 1 | 50 | -- 456 | 2006-04-27 22:18:35 | 2 | 16 | -- 431 +-+-++ The max date is correct but that isn't the correspoinding action id, they should be 456 and 431 instead... If you don't include id in either an aggregate function or the GROUP BY clause, MySQL 'helps' you by choosing a seemingly-random value to stick in the id field. -- Pat Adams Digital Darkness Promotions Check out the Dallas Music Wiki http://digitaldarkness.com/tiki signature.asc Description: This is a digitally signed message part
Re: Combining ansi and theta joins bug?
On Fri, 2006-04-21 at 11:42 -0500, Duzenbury, Rich wrote: Is there some known bug about combining theta and ansi style joins in the same query? As I say, this works on a 4.1 server, and it will be troublesome to convert all of the old queries in order to upgrade. In MySQL 5.0.12 they changed the way MySQL handles joins to conform to the ANSI standard. http://dev.mysql.com/doc/refman/5.0/en/join.html Previously, the comma operator (,) and JOIN both had the same precedence, so the join expression t1, t2 JOIN t3 was interpreted as ((t1, t2) JOIN t3). Now JOIN has higher precedence, so the expression is interpreted as (t1, (t2 JOIN t3)). This change affects statements that use an ON clause, because that clause can refer only to columns in the operands of the join, and the change in precedence changes interpretation of what those operands are. -- Pat Adams Digital Darkness Promotions Check out the Dallas Music Wiki http://digitaldarkness.com/tiki signature.asc Description: This is a digitally signed message part
RE: Form value editing
On Thu, 2006-04-20 at 19:15 -0400, fbsd wrote: can someone please just send me or post a example of editing feilds of a mysql database within an html form and then updating the values thanks alot These should tell you everything you need to know. http://www.php.net/manual/en/ref.mysql.php http://dev.mysql.com/doc/refman/5.0/en/insert.html http://dev.mysql.com/doc/refman/5.0/en/update.html http://dev.mysql.com/doc/refman/5.0/en/select.html -- omni Digital Darkness Promotions Check out the Dallas Music Wiki http://digitaldarkness.com/tiki signature.asc Description: This is a digitally signed message part
Re: mysql_query gives Resource id #3 error
On Sat, 2006-03-11 at 12:53 -0500, fbsd_user wrote:
$sql = SELECT logon_id
FROM members
WHERE logon_id = '$logonid' AND logon_pw =
'$logonpw';
$result = mysql_query($sql) or die('Query failed. ' .
mysql_error());
print $result; shows Resource id #3
Where can I find meaning for what this means?
And why does mysql_error() not contain the description of this
error?
And why was the 'or die' condition not taken?
Try print($result[0]) or print($result['logon_id']); $result is a handle
to the result set, not something you can print. It's the same thing as
if you tried to print out the return value of mysql_connect, which
should return a resource id. There wasn't an error with the query, so
the or die shouldn't execute, and mysql_error should return null.
--
Pat Adams
Digital Darkness Promotions
Check out the Dallas Music Wiki http://digitaldarkness.com/tiki
signature.asc
Description: This is a digitally signed message part
Re: inquiry
On Wed, 2006-02-22 at 03:47 -0800, Anago Chima wrote: Q: What do the exams cost? A: Both exams are offered at the local equivalent of US$200 / EUR 170*. This question and answer was copied from certification FAQ. Please can somebody tell me 'both' means in the answer here. Does it mean that the price for both MySQL Developer Exam I II are US $200? ie US $200 cover the two exams $200 for the core certification, and $200 for the Professional Certification. -- Pat Adams Digital Darkness Promotions Check out the Dallas Music Wiki http://digitaldarkness.com/tiki signature.asc Description: This is a digitally signed message part
Re: install trouble, perl DBI
On Mon, 2005-12-12 at 15:20 +, Lewis Ashley Foster wrote: warning: MySQL-server-standard-5.0.16-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: perl(DBI) is needed by MySQL-server-standard-5.0.16-0.rhel3 Suggested resolutions: perl-DBI-1.32-5.i386.rpm But I have already installed perl dbi 1.40 like this with no errors: rpm -ivh perl-DBI-1.40-5.src.rpm You're installing the source RPM, which you would then have to build and install yourself. Try installing the perl-DBI RPM without src in the filename. -- Pat Adams Digital Darkness Promotions Check out the Dallas Music Wiki http://digitaldarkness.com/tiki -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: need help with foreign keys, new to mysql
On Wed, 2005-08-24 at 06:11 -0500, John Gonzales wrote: CREATE TABLE `journal` ( `journal_id` int(10) unsigned NOT NULL auto_increment, `journal_category` int(10) unsigned NOT NULL default '1', `journal_datetime_created` timestamp NOT NULL default CURRENT_TIMESTAMP, `journal_datetime_modified` timestamp NOT NULL default '-00-00 00:00:00', `journal_title` varchar(50) NOT NULL default 'no title', `journal_entry` blob NOT NULL, PRIMARY KEY (`journal_category`), KEY `journal_category` (`journal_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 [jg.] CREATE TABLE comments ( comment_id INT, comment_journal_id INT, INDEX jrn_id (journal_id), FOREIGN KEY (comment_journal_id) REFERENCES journal (journal_id) ON DELETE CASCADE ON UPDATE CASCADE ) TYPE = INNODB; I got this as a respsone: Key column 'journal_id' doesn't exist in table From the manual: http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html Corresponding columns in the foreign key and the referenced key must have similar internal data types inside InnoDB so that they can be compared without a type conversion. The size and the signedness of integer types has to be the same. You've got an INT in comments table and an int(10) unsigned in the journal table. They need to match in signedness. -- Pat Adams Applications Programmer SYSCO Food Services of Dallas signature.asc Description: This is a digitally signed message part
Re: BLOCK SELECT INTO OUTFILE ?
On Wed, 2005-08-24 at 10:11 -0300, Alejandro Gad wrote: Hi, I am going to implement a mysql hosting, and I would to make a question, if a mysql-user with only a SELECT privilege make this query: SELECT * FROM table1 INTO OUTFILE '/mysqldb/data/test.sql'; the result is a file in this path with the content of the table. I could think that a malicious user can do several querys like this and fill my disk. How could I secure this command ? From the manual: http://dev.mysql.com/doc/mysql/en/select.html The SELECT ... INTO OUTFILE 'file_name' form of SELECT writes the selected rows to a file. The file is created on the server host, so you must have the FILE privilege to use this syntax. The file cannot currently exist, which among other things prevents files such as /etc/passwd and database tables from being destroyed. If you take away the FILE privilege they won't be able to write out the filesystem. -- Pat Adams Applications Programmer SYSCO Food Services of Dallas signature.asc Description: This is a digitally signed message part
RE: Linux vs. Windows?
On Fri, 2005-08-12 at 09:55 -0500, Jay Blanchard wrote: [snip] Same machine, any performance difference? [/snip] Yes. Linux will consistently outperform Windows in many areas. Except for those areas that it doesn't. -- Pat Adams Applications Programmer SYSCO Food Services of Dallas signature.asc Description: This is a digitally signed message part
RE: Linux vs. Windows?
On Fri, 2005-08-12 at 09:30 -0600, Duke, Brian wrote: Like crashing, auto-rebooting, memory leaking, program cost, etc... -Original Message- From: Pat Adams [mailto:[EMAIL PROTECTED] Sent: Friday, August 12, 2005 9:21 AM To: mysql@lists.mysql.com Subject: RE: Linux vs. Windows? On Fri, 2005-08-12 at 09:55 -0500, Jay Blanchard wrote: [snip] Same machine, any performance difference? [/snip] Yes. Linux will consistently outperform Windows in many areas. Except for those areas that it doesn't. In all seriousness, what operating system you use should not be based on expected performance. It should be based on your ability to administer it. If I were to test the performance of MySQL on two identical machines, one running Windows and one running Debian, I can almost guarantee that the Linux box would blow the Windows box away. On the flip side, my company would be better off running MySQL on a Windows box rather then one of our Solaris or AIX boxen, since none of us know much about them (they're maintained by our corporate office). Even though Linux more or less acts like its big UNIX cousins, the nitty gritty details of system administration, security, and patching are much difference. So put your database on whatever platform you're comfortable running. If you can secure a Windows box and make it stable, use Windows. If you can secure a Debian or RedHat or insert flavor of UNIX/Linux here, use it. You'll get a much higher return on investment from making sure that the server itself is set up correctly and the tables and queries that run on it are set up correctly then you will tuning e2fs parameters on a Linux box, or whatever it is that Windows admins do to make their boxen faster. -- Pat Adams Applications Programmer SYSCO Food Services of Dallas signature.asc Description: This is a digitally signed message part
Re: True randominess
On Thu, 2005-08-04 at 15:00 -0400, Scott Hamm wrote: I've noticed that rand() do not change on each query request. Is there a way I could get a TRUE randominess into MySQL? http://dev.mysql.com/doc/mysql/en/mathematical-functions.html Are you using RAND() or RAND(n)? Using RAND() makes MySQL choose its own seed (the documentation doesn't specify what seed it will use). If you choose to seed the random number generator (for example, RAND(3)) and then start using RAND() it will produce a repeatable sequence. mysql SELECT rand(3), rand(), rand(); +--+--+--+ | rand(3) | rand() | rand() | +--+--+--+ | 0.18109050875631 | 0.75023213843837 | 0.20788919665654 | +--+--+--+ 1 row in set (0.00 sec) mysql SELECT rand(), rand(), rand(); +--+--+--+ | rand() | rand() | rand() | +--+--+--+ | 0.78874959870125 | 0.32008043427028 | 0.23415340598128 | +--+--+--+ 1 row in set (0.01 sec) mysql SELECT rand(3), rand(), rand(); +--+--+--+ | rand(3) | rand() | rand() | +--+--+--+ | 0.18109050875631 | 0.75023213843837 | 0.20788919665654 | +--+--+--+ 1 row in set (0.00 sec) Notice that the numbers after calling RAND(3) are in the same sequence. However, in answer to your question, there is no way to get TRUE randomness in a computer system. Even cryptographically secure random number generators can be predicted under absolutely identical circumstances. -- Pat Adams Applications Programmer SYSCO Food Services of Dallas signature.asc Description: This is a digitally signed message part
Re: True randominess
On Thu, 2005-08-04 at 14:44 -0500, 2wsxdr5 wrote: There are also several places that you can get a reasonably random number for the seed from your machine. The amount of free disk space, unless that doesn't change much on your machine. The amount of free RAM, (up time mod cpu usage). Any number of things could be used that are not very predictable, if at all. But again, those aren't truely random. They're random-enough for the average web applications. The original poster, if memory serves, asked if it was possible to get true random numbers from MySQL. True random numbers can't be predicted even if I know everything about your system. Because computers are predictable beasts, the random number generators that they used are constrained by the hardware limits. But it's really just a semantic difference. Seeding with digits from the least significant part of a UNIX timestamp would be sufficient to seed a RNG randomly enough for average web applications, but it's not truely random, since a web log will show what time the user hit the application, and you can figure out what the RNG was seeded with at that point. -- Pat Adams Applications Programmer SYSCO Food Services of Dallas signature.asc Description: This is a digitally signed message part
Re: Help need search database
On Fri, 2005-07-29 at 14:00 +0200, Gregory Machin wrote: I need search all the tables in a database for a single string. I'm trying to figure out how, where and what other tables exponent cms saves it text pages and references to, so i can finish writing a mass page import module In short can mysql do a recursive search, through all the table's in a database .. I'm not aware of a way to do a recursive search, but I've had to solve a similar problem before. This command: grep -H --binary-files=text search_string *MYD | cut -f1 -d: | sort -u run in a database directory on a *NIX box (or Windows with Cygwin) will print out the tables that contain search_string. It takes a while, but it gives you the information you're looking for. I probably wouldn't run that on my tables if they're being written to, but I haven't had a problem (yet). -- Pat Adams Applications Programmer SYSCO Food Services of Dallas signature.asc Description: This is a digitally signed message part
RE: license question
--- Daevid Vincent [EMAIL PROTECTED] wrote: As my company and I understand it, if you intend on distributing mySQL on this appliance and the appliance is a sealed box yes with your own proprietary code (like PHP or C or Java or whatever) that interfaces to the STOCK/Untouched RDBMS It's like this: my_code -- stock PHP/Apache -- stock MySQL you NEED a mySQL Commercial License. wowza! :-( This license is a ridiculous $600 per unit which makes it completely unrealistic for any large scale deployment!!! Well, it means your profit per unit (not counting SQL expenses) must be significantly higher than $600 Not easy, given the fierce competition in the current market. If someone from mySQL can clarify that would be great I agree that the license is murky. That's why i actually asked mysql.com a question through official channels. I'm waiting their response. -- Pat Ballard __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
license question
Suppose i distribute MySQL-4.1 with an appliance, which is a sealed x86 machine running a Linux distribution made by another entity (ok, it's Red Hat). I don't write any code that's directly linked to MySQL, I'm only using the existing php-mysql, etc., packages already provided by the distribution, plus some third-party apps that are under GPL and link to MySQL (applications that access MySQL, not written by me, but are Open Source GPL projects off SourceForge and other places - i just bundle them with the appliance). Any code that I write personally is PHP and sits on top of the php-mysql module provided by Red Hat. The end-user has no direct visibility to the database, in fact, the end-user might never know it's MySQL - all that is visible is the PHP interface, via Apache. In this case, what's the license? Is MySQL still free (under GPL)? -- Pat Ballard __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: license question
--- [EMAIL PROTECTED] wrote: I thought that was discussed before over and over on this mailinglist. I am surprised that many people have isues with that topic. Well... 1. Licensing in general can be quite confusing for a non-lawyer geek 2. I want to make 101% sure I don't take any wrong steps before hitting the market. 1) Will you include and ditsribute the source code and the changes (if any) and the GPL license in your product ? The MySQL source code, you mean? Well, it's a sealed appliance, a black box from the customer's p.o.v. (duh, think of it as a VCR or a toaster), but sure, i can throw in a CD with source code and stuff if it's necessary. I don't plan to make any changes or write any code that even remotely touches MySQL. The only connection between the code that I write and MySQL is via php-mysql / httpd If yes, than you DONT need a commercial license. if NO, (in other words you dont want to publish any changes you made to the code) then you need a commercial license. I'm not making any changes to MySQL whatsoever. 2) Are you selling the product or a service ? If you are trying to sell the customer the very same MySQL product for $$ that he can download, then you must be good at sales, no questions asked. Same reasoning would apply to the hundreds, if not thousands other appliances currently on the market which are also running Linux (which is also something that the customer can download for free). Are all of those companies just good at sales? Case in point: the Linksys routers which everyone owns and which run Linux. My appliance is the same. It just happens it needs a SQL backend. Might be MySQL. Might be PostgreSQL if either/or it's faster in my particular case or more liberally licensed than MySQL (which are things I'm still investigating). Might be something else. shrug -- Pat Ballard __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: search through one/several tables
The best I've been able to come up with involves some shell scripting. If you're running Linux, using unpacked MyISAM tables, and have some scripting ability from whatever language you're writing your application in, you can run this in your MySQL directory: strings -f *.MYD | grep search string | cut -f1 -d'.' | sort -u It will give you back the table names that have that string somewhere inside them. Then in your scripting language you can check the columns on just the tables that the shell script returned. Note that it is NOT fast at all. My 1.7GB of database takes about 10 minutes to crunch through the data. If you're going to do something like this make sure you understand the security ramifications of running shell scripts with user input and how to secure it in your language of choice. -- Pat Adams Applications Programmer SYSCO Food Services of Dallas, L.P. (469) 384-6009 -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 10:09 AM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: search through one/several tables I can find the data, I was just wondering if mysql provides a kind of generic scan of a whole table. I could provide an advanced search, and ask the user what kind of info he wants to retrieve but I first would like a quickSearch that may retrieve too much info but is more intuitive. As I said, my first idea was to create a script to go through all my tables and scan the relevant columns (I don't want to scan the id keys for example), but I was just wondering if given a table it is possible to use mysql to scan all its columns: -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Lost connection during query when using SSH tunneling
-Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 12:08 PM To: [EMAIL PROTECTED] Subject: Lost connection during query when using SSH tunneling So I use Putty to create the SSH tunneler and then connecting to the local port. Now the problem, is that whenever I execute a long query or something that returns big resultset, i get an error - Lost connection during query. If I use direct connection - everythings fine. Putty has an option in the Connection category of the configuration for Seconds between keepalives. It's set to zero (off) by default. If you set it to 0 number, putty will send a null packet at the server to try and keep the connection alive. Have you tried that? -- Pat Adams Applications Programmer SYSCO Food Services of Dallas, L.P. (469) 384-6009 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Lost connection during query when using SSH tunneling
-Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 2:17 PM To: Adams, Pat 006; [EMAIL PROTECTED] Subject: RE: Lost connection during query when using SSH tunneling I am not sure of Putty as I am using plink.exe that is the SSH tunneler for tunnel. The thing is that I call up plink.exe from my app to create an ssh tunnel and then set the correct values for mysql_real_connect() in my app. What I am doing is that I am bundling plink.exe with my app and then ask the user for SSH info. Depending upon that I create a plink.exe process and then connect my app to the SSH process. I referred to Putty as many people seem to be using it and putty usese plink.exe which is the back end for it. Should I look into some options like what you suggested? plink can use putty's saved sessions, so you could set one of those up. Unfortunately it doesn't look like there's a command-line option to set the timeout or keepalive settings of plink. -- Pat Adams Applications Programmer SYSCO Food Services of Dallas, L.P. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Conditonal where
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 14, 2004 11:30 AM
To: [EMAIL PROTECTED]
Subject: Conditonal where
?php
$sql .= SELECT PostStart, JobTitle, Industry,
LocationState, VendorID FROM VendorJobs;
if ($s_Ind){
$sql .= WHERE VendorJobs.Industry IN ($s_Ind); }
if ($s_State){
$sql .= AND VendorJobs.LocationState IN ($s_State); }
What I think I need is some kind of default WHERE in the
first statement. Both Ind and State are conditional based on
whether the user input anything.
Right now they would be forced to at least choose the Ind.
So instead of the $s_Ind have a WHERE it should be an AND .
You could add a where condition that's always true to the main part of
the SQL statement so that you can just tack on more clauses
conditionally.
$sql .= SELECT PostStart, JobTitle, Industry, LocationState, VendorID
. FROM VendorJobs
. WHERE 1 = 1 ;
if ($s_Ind) {
$sql .= AND VendorJobs.Industry IN ($s_Ind) ;
}
if ($s_State) {
$sql .= AND VendorJobs.LocationState IN ($s_State);
}
--
Pat Adams
Applications Programmer
SYSCO Food Services of Dallas, L.P.
(469) 384-6009
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: SQL Syntax Problem
-Original Message-
From: David Blomstrom [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 10, 2004 4:08 PM
To: [EMAIL PROTECTED]
Subject: SQL Syntax Problem
$sql = 'SELECT
F.IDArea,
C.IDArea, C.Name, C.Pop, C.Nationality,
C.NationalityPlural, C.NationalityAdjective FROM cia_people
C, famarea2 F WHERE (C.Nationality is not null) AND (F.IDArea
= \'eur\') ORDER BY $_POST[\'order\'],
$_POST[\'direction\']'; $res = mysql_query($sql) or
die('Failed to run ' .
$sql . ' - ' . mysql_error());
If you change the single quotes on the outside of the SQL statement to
double quotes, PHP will parse variables inside the string. Try
$sql = SELECT F.IDArea, C.IDArea, C.Name, C.Pop, C.Nationality,
C.NationalityPlural, C.NationalityAdjective
. FROM cia_people C, famarea2 F
. WHERE (C.Nationality is not null) AND (F.IDArea = 'eur')
. ORDER BY {$_POST['order']}, {$_POST['direction']};
Notice that you need to put the variables in curly braces when you have
arrays being parsed.
--
Pat Adams
Applications Programmer
SYSCO Food Services of Dallas, L.P.
(469) 384-6009
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
R: myisamchk -R
Thnks a lot Patrizio -Messaggio originale- Da: Egor Egorov [mailto:[EMAIL PROTECTED] Inviato: lunedì 21 luglio 2003 14.02 A: [EMAIL PROTECTED] Oggetto: Re: myisamchk -R PaT! [EMAIL PROTECTED] wrote: I need a hint how to use myisamchk I use this syntax in a shell but it doesn't work myisamchk -R=ID \mysql\data\db\mytable.myi ID is the index name I want to use to sort the table I'm using mysql 4.0.13 on Win 2K server myisamchk -Rindex_number /path/to/the/index/file/table_name.MYI Index number you can see using SHOW INDEX command. For example: myisamchk -R1 /var/lib/mysql/mydatabase/table1.MYI -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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]
create index
Hi, I have a table: +-+--+--+-+-+--- -+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+--- -+ | id | int(11) | | PRI | NULL| auto_increment | | NUMFATT | int(5) unsigned zerofill | | | 0 | | | dataemiss | date | YES | | NULL| | +-+--+--+-+-+--- -+ (the table has more fields but I removed them to semplify the view of it) where I want to create a UNIQUE index with two tables 'dataemiss' and 'NUMFATT' 'dataemiss' is a date format and in the index I want to consider just the year part of the date. I cannot change the field type setting it as a string (ex. char, var, etc.). any hint on how to do it? The goal of this is index is to avoid to insert the same 'NUMFATT' twice or more in the same year. I'm using MySQL 4.0.13 on Win 2K server Thanks Patrizio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
myisamchk -R
Hi, I need a hint how to use myisamchk I use this syntax in a shell but it doesn't work myisamchk -R=ID \mysql\data\db\mytable.myi ID is the index name I want to use to sort the table I'm using mysql 4.0.13 on Win 2K server Thanks for help Patrizio
R: sum() problems - I don't understand
Exactly that's the problem! how can I rewrite the query syntax avoiding the multiplication? Thanks Patrizio -Messaggio originale- Da: Keith C. Ivey [mailto:[EMAIL PROTECTED] Inviato: giovedì 26 giugno 2003 22.15 A: [EMAIL PROTECTED] Oggetto: Re: sum() problems - I don't understand On 26 Jun 2003 at 15:07, gerald_clark wrote: The second query contains a join and may have many times more rows in the result set. [snip] ++-+--++--+ | date1 | sum1| sum2 | cod| fromprev | ++-+--++--+ | 29-05-2003 | 436.498 | 10 | SC0001GP | 2666 | ++-+--++--+ [snip] | date1 | sum1 | sum2 | cod | fromprev | numprev | date2 | ++--+--+-+--+-+-- +--- ---+ | 29-05-2003 | 3491.984 | 80 | SC0001GP| 2666 |2666 | 28-05-2003 | ++--+--+-+--+-+-- In fact it appears that for this query there are 8 rows in 'carello' corresponding to each row in 'ordini', so the sums are multiplied by 8. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- 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]
sum() problems
Dear All, I have this two queries The first one gives me the right result for the sum(): SELECT DATE_FORMAT(ordini.dataord,'%d-%m-%Y'), SUM(ordini.totale), SUM(ordini.quantita), ordini.codcliente, ordini.fromprev FROM ordini WHERE ordini.numordine = 2302 GROUP BY ordini.numordine; this other one gives me problems with the sum(), wrong result. SELECT DATE_FORMAT(ordini.dataord,'%d-%m-%Y'), SUM(ordini.totale), SUM(ordini.quantita), ordini.codcliente, ordini.fromprev, carello.numprev, DATE_FORMAT(carello.dataordine,'%d-%m-%Y') FROM ordini, carello WHERE ordini.numordine = 2302 AND carello.numprev = ordini.fromprev GROUP BY ordini.numordine, carello.numprev; Help is appreciated I'm using mysql 4.0.13 Patrizio
sum() problems - I don't understand
Dear All, I have these two queries which are supposed to return the same results for the fields with the same name (ex query 1 sum1 = query 2 sum1): The first query gives me back the correct result for the sum(): SELECT DATE_FORMAT(ordini.dataord,'%d-%m-%Y') date1, SUM(ordini.totale) sum1, SUM(ordini.quantita) sum2, ordini.cod, ordini.fromprev FROMordini WHERE ordini.numordine = 2302 GROUP BYordini.numordine; ++-+--++--+ | date1 | sum1| sum2 | cod| fromprev | ++-+--++--+ | 29-05-2003 | 436.498 | 10 | SC0001GP | 2666 | ++-+--++--+ this other one gives me problems with the sum(), wrong result. SELECT DATE_FORMAT(ordini.dataord,'%d-%m-%Y') date1, SUM(ordini.totale) sum1, SUM(ordini.quantita) sum2, ordini.cod, ordini.fromprev, carello.numprev, DATE_FORMAT(carello.dataordine,'%d-%m-%Y') date2 FROM ordini, carello WHEREordini.numordine = 2302 AND carello.numprev = ordini.fromprev GROUP BY ordini.numordine, carello.numprev; ++--+--+-+--+-+- ---+ | date1 | sum1 | sum2 | cod | fromprev | numprev | date2 | ++--+--+-+--+-+- ---+ | 29-05-2003 | 3491.984 | 80 | SC0001GP| 2666 |2666 | 28-05-2003 | ++--+--+-+--+-+- ---+ Help is required. I run Mysql 4.0.13 Thanks Patrizio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I: UPDATE doesn't work
:-) didn't pay enough attention Thanks PaT! -Messaggio originale- Da: Keith C. Ivey [mailto:[EMAIL PROTECTED] Inviato: venerdì 6 giugno 2003 19.08 A: [EMAIL PROTECTED] Cc: PaT! Oggetto: Re: UPDATE doesn't work On 6 Jun 2003 at 19:00, PaT! wrote: mysql UPDATE ordini SET prezzo = prezzo/1.024, totale = totale/1.024 WHERE numordine1385 AND dataord'2003-06-01'; Query OK, 1649 rows affected (0.10 sec) Rows matched: 1650 Changed: 1649 Warnings: 0 These are the values after the UPDATE mysql SELECT prezzo, totale FROM ordini WHERE numordine=1157; +++ | prezzo | totale | +++ | 6.795 | 6.795 | | 13.835 | 13.835 | | 17.578 | 17.578 | | 62.500 | 62.500 | +++ 4 rows in set (0.02 sec) Why the values didn't update? Your update query has WHERE numordine 1385, but 1157 isn't greater than 1385. Why would you expect the values to be updated? -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
UPDATE doesn't work
Hi I'm running MySQL 4.0.13 MS Windows XP Prof I've this problem: A db with a table called 'ordini' mysql desc ordini; +-+---+--+-++--- -+ | Field | Type | Null | Key | Default| Extra | +-+---+--+-++--- -+ | id | int(11) | | PRI | NULL | auto_increment | | numordine | int(10) | | | 0 | | | descrizione | varchar(150) | | || | | marca | varchar(250) | | || | | modello | varchar(250) | | || | | generica| varchar(250) | | || | | quantita| int(10) | | | 0 | | | prezzo | decimal(10,3) | | | 0.000 | | | type| varchar(10) | | || | | dataord | date | | | -00-00 | | | nominativo | varchar(200) | | || | | totale | decimal(10,3) | | | 0.000 | | | fromprev| int(11) | YES | | NULL | | | ptype | varchar(20) | YES | | NULL | | | idutente| int(11) | YES | | NULL | | | codcliente | varchar(8)| YES | | NULL | | | datamod | date | YES | | NULL | | +-+---+--+-++--- -+ 17 rows in set (0.00 sec) I need to update some values in two fields 'prezzo' and 'totale' These are the values before the UPDATE mysql SELECT prezzo, totale FROM ordini WHERE numordine=1157; +++ | prezzo | totale | +++ | 6.795 | 6.795 | | 13.835 | 13.835 | | 17.578 | 17.578 | | 62.500 | 62.500 | +++ 4 rows in set (0.02 sec) this is the UPDATE query mysql UPDATE ordini SET prezzo = prezzo/1.024, totale = totale/1.024 WHERE numordine1385 AND dataord'2003-06-01'; Query OK, 1649 rows affected (0.10 sec) Rows matched: 1650 Changed: 1649 Warnings: 0 These are the values after the UPDATE mysql SELECT prezzo, totale FROM ordini WHERE numordine=1157; +++ | prezzo | totale | +++ | 6.795 | 6.795 | | 13.835 | 13.835 | | 17.578 | 17.578 | | 62.500 | 62.500 | +++ 4 rows in set (0.02 sec) Why the values didn't update? The same query applied on a single row works perfectly. Any help is appreciated PaT! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
permission problem
Hi, I'm using MySQL 4.0.13 OS Windows 2000 server SP3 I have the following problem: I had a local user that used regularly to access with winmysqladmin User name and no password Now it can access from the shell but can't from winmysqladmin anymore. Don't know why, I think I didn't change anything I tried to delete and recreate user and again it can access from the shell but not from the winmysqladmin Because I was using MySQL 3.23.53 I decided to upgrade to 4.0.13 hoping something 'broke' could be fixed but unfortunately nothing changed Help is appreciated Cheers PaT! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
select with random result
Hi, how can I write a select where I have a limit result of records but random. Something like SELECT * FROM table1 LIMIT RAND(10); I know this syntax is wrong I need to know the right one Thanks. PaT! mysql
renaming
Hi, I need to change a column name. I wonder if there's any faster and simpler way to do it than: ALTER TABLE table_name CHANGE old_column_name new_column_name create_clause; Thanks for the support. Patrizio Pino Roma - Italia 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
ORDER BY DESC, missing rows
I have a problem with a bulletin board type system. When a new message is posted the script redirects back to the page that displays the messages. If I do a simple query i.e. SELECT * FROM messages WHERE subject='$subject'ORDER BY ID Then all relevant messages are displayed including the one just added. If I want to display the last message first SELECT * FROM messages WHERE subject='$subject'ORDER BY ID DESC Then the last couple of messages are always missing! -- Best regards, Pat [EMAIL PROTECTED] - 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: Lower Level Visibility
I'm not entirely familiar with how the daemon stores these values for the entire database, but I'm guessing it's done in memory. Is it not possible to allocate storage for these values in memory for each table that has been opened?(they'd be removed once the table is destroyed, and not stored at all for temporary tables I guess). Another possibility might be to store the values in memory until the table is no longer in an open state (I'm assuming you don't flush and close the tables on every operation) and flush them to disk in the table closing code (hopefully reducing the latency of updating each time they change). I like the idea of having it saved on disk as it would allow for persistent values during outages, so long as the system as a whole doesn't take too much of a performance hit. What exactly is feature sponsoring? - Pat -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 20, 2001 7:27 AM To: wendorf, pat Cc: '[EMAIL PROTECTED]' Subject: Lower Level Visibility wendorf, pat writes: Is it possible to observe Handler_read_next and Handler_read_key on a per table basis? If not, could this feature be added? I'm not subscribed to this list, please cc all replies back to this email address. - Pat Wendorf Hi! It could be possible to implement it, but it would be more costly, as data would have to be saved on disk. Would you be willing to sponsor this feature ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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
Re: simple commands, no joy
Assuming you are trying to execute MySQL(SQL) commands from 'netsloth.dump', remove the 'redirect to' after the mysql command. This also assumes you are logged into the localhost using the command line interface. Your command would appear similar to the following: mysql -u jjames -psd342 dbtheNetee /Library/WebServer/web1/book/install/netsloth.dump Remove the trailing semi-colon from the command line. I hope this helps... Pat... [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 18, 2001 9:44 PM Subject: simple commands, no joy what's wrong with this please: mysql -u jjames -psd342 dbtheNetee /Library/WebServer/web1/book/install/netsloth.dump; - (as i understand it a .dump = .sql file) thanks. - 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
Lower Level Visibility
Is it possible to observe Handler_read_next and Handler_read_key on a per table basis? If not, could this feature be added? I'm not subscribed to this list, please cc all replies back to this email address. - Pat Wendorf - 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: Relationships???
Referential integrity should be maintained by the program (programmer) using the file handler/database. We design all of our schemas with a Parent/Child hierarchy in mind. We always have a unique key and there is always a column or key in common where any relationship exists or could exist between tables. Consider an invoice with a 1-many relationship. Header information regarding the sold to, ship to, etc.. and the Detail containing the items, quantity, etc... . These two tables would have an invoice number field/column in common. The program used to Add,Edit,Delete would enforce the relationship, thereby, maintaining referential integrity. The concept of a DBA (read 'not a programmer') attempting to enforce referential integrity by pure schema design without consideration of the applications designed to use the data or the unlimited creativity of the end-user at the keyboard over simplifies the process and itself imposes data integrity questions. Pat... . - Original Message - From: Rolf Hopkins [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 14, 2001 9:28 PM Subject: Re: Relationships??? If you are really after referential integrity then perhaps you should consider another database or you could always modify the code. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 15, 2001 8:32 Subject: Relationships??? Hello all, Without explicitly creating foreign keys, what is the most common method to create a truly relational database that enforces referential integrity? Any responses to this question are greatly appreciated! Sincerely, N. Silverwise - 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: Can only create 127 records in a table :o(
Check your AUTO_INCREMENT column. You probably have it set to a TINYINT (0-128). Use ALTER TABLE to change it to an INT or BIGINT. I hope this helps. Pat... - Original Message - From: Mette Møller Madsen [EMAIL PROTECTED] To: mysql listserver [EMAIL PROTECTED] Sent: Friday, June 15, 2001 7:46 AM Subject: Can only create 127 records in a table :o( Hi there! When I try to insert more than 127 rows/records in a table I get this error: ERROR 1062: Duplicate entry '127' for key 1 (the key is an auto incremented primary key) Does anyone know how to store _more_ than 127 rows in a table? My guess is that I need to change to settings of my db, but I cannot find anything in the manual. (I'm running version 3.23.38 which should be a stable one.) best regards, Mette Madsen - 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
Help! How to use dBase with mySQL?
I'm doing a school project for which I'm to write a PHP script with MySQL that searches a dBase database. I've got my code planned out, but the problem right now seems to be that mySQL can't directly read dBase databases. It's a fairly large database (9 megs), and so I ask: do I need to convert it somehow or can I just read it directly? Thanks for any assistance you could spare. --Pat - 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: ADO RS.Update problem
Just a quick note about RecordCount. RecordCount only returns the number of records or rows from the recordset that have been 'seen'. Therefore it is only reliable if you have traversed the entire recordset before calling it. I agree, however, that direct SQL calls will generally produce a more predictable result Sorry for the interruption... Pat... - Original Message - From: "Dennis Salguero" [EMAIL PROTECTED] To: "Simon Abolnar" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, April 14, 2001 7:21 AM Subject: Re: ADO RS.Update problem Unfortunately, it doesn't seem like all ADO methods and properties and supported when working with MySQL. Update, as you know, is one of them, along with others like RecordCount. I would recommend using a connection object and then passing an SQL statement to run. If need be, you can add the results to a recordset object. You can write it like the following, where objConn is a ADO connection object: % strSQL = "SELECT * FROM Foo" objConn.Execute(strSQL) % Obviously, the above is ASP syntax, but you get the idea for VB :). Good luck, Dennis **' Beridney Computer Services [EMAIL PROTECTED] http://www.beridney.com - Original Message - From: "Simon Abolnar" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 14, 2001 4:46 AM Subject: ADO RS.Update problem Hello! I am using mysql with VB ADO under Windows 2000 Proffesional. I add data with: RS.Open "Query WHERE 0=1", Cn, , , adCmdText RS.AddNew RS.Fields(Cols).Value = xx . RS.Update After RS.Update RS.Fields(Cols).Value is NULL. If I use Access database, RS.Fields(Cols).Value has value of last inserted record. Would you like to tell me, why mysql works in different way and how to solve this problem to have compatible solution for mysql and Access? Thanks all! Simon - 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: Problem Setting up MyODBC Driver
Your workstation may not be in the host table of the MySQL Server. Pat... - Original Message - From: "Nick" [EMAIL PROTECTED] To: "mysql" [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 9:31 AM Subject: Problem Setting up MyODBC Driver HI I am trying to set up an ODBC connection between my Windows 2000 PC and my Web Server which has a MySQL database on it. I installed the MyODBC package for Windows NT and entered all the relevant information: DSN E-SkyMySQL MySQL host 192.168.1.100 MySQL Database Name eskylight User httpd and Password I did this as a machine data source When I try to connect I get the error message S1000[TCX][MYODBC] Host " is not allowed to connect to this MySQL Server. Any Ideas why this may be happening? Thanks Nick Steele - 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
Errors in Dump Files
I'm using 3.23.26-beta on FreeBSD 4.1.1-STABLE. I'm getting corruption in the dump files in the form of "^A"'s showing up in strange places (they mostly appear in table definitions, but also in the data that is close to these definitions). The dump file cannot be used to restore if they are not removed before hand. Has anyone experienced this? What can I do to remove these characters from the file? (they are control-a's not "hat" + a) Thanks, Pat Wendorf - 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: Bug in MyODBC 2.50.36-nt ??
Try setting the use manager cursors in the MyODBC panel for the database in question. Pat... [EMAIL PROTECTED] - Original Message - From: "Uwe Hein" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 08, 2001 2:17 PM Subject: Bug in MyODBC 2.50.36-nt ?? Hi everybody, I am using a MySQL Database with MyOdbc 2.50.36-nt under WinNt SP6a and Win 2000 SP 1. The language of my frontend is CA Visual Objects (ClassMate library for SQL) When skipping through my data set with nRetCode = SQLExtendedFetch(HStatement,SQL_FETCH_NEXT,0,@nNumRows,@nRowStatus) the function returns 100 (SQL_NO_DATA), when I try to skip beyond EOF of my dataset. Doing the opposite with nRetCode =SQLExtendedFetch(HStatement,SQL_FETCH_PRIOR,0,@nNumRows,@nRowStatus) I never get nRetCode = 100 when going beyond BOF. Trying the same with the Visual FoxPro (6.0) ODBC driver or MS SQL 7, I get nRetcode = 100 as expected in both cases (going beyond EOF and BOF). As I am rather new to MySQL, I do not know, if this is really a bug. Perhaps someone could tell me another way how to determine, that I reached the top of my result set. regards Uwe Uwe Hein Folkwang Musikschule der Stadt Essen / Germany Voca Ruhrpott - Sun, 04 Mar 2001 23:20 +0100 Email: [EMAIL PROTECTED] Uwe Hein Folkwang Musikschule der Stadt Essen / Germany Voca Ruhrpott - Thu, 08 Mar 2001 19:33 +0100 Email: [EMAIL PROTECTED] - 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: Problem
If you are ftp'ing make sure your set to binary transfer method. Pat... - Original Message - From: "ALICE CHIAPPETTA" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 08, 2001 2:37 PM Subject: Problem I have downloaded the stable release for Solaris. Everytime I try to gunzip and tar it. Everything works till the end then I get a checksum error. It never creaed the var directory in the mysql directory. Could this be the problem. I have even try to download the software from the Wisconsin mirrored site, Thank You - 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 Driver documentation request (again)
ODBC API documentation is, of course, available from Microsoft and is included with Visual Studio or available from their website (I'm not sure of the exact URL). All of the MyODBC source is available from your closest MySQL Mirror site. ODBC and JDBC are not the same. Try Sun for JDBC specifications. Good luck... Pat... [EMAIL PROTECTED] - Original Message - From: "Fernando Rodrguez Sela" [EMAIL PROTECTED] To: "MySQL Mailing List" [EMAIL PROTECTED] Sent: Thursday, March 08, 2001 2:53 AM Subject: ODBC Driver documentation request (again) Hi, I wrote some days ago making this same question, but I had problems witch my mail, and I lost messages (and probably some answers) ... so if somebody answered me, please, re-send it. Thanks. -- -- I'm working in a project to simulate the database servers efficiency. The system consists in some modules, one of that is a protocol analyser (to spy the net). My problem, is that I need to work with Oracle servers, and I don't have the Oracle SQLNet protocol, so I decided to make an ODBC driver that operate as an spy, saving all the SQL sentences send by the client application, and then send it to the real ODBC Driver. This idea is very usefull, because, it could be used to work with all database engines that uses ODBC drivers ... MS ODBC - Spy - OracleODBC, MyODBC, ... | v XML file with the SQL statements Where can I find the ODBC API Documentation to create a new ODBC driver? and the JDBC API? Regards, Fernando. - 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 trouble - please help
Ensure each table has a TIMESTAMP(14) and a PRIMARY KEY (recommend an AUTO_INCREMENT field). Pat... - Original Message - From: "Wojciech Spychaa" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 07, 2001 4:14 AM Subject: ODBC trouble - please help I 've got problem with ODBC support for Microsoft Access Very ofeten i can't edit records because one error. ODBC driver says "there is another user editing same record in this time" This isn't true - because i work alone :-( Is anyone who can help me? Thanks Wojtek - 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: key lengths
BLOBS and TEXT columns used as indices require the length to be specifically enumerated. (Sec 7.26 of the manual) CREATE TABLE foo( id INT NOT NULL AUTO_INCREMENT, name BLOB NOT NULL, PRIMARY KEY(id), UNIQUE(name(500)) ); Pat... [EMAIL PROTECTED] - Original Message - From: "Mike Thompson" [EMAIL PROTECTED] To: "mysql" [EMAIL PROTECTED] Sent: Tuesday, March 06, 2001 1:51 PM Subject: key lengths How is key length for a table defined? It seems that the default is 255 bytes, but in the online docs it mentions 500 byte keys. I happen to have some very long case sensitive strings that I need to use as keys, but mysql complains when I try to create a table as such CREATE TABLE foo( id INT NOT NULL AUTO_INCREMENT, name BLOB NOT NULL, PRIMARY KEY(id), UNIQUE(name) ); Any thoughts? --m - 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 got signal 11
You may have a corrupt library or mysqld. Signal 11 is a memory error (likely overwrite). I would try deleting and reinstalling mysqld from a fresh download. Pat... [EMAIL PROTECTED] - Original Message - From: "Steven Roussey" [EMAIL PROTECTED] To: "Mysql" [EMAIL PROTECTED] Sent: Tuesday, March 06, 2001 6:29 PM Subject: Re: mysqld got signal 11 Hi, OK, I now still have the same problem after upgrading to 3.23.33-pc-linux-gnu-i686 binary. After myisamchking all tables, this time it took just about one minute before crashing: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong Bogus stack limit or frame pointer, aborting backtrace Number of processes running now: 0 010306 15:13:38 mysqld restarted I'm off to compiling a debug version. :( Will send a real bug report if it dies again. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e - 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: winmysqladmin
I seem to get integer size exceeded error windows popping up using winmysqladmin (1.0) against mysqld-opt (3.23.22). This is all on a WIN98 Second Edition box. Any clues? (sorry for the vagueness, it's occurring on a machine not within my immediate reach) Pat... - 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: Connecting via MyODBC always brings up the TDX mysql Driver Connect dialog
Make sure you also have at least a user (and password as appropriate) filled out in the MyODBC Control Panel. Pat... [EMAIL PROTECTED] - Original Message - From: "Jan R Andersson" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 21, 2001 10:22 AM Subject: Connecting via MyODBC always brings up the "TDX mysql Driver Connect" dialog Hello, I've recently successfully downloaded and installed both MySQL and MyODBC on my Win2000 "box". Everything thing works great, except that for every connection via MyODBC I make, the ODBC-setup dialog "TDX mysql Driver Connect" pops up and I have to hit its OK button to close it. There is a checkbox named "Don't prompt on connect" which I thought was ment to have it stop poping up that dialog, but it has no effect. Any idea what to do? Thanks /Jan R Andersson /Kalix /Sweden WEB: www.jra.nu www.mobilesweden.org WAP: jra.nu/main.wml wap.mobilesweden.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
Some problems encountered when linked to glibc-2.2.1
Description: I built mysql-3.23.33 against glibc-2.2.1, under Linux, kernel 2.4.1 Although the server appeared to be functional, all "show" commands yielded blank lines, and mysqldump would not create a dump file for databases - it would still work for specified tables. Using mysqlshow, the output was the usual table, which contained a blank linex for each database Using mysqlshow mysql, the result was no tables. How-To-Repeat: I had exactly the same symptoms with both mysql-3.23.22-beta and with mysql-3.23.33, when built against the glic-2.2.1 libraries. Fix: Removed all the glibc-2.2.1.* libraries and restored the 2.1.2 libraries, rebuilt mysql, and the problem vanished. The problem does seem to be tied to the glibc-2.2.1 libraries, but whether "bug" lies in the libraries or in mysql is a more difficult question. Submitter-Id: submitter ID Originator:Pat Verner Organization: Isis Information Systems MySQL support: none [none | licence | email support | extended email support ] Synopsis: musql "show" functions not working Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.33 (Source distribution) Environment: System: Linux patspub 2.4.1 #5 Wed Jan 31 08:03:21 SAST 2001 i586 unknown Architecture: i586 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Feb 16 09:50 /lib/libc.so.6 - libc-2.1.2.so -rwxr-xr-x 1 root root 1008844 Sep 10 1999 /lib/libc-2.1.2.so -rw-r--r-- 1 root root 20019674 Sep 16 1999 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Sep 16 1999 /usr/lib/libc.so Configure command: ./configure - 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: special characters messing me up
When ftp'ing the file use the ASCII mode instead of the BINARY mode. All CR/LF conversions will take place automagically. Alternatively some linux distributions have a utility to strip CR's from ASCII files and there is always old reliable vi . I hope this helps... Pat... [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: "Irmund Thum" [EMAIL PROTECTED] Cc: "Mysql" [EMAIL PROTECTED] Sent: Tuesday, February 13, 2001 7:31 AM Subject: Re: special characters messing me up - Original Message - From: "John W Ford" [EMAIL PROTECTED] To: "Mysql" [EMAIL PROTECTED] Sent: Tuesday, February 13, 2001 15:04 Subject: special characters messing me up I can't figure out why my windows machine leaves "^M" character at the end of each line of code. This causes the file to be messed up when I put it on the Linux server. It makes my perl interpreter look for a file named ^M after the very first line. #!/usr/sbin/perl also... what else I can't figure out is why this special character is sometimes hidden and sometimes visible in my Emacs program in Linux... this is the program I used in which I found the problem. anybody know? John Ford this is a very old well-known Windows issue; you should use a text editor what can save your files in UNIX format: I guess every professinal editor has this option, see Textpad or Dreamweaver... -- http://it97.dyn.dhs.org/ IrmundThum +49 179 6998564 +49 6374 992541 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Disposition: attachment; filename="smime.p7s" Content-Description: Kryptographische Unterschrift mit S/MIME Attachment converted: Ionia:smime.p7s (/) (00013E6A) - 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: MS Access Checkbox equivalent format in MySQL
I use a short (0 unchecked, 1 checked).
Pat...
- Original Message -
From: "John Halladay" [EMAIL PROTECTED]
To: "MySQL List (E-mail)" [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 4:57 PM
Subject: MS Access Checkbox equivalent format in MySQL
If I am using MS Access and linking to tables in MySQL through MyODBC,
what
is the equivalent format of a checkbox (Yes/No) in MySQL?
Would it be ENUM('Yes','No') or ENUM('True','False')? All caps TRUE, YES,
etc.?
Thanks ahead of time for your input.
John Halladay
-
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: PHP does not work after upgrading MySQL to 3.23.32
The mysql version compiled into your web server uses shared libraries and your current version (upgrade) apparently is a statically linked version. Recompile your web server/php/mysql executable with consistent use of libraries i.e. either static or shared. I hope this helps... Pat... - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 7:43 PM Subject: Re: PHP does not work after upgrading MySQL to 3.23.32 Dear Fbio Ottolini, Thanks for your reply. I'm using Linux 2.2.16-22. The exact error that appears is: /usr/local/etc/httpd/httpd: error in loading shared libraries: libmysqlclient.so.6: cannot open shared object file: No such file or directory In MySQL version 3.22.32 there was a file ./lib/mysql/libmysqlclient.so.6 I suppose in MySQL version 3.23.32 this file corresponds to ./lib/libmysqlclient.a I thought it would be smart to alias link ./lib/mysql/libmysqlclient.so.6 to ./lib/libmysqlclient.a. But when I restart httpd, the following error appears /usr/local/etc/httpd/httpd: error in loading shared libraries: libmysqlclient.so.6: invalid ELF header I hope you can help me with this information. Thanks, Tim Samshuijzen At 22:21 3-2-2001 -0200, you wrote: I suppose your operational system is Windows... Or is it Linux? Regarding Windows at least, and I believe Linux also, MySQL has got nothing to do with your problem. If PHP is not working on your system, probabily this is something related to your web server. Are you sure the correct MIME types are being used? Please give as much information as you can. Otherwise it's very difficult to come to a conclusion. BR, Fbio Ottolini P.S.: Consider upgrading to PHP4.04Pl1. - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 10:02 PM Subject: PHP does not work after upgrading MySQL to 3.23.32 Hi, I have just upgraded from MySQL 3.22.32 to 3.23.32. Now PHP3 does not work. I've tried restarting httpd, but an error appears "file not found", and httpd fails to start up. HELP! What am I doing wrong? Thanks, Tim Samshuijzen - 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: myODBC question
John, To avoid the issues you mentioned, each table requires an AUTO_INCREMENT column and a TIMESTAMP(14) column. We have been coding with VC++ and using various third party ODBC clients, including MS Access, pretty much since the inception of MyODBC. When using the Jet Database Engine (MS Access) the ability to recognize uniqueness of a record/row is paramount. Adding the aforementioned columns assures uniqueness. Pat... [EMAIL PROTECTED] - Original Message - From: "John Jensen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 2:40 PM Subject: Re: myODBC question Speaking as one who tried working with such a connection, FORGET IT. While entering data, I might get all or half a record entered when the message arrives telling me the information cannot be posted, because another user was editing that record (which I could tell was simply NOT the case), and I had the option of either dropping my input, or put the whole record in the past buffer. Occasionally, I would get lucky and get a whole record entered and saved, but mostly, my datbase was getting filled with gaps. Get phpMyAdmin. It is far more reliable solution. On 1 Feb 2001, at 12:06, (Mr) Pekka Gaiser wrote: Hi there, A DB newbie question - can I use MS Access for remote mySQL databases using myODBC?? Thanks. John Jensen 520 Goshawk Court Bakersfield, CA 93309 - 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 time problems in Access
Actually to ensure updateable tables in MS Access you need a TIMESTAMP(14) and an AUTO_INCREMENT column. Pat... [EMAIL PROTECTED] - Original Message - From: "Scott Baker" [EMAIL PROTECTED] To: "Gregory King" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 31, 2001 11:43 AM Subject: Re: myODBC time problems in Access I'm trying to remember... yes I did have that problem. It's fixed now. I think you just need to have a primary key that is auto_incremented and the newest MyODBC. At 06:49 PM 1/30/2001 -0800, Gregory King wrote: Im trying to use myodbc to enter some data through MS access. The problem is, when I link to the table it shows the data in my data formatted fields all messed up. The data in the mysql table is fine, it is something the odbc driver or access is doing. I read on the Egroup that Scott Baker was having a simular problem in September, but I didnt see any responses to his request for help. - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "Children today are tyrants. They contradict their parents, gobble their food, and tyrannize their teachers." - Socrates - 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: setting autoincrement value help needed (Second post)
I would suggest you issue an ALTER TABLE command to change your AUTO_INCREMENT to unsigned. The concept of AUTO_INCREMENT negates the use of negative numbers. If you are using the change from positive to negative to flag for deletion or some other process, try adding a column for this purpose and not messing with the AUTO_INCREMENT column. ALTER TABLE can be executed on a production database. I hope this helps... Pat... - Original Message - From: "Enea Mansutti" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 29, 2001 2:44 AM Subject: setting autoincrement value help needed (Second post) First of all MySQL rocks!!! -- Now for my problem... Unfortunately, before I knew how autoincrement worked, I have setup a database with a signed autoincrement column in a production environment. When I insert columns, I usually pass NULL as the column value for the INSERT statement to correctly insert the next autoincrement value. Occasionally (for maintenance reasons) I have to MANUALLY insert values with negative numbers, this corrupts the autoincrement value (autoincrement seems to be unsigned) so i have to run myisamchk -A to fix it. I wanted to know if there is an sql command i can execute which has the same effect of myisamchk -A. I have tried to use SET INSERT_ID=# but it seems to set the autoincrement value only for the current connection and for the first insert only. Another question, is it safe to run myisamchk -A without shutting down the mysql in a production environment? regards, Enea -- P.Review srl +39 02 29061035 [EMAIL PROTECTED] www.presstoday.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: write problems via MS Access 97 in table with timestamp and primary key
Ensure that your TIMESTAMP definition is a TIMESTAMP(14). If it is, identify which workstations are failing and compare MDAC versions against those that are not failing (we are using MDAC 2.5 ). Upgrade/downgrade MDAC as appropriate. In any case, be sure to refresh all the link tables in MS Access. If some workstations still fail, delete the link tables in MS Access and set up link tables again. I hope this helps... Pat... [EMAIL PROTECTED] - Original Message - From: "John Jensen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 1:55 PM Subject: Re: write problems via MS Access 97 in table with timestamp and primary key I used to get this all the time, myself, when I was trying to update a mysql database with Access 2000 through myodbc. Funny, at the time, nobody else seemed to understand what I was talking about. Once I got phpMyAdmin working, the problem became academic, but it never did get solved. I'm still trying to find a solution to my $FORMATQUERY ORDER BY problem with a logic function on two values. Baring a solution, I can only hope for a workaround before a year of effort is not wasted, because someone else beat me to market. Please, this does not need to be a volunteer effort. If anyone thinks they can solve this, contact me directly and we can work something out. On 24 Jan 2001, at 6:34, Bob Hall wrote: One of our users is getting the message "another user has changed this database..etc save changes to clipboard or drop changes... etc", when he tries to update certain fields in the table. The table has a timestamp and a primary key. In fact, this user can change certain fileds without difficulty for certain types of data and not for others (i.e. Access accepts changes when the data is a document but not when its a collection). To make things more confusing., other users can change all fields in the same table via Access without receiving the error message. Any one else had and solved this problem? Susan Albright Ma'am, this is an ODBC problem, not a MySQL problem. I assume that the table is a linked table in Access. How is it accessed? Directly, through a query, or through a form? Are there any joins? Does the problem occur only through a query or form that joins the table with another table? What do you mean by 'the data is a document' and 'its a collection'? These aren't MySQL or Jet datatypes. What is the user who's having problems doing that the other users aren't doing? Things that people have done to solve this include dropping and adding primary keys and timestamp fields, setting up relationships between tables as much as possible (you can set up a relationship between linked tables, but I don't think you can specify what the relationship is), and selecting UniqueRecords in queries (DISTINCTROW in SQL). Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - 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 John Jensen 520 Goshawk Court Bakersfield, CA 93309 - 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: Problems Installing 3.23.31
Try compiling with the static switch set. Check the manual for exact syntax. Pat... - Original Message - From: "Robert Hough" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 23, 2001 8:10 AM Subject: Problems Installing 3.23.31 I compilied 3.23.31 and I keep getting this error: Cannot open "../libmysql/.libs/libmysqlclient.so" This happens with every client binary, and I can't seem to figure out where this is coming from during compile time. -- Robert Hough ([EMAIL PROTECTED]) - 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
