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 -060

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 th

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

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

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 l

Re: Huge Server configuration

= 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] --&g

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 ma

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

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_cha

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

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, a

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,

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 >

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.

[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

[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

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

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/MySQ

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

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-Maxi

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

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_

Re: How to build Relay Replication system ?

"Heo, Jungsu" <[EMAIL PROTECTED]>, Do you think the following links may help? * http://www.mysql.com/doc/en/Replication_HOWTO.html * http://www.mysql.com/doc/en/Replication.html * http://www.mysql.com/doc/en/Replication_FAQ.html * http://www.mysql.com/doc/en/Replic

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_op

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/exte

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/

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

Re: A query construction problem

Blaster <[EMAIL PROTECTED]>, Do you think the following links may help? * http://www.mysql.com/doc/en/InnoDB_Next-key_locking.html * http://www.mysql.com/doc/en/Query_log.html * http://www.mysql.com/doc/en/Query_results.html * http://www.mysql.com/doc/en/Query_Cach

Re: AW: apostrophe and comma error on submit (auto)

Hi "Rusch (ext) Reiner" <[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/Error_log.html * http://www.mysql.com/doc/en/Too_many_connections.html * http://www.my

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/

Re: speedup 'alter table' for large tables (auto)

Hi "Johannes Ullrich" <[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/Creating_many_tables.html * http://www.mysql.com/doc/en/ALTER_TABLE_problems.html * http

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 keyw

Re: Sorting with null values (auto)

Hi "Octavian Rasnita" <[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/NULL_values.html * http://www.mysq

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

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.mys

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/

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

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 t

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

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

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

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 s

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

Re: Rand slowness.

creases. > > Selecting a random value *PER ROW* ensures that a comparison between any two > given rows will always have the same result the second time you try it as it > did the first time you try it and will thus ensure deterministic and > reasonable sorting behavior. > > -J

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 row

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

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 w

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 'h

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,

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, lik

Re: Question

How about going to the dir where the mysql database is then just cp * /backupsqldatabase And just the other way when you want to restore then use fix database. Thats what I have done and it seems to work fine. > Hi, > > I am quite new with MySQL and I have a question. How can I easily make a > c

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

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_INCR

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 Messag

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 chec

Re: Question

t; 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]> >

Re: Question

hange.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 thi

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 ---

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 al

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

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/ ---

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 us

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 r