RE: Can AUTO_INCREMENT return from INSERT function into a table ?
Hi Son, On Monday, April 08, 2002 2:37 PM, Son Nguyen [SMTP:[EMAIL PROTECTED]] wrote: --- BD [EMAIL PROTECTED] wrote: Son, At 09:48 PM 4/7/2002, you wrote: mysql desc threads; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | thread_ID | int(11) | | PRI | NULL| auto_increment | | subject | varchar(255) | YES | | NULL| | | author | varchar(30) | YES | | NULL| | | last_by | varchar(30) | YES | | NULL| | | views | int(11) | | | 0 | | | date_posted | datetime | YES | | NULL| | +-+--+--+-+-++ 6 rows in set (0.00 sec) $SQL_insert_thread = INSERT into threads ; $SQL_insert_thread .= (subject, author, last_by, views, ; $SQL_insert_thread .= date_posted) values ; $SQL_insert_thread .= (\'some_subject\', \'test_username\', $SQL_insert_thread .= \'test_username\', 1, now()); In the table threads above, I do have a field: thread_ID with auto_increment value. My question is can I obtain the value thread_ID while I do the insert statement just by 1 mySQL statement? If yes, please can somebody give me a sample code? execute the MySQL query: select last_insert_id(); 1st: select last_insert_id() doesn't work 2nd: It's not the answer I am looking for ... Because of the race condition if two users access the that script at the same time... I will have when I leave the INSERT statement !!! Here is what I mean: think about this situation: USER 1 === INSERT STOP == due to process scheduling USER 2 === INSERT SELECT last_insert_id(); USER 1 === SELECT last_insert_id(); It's the race condition, I am talking about. True, this would seem to be the case, but MySQL returns the last_inert_id relative to the user and connection so as long as the user inserts and then selects in the same connection, it doesn't matter what other connections are doing because they are ignored. (I think if you did this in two different connections it would something meaningless anyway). http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html #Reference - search for LAST_INSERT_ID - about halfway down the page. cheers, noel - 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 AUTO_INCREMENT return from INSERT function into a table ?
Check out this: http://www.mysql.com/doc/L/O/LOCK_TABLES.html User 1 must do a 'write lock' on the table, before calling the insert statement. Then User 2's qery will have to wait till User 1 calls Unlock. USER 1 === WRITE LOCK USER 1 === INSERT STOP == due to process scheduling USER 2 === INSERT (this query will have to wait until the table is inlocked SELECT last_insert_id(); USER 1 === SELECT last_insert_id(); USER 1 === UNLOCK USER 2's query will be executed It's the race condition, I am talking about. There won't be a race condition. and retrieve the returned value or $last_thread_id = mysql_insert_id(); This function will not work properly if the auto-incrementing column is BigInt, because PHP does not have a BigInt equivalent. Int or smaller works fine. Brent - 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: regular backup database in mysql
EZ... Step 1. Create a BATCH FILE. backup.bat D:\YourPath\Mysql\Bin\mysqldump --opt DB1 C:/BackupDBS/DB1.sql D:\YourPath\Mysql\Bin\mysqldump --opt DB2 C:/BackupDBS/DB2.sql D:\YourPath\Mysql\Bin\mysqldump --opt DB3 C:/BackupDBS/DB2.sql D:\YourPath\Mysql\Bin\mysqldump --opt DB4 C:/BackupDBS/DB3.sql You can modify it in order to minimize the lines in the file. You decide. Step 2. Set a scheduled task Open Control Panel and Open Scheduled Task. Follow the Wizard. Choose the backup.bat file as the program set the hour (9:00 pm), diary, and choose another options. After that let Windows manage your database backups. Enjoy, Roberto Ramírez -Mensaje original- De: lorenzo.kh [mailto:[EMAIL PROTECTED]] Enviado el: Lunes, 08 de Abril de 2002 12:15 a.m. Para: [EMAIL PROTECTED] Asunto: regular backup database in mysql I am using MySql version 4.0.0-alpha in Windows 2000. Everytime when I want to backup the database,i do it in MS-DOS. Using this command: mysqldump --opt mydatabasename mybackup.sql Now,lets say i never shut down my pc and the MySql is running all the time. How can i do a regular backup (ie.every evening 9.00 pm) automatically? - 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
Got error 127 after using the alter table command
Hello, I am using MySQL 3.23.39 (on Windows NT and Windows 2000) and the = mm_mysql 2.0.4 JDBC driver. I encountered following problem: 1. I first create some tables via JDBC 2. then I fill in some data via the command line 3. I execute an alter table command (adding a column) on the table with Java 4. When I now try to execute a statement on this table I get error 127 I do not have this problem when: 1. I don't fill in data via the command line 2. I fill in the data via JDBC I have also tried this with a dump, and this also gave the same error.=20 Could this be a bug ? Kind regards, Ismaël - 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
Question about Cross Compiling MySql
Hi EveryOne I Wonder If Cross Comile is Possbile. I was trying to make Makefile by using configure shell script(Mysql 4.0.1 Alpha version). Target was Linux PPC and Compile Platform was Solaris Sparc. But test program could not be runned in cross compile environment. That resulted that Makefile count not be made. What shall I do? How can I make Makefile and A.out int Cross Compile Environment? 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: Security
John: Since you host your application(s) with your ISP, don't worry about it. It's a useful and valid question, but you're not in a position to address it completely while security is in control of someone beside yourself. Look here to make yourself better educated about MySQL security: http://www.mysql.com/doc/G/e/General_security.html Simply stated: If the host that has your data is not in a room/building that you have control over (i.e.: you have the keys), you can't have security. But, the above link will give you some logical security practices, regardless. Regards, Van -- = Linux rocks!!! http://www.dedserius.com/ = John Berman wrote: Hi Still fairly new to this and I'm using mysql-front for administration which makes life really easy. Anyway as I'm now adding tables etc should I be creating a new user to access them, I'm thinking of the web users, or can I use the default user set-up by my ISP Regards John Berman [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
foreign keys
i tried to use the foreign key feature in mysql 4.0.1 using innodb tables . then i have tried the delete cascade feature but it didn't work . I don't know why ? have you any suggestions ? . - 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: last_insert_id gives 0
Hi Paul On Monday 08 April 2002 12:56 am, Paul DuBois wrote: You're inserting a specific value into the AUTO_INCREMENT field, which doesn't result in the creation of a new automatic sequence number. If you want to insert a record with a specific value in that column, *and* you want the value to be treated like an AUTO_INCREMENT value, so that LAST_INSERT_ID() will return that value, then do this: INSERT INTO customers (customer_id VALUES(LAST_INSERT_ID(10)); Thank you very much indeed for this succinct explanation (and the workaround). This makes sense now, so another small corner of MySQL has been illuminated for me! Thanks again. Kevin - 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
Problem with binlog (bug?)
Hi there! I'm having a little Problem with the mysql binary log which I think could actually be a bug of some sort, though I wasn't able to try it on a new Version of MySQL. My system configuration is: MySQL 3.23.41´, Win32 binary Release WindowsNT 4.0 Service Pack 6 PII, 256 MB Ram I am using the binary log to back up a databse called 'www' to files like c:/server/mysql/data/www-bin.??? In this database there is a table 'satzungen', create Syntax is like this: CREATE TABLE satzungen ( rowid mediumint(8) unsigned zerofill NOT NULL auto_increment, titel tinytext NOT NULL, inhalt mediumtext NOT NULL, data longblob NOT NULL, content_type varchar(255) NOT NULL default '', gruppe enum('Allgemeine Verwaltung','Öffentliche Sicherheit und Ordnung','Schulen') NOT NULL default 'Allgemeine Verwaltung', kuerzel tinytext NOT NULL, kennung varchar(10) NOT NULL default '', last_change date NOT NULL default '-00-00', PRIMARY KEY (rowid), FULLTEXT KEY titel (titel), FULLTEXT KEY inhalt (inhalt), FULLTEXT KEY kuerzel (kuerzel), KEY last_changed (last_change) ) TYPE=MyISAM; due to some specific design reasons I use the following SQL-Statement to write data into the file INSERT INTO satzungen 'titel' VALUES(''); SET @rowid = LAST_INSERT_ID(); #...let's conser that @rowid now has a value of 125 #...some other statements, not concerning this table... UPDATE satzungen SET titel='title', inhalt = 'context', content_type='text/plain', data='data',kuerzel='kuerzel', kennung='kennung', last_change = NOW() WHERE rowid = @rowid; this is logged into c:/server/mysql/data/www-bin.007 what happens is that when I use mysqlbinlog --result-file=c:/log.sql c:/server/mysql/data/www-bin.007 it gets me a mysql dump which looks like this: #...other statements SET INSERT_ID = 125; SET TIMESTAMP=1017998537; INSERT INTO satzungen (titel) values(''); SET TIMESTAMP=1017998537; UPDATE satzungen SET titel = 'title', inhalt = 'context', content_type = 'text/plain', data = 'data', kuerzel = 'kuerzel', kennung='kennung' last_change = NOW(), WHERE rowid = @rowid; ### #^^^ THIS IS I THINK WHERE THE PROBLEM IS - THE LOG REMEBERS MY USAGE OF @rowid #BUT IT NEVER REMBERS WHAT I SET @rowid to (the line SET @rowid = LAST_INSERT_ID() ### #...other statements when I then try to read this dump on another server (using mysql -u username -p dumpfile.sql) which has an empty table satzungen with the same definition as above I get exactly empty row. So my question is: is it a design feature that variables are not dumped into the binary log? Was this problem solved in a later version of MySQL? Am I just blind and stupid-and is there maybe an easy workaround (w/o using updatewhere rowid = LAST_INSERT_ID()-this won#t work for me!) Thanks! Falk Eilenberger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with binlog (bug?)
UPDATE satzungen SET titel='title', inhalt = 'context', content_type='text/plain', data='data',kuerzel='kuerzel', kennung='kennung', last_change = NOW() WHERE rowid = @rowid; User variables are not replication safe in 3.23 :( MySQL -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - 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
Updated: Lost data problem Was: Corrupt .FRM files
Hi all, Some days ago (March 11) permissions were broken in catalogue of the mySQL database. Even though the permissions were not correct any more, MySQL continued to work. We think MySQL started to work with cache (with image of tables in RAM...) instead and all this time our backup system made copies automatically from HDD (not from RAM) which means that it backed up the same file all the time! On April 4th the server and Mysql were restarted and permissions were corrected at that time. Mysql then took the data from HDD and started to work with database from March 11th. As a result we have a current backup copy now. Is there any way to recover the data that used to be stored in RAM (maybe stored in some kind of cache file on the server)? Hopefully someone has an idea on what can be done! Best regards, Andreas - 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
UNIQUE index on nullable collumn - can't alter table
MySQL 3.23.47: I want to change a column that is currently non-indexed. SessionID is a nullable int column: alter table tbl_Orders add unique SessionID(SessionID); results in Column 'SessionID' is used with UNIQUE or INDEX but is defined as NOT NULL (A throwback to version 3.22???) I have tried creating new (simple) tables with such indices and they work fine. I've also tried adding an index to an existing test table, in the same scenario as this one. I can't seem to reproduce the error under test conditions, but I simply cannot add this index! In the end, I deleted recreated the entire table with the index I was trying to create defined. It worked. Some vestige of mysql's pre-nullable-index days are still haunting it for the alter, though. -- Jamie - 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
OLAP TOOLS
Good morning friends. We have the a project, what is search the OLAP SYSTEM for SUPORT DECISION. I like to know if anybody have the knwoledge about FREE OLAP SYSTEM TOOL and any what use the MYSQL with DW ? - 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
OpenBSD and MySql
Hi, I am using OpenBSD 2.8 and spent a frustrating evening last night trying to make MySql come to heel. Installed just fine - the first sign of something not right was inability to complete the run-all-tests scripts - just hung there gobbling up 95% CPU. Gave up on that eventually, and tried to load the databases with: /usr/local/mysql/bin/mysql --user=root --password=Dusebig7 dancedetails bars.sql Needless to say, the same thing happenned. I am sure I am not alone in this. Found http://www.hostbaby.com - but he's using OpenBSD 3.0. Being a lazy one, I had just installed 2.8 from the site. To implement his fix, I will have to start from scratch. Is there any other option? Is this the problem? Donna [depressed] - 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
200 milions records
HI, I want to insert into db 200.000.000 records of type (int6,int6).. the structure is: CREATE TABLE word_page ( IDword mediumint(6) NOT NULL default '0', IDpage mediumint(6) NOT NULL default '0', KEY IDword (IDword) ) TYPE=MyISAM; What do you think of it,, how would be the speed after then when i do simple select query ... for example Select IDpage where IDword=44 What should I do for best performance? thanks regards _ddd - 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
ignore the first sting in order
Hi all, I want to order a result with ignore the first word when it begins with a _. Begin the first word with a _ use the next word. Can I do it with SQL? Table example: _The Rock Scary Movie X-Files With order I want the output Scary Movie _The Rock X-Files Thanx Bernd - 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
adding 8-bit character encoding to mysql-max-3.23.49-win
Is it possible to add new 8-bit character encoding to compiled mysql (version 3.23.49-win) without recompiling? I would like to add ISO8859-15 encoding that seems not to be present in default installation. with best wishes, Taavi - 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
Which list should I ask
I have a question about a script that generated a SQL script from Access 97. Is this the right list, or do I need to write to another one? Thanks. Jim Swanson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help with asp/mysql
this is driving me mental, I'm using asp and mysql, I'm running a query and getting back these two records when running the query manually through mysqlfront , productid 5325301445 5325301446 when the page executes the query i get back a single result 1030334149 which doesnt actually exist in the database! anyone got any ideas? I know the query is being run , and its going to the right database , as I'm writing them to the page directly before the query is run and the results are written to the page. ___ Sean O'Donnell Sentia Technologies Ltd. Sentia House 104 Coolmine Business Park Dublin 15 Ireland e-mail [EMAIL PROTECTED] web http://www.sentia.ie phone + 353 1 821 9020 fax + 353 1 821 9025 mobile + 353 86 854 3389 - 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: help with asp/mysql
whoops, the sql is select distinct product.productid from product,productdetails where product.productid=productdetails.productid and product.recordstatus='O' and product.recordstatus='O' and productdetails.price= 1234.673264 and productdetails.price= 0 and (product.instore = 0 or product.instore = 0) limit 0, 10 I know there are some redundant sections in the sql but the statement is being generated on the fly, and i dont think that they would account for this effect. -Original Message- From: Sean O'Donnell Sent: 08 April 2002 06:36 To: [EMAIL PROTECTED] Subject: help with asp/mysql this is driving me mental, I'm using asp and mysql, I'm running a query and getting back these two records when running the query manually through mysqlfront , productid 5325301445 5325301446 when the page executes the query i get back a single result 1030334149 which doesnt actually exist in the database! anyone got any ideas? I know the query is being run , and its going to the right database , as I'm writing them to the page directly before the query is run and the results are written to the page. ___ Sean O'Donnell Sentia Technologies Ltd. Sentia House 104 Coolmine Business Park Dublin 15 Ireland e-mail [EMAIL PROTECTED] web http://www.sentia.ie phone + 353 1 821 9020 fax + 353 1 821 9025 mobile + 353 86 854 3389 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql_install_db locks after Installing all prepared tables
Hi, I'm having some trouble with mysql.. Running the mysql_install_db renders this... Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables At this point the script locks at this point won't go any further. I am using MySQL-3.23.49a-1.i386.rpm MySQL-client-3.23.49a-1.i386.rpm Red Hat Linux version 2.2.16-22 The install (rpm --install) goes in fine - I don't have any trouble until I run the mysql_install_db script. I have tried several different mysql rpms - from Redhat - from mysql.org to no avail. There must be something simple I am overlooking - but I just can't seem to see the trees through the forest. Any help would be GREATLY appreciated! Thanks! Chris Lamrock - 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: Uninstalling on MacOS X
Your binary distrubution downloaded from mysql.org installs in /usr/local/mysql If you remove everything from that directory, you can just install the binary distribution again into that directory. Don't forget to run the mysql_install_db script after installation so to set up your initial mysql databases: /usr/local/mysql/scripts/mysql_install_db You will also want to be sure to install the mysql distro as root. -RG On Sun, 7 Apr 2002, Gilbert Wilson wrote: SMW Mac OS X user looking for someone, anyone, to help him uninstall mySQL-3.23.49 because he has royally screwed up the installation. Chronology of events: 1) installed from binary, process went smoothly 2) several weeks go by without use, forget password to mysql 3) cannot remember password, at all 4) install mysql over itself, doesn't fix problem 5) Delete mysql directory 6) start over by installing from source thinking that¹s the REAL way to do it anyway. 7) More problems, use 'locate' to delete all (I thought) mysql files; don't think I really did delete all of them though. 8) Reinstall from binary, again! 9) now mysql is just broken, ka-putz, destroyed. Server won't start -- nuttin. I was thinking of updating the 'locate' database, and then searching for all files that have 'mysql' in them, again. Is this the best way to remove mysql? Or is there a better way? Also do all of mysql's files have mysql in their name? I have just enough CL knowledge to get myself into trouble, but not enough to pull myself out of it. Thanks, Gilbert Wilson - 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: ignore the first sting in order
Hi, Table example: _The Rock Scary Movie X-Files With order I want the output Scary Movie _The Rock X-Files select * from movies order by trim(leading from replace(movetitle, '_', ' ')); Regards, Sasa »mysql, select, 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: Security
Since you are using a hosted database you probably can't change any of the security. What I would do is create a table of usernames and passwords (and any other releveant user data). When your users login, check their password and proceed accordingly. Craig At 02:44 AM 4/8/2002, you wrote: Hi Still fairly new to this and I'm using mysql-front for administration which makes life really easy. Anyway as I'm now adding tables etc should I be creating a new user to access them, I'm thinking of the web users, or can I use the default user set-up by my ISP Regards John Berman [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: ignore the first sting in order
On 8 Apr 2002, at 13:52, Bernd Menzel wrote: I want to order a result with ignore the first word when it begins with a _. Begin the first word with a _ use the next word. Can I do it with SQL? Table example: _The Rock Scary Movie X-Files With order I want the output Scary Movie _The Rock X-Files I thought you wanted to ignore the The. Since you're going to have to process the titles before display anyway, to remove the _, why not move the The to the end for storage, separating it with some character that never occurs in a title: Rock|The? Then the sort should work correctly. A more flexible solution would be to introduce a new column to sort by, which would contain the title with initial The/A/An stripped off and maybe all spaces/punctuation removed as well -- or do you want X-Files to be before Xanadu? -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.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
Re: Do any of your applications work?
me thinks hmmm, it's gotta be a troll. I'm so gullible I don't even know if it is or not. If it is, life is good. My favorite it the church lady who storms the linux groups and demands that they stop supporting this operating system because she has ample proof that it is being run on web servers that dish out pornography. This one's good too but somehow I actually think it could be real. There's no way someone could know enough about UNIX to write that letter, and then have a strong opinionated stance like that is there? Is the world that big? On Sat, Apr 06, 2002 at 12:31:40PM +, Hugh O'Loughlin wrote: Responsible Person, We have been asked by a client, to use your products in our intergration efforts. Your MySQL 3.23.49a [Stable version?] for Sun Solaris x86, version, 5.8, is offered without the installation file ./scripts/mysql_install_db. The ./scripts/mysql_install_db, that comes with it, is EMPTY! Your MySQL-MAX 3.23.49a, although it gets a little further along in the installation phase [in that a deamon start-up], only some of the commands are execuatble/executing. This is not a normal [nor acceptable] situation in the UNIX world, when commands in the same directory are not all executable [No PATH problems here]. None of the following commands seem to work: mysql, mysqladmin, BINDER/(anything), just to name a few. The instructions were followed to the dot [as we have previously done with REDHat Linux 7.2, of the above mentioned]. We have also come to find, that your JDBC [mm.mysql.jdbc-1.2c.tar.gz] driver currently has a problem in being recognised in the FORTE developement environment. Please know, that we are not at all new to the communal-developement environment. However, whenevr anything is posted to be working, it should be exactly that. Ommission errors of the magnitude we have found, are pure 'Microsoftish' in nature, and should have no place anywhere, integrity not withstanding. Besides our practice of believing, that sometimes bad things happen to good people/things, perhaps by us bringing these faults to your attention that some good will come of this. In the meatime, I await a prompt response. As for our client, depending upon your promptness, they may not cancel the current licensing agreement with you. H. O'Loughlin, CEO O'LOUGHLIN ASSOCIATES CORPORATIION CC:/BLIND LIST - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How can I kill the slow query automatically?
Hi Marc, Thanks for the suggestion. I hope you would be kind enought to provide another. My application is transactional, in the business sense, in that, at the point of sale, the transactions must be quick. So inventory must be updated quickly to move the people through the line. The question is would not UPDATE LOW PRIORTY make the UPDATES then wait for any slow selects to finish before proceeding, thus making the point of sale pontentialy suffer? Maybe I don't understand UPDATE LOW PRIORITY. I think in my case I have conflicting requirement, but the main focus is to move the people at the cash register out the door :) These are ususaly very quick and short queries. This conflicts with reporting and product ordering and even data mining. Which in my case could be given a low priority, but not if it locks tables, or even run without locking (as our old system did!). Any advice or discussion is appreciated. Thanks, Ken - Original Message - From: Marc Prewitt [EMAIL PROTECTED] To: Ken Menzel [EMAIL PROTECTED] Cc: °í¼ø¹Î [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, April 07, 2002 6:43 PM Subject: Re: How can I kill the slow query automatically? Without setting up replication, you could use 'UPDATE LOW PRIORITY': http://www.mysql.com/doc/U/P/UPDATE.html If you do setup replication, you can set the replica database to use low priority updates too by using the --low-priority-updates option to mysqld: http://www.mysql.com/doc/C/o/Command-line_options.html You should try both of these before switching to innodb as the performance is not as fast as myisam. -Marc Ken Menzel wrote: Hi, There is no way to kill slow queries autmatically unless you were to write a script (maybe in perl or php?) to do this job. I have a similar problem and am thinking of replicating the database just to avoid this problem. I would then direct certain type of queries to the replicated server. The issue I have is I need selects not to lock the table for update! On FreeBSD this seems also to cause the CPU usage to jump very high. I was thinking of writing some test scripts, but I think the real answer for both of us may be to change to the InnoDB table type. Have you tried this? use ALTER TABLE type=innodb, after you have intalled mysql-max and created the tablespace. I hope this helps, Ken - Original Message - From: °í¼ø¹Î [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 5:28 AM Subject: How can I kill the slow query automatically? My DB has many update queries and a few select queries. Sometimes select queries take very long time so update can't proceed. I can kill the select query manually. But I can't check the status all the time. Are there any ways to kill slow query automatically? If you know, please let me know. Any information will be appreciated. - 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 AUTO_INCREMENT return from INSERT function into a table ?
At 21:36 -0700 4/7/02, Son Nguyen wrote: --- BD [EMAIL PROTECTED] wrote: Son, At 09:48 PM 4/7/2002, you wrote: mysql desc threads; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | thread_ID | int(11) | | PRI | NULL| auto_increment | | subject | varchar(255) | YES | | NULL| | | author | varchar(30) | YES | | NULL| | | last_by | varchar(30) | YES | | NULL| | | views | int(11) | | | 0 | | | date_posted | datetime | YES | | NULL| | +-+--+--+-+-++ 6 rows in set (0.00 sec) $SQL_insert_thread = INSERT into threads ; $SQL_insert_thread .= (subject, author, last_by, views, ; $SQL_insert_thread .= date_posted) values ; $SQL_insert_thread .= (\'some_subject\', \'test_username\', $SQL_insert_thread .= \'test_username\', 1, now()); In the table threads above, I do have a field: thread_ID with auto_increment value. My question is can I obtain the value thread_ID while I do the insert statement just by 1 mySQL statement? If yes, please can somebody give me a sample code? No. You have to create the record first in order to generate the AUTO_INCREMENT value. execute the MySQL query: select last_insert_id(); 1st: select last_insert_id() doesn't work It should. 2nd: It's not the answer I am looking for ... Because of the race condition if two users access the that script at the same time... I will have when I leave the INSERT statement !!! There is no race condtion. LAST_INSERT_ID() is designed to avoid that problem; it's connection-specific, so it doesn't matter what other users are doing. This is explained in the MySQL manual. Here is what I mean: think about this situation: USER 1 === INSERT STOP == due to process scheduling USER 2 === INSERT SELECT last_insert_id(); USER 1 === SELECT last_insert_id(); It's the race condition, I am talking about. LAST_INSERT_ID() makes the race condition irrelevant. - 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: ignore the first sting in order
Hi, Table example: _The Rock Scary Movie X-Files With order I want the output Scary Movie _The Rock X-Files After reading your message again, look like this is what you've been searching for. Sorry :( select * from movies order by substring_index(movietitle, '_', -1); And if you have underscores in the rest of the title, it won't work well... Regards, Sasa »mysql, select, 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: Do any of your applications work?
-Original Message- From: Hugh O'Loughlin [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 06, 2002 7:32 AM To: [EMAIL PROTECTED] Subject: Do any of your applications work? Responsible Person, We have been asked by a client, to use your products in our intergration efforts. Your MySQL 3.23.49a [Stable version?] for Sun Solaris x86, version, 5.8, is offered without the installation file ./scripts/mysql_install_db. The ./scripts/mysql_install_db, that comes with it, is EMPTY! Your MySQL-MAX 3.23.49a, although it gets a little further along in the installation phase [in that a deamon start-up], only some of the commands are execuatble/executing. This is not a normal [nor acceptable] situation in the UNIX world, when commands in the same directory are not all executable [No PATH problems here]. None of the following commands seem to work: mysql, mysqladmin, BINDER/(anything), just to name a few. The instructions were followed to the dot [as we have previously done with REDHat Linux 7.2, of the above mentioned]. We have also come to find, that your JDBC [mm.mysql.jdbc-1.2c.tar.gz] driver currently has a problem in being recognised in the FORTE developement environment. Please know, that we are not at all new to the communal-developement environment. However, whenevr anything is posted to be working, it should be exactly that. Ommission errors of the magnitude we have found, are pure 'Microsoftish' in nature, and should have no place anywhere, integrity not withstanding. Besides our practice of believing, that sometimes bad things happen to good people/things, perhaps by us bringing these faults to your attention that some good will come of this. In the meatime, I await a prompt response. As for our client, depending upon your promptness, they may not cancel the current licensing agreement with you. Will they cancel their licensing agreement with MySQL or with you?? I'd pity them if it is with MySQL . O'Loughlin, CEO O'LOUGHLIN ASSOCIATES CORPORATIION CC:/BLIND LIST - 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
char() function
Hi guys, Our java code blows up when we try to insert a string with a ';' inside of it. So we tried to do a work-around by replacing ';' with '||CHAR(59)||' to insert it, using the char function and the character's respecitve ascii value. So instead of: insert into table (key, field) values (1, 'test;string'); we had: insert into table (key, field) values (1, 'test'||CHAR(59)||' string'); it seems to work initially...(Query OK, 1 row affected (0.00 sec)) but when I try to select the value of the field I get just the value '0' (string of zero). Anyone know what gives? If not, any ideas on another way to handle the problem? It seemed like the CHAR() function was made for situations like this thanks, Don - 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: 200 milions records
Subject: Re: 200 milions records From: Vic Cekvenich [EMAIL PROTECTED] === 1. Use PostgreSQL. 2. Use multi channel disk cache controller 3. Get rid of not NULL. 4. index a primary seqnecy key It should be subsecond. Vic ddd wrote: HI, I want to insert into db 200.000.000 records of type (int6,int6).. the structure is: CREATE TABLE word_page ( IDword mediumint(6) NOT NULL default '0', IDpage mediumint(6) NOT NULL default '0', KEY IDword (IDword) ) TYPE=MyISAM; What do you think of it,, how would be the speed after then when i do simple select query ... for example Select IDpage where IDword=44 What should I do for best performance? thanks regards _ddd - 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: Do any of your applications work?
The only thing I wish is to know who his client was or is and set them straight on MySQL and get some extra work ;). Probably trying to sell them the hacker proof Oracle..LMAO. MySQL Select * - 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: char() function
nevermind...instead of using '||' to concat the fields i needed to use the CONCAT() function. So the syntax should have been: insert into table (key, field) values (1, CONCAT('test',CHAR(59), ' string')); still...I wonder why I got a 'Query OK, 1 row affected' message -Don -Original Message- From: Don Vu Sent: Monday, April 08, 2002 11:08 AM To: MySQL Mailing List (E-mail) Subject: char() function Hi guys, Our java code blows up when we try to insert a string with a ';' inside of it. So we tried to do a work-around by replacing ';' with '||CHAR(59)||' to insert it, using the char function and the character's respecitve ascii value. So instead of: insert into table (key, field) values (1, 'test;string'); we had: insert into table (key, field) values (1, 'test'||CHAR(59)||' string'); it seems to work initially...(Query OK, 1 row affected (0.00 sec)) but when I try to select the value of the field I get just the value '0' (string of zero). Anyone know what gives? If not, any ideas on another way to handle the problem? It seemed like the CHAR() function was made for situations like this thanks, Don - 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: char() function
Hi. Have a look at http://www.mysql.com/doc/E/x/Extensions_to_ANSI.html (rather at the end). || has a different meaning in MySQL started without explicit --ansi. Also see http://www.mysql.com/doc/A/N/ANSI_mode.html. Bye, Benjamin. On Mon, Apr 08, 2002 at 11:08:15AM -0400, [EMAIL PROTECTED] wrote: Hi guys, Our java code blows up when we try to insert a string with a ';' inside of it. So we tried to do a work-around by replacing ';' with '||CHAR(59)||' to insert it, using the char function and the character's respecitve ascii value. So instead of: [...] -- [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
no subject
Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a table. For example I only like to see the names and birthday? Or will as so all fields for a given table. Chuck Payne - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: adding 8-bit character encoding to mysql-max-3.23.49-win
Taavi, Monday, April 08, 2002, 3:39:29 PM, you wrote: TT Is it possible to add new 8-bit character encoding to compiled TT mysql (version 3.23.49-win) without recompiling? No, you should re-configure and re-compile after adding new character set. You can read instruction how to add new character set at: http://www.mysql.com/doc/A/d/Adding_character_set.html TT I would like to add ISO8859-15 encoding that seems not to TT be present in default installation. TT with best wishes, TT Taavi -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Question about Cross Compiling MySql
豤Èñ, Monday, April 08, 2002, 10:44:47 AM, you wrote: I Wonder If Cross Comile is Possbile. Yes, it's possible, but this case needs deep involvement and a long-time check-up works... Maybe Monty will clarify something. I was trying to make Makefile by using configure shell script(Mysql 4.0.1 Alpha version). Target was Linux PPC and Compile Platform was Solaris Sparc. But test program could not be runned in cross compile environment. That resulted that Makefile count not be made. What shall I do? How can I make Makefile and A.out int Cross Compile Environment? Thanks!. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FOREIGN KEY Constraints
Carl, Monday, April 08, 2002, 3:16:26 AM, you wrote: CS From the mysql docs, it looks like you can only use foreign keys if your CS tables are type InnoDB. Is this correct? Yes, you are right. In MyISAM tables you can use REFERENCE clause, but it does nothing. CS Carl -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help restoring data with mysqlbinlog
balteo, Sunday, April 07, 2002, 3:50:05 PM, you wrote: b I am trying to restore some data from the binary log and I am not sure on b how to proceed. b I understand restoring data is a two-stage process: b 1. You start by restoring data saved with mysqldump. b 2. Using mysqlbinlog, you restore the data logged in the binary log from the b point where mysqldump stopped. b It is on this second point that I would be grateful to get some help. My b question is specifically: how does one know the value of the parameter b position to pass on to mysqlbinlog? Option --position points on position in the log file where binlog reading begins. To get more info use: mysqlbinlog --help b Thanks in advance, b Balteo. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: foreign keys
root, Monday, April 08, 2002, 12:24:42 PM, you wrote: r i tried to use the foreign key feature in mysql 4.0.1 using innodb tables . r then i have tried the delete cascade feature but it didn't work . I don't r know why ? have you any suggestions ? . InnoDB does not yet support ON DELETE CASCADE ... -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: Help with Tables Please
Soheil, Monday, April 08, 2002, 7:09:44 AM, you wrote: SS Thanks for the tip Dan, SS I changed it, but it still gives me the same error. SS Any other suggestion? hm ... I have tested your example and it worked fine ... What version of MySQL server do you use and how did you changed column type? SS In the last episode (Apr 07), Soheil Shaghaghi said: Hi all, I have create the following mysql table, and when I try to add more than 128 rows in the table, I get this error: Duplicate entry '127' for key 1 I have no duplicate entries in there, and I can not figure out what's going on! CREATE TABLE CMSHOWNREQUIREDFIELDS1 ( FieldID tinyint(4) DEFAULT '0' NOT NULL, PRIMARY KEY (FieldID) ); SS This is a FAQ. TINYINT has a range of -127 to 127. Change it to INT. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql_install_db locks after
Chris, Monday, April 08, 2002, 4:52:26 PM, you wrote: CL I'm having some trouble with mysql.. Running the mysql_install_db renders CL this... CL Installing all prepared tables CL At this point the script locks at this point won't go any further. CL I am using CL MySQL-3.23.49a-1.i386.rpm CL MySQL-client-3.23.49a-1.i386.rpm CL Red Hat Linux version 2.2.16-22 CL The install (rpm --install) goes in fine - I don't have any trouble until I CL run the mysql_install_db script. CL I have tried several different mysql rpms - from Redhat - from mysql.org to CL no avail. There must be something simple I am overlooking - but I just CL can't seem to see the trees through the forest. If you installed MySQL server from RPM you shouldn't run mysql_install_db script. CL Any help would be GREATLY appreciated! CL Thanks! CL Chris Lamrock -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication: Slave performance
Hi there, currently I am using a single server for my webapp. Within the next days I get another box which will host the mysql-database (which is currently running on the other server). I want to set up replication between the 2 ones, using my current server as SLAVE and the new on as master. Does this make sence? All queries and datamanipulations are (and will be) performed by the current server (which is running out of resources...). Will the load on my current server decrease if I set it up as SLAVE and having all connections to the new master? thanks in advance pero - 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: no subject
On Monday 08 April 2002 9:49 am, Chuck \PUP\ Payne wrote: Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a table. For example I only like to see the names and birthday? Or will as so all fields for a given table. SELECT field1, field2 FROM tablename WHERE condition; - 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: no subject
Chuck, Monday, April 08, 2002, 6:49:20 PM, you wrote: CPP Ok, I know I am going to get yell about this but how can I do an SQL and CPP only show to fields from a table. For example I only like to see the names CPP and birthday? Or will as so all fields for a given table. If you want to see data from certain columns you should specify column names in the SELECT statement, for example: SELECT name, birthday from table_name; Look at: http://www.mysql.com/doc/R/e/Retrieving_data.html http://www.mysql.com/doc/S/E/SELECT.html CPP Chuck Payne -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql
mysql See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - 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: no subject
SELECT name,birthday FROM mytable -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 10:49 AM To: MySQL Mailing List (E-mail) Subject: no subject Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a table. For example I only like to see the names and birthday? Or will as so all fields for a given table. Chuck Payne - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: no subject
select name, birthday from ??? order by name; Along those lines anyway. Chuck \PUP\ Payne wrote: * This Message Was Virus Checked With : SAVI 3.54 Feb 2002 Last Updated 25th March 2002 * Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a table. For example I only like to see the names and birthday? Or will as so all fields for a given table. Chuck Payne - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Email: [EMAIL PROTECTED] [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
SPAM ALERT -Original Message- From: va ku [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 11:04 AM To: [EMAIL PROTECTED] Subject: mysql mysql See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_02 0201/splash.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql
sometimes, all you can say is LOL and walk away shaking your head...thinking... *...the poor guy actually went to the trouble of defeating the filter, only later to invite the flames of hell upon his head* -Original Message- From: va ku [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 12:04 PM To: [EMAIL PROTECTED] Subject: mysql mysql See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.co m/lycos_020201/splash.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: show to fields from a table
6.6.2 DESCRIBE Syntax (Get Information About Columns) http://www.mysql.com/doc/D/E/DESCRIBE.html ... aka MySQL(homePage)-Search::subject. C:~ -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 9:04 AM To: 'Chuck PUP Payne'; MySQL Mailing List (E-mail) Subject: RE: no subject SELECT name,birthday FROM mytable -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 10:49 AM To: MySQL Mailing List (E-mail) Subject: no subject Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a table. For example I only like to see the names and birthday? Or will as so all fields for a given table. Chuck Payne - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: no subject
Thanks, I got it :) I am using phpMySQL and command line and I couldn't see anything because it was showing everything but now I am cool. Again everyone thanks. Chuck Payne On 4/8/02 12:03 PM, Rick Emery [EMAIL PROTECTED] wrote: SELECT name,birthday FROM mytable -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 10:49 AM To: MySQL Mailing List (E-mail) Subject: no subject Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a table. For example I only like to see the names and birthday? Or will as so all fields for a given table. Chuck Payne - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie Question on Replication
After a orderly system and MySQL shutdown and restart of both slave and master, replication failed to start on the slave. Any suggestions on how to get replication going again without shutting down, taking a snapshot and starting replication would be greatly appreciated. The error logs on the slave show the following: Slave: reconnected to master 'slave@master:3306', Replication resumed in log 'FIRST' at position 4 Error reading packet from server: could not open log file (read_errno 0, server errno=2) I did a slave start and stop and am getting the same error. I can telnet from master to slave and slave to master. File permissions on the master seem to be OK. Master Status shows only master-bin.065 4732281 Slave Status shows Connect_retry 60Log_file Pos 4 Slave running yes Thanks, Howie Kamholz - 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
Benchmark test
Hello! On your homepage i have seen that you did Benchmark tests with MYSQL and MS Access 2000(on Windows) and compared the Benchmark results. I also want to do this but i dont know how to do such Benchmarktests on MYSQL and Access because i am a beginner in working with these databases. so please help me!!! i hope my english isn't that bad:-) thanks steve -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net - 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: RE: Help with Tables Please
Thanks, It worked :) It was my mistake! Thanks again, Soheil Soheil, Monday, April 08, 2002, 7:09:44 AM, you wrote: SS Thanks for the tip Dan, SS I changed it, but it still gives me the same error. SS Any other suggestion? hm ... I have tested your example and it worked fine ... What version of MySQL server do you use and how did you changed column type? SS In the last episode (Apr 07), Soheil Shaghaghi said: Hi all, I have create the following mysql table, and when I try to add more than 128 rows in the table, I get this error: Duplicate entry '127' for key 1 I have no duplicate entries in there, and I can not figure out what's going on! CREATE TABLE CMSHOWNREQUIREDFIELDS1 ( FieldID tinyint(4) DEFAULT '0' NOT NULL, PRIMARY KEY (FieldID) ); SS This is a FAQ. TINYINT has a range of -127 to 127. Change it to INT. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL won't keep running on my Mac OSX
I'm having trouble keeping MySQL running on my computer (PowerBook G3 -Firewire, 576MB RAM, G3/400 - 40GB HD with plenty free in the main OS X partition). I'm running OS X 10.1.3. 1. I installed MySQL (binary) in \Users\hill\MySQL\ directory (logged in as me/hill, not root) 2. I can run the install and safe_mysqld and initially get the database up and running. I can log in as root (database not OS), assign passwords. I can even load PHPMyAdmin and manage the databases. 3. If I restart the computer or log-off/log-on, I've received different errors. The main error is Error 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). I've also gotten an error that the current user is not authorized or some other issue with password. I can't connect to the database to test out what the 'password' is supposed to be. So then . 4. If I delete the \data\ directory contents, I can reinstall and go through the process again. It will work well until I do a sleep or restart and then I must delete and do everything all over. I'm somewhat new to UNIX (used it many years ago) and don't know all the tricks, tests but am not uncomfortable digging around for fixes. And I know there are too many folks with success that it's obviously something on/about my system, but not sure where to dive in. Can someone give me an idea as to why the database won't keep running or at least some things to check for? Thanks in advance for any help. -- Jay Hill NetLearning, Inc. Knoxville, Tennessee 865.251.4335 www.net-learning.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
Help restoring data with mysqlbinlog
Victoria, Thanks for replying. How does one know what parameter to pass on as position, in other words how do I know from what point to start the roll-forward from the binlog? What's more what format is this parameter? (timestamp, integer??) Thanks, Balteo. P.S. I tried mysqlbinlog --help but It doesn't tell you much - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SQL Script stopping
You have a semicolon(;) after the line Service CHAR (80) Besides after CREATE TABLE tablename syntax you have to define the columns and their datatypes in parenthesis. See: http://www.mysql.com/doc/C/R/CREATE_TABLE.html Gurhan -Original Message- From: Jim Swanson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 12:07 PM To: [EMAIL PROTECTED] Subject: SQL Script stopping I have a script I'm trying to run through the mysql command. When I run the script, I get a 1064 error, specifically CREATE TABLE 185_s_Prices\g PriceID INT NOT NULL DEFAULT 0, Service CHAR (80); Category CHAR (20),--- here Can anyone tell me what's wrong with this line? I dumped the tables, changed Category to ctg, still the same error. I'm running a fresh install of Mandrake 8.2. Thanks in advance. Jim Swanson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SQL Script stopping
ERROR 1064 at line 1: You have an error in your SQL syntax near ' ' at line 1 - perhaps you'd prefer the semicolon to complete your query - C:~ -Original Message- From: Jim Swanson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 9:07 AM To: [EMAIL PROTECTED] Subject: SQL Script stopping I have a script I'm trying to run through the mysql command. When I run the script, I get a 1064 error, specifically CREATE TABLE 185_s_Prices\g PriceID INT NOT NULL DEFAULT 0, Service CHAR (80); Category CHAR (20),--- here Can anyone tell me what's wrong with this line? I dumped the tables, changed Category to ctg, still the same error. I'm running a fresh install of Mandrake 8.2. Thanks in advance. Jim Swanson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Best field type for ID?
Hi everyone, What is the best field type to use for an ID field which is the primary key and auto-increment? I wanted to use SMALLINT UNSIGNED because its half the bytes of INT but was wondering what happens when it reaches 65535, does the auto-increment go back to 1 or will it cause an error? Should one use INT instead? Regards Luke van Blerk (mysql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Concurrent Connections Ceiling?
Anybody have any idea what kind of concurrent user load MySQL is (or at least should be) capable of handling? - 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
Reg MYSQL and JAVA
Hi, I don't know is this is the correct form. I am looking for some help in developing report on Java. I am using MYSQL and Java for development. I need to generate a formatted output which contains values from database, some paragraphs etc. I am expecting a report in 'doc' or 'rtf' or 'pdf' format. Can you suggest any free software for this purpose. Regards See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - 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 and GCC
I have a system here based on Red Hat's 7.2 distribution and I am wanting to get MySQL up and running. After browsing your web page it seems that I will have go to a different version of gcc. Would I be safe to go to the latest version (3.0.4) of gcc? Barry Blatz Pason Systems Corp. (403) 301-3481 [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: SQL Script stopping
The semi-colon (;) after Service CHAR(80) should be a comma (,). On Mon, 8 Apr 2002, Jim Swanson wrote: I have a script I'm trying to run through the mysql command. When I run the script, I get a 1064 error, specifically CREATE TABLE 185_s_Prices\g PriceID INT NOT NULL DEFAULT 0, Service CHAR (80); Category CHAR (20),--- here Can anyone tell me what's wrong with this line? I dumped the tables, changed Category to ctg, still the same error. I'm running a fresh install of Mandrake 8.2. Thanks in advance. Jim Swanson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL won't keep running on my Mac OSX
I have the same exact setup down to the hardware (believe it or not). Your best game plan is to install the MySQL binary distro into /usr/local/mysql as the root user. And then run the MySQL server as root. You'll have to start the MySQL Server when you start the laptop. Otherwise, you can log out or put the laptop to sleep, and the MySQL server should keep running. This setup works fine on my G3-firewire Mac OS 10.1.3 Lap Top computer. -RG On Mon, 8 Apr 2002, Jay Hill wrote: I'm having trouble keeping MySQL running on my computer (PowerBook G3 -Firewire, 576MB RAM, G3/400 - 40GB HD with plenty free in the main OS X partition). I'm running OS X 10.1.3. 1. I installed MySQL (binary) in \Users\hill\MySQL\ directory (logged in as me/hill, not root) 2. I can run the install and safe_mysqld and initially get the database up and running. I can log in as root (database not OS), assign passwords. I can even load PHPMyAdmin and manage the databases. 3. If I restart the computer or log-off/log-on, I've received different errors. The main error is Error 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). I've also gotten an error that the current user is not authorized or some other issue with password. I can't connect to the database to test out what the 'password' is supposed to be. So then . 4. If I delete the \data\ directory contents, I can reinstall and go through the process again. It will work well until I do a sleep or restart and then I must delete and do everything all over. I'm somewhat new to UNIX (used it many years ago) and don't know all the tricks, tests but am not uncomfortable digging around for fixes. And I know there are too many folks with success that it's obviously something on/about my system, but not sure where to dive in. Can someone give me an idea as to why the database won't keep running or at least some things to check for? Thanks in advance for any help. -- Jay Hill NetLearning, Inc. Knoxville, Tennessee 865.251.4335 www.net-learning.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL Script stopping
Also, the CREATE TABLE statement doesn't look right. It should probably be: create table 185_s_Prices ( PriceID INT NOT NULL DEFAULT 0, Service CHAR (80), Category CHAR (20) ); See the MySQL Manual section on CREATE TABLE. On Mon, 8 Apr 2002, Jim Swanson wrote: I have a script I'm trying to run through the mysql command. When I run the script, I get a 1064 error, specifically CREATE TABLE 185_s_Prices\g PriceID INT NOT NULL DEFAULT 0, Service CHAR (80); Category CHAR (20),--- here Can anyone tell me what's wrong with this line? I dumped the tables, changed Category to ctg, still the same error. I'm running a fresh install of Mandrake 8.2. Thanks in advance. Jim Swanson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
database setup
Hi, I am setting up a mysql database, with two tables. One keeps the user authentication info such as user name, password and user level. The other table with contains files for upload and download. Is there a good way to setup the user authentication table so it can check appropriate user rights (user level) then provide the appropriate upload or download page? I came up with a scheme as follows, userlevel unsigned tinyint not null primary key, username char(8) not null, userpass char(16) not null I can store user passwords using MySQL's password encryption. But when I need to access the upload/download table I need to somehow notify the database that what level of access the user has. If I set userlevel=1 (or any number) after succesful authentication in the script, I would compromised the other table. As hackers can change userlevel in the php script without going through the authentication. Can someone please provide me a couple of pointers how I go about setting up my database? TIA. Regards, Norman - 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
binlog and replication stuff
Hello. I'm using MySQL-3.23.38 on 5 RedHat 7.1/7.2 servers composed by one master and 4 mysql slave, every write is made on the master and then replicated to the slave. The problem is that if one client crash or must be rebooted i've to: - on the mysql master stop mysql, delete binlogfile, tar all the data in a file and then restart mysql - on ALL the mysql slave stop mysql, delete all data, get the tar file from the master and the restart mysql so i've to restart all mysql slave even if only one is really crash, if i don't do this i loose the syncronization between master and slave (as shown in the mysql.log). As your experience what do you do when a mysql slave crash and loose the sync? I would like to use a method to restart only the crashed client without touch other's slave and without restart master. I could make a backup script that get all the data from the the master (like mysqlhotcopy) without restart nothing, but what about the binlog file? i could FLUSH them in the server but then other slave will loose the sync I appreciate any help or suggestion. Best Regards. -- Davide Giunchi. Membro del FoLUG (Forlí Linux User Group) - http://folug.linux.it GPG Key available on http://www.keyserver.net Fingerprint: 8075 363A B4FA 0196 FEEC AF9C 19A9 66C7 CDAB D0D5 - 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: Help with Tables Please
FieldID INT UNSIGNED DEFAULT '0' NOT NULL, -Original Message- From: Soheil Shaghaghi [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 07, 2002 11:10 PM To: [EMAIL PROTECTED] Subject: RE: Help with Tables Please Thanks for the tip Dan, I changed it, but it still gives me the same error. Any other suggestion? -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 07, 2002 7:08 PM To: Soheil Shaghaghi Cc: [EMAIL PROTECTED] Subject: Re: Help with Tables Please In the last episode (Apr 07), Soheil Shaghaghi said: Hi all, I have create the following mysql table, and when I try to add more than 128 rows in the table, I get this error: Duplicate entry '127' for key 1 I have no duplicate entries in there, and I can not figure out what's going on! CREATE TABLE CMSHOWNREQUIREDFIELDS1 ( FieldID tinyint(4) DEFAULT '0' NOT NULL, PRIMARY KEY (FieldID) ); This is a FAQ. TINYINT has a range of -127 to 127. Change it to INT. -- Dan Nelson [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 - 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: Best field type for ID?
* Luke van Blerk What is the best field type to use for an ID field which is the primary key and auto-increment? I wanted to use SMALLINT UNSIGNED because its half the bytes of INT but was wondering what happens when it reaches 65535, does the auto-increment go back to 1 or will it cause an error? Should one use INT instead? The best type to use is the one big enough to hold your expected biggest value, but not bigger. If you think 65535 is too small, use the next bigger type, MEDIUMINT UNSIGNED. Don't use INT just to be sure... been there, done that... ;) when your table grows big, you will benefit from the fact that you save a byte for every column, making the indexes smaller faster. -- Roger query - 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 won't keep running on my Mac OSX
At 12:48 -0400 4/8/02, Jay Hill wrote: I'm having trouble keeping MySQL running on my computer (PowerBook G3 -Firewire, 576MB RAM, G3/400 - 40GB HD with plenty free in the main OS X partition). I'm running OS X 10.1.3. 1. I installed MySQL (binary) in \Users\hill\MySQL\ directory (logged in as me/hill, not root) DOS paths? What? 2. I can run the install and safe_mysqld and initially get the database up and running. I can log in as root (database not OS), assign passwords. I can even load PHPMyAdmin and manage the databases. 3. If I restart the computer or log-off/log-on, I've received different errors. The main error is Error 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). I've also gotten an error that the current user is not authorized or some other issue with password. I can't connect to the database to test out what the 'password' is supposed to be. So then . 4. If I delete the \data\ directory contents, I can reinstall and go through the process again. It will work well until I do a sleep or restart and then I must delete and do everything all over. Sounds like you don't have your system set up to start MySQL at boot time. Go to this page: http://www.entropy.ch/software/macosx/mysql/ The page contains a link for an item called mysql-startupitem.pkg.tar.gz. Download that package and install it. Then cd into /Library/StartupItems/MySQL and edit the file MySQL in that directory to reflect the actual pathname where your MySQL distribution is installed. I'm somewhat new to UNIX (used it many years ago) and don't know all the tricks, tests but am not uncomfortable digging around for fixes. And I know there are too many folks with success that it's obviously something on/about my system, but not sure where to dive in. Can someone give me an idea as to why the database won't keep running or at least some things to check for? Thanks in advance for any help. -- Jay Hill NetLearning, Inc. Knoxville, Tennessee 865.251.4335 www.net-learning.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: Concurrent Connections Ceiling?
* Tab Alleman Anybody have any idea what kind of concurrent user load MySQL is (or at least should be) capable of handling? This depends on a lot of factors, the application and the hardware beeing the most important ones... the recent benchmark test in eweek may give you some hints: URL: http://www.mysql.com/news/article-91.html -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: database setup
First, I assume that the same value for userlevel may be used by multiple users. That is, multiple users can have userlevel equal to 1 or equal to 2 or 3 or whatever. Therefore, you CANNOT use userlevel as PRIMARY KEY. PRIMARY KEY is a UNIQUE identifier. Thus, I recommend that each user be identified by a unique user_id. user_id int unsigned not null primary key, userlevel unsigned tinyint not null, username char(8) not null, userpass char(16) not null, security_key int Next, once the user is authenticated, you can pass value of user_id through sessions, to preserve security. Include with the session values a unique, random key that is generated during authentication. Store this random key in security_key. When a user makes a download/upload request, ensure that the key stored in the database is the same as that of the session. -Original Message- From: Norman Zhang [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 12:49 PM To: [EMAIL PROTECTED] Subject: database setup Hi, I am setting up a mysql database, with two tables. One keeps the user authentication info such as user name, password and user level. The other table with contains files for upload and download. Is there a good way to setup the user authentication table so it can check appropriate user rights (user level) then provide the appropriate upload or download page? I came up with a scheme as follows, userlevel unsigned tinyint not null primary key, username char(8) not null, userpass char(16) not null I can store user passwords using MySQL's password encryption. But when I need to access the upload/download table I need to somehow notify the database that what level of access the user has. If I set userlevel=1 (or any number) after succesful authentication in the script, I would compromised the other table. As hackers can change userlevel in the php script without going through the authentication. Can someone please provide me a couple of pointers how I go about setting up my database? TIA. Regards, Norman - 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 TEMPORARY TABLE
If I want to use temporary tables I know I can create tables that are unique without using CREATE TEMPORARY TABLE table_name. What I want to know, because it might be more efficient, is if I use CREATE TEMPORARY TABLE table_name and more than one person hits the page (I am using PHP to access the MySQL DB), does the second person have to wait until the first person is done and the temporary table is gone before the temporary table is created again, or is it unique for each connection. Example: if 100 people hit the page at the same time, will each have a temporary table called table_name that only their connection can see, meaning that there would actually be 100 tables with the same name? I sure hope that makes since. Thanks Steve Buehler - 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: FOREIGN KEY Constraints
Hi, Yes, you are right but be aware with the delete cascade feature, maybe in the way?. Regards - Original Message - From: Carl Schmidt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 07, 2002 7:16 PM Subject: FOREIGN KEY Constraints From the mysql docs, it looks like you can only use foreign keys if your tables are type InnoDB. Is this correct? Carl - 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: Best field type for ID?
On 8 Apr 2002, at 20:20, Roger Baklund wrote: The best type to use is the one big enough to hold your expected biggest value, but not bigger. But when calculating your expected biggest value, keep in mind that the autoincrement counter increases on every attempted insert, even if the insert fails. That may or may not be significant, depending on what indexes your table has and how you do your inserts. [Filter fodder: SQL, query] -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.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
Re: char() function
Hello. On Mon, Apr 08, 2002 at 11:24:56AM -0400, [EMAIL PROTECTED] wrote: [...] still...I wonder why I got a 'Query OK, 1 row affected' message [...] insert into table (key, field) values (1, 'test'||CHAR(59)||' string'); it seems to work initially...(Query OK, 1 row affected (0.00 sec)) but when I try to select the value of the field I get just the value '0' (string of zero). [...] That's because it is a valid expression. In the context of ||, 'test' will be converted to a number. Same for CHAR(59) which returns a string: mysql SELECT 'test' + 0, 'test' || 0, CHAR(59) || 0, VERSION(); ++-+---+---+ | 'test' + 0 | 'test' || 0 | CHAR(59) || 0 | VERSION() | ++-+---+---+ | 0 | 0 | 0 | 3.23.42-debug-log | ++-+---+---+ 1 row in set (0.00 sec) ORing the expressions with || results in a boolean value which is represented by 1 (true) or 0 (false) respectively. So your insert INSERT INTO table1 (key, field) VALUES (1, 'test'||CHAR(59)||' string') statement boils down to INSERT INTO table1 (key, field) VALUES (1, 0) which is perfectly valid. Well, with some other strings, you could get even a 1 as result :-) mysql SELECT '21test' || 0, CHAR(53) || 0; +---+---+ | '12test' || 0 | CHAR(53) || 0 | +---+---+ | 1 | 1 | +---+---+ 1 row in set (0.00 sec) Bye, Benjamin. -- [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
Uninstall Mysql
Can anyone tell me how can I uninstall mysql. I have done it again. I have messed up my permission. I dont know what is is that i'm doing that makes me loose my previleges. I keep getting the access denied error Kathy Reyes Live Technology International 2975 Westchester Avenue Suite 103 Purchase, NY 10577 Tel: (914) 490-7096 [EMAIL PROTECTED] www.LiveTechnology.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: CREATE TEMPORARY TABLE
Thank You. That is what I was hoping for. I would assume that this would be faster than actually coming up with a random name, using srand and rand, for a table, creating it and deleting it when done. Thanks Steve Buehler At 02:19 PM 4/8/2002, you wrote: Yes a TEMPORARY TABLE is specific to the connection if 100 people have the same name on a Temporary table they are still separate tables that only exist to the connection that created them. -Original Message- From: Steve Buehler [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 2:40 PM To: mysql Subject: CREATE TEMPORARY TABLE If I want to use temporary tables I know I can create tables that are unique without using CREATE TEMPORARY TABLE table_name. What I want to know, because it might be more efficient, is if I use CREATE TEMPORARY TABLE table_name and more than one person hits the page (I am using PHP to access the MySQL DB), does the second person have to wait until the first person is done and the temporary table is gone before the temporary table is created again, or is it unique for each connection. Example: if 100 people hit the page at the same time, will each have a temporary table called table_name that only their connection can see, meaning that there would actually be 100 tables with the same name? I sure hope that makes since. Thanks Steve Buehler - 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: CREATE TEMPORARY TABLE
On Mon, Apr 08, 2002 at 01:40:02PM -0500, Steve Buehler wrote: If I want to use temporary tables I know I can create tables that are unique without using CREATE TEMPORARY TABLE table_name. What I want to know, because it might be more efficient, is if I use CREATE TEMPORARY TABLE table_name and more than one person hits the page (I am using PHP to access the MySQL DB), does the second person have to wait until the first person is done and the temporary table is gone before the temporary table is created again, or is it unique for each connection. There should be no waiting involed, other than the time required to create the table(s). Example: if 100 people hit the page at the same time, will each have a temporary table called table_name that only their connection can see, meaning that there would actually be 100 tables with the same name? Yes. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 60 days, processed 1,630,321,161 queries (313/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
Running mysql on a certain IP
I need to run two MySQL servers on one machine. One needs to use /var/lib/mysql.sock and the other needs to use /home/mindbender/production/db/mysql.sock One needs to run on one ip address: ie: 10.0.0.10:3306 and the other on 10.0.0.11:3306 how do I tell mysql to run only on a certain IP address? - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 - 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: Running mysql on a certain IP
On Mon, Apr 08, 2002 at 03:04:58PM -0500, Johnny Withers wrote: I need to run two MySQL servers on one machine. One needs to use /var/lib/mysql.sock and the other needs to use /home/mindbender/production/db/mysql.sock One needs to run on one ip address: ie: 10.0.0.10:3306 and the other on 10.0.0.11:3306 how do I tell mysql to run only on a certain IP address? --bind-address, as described in the manual. 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.47-max: up 60 days, processed 1,631,748,118 queries (313/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
HELP!
Dear all of member, Would you help me, how to install, setup, and configure MySQL in my server with O/S windows 2000 server and IIS v. 5 Thank you, Best Regards, - 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: Uninstall Mysql
Hi, You give up so quicly? What OS use for MySQL? - Original Message - From: Kathy Reyes [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Monday, April 08, 2002 10:10 PM Subject: Uninstall Mysql Can anyone tell me how can I uninstall mysql. I have done it again. I have messed up my permission. I dont know what is is that i'm doing that makes me loose my previleges. I keep getting the access denied error Kathy Reyes Live Technology International 2975 Westchester Avenue Suite 103 Purchase, NY 10577 Tel: (914) 490-7096 [EMAIL PROTECTED] www.LiveTechnology.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
mysql and java
Hey Guys, I'm not sure if this is the right place to ask this question, but to be honest I didn't know where else to turn since my script deals with mysql. Here's my problem: I am using stylesheets and javascript to display a small blurb about a review on my site and it display is in a stylesheet which is only visible when the mouse is over the link. The page is here for a reference: http://www.hardware-unlimited.com/hardware.php (The [Description] link is where im using java script) Here's my ordeal, this mysql script generates syntax that is hidden from the viewer until they put their mouse over a review for a description, however it has to store this lil bit of syntax 90 times (beacuse I have 90 reviews listed on the page) and it starts to add up, my page is already 132K and I need to make it smaller. Is it possible to somehow store these descriptions in a mysql table or on another page and then have them linked to when you put your mouse over the link? Syntax for descriptions is here: ?php $db = mysql_connect( db32.pair.com, **, ***); mysql_select_db( net3dual_reviews,$db); $search = mysql_query(SELECT * FROM hwureviews); while($num=mysql_fetch_array($search)) { printf (span id='%s' class='myStyle'table bgcolor='#025689' width='300' style='border-style: ridge; border-color: #00314F'trtdfont face='Tahoma, Verdana, Arial, Helvetica' size='2' color='#FF'bp align='center'Description for %s:/bbrbr/p%s/font/p/tr/td/table/span,$num[name],$num [name],$num[info]); } ? Syntax for links, displaying the descriptions is here: ?php $db = mysql_connect( db32.pair.com, **, ***); mysql_select_db( net3dual_reviews,$db); $r = mysql_query(SELECT * FROM hwureviews ORDER BY num DESC); $max = mysql_query(select max(num) from hwureviews,$db); while ($info = mysql_fetch_row($max)) { printf (bfont color='#ff'Hardware Reviews - %s Articles Total/b/fontbr, $info[0]); } while($a=mysql_fetch_array($r)) { printf (- a href=\%s\%s/a (Written by: a href=\mailto:%s\;%s/a) - [a href='%s' onMouseOver='if (window.event || document.layers) show(\%s\,event)' onMouseOut='hide(\%s\)'Description/a]br,$a[url],$a[name],$a[ema il],$a[author],$a[url],$a[name],$a[name]); } ? I need to somehow have the ='if (window.event || document.layers) show(\%s\,event)' onMouseOut='hide(\%s\)' syntax pull its data from a mysql table or another page, how can I do this? Thanks! -Alex Big Al Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [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
MySQL 3.23.43-nt stop working after approx 10 days.
I have a problem with my MySQL server, it has started to stop working after approximately 10 days of uptime. After a reboot it works fine again. The users get the error can't connect to server on localhost. I also have a testserver with similar setup, on that MySQL has run for 54 days with no problems. I run MySQL V 3.23.43-nt on Windows 2000. Best Regards Tommy Jensen - 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
DBD and Mysql
WinXp Crashed my D: drive and I had most everything backup.. So when I reinstalled ActivePerl 5.6.xx I downloaded via PPM (perl package installer) the DBI, DBIx::AnyDBD but could not find DBD:mysql. Where is the package for Windows.. I did find, at CPAN, the mysql.gz.tar version which I use with Linux but that requires a gzip, tar and a c compiler.. Now I was running CGI scripts on WinXP with my $dbh = DBI- connect( DBI:mysql:Adatabase,bobby,bobby) and this worked. Will someone point me to the Win module for DBD:mysql.. Bob T - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql and java
this is actually OT, btw, but I'll try to answer... need to make it smaller. Is it possible to somehow store these descriptions in a mysql table or on another page and then have them linked to when you put your mouse over the link? No. There are methods of accessing databases from the client-side in a browser, such as MS's RDS, but that's beyond the scope of this mailing list. It's actually beyond the scope of server-side programming in general, as what you are interested in is a client-side problem. Perhaps XML and XSLT might better help you solve your problem, but again, that's beyond the scope of this list... I'd be happy to help you work thru this problem if you want to contact me off-list... greg - 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: Running mysql on a certain IP
Yes, I found this about 2 seconds after I sent my email.. However, I still can not get mysql to run on either a) different ip address on port 3306 or b) same ip address on port 3307 Either way, I get the error: 020408 15:47:00 mysqld started 020408 15:47:00 Can't start server: Bind on TCP/IP port: Address already in use 020408 15:47:00 Do you already have another mysqld server running on port: 3306 ? 020408 15:47:00 Aborting 020408 15:47:00 /usr/sbin/mysqld-max: Shutdown Complete 020408 15:47:00 mysqld ended Here's the setup I have: in my.cnf: # The MySQL server [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock skip-locking . . !-- snip -- . . [mysqld_multi] mysqld = /usr/bin/safe_mysqld mysqladmin = /usr/bin/mysqladmin [mysqld2] socket = /home/mindbender/production/db/mysql.socket port = 3307 pid-file = /home/mindbender/production/db/mysql.pid datadir= /home/mindbender/production/db #EOF# Then, I simply want to run mysqld_multi start 2 but, it says it can't bind to 3306 on the ip address.. and as you can see I'm telling it to use 3307 I've even tried: /usr/sbin/mysqld-max \ --bind-address=10.0.0.50 \ --port=3306 \ --data-dir=/home/mindbender/production/db \ --socket=/home/mindbender/production/db/mysql.socket \ --pid-file=/home/mindbender/production/db/mysql.pid And this does nothing at all except display the variables I may set when I run mysqld_max (as if I didn't pass anything at all for mysqld_max to do at startup) I'm at a loss here? I read somewhere that mysql reads /etc/my.cnf before it does any command line options, is this correct? If so, how can I have a my.cnf file and then run two servers if I have to have a [mysqld] section in the my.cnf file that tells the server which port and socket to listen on? Should I remove the [mysqld] section from the file and start the servers from the command line using command line options and just leave the innodb/mysql-client options in my.cnf ? Any help ? - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 3:10 PM To: Johnny Withers Cc: [EMAIL PROTECTED] Subject: Re: Running mysql on a certain IP On Mon, Apr 08, 2002 at 03:04:58PM -0500, Johnny Withers wrote: I need to run two MySQL servers on one machine. One needs to use /var/lib/mysql.sock and the other needs to use /home/mindbender/production/db/mysql.sock One needs to run on one ip address: ie: 10.0.0.10:3306 and the other on 10.0.0.11:3306 how do I tell mysql to run only on a certain IP address? --bind-address, as described in the manual. 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.47-max: up 60 days, processed 1,631,748,118 queries (313/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
Re: Reg MYSQL and JAVA
Hi, Thanks for the reply. I also need few 'doc' features such as 1. Bold letters 2. Formatted paragraphs The document I want to take a report is a student declaration form where on top it will display student details in the middle the declaration and at the end Signature. The document consists of predefined declaration with bold and italics, Big text size etc Any help is appreciated ? Regards -- On Mon, 8 Apr 2002 11:55:23 Christopher Thompson wrote: On Monday 08 April 2002 11:22 am, va ku wrote: I don't know is this is the correct form. Not really. I am looking for some help in developing report on Java. I am using MYSQL and Java for development. I need to generate a formatted output which contains values from database, some paragraphs etc. I am expecting a report in 'doc' or 'rtf' or 'pdf' format. Can you suggest any free software for this purpose. You will basically not be able to create any output in doc format, partly because it isn't a standard and partly because it isn't open. That said, you could easily use Java and MySQL to query a database and present the output in some format, such as comma-delimited. You wouldn't need anything other than Java and MySQL to do this. See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - 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
Strange behavior
I have a table with the following fields: id=autoincrement, int (11) ts_h=decimal ts_pid=int (11) ts_day=text There is a unique record where ts_pid=60 and ts_day=2002032800 (ts_h=0). If I do [update t_timesheet set ts_h=0 where ts_pid=60 and ts_day=2002032800 ], every thing works fine. (nothing is changed because the values remain the same) But if I change the query to ts_h=1: [update t_timesheet set ts_h=1 where ts_pid=60 and ts_day=2002032800 ] The record is deleted instead of being update. I changed ts_h to a decimal, or integer, same behavior. It deletes my record instead of updating it. Any idea why this occurs? Thank you. Jean-Louis - 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: Reg MYSQL and JAVA
still OT, but here goes anyway... you can in fact use PHP or ASP or whatever to generate PDFs. See http://www.pdflib.com/pdflib/index.html -Original Message- From: va ku [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 5:04 PM To: Christopher Thompson; [EMAIL PROTECTED] Subject: Re: Reg MYSQL and JAVA Hi, Thanks for the reply. I also need few 'doc' features such as 1. Bold letters 2. Formatted paragraphs The document I want to take a report is a student declaration form where on top it will display student details in the middle the declaration and at the end Signature. The document consists of predefined declaration with bold and italics, Big text size etc Any help is appreciated ? Regards -- On Mon, 8 Apr 2002 11:55:23 Christopher Thompson wrote: On Monday 08 April 2002 11:22 am, va ku wrote: I don't know is this is the correct form. Not really. I am looking for some help in developing report on Java. I am using MYSQL and Java for development. I need to generate a formatted output which contains values from database, some paragraphs etc. I am expecting a report in 'doc' or 'rtf' or 'pdf' format. Can you suggest any free software for this purpose. You will basically not be able to create any output in doc format, partly because it isn't a standard and partly because it isn't open. That said, you could easily use Java and MySQL to query a database and present the output in some format, such as comma-delimited. You wouldn't need anything other than Java and MySQL to do this. See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.co m/lycos_020201/splash.asp - 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: Strange behavior
it worked for me: mysql describe t_timesheet; ++---+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-++ | id | int(11) | | PRI | NULL| auto_increment | | ts_h | decimal(10,0) | YES | | NULL|| | ts_pid | int(11) | YES | | NULL|| | ts_day | text | YES | | NULL|| ++---+--+-+-++ 4 rows in set (0.00 sec) mysql select * from t_timesheet; ++--+++ | id | ts_h | ts_pid | ts_day | ++--+++ | 1 |0 | 60 | 2002032800 | ++--+++ 1 row in set (0.00 sec) mysql update t_timesheet set ts_h=1 where ts_pid=60 and ts_day=2002032800; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select * from t_timesheet; ++--+++ | id | ts_h | ts_pid | ts_day | ++--+++ | 1 |1 | 60 | 2002032800 | ++--+++ 1 row in set (0.00 sec) -Original Message- From: LeTortorec, Jean-Louis [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 4:17 PM To: '[EMAIL PROTECTED]' Subject: Strange behavior I have a table with the following fields: id=autoincrement, int (11) ts_h=decimal ts_pid=int (11) ts_day=text There is a unique record where ts_pid=60 and ts_day=2002032800 (ts_h=0). If I do [update t_timesheet set ts_h=0 where ts_pid=60 and ts_day=2002032800 ], every thing works fine. (nothing is changed because the values remain the same) But if I change the query to ts_h=1: [update t_timesheet set ts_h=1 where ts_pid=60 and ts_day=2002032800 ] The record is deleted instead of being update. I changed ts_h to a decimal, or integer, same behavior. It deletes my record instead of updating it. Any idea why this occurs? Thank you. Jean-Louis - 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
sum function doubling
I have MySQL v. 3.23 The SUM function seems to be doubling one of my values when used in conjunction with another SUM function. Here I show that I have only 95 in insFreq: mysql select t2.andersonStart_pos, sum(t2.insFreq) from InsertionFreq t2 where t2.andersonStart_pos = 1072 group by t2.andersonStart_pos; +---+-+ | andersonStart_pos | sum(t2.insFreq) | +---+-+ | 1072 | 95 | +---+-+ Here I show I have 73 in delFreq: mysql select t1.andersonStart_pos, sum(t1.delFreq) from DeletionFreq t1 where t1.andersonStart_pos = 1072 group by t1.andersonStart_pos; +---+-+ | andersonStart_pos | sum(t1.delFreq) | +---+-+ | 1072 | 73 | +---+-+ OK. Now notice that insFreq has DOUBLED when used in conjunction with with delFreq! mysql select t1.andersonStart_pos, sum(t2.insFreq), sum(t1.delFreq) from InsertionFreq t2, DeletionFreq t1 where (t2.andersonStart_pos = 1072) and (t1.andersonStart_pos = 1072) group by t1.andersonStart_pos; +---+-+-+ | andersonStart_pos | sum(t2.insFreq) | sum(t1.delFreq) | +---+-+-+ | 1072 | 190 | 73 | +---+-+-+ Is this a known bug? I couldn't find anything. Or is it just my SQL? Any help is much appreciated! Thanks Ari - 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++ (?) bug
Hi, I've built MySQL++ 1.7.9 libs on an smp machine. But every application which is built using mysql++ crashes with segfault when invoking connect() method. For example: #include iostream #include mysql++ void main() { try { Connection con( use_exceptions ); con.connect(); } catch ( BadQuery er ) { std::cout er.error.c_str() endl; } } Last lines of strace - libc 2.2.5, linux 2.4.18 smp (the same result for libc 2.2.4, linux 2.4.16 smp).: .. open(/etc/mysql/my.cnf, O_RDONLY|O_LARGEFILE) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=1897, ...}) = 0 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40016000 read(3, # You can copy this to one of:\n#..., 4096) = 1897 read(3, , 4096) = 0 close(3)= 0 munmap(0x40016000, 4096)= 0 open(/var/lib/mysql/my.cnf, O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open(/home/projects/kia2/.my.cnf, O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) --- SIGSEGV (Segmentation fault) --- +++ killed by SIGSEGV +++ On another server (libc 2.2.4, linux 2.4.3, MySQL++ 1.7.9) the same place: open(/etc/mysql/my.cnf, O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open(/var/lib/mysql/my.cnf, O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open(/home/baubas/.my.cnf, O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) socket(PF_UNIX, SOCK_STREAM, 0) = 3 fcntl64(3, F_GETFL) = 0x2 (flags O_RDWR) connect(3, {sin_family=AF_UNIX, path=/var/run/mysqld/mysqld.sock}, 110) = -1 ENOENT (No such file or directory) shutdown(3, 2 /* send and receive */) = 0 close(3)= 0 brk(0x8058000) = 0x8058000 brk(0x805a000) = 0x805a000 fstat64(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 2), ...}) = 0 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40016000 write(1, Can\'t connect to local M..., 93) = 93 munmap(0x40016000, 4096)= 0 _exit(0)= ? I don't get where is the problem, because it crashes only on the second server. Any help would be appreciated. Thanks in advance :) .:: Andrius Armonas ::. .:: [EMAIL PROTECTED] ::. .:: http://baubas.andrius.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
Re: sum function doubling
On 8 Apr 2002, at 18:18, Ari B Kahn wrote: OK. Now notice that insFreq has DOUBLED when used in conjunction with with delFreq! mysql select t1.andersonStart_pos, sum(t2.insFreq), sum(t1.delFreq) from InsertionFreq t2, DeletionFreq t1 where (t2.andersonStart_pos = 1072) and (t1.andersonStart_pos = 1072) group by t1.andersonStart_pos; +---+-+-+ | andersonStart_pos | sum(t2.insFreq) | sum(t1.delFreq) | +---+-+-+ | 1072 | 190 | 73 | +---+-+-+ Is this a known bug? I couldn't find anything. Or is it just my SQL? It's your SQL. You're not specifying any criterion for joining the tables, so your result set will contain every possible combination of a row from InsertionFreq that has andersonStart_pos = 1072 and a row from DeletionFreq that has andersonStart_pos = 1072. That means if there are 2 rows like that in DeletionFreq your insFreq sum will be twice what you expected. If there's a relationship between the rows in the two tables, then use it to specify a join criterion. If there's not, then leave it as two queries the way you did first. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.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
Re: MySQL Power ?
On Friday 05 April 2002 11:32, Steve Rapaport wrote: I'm currently running MySQL for a big, fast app without problems. BUT: I'm in the middle of specifying a new application with a high load, and I'm consideing looking for alternatives to MySQL because without InnoDB, it gets really slow on tables with frequent updates and reads (no row locking). We have, for example, a session table that records all the incoming requests for holding state. Since it's constantly being updated and read, it is frequently locked, and there are often instances where 50 reads will stack up while a lock is held. This slows down the whole database. Only if you insist on locking your tables. If you're talking about a webapp, Apache only really will be servicing 1 request at a time, generally. I have yet to be forced to lock my session table. Maybe you rely too much on this one table? Also you might try using a HEAP table for session state. Its much much faster if you can afford the memory (but again, keep your session state small and simple!). With InnoDB, I'm sure this problem goes away, but as soon as we go to InnoDB, we have to pay for backups and support, which means we start looking around at 'pay' solutions. I guess I don't understand why you see InnoDB as being more expensive than using standard myisam. Its just a table handler, there are not that many fundamental differences in how things work, and 99% of the existing MySQL infrastructure works fine with any table type. Backups are pretty basically the same as ever, just back up the tablespaces! Admittedly they use the disk a bit different, but it has caused us no real problems. Is there something I'm missing? Steve However, my impression is that while the answer, for the very highest volumes, is that Oracle is better, the point at which Oracle betters MySQL is *much* higher than doubters might think. So, if anybody give the reply that Oracle is best at the high end, please could they also try to quantify the point at which MySQL begins to run out of steam - and what it is it can't do and Oracle can at that point. (For example, MySQL can handle high read loads by use of replication, but would bottleneck on high write loads - I think). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL vs. MS SQL
On Friday 05 April 2002 02:25, David Williamson wrote: Hi there, I will shortly be installing a MySQL server at my place of work, the box I will be installing it on currently has MS SQL server running as well. (I believe its a wintel box). Anyway, I am wondering if there are any known problems having MS SQL and MySQL running on the same machine. My personal opinion is no - but I need to find some info to reassure the network guys:) Any information on this subject will be greatly appreciated. Regards, David Should be fine. I never ran both at high load together, but they will at least peacefully coexist, and on a dual 1 Ghz PIII with 1 gig ram and some fast SCSI drives both seemed pretty snappy (well SQL Server is NEVER snappy, but you know what I mean... ;o)). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL vs. MS SQL
If your databases have any size to them (like more than 1/2 the amount of ram you have), you'll need to manage memory. SQL Expects to be an only child. Check out sp_configure in books on line to learn how to limit the amount of RAM sql will take At 06:56 PM 4/8/2002 -0500, Tod Harter wrote: On Friday 05 April 2002 02:25, David Williamson wrote: Hi there, I will shortly be installing a MySQL server at my place of work, the box I will be installing it on currently has MS SQL server running as well. (I believe its a wintel box). Anyway, I am wondering if there are any known problems having MS SQL and MySQL running on the same machine. My personal opinion is no - but I need to find some info to reassure the network guys:) Any information on this subject will be greatly appreciated. Regards, David Should be fine. I never ran both at high load together, but they will at least peacefully coexist, and on a dual 1 Ghz PIII with 1 gig ram and some fast SCSI drives both seemed pretty snappy (well SQL Server is NEVER snappy, but you know what I mean... ;o)). - 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