Re: Sun and mysql
On Thu, 17 Jan 2008 11:07:19 -0500 Olaf Stein [EMAIL PROTECTED] wrote: I am still amazed by the fact that youtube is worth 1.5 billion and MySQL AB barely 1 billion. Did they sell under price? Or does Google just have way to much many to spend/waste? On Thu, 17 Jan 2008 10:14:36 -0600 Jay Blanchard [EMAIL PROTECTED] wrote: Or that Facebook is 'worth' multiple billions when they do not really have a way to make money yet. Uh, you both have to be kidding comparing MySQL with Youtube and Facebook, right? I'm not saying the $1 billion for MySQL was the right price, I believe it was a bargain for Sun but you are comparing apples and oranges. Go out on the street and ask people if they ever heard of these three. I bet you a few people will know MySQL, a lot will know Facebook and everybody will know Youtube. Youtube and Facebook are websites, visited by millions of people every day. That's what makes it it's value, future and present advertisements. YouTube was even used by CNN for the Republican and Democratic debates. Did you ever hear of MySQL on TV, anywhere? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
condense mulitple tables....
I am using 3 different systems... Each have a registration system... I believe they all use md5 to encrypt the password. Is it possible to just put as the value of the password record something like this: dbname.dbtablename So that it will be that value, instead of one that is inserted into the database? Then I can have them all use the same usernames and password for all the systems, instead of having 3 different ones? One is Perl, two are PHP. Thank you. Richard
Show Master Status php
I am having a heck of a time ... I would like to use php to do a SHOW MASTER STATUS and print the output but for the life of me can't figure it out. I can get it to SHOW DATABASES and SHOW TABLES in a database but now SHOW MASTER STATUS or SHOW SLAVE STATUS. David Rodgers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Huge Server configuration
Hello all, I have a server like 8way Intel Pentium 4 Xeon processor with 12GB RAM and 1TB harddisk space. All the tables size are over 10GB and they have over 100mm records. Could some one help me get an appropriate mysql configuration(my.conf) file for the machine. I understand ther are lots of factors depends on it to get a steady working configuration. All I need is some model configuration. I think later on I can tune thar up. Thanx in Advance -Chandra -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Huge Server configuration
Christopher Knight wrote: what table types? Innodb.etc... It is mainly innodb. about how many tables? there are around 200 tables do you do alot of sorting? Lots of sorting and fltering is done are the exact same queries repeated alot? Not likely is the machine doing anything else or is mainly a DB server? Nope. Just DB. can I borrow the machine for awhile? Nope. It is our to be production box what version of mysql are you running? 4.0.14 Thanks for your reply -Chandra -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Huge Server configuration
Dathan Vance Pattishall wrote: NICE No matter how big your disks are, the number of spindles and throughput is your win. I have RAID 5 with 5 hardisks, so usuable number of spindle will only be 4. my.cnf 3.5x options skip-locking skip-name-resolve set-variable = tmp_table_size=4096 log-bin=binlog/something make sure binlog is a symlink to a separate partition / drive set-variable = key_buffer=4G set-variable = table_cache=2600 # make sure your OS can handle *2 this many file descriptors set-variable = sort_buffer=512M # this is not a common mem pool but a thread pool set-variable = record_buffer=512M set-variable = record_rnd_buffer=512M set-variable = myisam_sort_buffer_size=512M set-variable = max_allowed_packet=16M ---Original Message- --From: Mysql List [mailto:[EMAIL PROTECTED] --Sent: Thursday, July 24, 2003 9:38 AM --To: [EMAIL PROTECTED] --Subject: Huge Server configuration -- --Hello all, -- --I have a server like 8way Intel Pentium 4 Xeon processor with 12GB RAM --and 1TB harddisk space. --All the tables size are over 10GB and they have over 100mm records. -- --Could some one help me get an appropriate mysql configuration(my.conf) --file for the machine. -- --I understand ther are lots of factors depends on it to get a steady --working configuration. --All I need is some model configuration. I think later on I can tune thar --up. -- --Thanx in Advance ---Chandra -- -- -- -- --MySQL General Mailing List --For list archives: http://lists.mysql.com/mysql --To unsubscribe: --http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Huge Server configuration
Dathan Vance Pattishall wrote: RAID-5 is cool, RAID-1+0 (10) is better for writes. Your defiantly are going to be IO bound. I would go with many smaller disks = 20 disk, in multiple RAID-1+0 configurations on different channels or better yet different RAID controllers. Well I do not have the luxury. Money is already spent. Well there is no other way to change any of these things. This whole system will only act for readonly purpose. There will be not much of updates will be going on. Only for read with lots of filtering. Sorting is not a priority. Only for retreiving data with multiple conditions. some of the fields are indexed. some of them are not. but those will also be used in the where condition. Reason by example: Sun T3 with 7 drives. I'm IO bound with a read heavy 2 Gb where most of the data is in memory. I'm transferring 15Mb a second of read traffic. Please explain. Thanks Again Chandra -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: select part of a field into another field
Jason Joines wrote: I have a table with an email field that contains values of the form [EMAIL PROTECTED] I need to populate a new field called uid with just the uid part of the email address. Is there any way of using select to just retrieve the part before the @ and insert it into the uid field? select SUBSTRING(email, 1, INSTR(email, '@') - 1) frommytable limit 1,10; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Just a doubt.....
Hi, I made a table with a primary key,and all the columns i declared char got converted into varchar. plz someone throw a light on it as i had seen somewhere that using primary key increase search speed and using varchars decrease so im in confusion. :( http://www.mysql.com/doc/en/Silent_column_changes.html: 6.5.3.1 Silent Column Specification Changes In some cases, MySQL silently changes a column specification from that given in a CREATE TABLE statement. (This may also occur with ALTER TABLE.): VARCHAR columns with a length less than four are changed to CHAR. If any column in a table has a variable length, the entire row is variable-length as a result. Therefore, if a table contains any variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns longer than three characters are changed to VARCHAR columns. This doesn't affect how you use the columns in any way; in MySQL, VARCHAR is just a different way to store characters. MySQL performs this conversion because it saves space and makes table operations faster. See section 7 MySQL Table Types. Leander -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Insert using placeholders....
I'm using placeholders like this: (using Perl) $stmt .= , if $stmt; $stmt .= $f-{t_name} . = ?; my $temp_value_holder = $f-{value}; $temp_value_holder =~ s/\,/\;/g; push (@placeholder, $temp_value_holder); The reason I'm using a temp value then switching the commas with ; is because the syntax for the placeholders is using commas. the strings might contain commas, which throws the whole thing off. Is there a way to LEAVE the commas? Does MySQL recognize escapes if I where to switch the commas with an Escaped comma? or is there another way to do it? Thanks, Richard
How should I... [store data for later]
I am making my own shopping cart, and I'm trying to figure out, how to store previous orders, so they can view them later. If they have multiple products(tangible to be shipped), and they have the possibility of having colors, sizes, and or styles, each of them their own attribute, plus qty, and price, should I store that in ONE column, maybe like this: $column_data_to_insert = $item . '|' . $qty . '|' . $color . '|' . $size . '|' . $style . '|' . $extended_price . \n; then insert $column_data_to_insert into the database, in the one column. then when they look at their previous orders, have it take that column and parse it with a split statement: ($item,$qty,$color,$size,$style,$total_price) = split /\|/, $column_data_to_insert, 6; Something like that, or is there a standard way, or even better, a easier, faster and better way? Thanks, Richard.
Help With Default Value
I am trying to do one of two things. First I'd rather do this, but if not possible, then the other way that I'll describe will suffice. 1) I need to have a default value of a column named invoice_id be this: Column names of importance: idinvoice_id id is auto_increment and BIGINT unsigned. invoice_id needs to be gc+ id How can I have invoice_id have that as default? in other words if it's inserting data into that table, and it's the first record, then id would = 1. So I need invoice_id to be gc1 Is that possible? 2) If 1 is not possible, then how can I get the value of id of the one I just inserted? Is it possible to get that at the same time as I insert it, so I can then UPDATE that invoice_id with the correct data? If I need to clarify this, please by all means do let me know. Thank you, kindly, Richard
Re: Help With Default Value
Nevermind I got it $next_number = $dbh-selectrow_array(qq{ SELECT MAX(id) FROM whatever_table }); Richard. - Original Message - From: MySQL List [EMAIL PROTECTED] To: Bhavin Vyas [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, March 30, 2003 9:44 PM Subject: Re: Help With Default Value Ok, how do I get the MAX(id)? Thanks, Richard - Original Message - From: Bhavin Vyas [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, March 30, 2003 7:59 PM Subject: Re: Help With Default Value First option, I don't think, is possible. Reg. 2, You can get MAX(Id) before inserting, increment it by 1 in your script and then Insert 'gcId' as the invoice_id value. Bhavin. - Original Message - From: MySQL List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 30, 2003 7:23 PM Subject: Help With Default Value I am trying to do one of two things. First I'd rather do this, but if not possible, then the other way that I'll describe will suffice. 1) I need to have a default value of a column named invoice_id be this: Column names of importance: idinvoice_id id is auto_increment and BIGINT unsigned. invoice_id needs to be gc+ id How can I have invoice_id have that as default? in other words if it's inserting data into that table, and it's the first record, then id would = 1. So I need invoice_id to be gc1 Is that possible? 2) If 1 is not possible, then how can I get the value of id of the one I just inserted? Is it possible to get that at the same time as I insert it, so I can then UPDATE that invoice_id with the correct data? If I need to clarify this, please by all means do let me know. Thank you, kindly, Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[ADMIN] Mailing lists back in service.
Hello again, MySQL list subscriber! We have completed the first phase of maintenance on the mailing lists, and mail should now start flowing on the lists again. Along with upgrading the hardware serving the lists, we have put in place new systems to help combat spam. One part of this system requires that non-subscribers to the mailing list confirm that they are a real person before their message is let through to the list. (And depending on how your local systems are configured, even some subscribers may be required to go through this one-time confirmation.) We will be keeping a close eye on things to make sure no real emails get dropped by the new systems, but please bear with us in the event that a few pieces of spam email slip through in the meantime. The mailing list archives at http://lists.mysql.com/ have also received the first phase of a facelift, and we will be rolling out additional improvements there in the weeks to come. If you encounter any difficulties with the lists, please don't hesitate to drop us a line at [EMAIL PROTECTED] Again, we're sorry about the interruption and inconvenience, and thanks in advance for your patience as we work the kinks out of the new systems! - The MySQL Team -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[ADMIN] Mailing list maintenance this weekend.
Hello, MySQL list subscriber! We will be performing maintenance on the servers hosting the MySQL mailing lists this weekend, which will result in some periods of unavailability, and possible delays in mail delivery. Sorry about the interruption and inconvenience, and thanks for your patience! We will send another message to the lists once the work has been completed. - The MySQL Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Locating Duplicate records always results in Error 127
I am locating 'duplicate entries in a table and updating a status field accordingly. The idea is to locate rows which have a matching 'Name' field, and mark them for subsequent processing. However, my update query *ALWAYS* returns Error 127, even on a newly created table if the matching name field is 8 characters or more???. Below is a minimum script which always results in the error Got error 127 from table handler, with only two records in the table. Change the name fields from (8 chars) to AAA (7 chars) and no error. I would appreciate any help in tracking this down, or a suggestion for another way of detecting duplicate records which doesn't cause the problem. Ian # --- USE test; # # Table structure for table 'error127' # DROP TABLE IF EXISTS `error127`; CREATE TABLE `error127` ( `ItemID` int(11) NOT NULL default '0', `Name` varchar(70) NOT NULL default '', `Status` int(11) NOT NULL default '0', PRIMARY KEY (`ItemID`), KEY `Name` (`Name`) ) TYPE=MyISAM; # # Dumping data for table 'error127' # INSERT INTO `error127` (`ItemID`, `Name`) VALUES(1, ); INSERT INTO `error127` (`ItemID`, `Name`) VALUES(2, ); # # Set status # UPDATE error127 AS a,error127 AS b SET a.status=2 WHERE a.name = b.name AND a.itemid != b.itemid; # --- MySQL 4.011g, WinXP Prof -- Ian Wall - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Test
Adam Randall [EMAIL PROTECTED], Do you think the following links may help? * http://www.mysql.com/doc/en/Which_version.html * http://www.mysql.com/doc/en/MySQL_test_suite.html * http://www.mysql.com/doc/en/running_mysqltest.html * http://www.mysql.com/doc/en/extending_mysqltest.html * http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html This was an automated response to your email 'Test'. Final search keyword used to query the manual was 'Test'. Feedbacks, suggestions and complaints about me should be directed to [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: BUG: InnoDB ORDER BY DESC may hang in 4.0.10
Heikki Tuuri [EMAIL PROTECTED], Do you think the following links may help? * http://www.mysql.com/doc/en/DESCRIBE.html * http://www.mysql.com/doc/en/ALTER_TABLE.html * http://www.mysql.com/doc/en/Group_by_functions.html * http://www.mysql.com/doc/en/ORDER_BY_optimisation.html * http://www.mysql.com/doc/en/Change_column_order.html This was an automated response to your email 'BUG: InnoDB ORDER BY DESC may hang in 4.0.10'. Final search keyword used to query the manual was 'BUG: InnoDB ORDER BY DESC may hang 4.0.10'. Feedbacks, suggestions and complaints about me should be directed to [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: [BUG] Seg fault on REPLACE into large table
Chris Wilson [EMAIL PROTECTED], Do you think the following links may help? * http://www.mysql.com/doc/en/Packet_too_large.html * http://www.mysql.com/doc/en/Creating_many_tables.html * http://www.mysql.com/doc/en/REPLACE.html * http://www.mysql.com/doc/en/String_functions.html * http://www.mysql.com/doc/en/Client-Side_Overview.html This was an automated response to your email '[BUG] Seg fault on REPLACE into large table'. Final search keyword used to query the manual was '[BUG] Seg fault REPLACE into large table'. Feedbacks, suggestions and complaints about me should be directed to [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 and Windows XP (Pro)
Dan Cumpian [EMAIL PROTECTED], Do you think the following links may help? * http://www.mysql.com/doc/en/ODBC.html * http://www.mysql.com/doc/en/Contrib.html * http://www.mysql.com/doc/en/Windows_client_compiling.html * http://www.mysql.com/doc/en/Windows.html * http://www.mysql.com/doc/en/Win95_start.html This was an automated response to your email 'MySQL and Windows XP (Pro)'. Final search keyword used to query the manual was 'Windows XP (Pro)'. Feedbacks, suggestions and complaints about me should be directed to [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: Reading fixed column format file
[EMAIL PROTECTED], Do you think the following links may help? * http://www.mysql.com/doc/en/Static_format.html * http://www.mysql.com/doc/en/Miscellaneous_functions.html * http://www.mysql.com/doc/en/Compressed_format.html * http://www.mysql.com/doc/en/example-Maximum-column.html * http://www.mysql.com/doc/en/Column_types.html This was an automated response to your email 'Reading fixed column format file '. Final search keyword used to query the manual was 'Reading fixed column format file'. Feedbacks, suggestions and complaints about me should be directed to [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: How to Archive and restore the data in MySQL database.
Prasad Budim Ram [EMAIL PROTECTED], Do you think the following links may help? * http://www.mysql.com/doc/en/Asking_questions.html * http://www.mysql.com/doc/en/RESTORE_TABLE.html * http://www.mysql.com/doc/en/Miscellaneous_functions.html * http://www.mysql.com/doc/en/CREATE_DATABASE.html * http://www.mysql.com/doc/en/DROP_DATABASE.html This was an automated response to your email 'How to Archive and restore the data in MySQL database.'. Final search keyword used to query the manual was 'How to Archive restore the data database.'. Feedbacks, suggestions and complaints about me should be directed to [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: support question (win98_se) (auto)
Hi [EMAIL PROTECTED], I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: * http://www.mysql.com/doc/en/Business_Services_Support.html * http://www.mysql.com/doc/en/Which_OS.html * http://www.mysql.com/doc/en/MySQL_licenses.html * http://www.mysql.com/doc/en/Support.html * http://www.mysql.com/doc/en/Languages.html This was an automated response to your email 'support question (win98_se)'. Final search keyword used to query the manual was 'support (win98_se)'. Comming soon... * Support for mysql archives Feedbacks, suggestions and complaints should be directed to [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: converting MS SQL to MySQL
Hi Hawk [EMAIL PROTECTED], I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: * http://www.mysql.com/doc/en/Using_mSQL_tools.html * http://www.mysql.com/doc/en/Using_InnoDB_tables.html This was an automated response to your email 'converting MS SQL to MySQL'. Final search keyword used to query the manual was 'converting MS SQL'. Comming soon... * Support for querying mysql archives for related discussions. Feedbacks, suggestions and complaints should be directed to [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: replication
Hi [EMAIL PROTECTED], I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: * http://www.mysql.com/doc/en/Replication.html * http://www.mysql.com/doc/en/Replication_FAQ.html * http://www.mysql.com/doc/en/Replication_HOWTO.html * http://www.mysql.com/doc/en/Replication_SQL.html * http://www.mysql.com/doc/en/Replication_Problems.html * http://www.mysql.com/doc/en/Replication_Options.html * http://www.mysql.com/doc/en/Replication_Features.html * http://www.mysql.com/doc/en/Replication_Implementation.html This was an automated response to your email 'replication'. Final search keyword used to query the manual was 'replication'. Comming soon... * Support for querying mysql archives for related discussions. Feedbacks, suggestions and complaints should be directed to [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: Replication is out of sync? (auto)
Hi goth [EMAIL PROTECTED], I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: * http://www.mysql.com/doc/en/Commands_out_of_sync.html * http://www.mysql.com/doc/en/Replication.html * http://www.mysql.com/doc/en/Replication_HOWTO.html * http://www.mysql.com/doc/en/Replication_FAQ.html * http://www.mysql.com/doc/en/Replication_Problems.html This was an automated response to your email 'Replication is out of sync?'. Final search keyword used to query the manual was 'Replication out of sync'. Comming soon... * Support for mysql archives Feedbacks, suggestions and complaints should be directed to [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: natural left join (auto)
Hi Varshavchick Alexander [EMAIL PROTECTED], I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: * http://www.mysql.com/doc/en/JOIN.html * http://www.mysql.com/doc/en/LEFT_JOIN_optimisation.html * http://www.mysql.com/doc/en/String_functions.html * http://www.mysql.com/doc/en/Bit_functions.html * http://www.mysql.com/doc/en/libmysqld_TODO.html This was an automated response to your email 'natural left join'. Final search keyword used to query the manual was 'natural left join'. Comming soon... * Support for mysql archives Feedbacks, suggestions and complaints should be directed to [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: CREATE TABLE, NOT NULL fields, and empty strings (auto)
Hi Doug Beyer [EMAIL PROTECTED], I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: * http://www.mysql.com/doc/en/Problems_with_NULL.html * http://www.mysql.com/doc/en/CREATE_TABLE.html * http://www.mysql.com/doc/en/SHOW.html * http://www.mysql.com/doc/en/SHOW_CREATE_TABLE.html * http://www.mysql.com/doc/en/ODBC_administrator.html This was an automated response to your email 'CREATE TABLE, NOT NULL fields, and empty strings'. Final search keyword used to query the manual was 'CREATE TABLE NOT NULL fields empty strings'. Comming soon... * Support for mysql archives Feedbacks, suggestions and complaints should be directed to [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: SQLyog 3.02 Released (auto)
Hi Insanely Great [EMAIL PROTECTED], I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: * http://www.mysql.com/doc/en/Many_versions.html This was an automated response to your email 'SQLyog 3.02 Released'. Final search keyword used to query the manual was 'SQLyog 3.02 Released'. Comming soon... * Support for mysql archives Feedbacks, suggestions and complaints should be directed to [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: Replication error (auto)
Hi Oliver Schlag [EMAIL PROTECTED], I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: * http://www.mysql.com/doc/en/Replication_FAQ.html * http://www.mysql.com/doc/en/Replication.html * http://www.mysql.com/doc/en/Replication_HOWTO.html * http://www.mysql.com/doc/en/Replication_SQL.html * http://www.mysql.com/doc/en/Replication_Options.html This was an automated response to your email 'Replication error'. Final search keyword used to query the manual was 'Replication error'. Comming soon... * Support for mysql archives Feedbacks, suggestions and complaints should be directed to [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: converting MS SQL to MySQL
Hawk [EMAIL PROTECTED], Do you think the following links may help? * http://www.mysql.com/doc/en/Using_mSQL_tools.html * http://www.mysql.com/doc/en/Using_InnoDB_tables.html This was an automated response to your email 'converting MS SQL to MySQL'. Final search keyword used to query the manual was 'converting MS SQL to'. Feedbacks, suggestions and complaints about me should be directed to [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: InnoDB foreign keys bug
Scott Wong [EMAIL PROTECTED], Do you think the following links may help? * http://www.mysql.com/doc/en/example-Foreign_keys.html * http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html * http://www.mysql.com/doc/en/ALTER_TABLE.html * http://www.mysql.com/doc/en/Using_InnoDB_tables.html * http://www.mysql.com/doc/en/Indexes.html This was an automated response to your email 'InnoDB foreign keys bug'. Final search keyword used to query the manual was 'InnoDB foreign keys bug'. Feedbacks, suggestions and complaints about me should be directed to [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 on large server
Hi, I was wondering if anybody has built MySQL 3.23 from source that can handle a high number of connections threads. I've have tried MySQL binaries in the past (not RPMs), but these have had stability/load problems. When building from source I don't have those issues, but I am limited by the inbuilt limits (of glibc,etc...) I read that glibc needs to be modified and file descriptor limits need to be increased, but I have been unsuccessful in finding some definitive documentation to achieve this. I need to build MySQL 3.23 on a production server running RedHat 7.2, patched glibc (2.2.5-42) and a custom kernel (2.4.19-2 SMP). Hardware contains Dual Xeon 2.4GHz (hyperthreading disabled) and 6GB RAM. My understanding is that MySQL can handle is 500 connections (recommended setting) by default. This is something I would need to increase as well as the ability to handle more threads. I would appreciate any help whatsoever. Many thanks _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Date()
Look at the DATE_FORMAT function. http://www.mysql.com/doc/en/Date_and_time_functions.html -Original Message- From: hotel [mailto:[EMAIL PROTECTED]] Sent: Friday, November 29, 2002 6:07 PM To: mySQL Subject: Date() Is it possible for mySQL to recognize and compare dates written in this format: MM/DD/YY? I know standard date format for mySQL is YYY-MM-DD, but I need to be able to support this other format if possible. For example, I have a string of 01/30/02 and I just need to compare it to another value already in the dB, being held as a varchar with a value of 02/28/02. I need to compare these to determine if one date preceeds the other. Any way of doing this with the resources mySQL already has built in - without having to convert the format of the date values? Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
FULLTEXT search against a query result
Okay, here we go ... I would like to do a FULLTEXT search against a query result. There are multiple columns that have a FULLTEXT index. Hopefully I break this down in a manner that can be understood. The fields of interest: Table events: event_id [int(11)] event [varchar(255)] description [text] FULLTEXT (event, description) Table event_times: event_id [int(11)] from events.event_id start_date [date] place [varchar(255)] FULLTEXT (place) I would like to search the fields events.event, events.description, and event_times.place. So hypothetically it would look something like MATCH(events.event, events.description, event_times.place) AGAINST('keywords'). The results I need to use for the search is produced from the query: SELECT events.category_id, events.event_id, events.event, events.description, event_times.start_date, chc_event_times.place FROM events INNER JOIN event_times ON events.event_id = event_times.event_id GROUP BY events.event_id If this makes no sense to you or if you need more information, please let me know. Thanks for your time. Jay Douglas Systems Consultant Fort Collins, CO - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Relay Fails.
We are trying to setup the following MySQL replication MSSQL Server - Push replication to Server 1 Server 1 - (Receives push replication from MSSQL and is Master MySQL for Server 2) Server 2 - (Slave to Server 1, Master for Server 3) Server 3 - (Slave to Server 2) Okay to make a long story short we have a MSSQL server required by our accounting package. We use a push replication on the MSSQL server to replicate the data from MSSQL to a local MySQL database in a remote office (accounting office). The information in that database needs to be replicated over a relatively slow WAN link to a series of MySQL slaves. In order to save bandwidth we set-up a single MySQL server that will slave from the remote MySQL in our accounting office and redistribute the database to our other MySQL servers. The first MySQL server is in the remote accounting office. All updates and changes from the accounting department are made to that database server through a push replication from MSSQL. This part works fine. In another office we have a single MySQL server (Server 2) that is a slave to Server 1. We then have 4 MySQL servers which slave from Server 2. Since these are all identical read only slaves I'll refer to them collectively as Server 3 (they all experience the same behavior) The problem we are having is that Server 2 does not make the data it replicates from Server 1 available for replication to Server 3 Example We make data change to MSSQL MSSQL replicates the change to Server 1 Server 1 updates its master status to indicate new data Server 2 pulls the changes from Server 1 and updates its slave status to show its in sync with Server 1 Server 2 does NOT update its master status to indicate that anything has changed in its database Server 3's slave index still matches with server 2's master index so server 3 does not replicate the changes that server 2 received through replication. What seems to be strange is if we update server 2 directly with a change (make any update that does NOT come from replication) it will update its master status and Server 3 will replicate that change. It appears that MySQL does not treat replicated data as changed data when it comes to the master status and bin-log. We are using MySQL 4.0.4 as we require transaction support to do the push replication from MSSQL. Does anyone have an idea on how we can force server 2 to add the data it receives to its bin-log and update its master status so that it will be replicated down to server 3. Thanks in advance Kelvin Hockin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Rand slowness.
Hi, Is there a quicker way to get a selection of random rows than RAND()? I basically use: SELECT * FROM table ORDER BY RAND() LIMIT 3; But I find that as the # of rows increases in table, it keeps taking longer and longer to get a result back. And I am talking a large increase, basically 50 rows took about 1 second, 700 rows now takes almost a minute. I am not sure why the # of rows would affect RAND. I am using the latest version of Mysql and php4 to get the rows. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RAND slowness?
Hi, Can someone tell me which query would be faster with say 1000 rows: SELECT * FROM table ORDER BY RAND() LIMIT 3; or SELECT * FROM table; then use php to get 3 random rows from the returned data? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A LEFT OUTER JOIN question.
I have two tables, 'items' and 'stuff'. Items has a primary key of itemid. and looksmlike this ItemID other fields... 1 ... 2 3 4 5 6 Stuff contains something like this: ItemID type info 1 0blah blah 2 0something 2 1... 3 1... I want a query which returns all the items, and if it exists, the info field from related 'stuff' of type 0. So far I've got: SELECT Items.ItemID, Stuff.info FROM Items LEFT OUT JOIN Stuff ON Items.ItemID = Stuff.ItemID WHERE (type = 0 OR type = NULL); This works if there are no Stuff records with a type other than 0, eg, the last one in the example. The Query returns items 1,2,4,5, 6, no 3. How can I make a query which returns all items and type 0's info (if it exists)? ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: A LEFT OUTER JOIN question.
Hi Peter, Thanks a lot - that does the trick! Incredibly quick response :) Ian -Original Message- From: Peter Normann [mailto:[EMAIL PROTECTED]] Sent: 16 June 2002 17:06 To: 'mySQL list'; [EMAIL PROTECTED] Subject: RE: A LEFT OUTER JOIN question. Try SELECT Items.ItemID, Stuff.info FROM Items LEFT JOIN Stuff ON (Items.ItemID = Stuff.ItemID (type=0 || type IS NULL)); Peter Normann -Original Message- From: mySQL list [mailto:[EMAIL PROTECTED]] Sent: 16. juni 2002 17:59 To: [EMAIL PROTECTED] Subject: A LEFT OUTER JOIN question. I have two tables, 'items' and 'stuff'. Items has a primary key of itemid. and looksmlike this ItemID other fields... 1 ... 2 3 4 5 6 Stuff contains something like this: ItemID type info 1 0blah blah 2 0something 2 1... 3 1... I want a query which returns all the items, and if it exists, the info field from related 'stuff' of type 0. So far I've got: SELECT Items.ItemID, Stuff.info FROM Items LEFT OUT JOIN Stuff ON Items.ItemID = Stuff.ItemID WHERE (type = 0 OR type = NULL); This works if there are no Stuff records with a type other than 0, eg, the last one in the example. The Query returns items 1,2,4,5, 6, no 3. How can I make a query which returns all items and type 0's info (if it exists)? ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyODBC DSN Configuration Dialog Hidden
Hi, I have a vb application which connects to mysql via ado/myodbc 3.51.03. In it, users can choose to connect to databases on different machines. I construct a connection string from the hostname, database etc. So far so good. The problem I have only occurs (as far as I can tell) on Windows XP, not Windows 2000: If I try and connect to a host where mysql is not running, the driver (or at least I assume its the driver), pops up an error message box, saying [MySQL][ODBC 3.51 Driver] Can't connect to MySQL server on 'hostname' (10061), then after clicking ok, the DSN Configuration Dialog is opened, but hidden behind the application window. In contrast, on Windows 2000, no error message box or dsn dialog appears at all (which I prefer). I can't find any difference between the two machines except that the 2000 machine also has myodbc 2.5 installed, but not used. ANY help appreciated! ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC DSN Configuration Dialog Hidden
Hi Venu, The problem I have only occurs (as far as I can tell) on Windows XP, not Windows 2000: If I try and connect to a host where mysql is not running, the driver pops up an error message box, saying [MySQL][ODBC 3.51 Driver] Can't connect to MySQL server on 'hostname' (10061), then after clicking ok, the DSN Configuration Dialog is opened, but hidden behind the application window. In contrast, on Windows 2000, no error message box or dsn dialog appears at all (which I prefer). You can disable the re-connect prompt in ado by using DriverNoPrompt option from your conn.open method. I can't find any option to use DriverNoPrompt in ADO, only DAO, unless you mean in the OPTION= part of the connection string. Originally I had OPTION=35, I've tried OPTION=51 (adding 16 which should disable any prompts), but its just the same. You can also disable the prompt during the failed connection from the DSN using the option 'Don't prompt on connect'. And as far as hidden dialog, am not sure how does that come in to picture as we use XP and 2000 for all internal testing. Can you cross check whether the dialog is really active by using 'alt-tab' ? Yes it is there - alt-tab brings it to the front (and the Don't prompt on connect checkbox is set when I use OPTION=51). Regards, Ian Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ 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
UPDATE-ing a table with keys to a related table?
Hi, hope somebody can help me - what I want to do is simple I'm sure, but I can't work out how to do it: I want to replace a column in a table, containing text, with a key to another new table which holds the text. Example: Given a table, 'people', which contains two columns, name, and town, like this: name town ---- fred london joliverpool amy chicago mary chicago I create a new table, towns: townidtown -- 1 london 2 liverpool 3 chicago So far good. Now I want to add a townid column to 'people', and update to point to the corresponding row in 'towns'. I add a new column, townid, but then how do I update the values?? I have tried both of these: UPDATE people SET people.townid = towns.townid WHERE people.town=towns.town; and UPDATE people INNER JOIN towns ON people.town = towns.town SET people.townid = towns.townid; mysql gives syntax errors in both cases (both work ok with access 2000). Is there a way to do this without creating temporary intermediate tables? Any help greatly 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
Help with Auto Increment
Hi, How do I start an autoincrement field at a certain value, say 1000? I have a field as: ID INT NOT NULL AUTO_INCREMENT,PRIMARY KEY (ID) How do I modify it to start at 1000? These all generate errors: modify mytable ID AUTO_INCREMENT = 1000; modify mytable ID = 1000; modify mytable ID AUTO_INCREMENT 1000; And I can't find an example in the manual. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: User issues in installation. New beginner
In General Terms: Most default linux installs do not allow root user to telnet in to the machine, this is good as a default. You need to add the user that you do logon as to the MySQL permissions. This can be found in the manual. To access your MySQL db from Access, all you need to do is install the MySQLODBC driver and setup an ODBC source to point the your server. You should enter another User to MySQL for this, and allow only that user from a specific IP address(the machine access is on). You do not need Samba for this. Hey people, I've just set-up mysql on a redhat version6.1 of linux. I am new to both. If i log into the machine as root I can run mysql. If I log into the machine as a normal user I can't run mysql. Is it a case of permissions in linux? I need to be able to run mysql through a telnet window on a win98 machine. I have managed to telnet between the two but only as a normal user not as root. Should this be the case? Should I be able to telnet as root. I eventually want MS Access to call the databases on MySQL via ODBC (MyODBC)what configurations will I need to do to the two machines for this to possible? Do I need SAMBA installed? if so how? and why exactly? Any help will be greatly appreciated. Regards, Faizal. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.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
How many OR, AND in a query?
Hi, How many OR or AND can I put in a select query statement? ex: WHERE mycolumn = 1 OR mycolumn = 3 OR mycolumn = 23 etc . . . A thousand? How would that affect the database execution time? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How many OR, AND in a query?
in() is usefull for OR ing, but is there a way to do this AND ing? You might want to try: WHERE mycolumn in (1, 3, 23, ...) Or even better, put your thousand records into a temporary table and then just do a join. --jfarr - Original Message - From: Mysql List [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Wednesday, September 26, 2001 12:06 PM Subject: How many OR, AND in a query? Hi, How many OR or AND can I put in a select query statement? ex: WHERE mycolumn = 1 OR mycolumn = 3 OR mycolumn = 23 etc . . . A thousand? How would that affect the database execution time? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question
Hi, Why is mysql(ver 3.23.41) complaining about this: CREATE TABLE mytable(ID INT NOT NULL AUTO_INCREMENT = 1000,PRIMARY KEY (ID), I know it is not the entire statement, but mysql does not like the AUTO_INCREMENT = 1000 part, how do I do that so it is acceptable? Thanks, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
That didn't work either. The documentation seems to show that you have to use = 1000, but I can't get it to work. Try putting it like this :: AUTO_INCREMENT(1000), . Not sure but that should work - Deryck H - http://www.comp-u-exchange.com - Original Message - From: Mysql List [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Friday, September 07, 2001 3:49 PM Subject: Question Hi, Why is mysql(ver 3.23.41) complaining about this: CREATE TABLE mytable(ID INT NOT NULL AUTO_INCREMENT = 1000,PRIMARY KEY (ID), I know it is not the entire statement, but mysql does not like the AUTO_INCREMENT = 1000 part, how do I do that so it is acceptable? Thanks, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Question
Thanks, I already tried that, and I am only trying to insert about a dozen fields. Thanks for the response, I will wait and see if anyone else has an idea. Chris MaybeI guessThere's either too many datatypes or try putting like this (again, probably wont work) Auto_Increment=1000, . - Deryck H - http://www.comp-u-exchange.com - Original Message - From: Mysql List [EMAIL PROTECTED] To: Deryck Henson [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Friday, September 07, 2001 4:26 PM Subject: Re: Question That didn't work either. The documentation seems to show that you have to use = 1000, but I can't get it to work. Try putting it like this :: AUTO_INCREMENT(1000), . Not sure but that should work - Deryck H - http://www.comp-u-exchange.com - Original Message - From: Mysql List [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Friday, September 07, 2001 3:49 PM Subject: Question Hi, Why is mysql(ver 3.23.41) complaining about this: CREATE TABLE mytable(ID INT NOT NULL AUTO_INCREMENT = 1000,PRIMARY KEY (ID), I know it is not the entire statement, but mysql does not like the AUTO_INCREMENT = 1000 part, how do I do that so it is acceptable? Thanks, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query Question
Hi, Can any of you query experts tell me if this is possible in a query? I have 3 tables, categories, products, groups. Groups table consists of categoryid and productid, it just keeps track of which categories have which products. I need a query(if possible) that would basically say: Select all products that do not have an entry in groups with the corresponding categoryid of 1000 (example id) Basically, I bring up the category on a page, with all of the products that are grouped with it, and I want to select all the other products that are not already there. CategoryProductsGroups --- IDIDCID |PID --- 10001 10001 2 10002 3 4 Query would return products 3 4 because 1 2 are already grouped with Category 1000 Make sense? Chris
DuBois's book's scripts - where to get them?
I have the book, are the little scripts in the book available online? I went to the book's site at http://newriders.com/books/title.cfm?isbn=0735709211 which sent me to the author site at http://www.mysql.com/Contrib/Examples/ but gets the no permission error You don't have permission to access /pub/mirrors/mysql/Downloads/Contrib/Examples/ on this server. Any other place to get them from? __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What is the for in ' safe_mysqld --log '
I lost track of the tutorial where I saw the command safe_mysqld --log What is the for? __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Where to get a list of explanations for Errcodes?
When I attempt to get into this database this error comes up, but other databases work ok. I cannot find a reference to 'Errcode: 13' or any 'Errorcode' in the manual or mailing list archives. mysql use vhosts; Can't read dir of './vhosts/' (Errcode: 13) There is instruction on how to perform repair for specific tables but not for an entire database. Where should I start? once I start I could likely find the next step. Thanks for the help. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to start mysql server as user mysql
In my UNIX (FreeBSD) system the database directories shows up as below. drwx-- 2 mysql mysql512 May 11 11:51 mysql drwx-- 2 mysql mysql512 May 11 22:40 test I guess this means I should only start mysql server by being the user mysql. But how can I become the user mysql? The user/group mysql was created automatically during install and mysql is actually a system process, thus it has no password, the password database shows this listing for the user mysql. mysql:*:88:88::0:0:MySQL Daemon:/var/db/mysql:/sbin/nologin __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php