Re: MySQL has transactions, foreign keys, and an option for NO DEFAULT
Hi Kodrik, - Original Message - From: Kodrik [EMAIL PROTECTED] To: Franklin Schmidt [EMAIL PROTECTED] * Transaction * Subselects * Foreign keys * Stored Procedures Do you actually believe that the lack of NO DEFAULT is much worst than those features above, which cannot be as easily worked around? Please allow me to clarify a few items here, since we don't want misunderstandings to linger around forever 1) MySQL supports transactions since 3.23.34a, with the InnoDB and BDB table types. Using the the InnoDB table handler you have commit, rollback, crash recovery capabilities, row level locking, consistent non-locking read, and much more... See http://www.mysql.com/doc/I/n/InnoDB.html and elsewhere in the manual for heaps of info. 2) Foreign keys are supported by the InnoDB table handler from 3.23.44. http://www.mysql.com/doc/S/E/SEC427.html 3) The other items you mentioned are already part of the 4.x development track. http://www.mysql.com/doc/N/u/Nutshell_4.1_development_release.html For the curious: implementation of these new features should not adversely affect your performance if you don't use the features. In simple terms: trust Monty! ;-) 4) Finally, MySQL does in fact have a NO DEFAULT option. This was kindly pointed out by Paul DuBois a few days ago. The DONT_USE_DEFAULT_FIELDS compile time option has existed since as early as version 3.20.14. From the manual: You can configure MySQL not to use DEFAULT column values for non-NULL columns (that is, columns that are not allowed to be NULL). This causes INSERT statements to generate an error unless you explicitly specify values for all columns that require a non-NULL value. See http://www.mysql.com/doc/c/o/configure_options.html I do believe this option addresses the issue put forward by Frank and Shelby. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ 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
Newbie Help Question: mySQL: table does not exist or has no columns
Hi just ported a web site from one server to my own. MySQL is running just fine. When I run my page that talks to my database however, I get this; mySQL: table does not exist or has no columns ...then the rest of the page comes in just fine. Any idea what I have missed here? THX Mike [EMAIL PROTECTED] __ Do You Yahoo!? Find a job, post your resume. http://careers.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
Can't reset the server-id
I am setting up a replication slave. Master is server-id = 1 Slave is server-id = 2 Relevant section of /etc/my.cnf from the slave # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=8M set-variable= table_cache=128 set-variable= sort_buffer=512K set-variable= net_buffer_length=64K set-variable= myisam_sort_buffer_size=8M log-bin server-id = 2 master-host = * master-user = ** master-password = ** master-port = 3306 log-slave-updates From the err log on the slave: 011109 15:03:16 mysqld ended 011109 15:03:22 mysqld started /usr/local/nusphere/mysql/bin/mysqld: ready for connections 011109 15:03:22 Slave: connected to master *, replication started in log 'FIRST' at position 4 011109 15:03:23 Slave: received 0 length packet from server, apparent master shutdown: (0) 011109 15:03:23 Slave: Failed reading log event, reconnecting to retr y, log 'FIRST' position 29 011109 15:03:23 Slave: reconnected to master *** ,replication resumed in log 'FIRST' at position 29 011109 15:03:23 Slave: received 0 length packet from server, apparent master shutdown: (0) 011109 15:04:23 Slave: Failed reading log event, reconnecting to retr y, log 'FIRST' position 29 This is the first few relevant lines after the first startup, all subsequent lines are just repeated. My guess as to the problem: ./mysqladmin variables reports the slave as being server-id = 1 No matter what I can't change it. Permissions have been checked and double checked. Have been all around the globe on this one and can't figure it. Master is running MySql version 3.23.34 Slave is running MySql version 3.23.37 All indications are that the setup is correct but no updates happen. I am left to believe the server-id problem is causing this to not work. I understand that the server-id's need to be different on the master and the slave. On a test system at home when I change the server-id and restart the server the change takes. This test system is running MySql 3.23.43 Has anyone seen this before and am I on the right track? Paul [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: MySQL has transactions, foreign keys, and an option for NO DEFAULT
That is all good :) I'm mostly aware of the possibilities I had offered to me the last time I set up my developing environmenta and the db design decision I had to make accordingly. I guess in less then a year, when 4.x will have some good mileage, I'll set myself a new developing environment and rethink my future database logics. Some of those features will help a lot. Please allow me to clarify a few items here, since we don't want misunderstandings to linger around forever 1) MySQL supports transactions since 3.23.34a, with the InnoDB and BDB table types. Using the the InnoDB table handler you have commit, rollback, crash recovery capabilities, row level locking, consistent non-locking read, and much more... See http://www.mysql.com/doc/I/n/InnoDB.html and elsewhere in the manual for heaps of info. 2) Foreign keys are supported by the InnoDB table handler from 3.23.44. http://www.mysql.com/doc/S/E/SEC427.html 3) The other items you mentioned are already part of the 4.x development track. http://www.mysql.com/doc/N/u/Nutshell_4.1_development_release.html For the curious: implementation of these new features should not adversely affect your performance if you don't use the features. In simple terms: trust Monty! ;-) 4) Finally, MySQL does in fact have a NO DEFAULT option. This was kindly pointed out by Paul DuBois a few days ago. The DONT_USE_DEFAULT_FIELDS compile time option has existed since as early as version 3.20.14. From the manual: You can configure MySQL not to use DEFAULT column values for non-NULL columns (that is, columns that are not allowed to be NULL). This causes INSERT statements to generate an error unless you explicitly specify values for all columns that require a non-NULL value. See http://www.mysql.com/doc/c/o/configure_options.html I do believe this option addresses the issue put forward by Frank and Shelby. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ 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
Installing mysql/php problems
Hello, Ive been using MySql for about a year now, and have finally become comfortable with sql and php scripting. Now my life has changed as Ive taken the next step into the actual server, which Im finding myself not to be cut out for...! This is my problem: I have a win2000 professional laptop that I want to use for development before live deployment. I have installed MySql, php, and IIS on the system. So far I have done this four times (after reading pages and pages of manuals) and run into the same problem again and again: I create a new virtual directory in the IIS and all is cheery for around 5 to 10 minutes then I may get an error (normally something about inability to access the mysql - I cant remember anything specific) and from then on out its all 500 errors on any page including a php/mysql call, after a 30 second time out (some times the page just spins and spins, never connecting). Before all of this, it was working perfectly, all mysql functions along with php interaction. Thinking I was too slow for such an undertaking I downloaded the PHPTriad program from phpgeek.com which should do it all for me... no dice (exactly the same symptoms). Has anyone every had a problem like this? Its especially strange that all seems just fine before the crash. Thanks for any help, Im at my wits end! Sean mail2web - Check your email from the web at http://mail2web.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
Securing username and password in script file
How does one go about securing database access username and password information that's kept in a script's config file? Most of the PHP and Perl applications floating around Sourceforge, as well as most of the commercially available scripts, store the database access username and password in a config file. This can be called anything, and can be kept either inside or outside the htdocs area on website. It doesn't matter for my example. This file needs to be readable by the process running the web server (typically nobody on Linux shared servers running Apache). Once I know where this file is stored by the application relative to the user's root directory, and it's name, on most if not all the shared server configurations hosting websites around the world, I can simply open the file using the pathname to the file and read and display it, or require it and then display the username and password variables, etc. This of course I'm doing from another user account on the server. In the case of a popular forum script written in PHP, I was able to discover more than one other config file on my server and read it's contents. I notified the owner of the site that I was able to do this, however I had no suggestions for him to protect his information from anyone else who might want to do the same. In a shared server environment where the files must be readable by the webserver process, and there is one web server user on the shared server, how can you protect this information? Are you simply screwed? If so, than much of the world is screwed... Any ideas on how to secure this situation? Thanks, -Tim - 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: Default forced on MySQL
On Saturday 10 Nov 2001 21:00, Franklin Schmidt wrote: The worst thing any development tool can do is silent unwanted favors. Java and C don't do unwanted favors which is why they are great. Javascript and most Microsoft tools do lots of unwanted favors which is why I hate them. This is a personal preference but I suspect most programmers with experience in large projects share this preference. MySQL does many unwanted favors to avoid rollback. This was a bad design decision because update speed usually doesn't matter much. What matters is the speed of reading and reliability of the data. That is very arguable. IMHO, the design decision was the correct one because the primary design goal of MySQL is speed. There are lots of databases out there. Use the one that agrees with you. If you want referential integrity checks, triggers, detailed data checking, defaults, stored procedures, etc, you should probably be using a different database. Personally, I use PostgreSQL a lot of the time, when I need the features listed above. When the primary requirement of my application is speed, I use MySQL, because it is AT LEAST twice as fast as PostgreSQL on most things, sometimes much faster. You cannot have it all. Now, can we please stop the criticism thread, and stick to doing the sensible things, i.e. using the right tool for the job? My point about unique indexes is that I assume that this forces MySQL to deal with the rollback problem anyway. Any reduction in the frequency of the rollback problem is beneficial if performance is the primary requirement. If you have a multi-row insert and one of these rows violates a unique index, what does MySQL do? Besides, uniqueness checking on an index for the insert is likely a lot faster, as typically it only needs checking on one of two fields per table, as opposed to EVERY field in the table. There is also less data transferred and overheads than doing a SELECT first to see if there's a records already there. You either do a rollback or lose atomicity. This looks like exactly the same problem that you would have implementing NO DEFAULT or any other column value sanity check in the database. But it unarguably reduces the frequency of the problem, and thus the speed of operation in most cases. Just MHO... Regards. Gordan - 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
how to get a script to run/work
i want to convert my access database to mysql. and then it will run on a linux server if i ever figure out how to run these darn scripts though i downloaded mysql for windows 98. i have tried for a week to run these scripts and even reinstalled mysql and even tried it on another computer with nt4.0. this is where i saved mysql and the title of the script i want to run. C:\mysql\scripts\pet.sql i am sitting at the mysql prompt and i have the server/daemon running in the background. Please exactly what do i type after the mysql prompt?? - 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 get a script to run/work
Tryhttp://www.anse.de/mysqlfront/ easy to use Windoze graphical front end. M;) Barbara Ferrell wrote: i want to convert my access database to mysql. and then it will run on a linux server if i ever figure out how to run these darn scripts though i downloaded mysql for windows 98. i have tried for a week to run these scripts and even reinstalled mysql and even tried it on another computer with nt4.0. this is where i saved mysql and the title of the script i want to run. C:\mysql\scripts\pet.sql i am sitting at the mysql prompt and i have the server/daemon running in the background. Please exactly what do i type after the mysql prompt?? - 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
Win2k - User defined function - how?
I want to be able to define a user defined function in a Update query eg Update Table Set MyField=MyFunction(TestField1,TestField2); Where Myfunction tests 2 fields to return a result. I am after a quick solution Thanks Dean - 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't reset the server-id
On Sat, Nov 10, 2001 at 04:49:59PM -0700, Paul Chilson wrote: I am setting up a replication slave. Master is server-id = 1 Slave is server-id = 2 [snip] This is the first few relevant lines after the first startup, all subsequent lines are just repeated. My guess as to the problem: ./mysqladmin variables reports the slave as being server-id = 1 No matter what I can't change it. Permissions have been checked and double checked. Have been all around the globe on this one and can't figure it. Hmm... Check the master.info file on your slave. Edit the file by hand with the server down to adjust it. Don't know of a better way. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 66 days, processed 1,461,530,889 queries (255/sec. avg) - 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
GPL and MySQL (was: New fork of MySQL)
Paul DuBois writes: When you distribute a non-GPL application that ONLY works with the MySQL server and ships it with MySQL. This type of solution is actually considered to be linking even if it's done over a network. I believe that bit about even if it's done over the network was added sometime around last December. I'm not quite sure what to make of it, particularly in light of the paragraph from the GPL FAQ. Interesting. As the GPL FAQ points out, the interpretation of the GPL in cases like this would ultimately have to be tested in court. I have a feeling that that paragraph on the MySQL site is enough to tip the scales. At least it's enough to make anyone who chooses to bundle MySQL with a non-GPL application aware of the possible license violation that this constitutes. The workaround would of course be to include support for one more RDBMS, or to just not ship with MySQL. Thanks for pointing this out to me. This information may be useful to me in the future, as although I'd love to release it under the GPL, the project I'm working on involves two more people, and they don't seem to be so easy to convince. Specifically, their concern is what potential buyers will think of aquiring something that might be available to their customers for free. My counter-argument would be that if someone wants to pay us to incorporate it into a proprietary product, some sort of value has to be added, and that is what people will pay for. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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.Sock Missing
Hello, I am running MySQL version 3.23.44 and I have been trying for quite some time to install this version of MySQL on Suse Linux Professional 7.2. When I enter the command bin/safe_mysqld to start MySQL I receive the following messages: #Starting mysqld daemon with databases from /usr/local/mysql/data 011104 mysqld ended When I try to confirm the status of the database by entering the command: /usr/local/mysql/bin/mysqladmin I receive the following message from my system: /usr/local/mysql/bin/mysqladmin: connect to server at localhost failed. Error: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2) Check that mysqld is running and that the socket: /var/lib/mysql/mysql.sock exists I have found out that /var/lib/mysql/mysql.sock does not exist. How do I create it? What is this files contents? With regards to my configuration files, I have confirmation that localhost is in these files. Any help you can provide to assist me in getting MySQL up and running on my system would be greatly appreciated. Thank you, Warren
Re: Default forced on MySQL
DownloadFAST.com wrote: But hey apparently I did finally get a solution from a helpful chap on this list What is it? I would like to know. My email is [EMAIL PROTECTED] P.S. for spam filter - database,sql,query,table - 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 Missing
Warren C. Sherard III writes: #Starting mysqld daemon with databases from /usr/local/mysql/data 011104 mysqld ended You need to check the log file for error messages. The two most common reasons that people can't start mysqld are that they've forgotten to run mysql_install_db (or whatever it's called), and that they've forgotten to set the correct permission on mysql's data directory (which of course should be owned by whatever user mysqld is running as). mysql.sock is not a regular file. It's a unix socket, and thus it won't exist if mysqld isn't running. There's a chapter on this in the FAQ. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: Default forced on MySQL
Sinisa Milivojevic wrote: As your entire discussion centers on the non-existence of NO DEFAULT, I will briefly comment only on that. I would like to add my support for NO DEFAULT. The lack of this feature is by far the worst thing about MySQL. Forcing default on all columns is a design decision which had to be forced for many reasons. Most important reason of all is that MyISAM tables are designed for utter speed. Therefore, they are not transactional tables nor do they have any form of pre-imaging. As on the other hand, MySQL supports multi-row inserts (and soon even multi-table updates), having defaults was a necessity as rolling back upon hitting the error in user's data in N'th row is simply impossible. I don't get this argument. What happens when a unique index is violated? Isn't this the same problem? - 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: Default forced on MySQL
I just found the following at http://www.mysql.com/doc/B/u/Bugs.html -- Because MySQL allows you to work with table types that don't support transactions, and thus can't rollback data, some things behave a little differently in MySQL than in other SQL servers. This is just to ensure that MySQL never need to do a rollback for a SQL command. This may be a little awkward at times as column values must be checked in the application, but this will actually give you a nice speed increase as it allows MySQL to do some optimisations that otherwise would be very hard to do. If you set a column to an incorrect value, MySQL will, instead of doing a rollback, store the best possible value in the column: If you try to store a value outside the range in a numerical column, MySQL will instead store the smallest or biggest possible value in the column. If you try to store a string that doesn't start with a number into a numerical column, MySQL will store 0 into it. If you try to store NULL into a column that doesn't take NULL values, MySQL will store 0 or '' (empty string) in it instead. (This behavior can, however, be changed with the -DDONT_USE_DEFAULT_FIELDS compile option). MySQL allows you to store some wrong date values into DATE and DATETIME columns. (Like 2000-02-31 or 2000-02-00). If the date is totally wrong, MySQL will store the special -00-00 date value in the column. If you set an ENUM column to an unsupported value, it will be set to the error value 'empty string', with numeric value 0. If you set an SET column to an unsupported value, the value will be ignored. -- This is very appropriately in the page for Known Errors and Design Deficiencies in MySQL. I think all of the above are design deficiencies. The right behavior for all these cases is to generate an error, even at some cost to performance. - 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
taiwan.com
It seems that once again a taiwan.com address has been subscribed to this mailing list. In case you haven't noticed, taiwan.com has a very broken mailer, which sends an error message to whoever posts anything on this list. Apart from this being annoying (especially since the date on taiwan.com's mail server is one day into the future), I have in the past received several spam mails from taiwan.com. I have no reason to believe that my address was not harvested from this list, so I think it would be in the interest of everyone here to have taiwan.com banned. Is this a reasonable request, or should I just ask the admin of my mail server to add a filter? //C database,sql,query,table -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: Default forced on MySQL
I would like to add my support for NO DEFAULT. The lack of this feature is by far the worst thing about MySQL. I don't get this argument. What happens when a unique index is violated? Isn't this the same problem? Those two comments together are quite interesting. Can you enlighten me with an example where you can't add just one line of code before the call to do exactly that. Understand also that the check for a uniq index has to be made by a call to the DB so it makes sense the DB does it, but a check on the content of a variable can be made by one line of code without any call to the db. In php, which is what he is using, you can just write if($variable1 and $variable2) { makeyourcall } There are many features in MySQL that cannot be solved so easily, so I am really interested in your view that this is the worst thing about MySQL. I must be missing something that is why I would love a situation example from 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
Need a help
My question is how in MySQL I can get information is table exists or not ( I don't want some query that return error but kind of message from serwer !) I'm beginner and I have no idea how to do it smart and properly Please help !!! --- Nagrywarka SONYx16 za 419z. Sklep Wirtualnej Polski zaprasza! Kliknij i zobacz! http://www.ws.pl/komputery/index.html?prodid=1NAIDSON0107 - 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: taiwan.com
It seems that once again a taiwan.com address has been subscribed to this mailing list. In case you haven't noticed, taiwan.com has a very broken mailer, which sends an error message to whoever posts anything on this list. Apart from this being annoying (especially since the date on taiwan.com's mail server is one day into the future), I have in the past received several spam mails from taiwan.com. I have no reason to believe that my address was not harvested from this list, so I think it would be in the interest of everyone here to have taiwan.com banned. Is this a reasonable request, or should I just ask the admin of my mail server to add a filter? //C database,sql,query,table Carl, I have just spent over three weeks trying to reestablish email contact with a personal friend in the States. Someone at my ISP has apparently been ACCUSED of spamming someone at his ISP. The reaction was to 'bounce' all email between the two domains. The fact that I have my own sub-domain completely escaped their attention/interest. The baby was thrown out with the bathwater! I have finally managed to get the two ISPs talking (not an easy task when one is 'bouncing' the other's domain!) Duh!!!??? Freedom of speech: insert standard speech here Open systems begins with the word open: insert speech about the principle of banning in general, here Like any 'security' measure, as fast as you build a wall, the 'bad guys' are figuring a way over/under/around/through it... Although we are both Vets and 11Nov a very significant date on our calendar, resist the temptation to talk about having fought for freedom and justice, blah, blah, blah Personally I hate spam. I'm also ticked off by list-bounce msgs. However I was mightily insulted to be unfairly and unjustly banned - and left with no means of recourse (guilty until proven innocent, which is not my memory of the intent of the American Constitution as I pointed out to my Yankee tormentors) - and all because (at least one of) the two ISPs couldn't be bothered to speak nicely with the other - and that all because some person in the States felt that hitting the DELete key or installing a rules/filter was more hassle (for him/her)... To prevent the waste of bandwidth the 'higher' up the food-chain these people can be shut-down, the better. However automated bans carry a 'risk' of shutting out some of the 'good' in a doomed-attempt to 'prevent' the 'bad'. Therefore the 'higher up' the filter, the greater amount of 'good' gets caught up and unjustly banned (think of the filter on this list which does not include data analysis, apparently not even MySQL (read the warning msg), and certainly not a list of all the MySQL commands...and how often that incorrectly slaps-down genuine contributors. Ultimately spam is a personal taste (both the meat product and the email variety) - some people like email advertising (and don't think it's spam). Today in and amongst the viagra, porn, won-holidays, and get-rich-quick schemes I found my first advert for a squirrel-proof winter bird feeder. The first was almost amusing. The next will definitely be spam! Our newspapers and magazines are full of irrelevant advertising, but we learned to 'deal with them' and now barely even notice. Recommend the list leave filtering alone. Recommend you (with apologies), I, and everyone else affected, install personal/client email filtering, tuned to our own personal tastes and irritation-factors. =dn - 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
Beginner SQL Question
Hi, Can someone tell me why this will not work, please SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn = 15); (Table and column names changed to protect the innocent, 15 could be a variable or anything) I thought this was just a common or garden 'Inner Query'. I Have a feeling this has to do with the fact that I have to use different syntax for MySQL. I'm no SQL guru. Could someone please Point me in the right direction. Thanks in anticipation, john John Morton http://www.jdmorton.com Australia (08) 9451 6447 [EMAIL PROTECTED] Where is the wisdom we've lost in knowledge. Where is the knowledge we've lost in information? -T.S. Eliot - 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
localstatedir [PREFIX/var]
Description: ./configure --help claims that the default value of localstatedir is PREFIX/var, but after setting --prefix it appears to be still pointing to '/var'. How-To-Repeat: ./configure --prefix=/opt/mysql-3.23.44 make make install ./scripts/mysql_install_db mkdir: cannot create directory `/var/lib/mysql/mysql': Permission denied chmod: getting attributes of `/var/lib/mysql/mysql': No such file or directory mkdir: cannot create directory `/var/lib/mysql/test': Permission denied chmod: getting attributes of `/var/lib/mysql/test': No such file or directory [etc] Fix: additionally set --localstatedir on the configure line, I guess. Submitter-Id: submitter ID Originator: Hugo van der Sanden Organization: MySQL support: [none | licence | email support | extended email support ] none Synopsis: configure flag '--localstatedir' does not adopt documented default Severity: non-critical Priority: low Category: mysql configure Class: sw-bug or doc-bug Release: mysql-3.23.44 (Source distribution) mysql-3.23.44 (Source distribution) Environment: System: Linux crypt.org 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jul 1 20:37 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1236396 Apr 6 2001 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 Apr 6 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 6 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/opt/mysql-3.23.44 - 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
What Licence of Mysql Win32 is Free ?
I'need know what version of MySQL running in Windows, is free licence ? 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
Re: localstatedir [PREFIX/var]
[EMAIL PROTECTED] wrote: :Description: : ./configure --help :claims that the default value of localstatedir is PREFIX/var, but :after setting --prefix it appears to be still pointing to '/var'. : :How-To-Repeat: : ./configure --prefix=/opt/mysql-3.23.44 : make : make install : ./scripts/mysql_install_db :mkdir: cannot create directory `/var/lib/mysql/mysql': Permission denied :chmod: getting attributes of `/var/lib/mysql/mysql': No such file or directory :mkdir: cannot create directory `/var/lib/mysql/test': Permission denied :chmod: getting attributes of `/var/lib/mysql/test': No such file or directory :[etc] : :Fix: : additionally set --localstatedir on the configure line, I guess. No, that didn't work. After: /configure --prefix=/opt/mysql-3.23.44 --localstatedir=/opt/mysql-3.23.44/var make make install I get: crypt.org% /opt/mysql-3.23.44/bin/my_print_defaults mysqld mysql_install_db --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock crypt.org% .. so now I don't know. Hugo - 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: Beginner SQL Question
John Morton writes: Can someone tell me why this will not work, please SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn = 15); That's a subselect, and a search in the manual gave me this page, which probably has all the info you need: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: taiwan.com
On Sat, 2001-11-10 at 04:50, DL Neil wrote: It seems that once again a taiwan.com address has been subscribed to this mailing list. In case you haven't noticed, taiwan.com has a very broken mailer, which sends an error message to whoever posts anything on this list. Apart from this being annoying (especially since the date on taiwan.com's mail server is one day into the future), I have in the past received several spam mails from taiwan.com. I have no reason to believe that my address was not harvested from this list, so I think it would be in the interest of everyone here to have taiwan.com banned. Is this a reasonable request, or should I just ask the admin of my mail server to add a filter? //C database,sql,query,table Carl, I have just spent over three weeks trying to reestablish email contact with a personal friend in the States. Someone at my ISP has apparently been ACCUSED of spamming someone at his ISP. The reaction was to 'bounce' all email between the two domains. The fact that I have my own sub-domain completely escaped their attention/interest. The baby was thrown out with the bathwater! I have finally managed to get the two ISPs talking (not an easy task when one is 'bouncing' the other's domain!) Duh!!!??? While I sympathize with you, I have to agree somewhat with Carl on this one. While I haven't gotten any spam from taiwan.com (or at least none that I've noticed -- I have all the taiwan.com mail filtered out here) the fact remains that their mailer is busted. It only looks at the TO and FROM headers, while it should only look at the RCPT and FROM SMTP commands. It's really rather amusing, until you get dozens of them. Because of the above problem with the mailer, I don't believe that the MySQL list is making it to whoever the intended recipient is anyway, since their address is not in the TO field. If the taiwan.com address was unsubscribed, I don't think it would actually have any detrimental affects on anyone... Just my 2c. Steve Meyers - 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: Need a help
On Sat, 2001-11-10 at 04:33, Artur Kowal wrote: My question is how in MySQL I can get information is table exists or not ( I don't want some query that return error but kind of message from serwer !) I'm beginner and I have no idea how to do it smart and properly Please help !!! Try: SHOW TABLES LIKE 'tablename' Steve Meyers - 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: Beginner SQL Question
On Sat, 2001-11-10 at 05:53, John Morton wrote: Hi, Can someone tell me why this will not work, please SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn = 15); There are no subselects in MySQL (yet). However, they're usually a bad idea anyway, which is why it's never been such a big rush to get them in. In this case, you'd be better served by a join. Try: SELECT tbl1.* FROM tbl1, tbl2 WHERE tbl1.column = tbl2.column AND tbl2.intcolumn = 15; Steve Meyers - 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: Beginner SQL Question
NOt supported... Yet. Rumor has it sub-selects will be in 4.1 John Morton wrote: Hi, Can someone tell me why this will not work, please SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn = 15); (Table and column names changed to protect the innocent, 15 could be a variable or anything) I thought this was just a common or garden 'Inner Query'. I Have a feeling this has to do with the fact that I have to use different syntax for MySQL. I'm no SQL guru. Could someone please Point me in the right direction. Thanks in anticipation, john John Morton http://www.jdmorton.com Australia (08) 9451 6447 [EMAIL PROTECTED] Where is the wisdom we've lost in knowledge. Where is the knowledge we've lost in information? -T.S. Eliot - 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 -- Bruce One day at a time... One second if that's what it takes - 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
load_file problem
Hi All! I am sorry that I posted that message with a syntactical error. but what i meant to write was this.. insert into table_name(field_name1,data_file) values (1,load_file('/absolute/path/file_name.jpg')); sorry abt the error guys.. but guys this still returns a NULL value. please help. thanks! venu = Venugopal Allavatam Ph: (res.): 949-361-6604 1100 Calle Del Cerro, (mobile): 949-842-1767 Apt.# 123-J, San Clemente, CA-92672 E-mail: [EMAIL PROTECTED] [EMAIL PROTECTED] __ Do You Yahoo!? Find a job, post your resume. http://careers.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
Re: Beginner SQL Question
Steve Meyers wrote: There are no subselects in MySQL (yet). However, they're usually a bad idea anyway, which is why it's never been such a big rush to get them in. Sometimes (just sometimes), there is no way to do it except with a subselect. For instance, we have a table where we get record updates of a 'file' (filename, last-update time, handle to where this version of the file contents are kept). The way to get the most recent version of each file is select filename, received_time, handle from file_updates where (filename, received_time) in (select unique filename, max(received_time) from file_updates group by orig_file_path); This is elegant and reasonably efficient (as long as there's an index on (filename, received_time)). There is no equivalent join or outer join statement that can express this. The temporary-table solution is somewhat MySQL-specific. The only *portable* way to do this across DBs is to also maintain some other boolean flag (latest), keep that correctly updated as new updates come in, and search on that (which is what we'll be doing in the interests of efficiency). -- Shankar. - 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
difference between MySQL version for linux windows
almost of all my application (Java with JDBC) use select encrypt(password,salt) to encrypt and store user's password. it work well in linux/unix. but i have just found that encrypt command does not work in windows version of MySQL. pls help me ! 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
Re: Beginner SQL Question
we can use subselect now with MySQL-Max version. - Original Message - From: Steve Meyers [EMAIL PROTECTED] To: John Morton [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, November 10, 2001 8:13 AM Subject: Re: Beginner SQL Question On Sat, 2001-11-10 at 05:53, John Morton wrote: Hi, Can someone tell me why this will not work, please SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn = 15); There are no subselects in MySQL (yet). However, they're usually a bad idea anyway, which is why it's never been such a big rush to get them in. In this case, you'd be better served by a join. Try: SELECT tbl1.* FROM tbl1, tbl2 WHERE tbl1.column = tbl2.column AND tbl2.intcolumn = 15; Steve Meyers - 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: Beginner SQL Question
in some case, we have to use some programming technique to resolve that problem, ex: we create a new Connection or new Statement (with one Connection) . we can have many statement. rs2 = stmt2.executeQuery(select unique filename, max(received_time) from file_updates group by orig_file_path); while (rs2.next()) { rs1 = stmt1.executeQuery(select filename, received_time, handle from file_updates where filename=+rs2.getString(1)+ and received_time=+rs2.getTime(2)); ... } - Original Message - From: Shankar Unni [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 10, 2001 10:08 AM Subject: Re: Beginner SQL Question Steve Meyers wrote: There are no subselects in MySQL (yet). However, they're usually a bad idea anyway, which is why it's never been such a big rush to get them in. Sometimes (just sometimes), there is no way to do it except with a subselect. For instance, we have a table where we get record updates of a 'file' (filename, last-update time, handle to where this version of the file contents are kept). The way to get the most recent version of each file is select filename, received_time, handle from file_updates where (filename, received_time) in (select unique filename, max(received_time) from file_updates group by orig_file_path); This is elegant and reasonably efficient (as long as there's an index on (filename, received_time)). There is no equivalent join or outer join statement that can express this. The temporary-table solution is somewhat MySQL-specific. The only *portable* way to do this across DBs is to also maintain some other boolean flag (latest), keep that correctly updated as new updates come in, and search on that (which is what we'll be doing in the interests of efficiency). -- Shankar. - 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: Beginner SQL Question
Nguyen Trong Phuc wrote: we can use subselect now with MySQL-Max version. I think not. I know it failed with 3.23.43, when I tried it just now (mysqld-max). Regarding encrypt(), the manual does say that encrypt() returns NULL on OSes where the crypt() function is not available. True. However, there's a nice GPLed version of crypt() that comes as part of GLIBC which can surely be incorporated into the now-GPL'ed MySQL distribution (thus making it OS-independent).. -- Shankar. - 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: Beginner SQL Question
yeah, mysql is compatible for small business with small and simple database. We can use PostgreSQL for subselect query as a free SQL server, but it's too slow. - 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: taiwan.com
Guys... this is the internet just delete the spam... and dont complain like a school girl with a skinned knee... I am a system admin and if i blocked every domain that sent spam mail people would only be able to email to other on our domain.. Spam Happens.. delete it and go on with your day... If you really want to stop spammers... preach about turning off MAIL RELAYING. most spammers telnet into a servers incomming mail port and send the spam.. so other than lazyness and stupidity it usally isnt the Domains fault... now... can we use this list for MySQL relayted stuff... thats why its here... Adam Graham Datastream Cowboys Inc mysql,database,table - 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
(WOT) Re: taiwan.com
Um. I block every domain I catch spamming and my users don't seem to have problems. kronos wrote: Guys... this is the internet just delete the spam... and dont complain like a school girl with a skinned knee... I am a system admin and if i blocked every domain that sent spam mail people would only be able to email to other on our domain.. Spam Happens.. delete it and go on with your day... If you really want to stop spammers... preach about turning off MAIL RELAYING. most spammers telnet into a servers incomming mail port and send the spam.. so other than lazyness and stupidity it usally isnt the Domains fault... now... can we use this list for MySQL relayted stuff... thats why its here... Adam Graham Datastream Cowboys Inc mysql,database,table - 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
Maximum # of Columns
am trying to design a good database, that has a matrix of data per record. For example, 1 record already has 80x43 = 3440 datafields which each need to hold real numbers. The way I would do it would be to hold a row of 3440 columns, but I do not know if that will be a mistake or if that would be the best way of doing it. I could store each matrix in a file, but how efficient would that be. Also, I have never created 3440 columns on a database, but it does sound awkward especially given the fact that there will only be 350 records. - 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: Maximum # of Columns
From: Sparta Cruz [EMAIL PROTECTED] Do you think this was due to software constraints(MySQL), or do you think it had to do with hardware constraints? I'm sure it was software. Possibly the MyISAM tables I'm using. -Original Message- From: Rodney Broom [mailto:[EMAIL PROTECTED]] I had to do something like this the other day. I tested and was only able to create 2945 columns per table. If you ~could~ keep the data in a single file per record, then maybe you'd bennefit from putting all of the data (formatted) into a text or blob. --- Rodney Broom Programmer: Desert.Net Spam filter: sql database - 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: Maximum # of Columns
am trying to design a good database, that has a matrix of data per record. For example, 1 record already has 80x43 = 3440 datafields which each need to hold real numbers. The way I would do it would be to hold a row of 3440 columns, but I do not know if that will be a mistake or if that would be the best way of doing it. I could store each matrix in a file, but how efficient would that be. Also, I have never created 3440 columns on a database, but it does sound awkward especially given the fact that there will only be 350 records. You're pushing a bit past the limits... http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_5_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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: Maximum # of Columns
Why not just use 43 db rows each with 80 fields and a matrix row index field? Then 350 records with 80x43=3440 fields turns into 350x43=15050 records with 81 fields, which is much more manageable. PS - Does this table happen to be for recording the contents of a text window? (43 columns and 80 rows). Ernie Hershey [EMAIL PROTECTED] -Original Message- From: Sparta Cruz [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 10, 2001 3:10 PM To: [EMAIL PROTECTED] Subject: Maximum # of Columns am trying to design a good database, that has a matrix of data per record. For example, 1 record already has 80x43 = 3440 datafields which each need to hold real numbers. The way I would do it would be to hold a row of 3440 columns, but I do not know if that will be a mistake or if that would be the best way of doing it. I could store each matrix in a file, but how efficient would that be. Also, I have never created 3440 columns on a database, but it does sound awkward especially given the fact that there will only be 350 records. - 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
Create Table
Hi, For a university project I've recently started to learn to use MySQL. Obviously one of the first things I did, having read numerous tutorials was to create a database and attempt to add some tables. Unfortunately I have spent the past two weeks trying to do this presumably straight forward task and am sure that I am missing something. The problem occurs due to my wishing to place too many keywords after any attribute. If I create a simple table like: create table Products( ID int(7) unsigned not null unique zerofill default '000' auto_increment, primary key(ID)); I get an error message similar to: Error 1064 at line 3: You have an error in your SQL syntax near omitted text at line 2. After two weeks of changing combinations of keywords and deleting some and inserting others I finally found that the following command works: create table Products( ID int(7) unsigned zerofill default '000' not null unique auto_increment, primary key(ID)); So does anyone have any idea why the order of these keywords matters? In all the references on MySQL or SQL there is no mention of any specific order. While I've now got my first table working I'm still having difficulties getting other tables to work. Hopefully the answer to this question may shed some light on my difficulties. Thanks very much in advance. Regards, Saqib Shaikh Email: [EMAIL PROTECTED] Web site: http://www.saqibshaikh.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
Treating multiple records as a single-multiple value
mysql create database colors; Query OK, 1 row affected (0.01 sec) mysql use colors Database changed mysql CREATE TABLE Colors( - - cid INT UNSIGNED NOT NULL, - data VARCHAR(10) NOT NULL - ); Query OK, 0 rows affected (0.06 sec) mysql insert into Colors values ( 1, 'red'); Query OK, 1 row affected (0.00 sec) mysql insert into Colors values ( 1, 'orange'); Query OK, 1 row affected (0.00 sec) mysql insert into Colors values ( 1, 'yellow'); Query OK, 1 row affected (0.00 sec) mysql mysql insert into Colors values ( 2, 'blue'); Query OK, 1 row affected (0.00 sec) mysql insert into Colors values ( 2, 'green'); Query OK, 1 row affected (0.00 sec) mysql insert into Colors values ( 2, 'purple'); Query OK, 1 row affected (0.00 sec) mysql mysql insert into Colors values ( 3, 'violet'); Query OK, 1 row affected (0.00 sec) mysql insert into Colors values ( 3, 'pink'); Query OK, 1 row affected (0.00 sec) mysql insert into Colors values ( 3, 'blue'); Query OK, 1 row affected (0.00 sec) mysql select * from colors; +-++ | cid | data | +-++ | 1 | red| | 1 | orange | | 1 | yellow | | 2 | blue | | 2 | green | | 2 | purple | | 3 | violet | | 3 | pink | | 3 | blue | +-++ 9 rows in set (0.00 sec) mysql select * from colors where data 'blue'; +-++ | cid | data | +-++ | 1 | red| | 1 | orange | | 1 | yellow | | 2 | green | | 2 | purple | | 3 | violet | | 3 | pink | +-++ 7 rows in set (0.01 sec) mysql select * from colors where data != 'blue'; +-++ | cid | data | +-++ | 1 | red| | 1 | orange | | 1 | yellow | | 2 | green | | 2 | purple | | 3 | violet | | 3 | pink | +-++ 7 rows in set (0.00 sec) - 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: Default forced on MySQL
Kodrik wrote: Understand also that the check for a uniq index has to be made by a call to the DB so it makes sense the DB does it, but a check on the content of a variable can be made by one line of code without any call to the db. Anything that the database does, one can also do in code. I could make sure a column is unique by checking it in code before inserting or updating values, but I prefer that it is done in the database with a unique index because this centralizes it. For the same reason, I prefer having NO DEFAULT in the database, because this centralizes the check and avoids errors. The worst thing any development tool can do is silent unwanted favors. Java and C don't do unwanted favors which is why they are great. Javascript and most Microsoft tools do lots of unwanted favors which is why I hate them. This is a personal preference but I suspect most programmers with experience in large projects share this preference. MySQL does many unwanted favors to avoid rollback. This was a bad design decision because update speed usually doesn't matter much. What matters is the speed of reading and reliability of the data. My point about unique indexes is that I assume that this forces MySQL to deal with the rollback problem anyway. If you have a multi-row insert and one of these rows violates a unique index, what does MySQL do? You either do a rollback or lose atomicity. This looks like exactly the same problem that you would have implementing NO DEFAULT or any other column value sanity check in the database. - 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: Treating multiple records as a single-multiple value
In your examples, ID 2 should NOT get returned. What I'm after is analogous to a Perl hash where you could say: if (!exists $colors{2}-{blue}) { ... } Make sence? --- Rodney Broom Programmer: Desert.Net Spam filter: sql database - 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: Maximum # of Columns
Well since you'd only have 80 data columns to refer to instead of 3440, it could make generating queries easier. I could see dealing with the data being a little bit more complex, but if the data represents a matrix, storing the data this way is probably closer to how it would be stored in a given program anyways, so it would be more organized. Ernie Hershey [EMAIL PROTECTED] -Original Message- From: Sparta Cruz [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 10, 2001 3:48 PM To: Ernie Hershey Subject: RE: Maximum # of Columns This doesn't have to be for recording the contents of a text window, but I have thought of what you said, and I think it would be possible, but it may make making queries difficult? -Original Message- From: Ernie Hershey [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 10, 2001 12:38 PM To: 'Sparta Cruz'; [EMAIL PROTECTED] Subject: RE: Maximum # of Columns Why not just use 43 db rows each with 80 fields and a matrix row index field? Then 350 records with 80x43=3440 fields turns into 350x43=15050 records with 81 fields, which is much more manageable. PS - Does this table happen to be for recording the contents of a text window? (43 columns and 80 rows). Ernie Hershey [EMAIL PROTECTED] -Original Message- From: Sparta Cruz [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 10, 2001 3:10 PM To: [EMAIL PROTECTED] Subject: Maximum # of Columns am trying to design a good database, that has a matrix of data per record. For example, 1 record already has 80x43 = 3440 datafields which each need to hold real numbers. The way I would do it would be to hold a row of 3440 columns, but I do not know if that will be a mistake or if that would be the best way of doing it. I could store each matrix in a file, but how efficient would that be. Also, I have never created 3440 columns on a database, but it does sound awkward especially given the fact that there will only be 350 records. - 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
Treating multiple records as a single-multiple value
Sorry I misread what the question was asking since I have run into MySQL related problems that are not problems in other databases, so I just wanted to check that out. You would have to have some function that could read a resultset similar to the select * from colors where data !='blue'; since MySQL does not allow you to just have the id returned. Once you have the ids you need in a resultset you may just read unique id's and store it in a list. By the way have you had a chance to make the ids unique when calling the statement. My sytax is not correct since I just tried it, but the query should be similar to select unique id from colors where data != 'blue';. I am going to try and find some information on using unique, but I think I remember also having a problem with using unique. Please let me know if this was of help since I think we both will be having problems that are not related but are isomorphically logical. Sorry for the confusion, and I don't know perl, but I do know that when you make a field the primary key, it uses a hash function to find that id. - 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
renaming a database
Can you rename a database? If so, how does it handle all the tables inside it? 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
Re: Default forced on MySQL
On Saturday 10 November 2001 01:00 pm, you wrote: Kodrik wrote: Understand also that the check for a uniq index has to be made by a call to the DB so it makes sense the DB does it, but a check on the content of a variable can be made by one line of code without any call to the db. Anything that the database does, one can also do in code. I could make sure a column is unique by checking it in code before inserting or updating values, but I prefer that it is done in the database with a unique index because this centralizes it. For the same reason, I prefer having NO DEFAULT in the database, because this centralizes the check and avoids errors. I said one line of code without any call to the db. You cannot make sure a column is uniq without a call to the db. And for lack of a feature that you can and should do anyway from code, you state The lack of this feature is by far the worst thing about MySQL. Can you do these with one line of code without a call to the DB: * Transaction * Subselects * Foreign keys * Stored Procedures If you can, you are my God. Do you actually believe that the lack of NO DEFAULT is much worst than those features above, which cannot be as easily worked around? Why did you make that extreme statement? What was the purpose for it? - 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: renaming a database
Can you rename a database? If so, how does it handle all the tables inside it? By shutting down the server, renaming the directory of that database and restarting the server. The server will be able to handle the change just fine. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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
Using MySQL++ with CodeWarrior 7
Greetings list members. I'm trying to build an application for OS X using CW7 - and though I've gotten mysql++ to build and install properly (from the command line, using configure gcc) - I can't seem to get CW happy with using mysql++ ... when I include the sqlplus header, I get about 300+ errors (and numerous warnings) about things that the CW compiler apparently doesn't care for. Does anyone know what might be going on? I'm not really interested in rewriting copious amounts of mysql++ to make it compatible - since I don't consider my C++ experience to be quite up to that level! Any help would be appreciated! Sincerely, Brice Ruth p.s. please cc: me directly, as I'm not currently on the list. Also - apologies if this isn't the correct place to post, please let me know if it isn't. -- WebProjkt, Inc. VP, Director of Internet Technology http://www.webprojkt.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