MOSSCon in Louisville in May! Submit your proposal this week!

2013-03-27 Thread John List
But get to it! The deadline for submitting your preliminary proposal is this Friday, March 29! http://mosscon.org/ Spread the word and submit your proposal! Thanks, John Hicks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: user last activity and log in

2012-10-04 Thread List Man
There is no such thing. Your application has to deal with such info. LS On Oct 4, 2012, at 11:28 AM, Aastha wrote: > Hello, > > I want to find the last time the given list of users logged in. > Is there any mysql table from where i can retrieve the data or anyt > specific sql

Re: Filesystem choice

2012-02-07 Thread List Man
rrier is too unsafe? Only for mysql partition, non for the root. rr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

mysqldumpslow error

2012-01-16 Thread List Man
om google. TIA, LS -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: setting max_allowed_packet dynamically problem

2011-11-03 Thread List Man
Thanks for the explanation. LS On Nov 3, 2011, at 4:41 PM, Dan Nelson wrote: > In the last episode (Nov 03), List Man said: >> I am running Server version: 5.1.45-log MySQL Community Server (GPL) and I >> attempted to change max packet with the following: SET GLOBAL >>

setting max_allowed_packet dynamically problem

2011-11-03 Thread List Man
I am running Server version: 5.1.45-log MySQL Community Server (GPL) and I attempted to change max packet with the following: SET GLOBAL max_allowed_packet=16*1024*1024; but it did not work properly. The configuration did not change by using the show variables command. I changed the configur

Re: Need Help Writing Simple Query

2010-07-25 Thread John List
able2 as hTable on hID = hTable.ID left join Table2 as vTable on vID = vTable.ID -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

max() can't work

2010-02-06 Thread tech list
select * from table_name where movid = max(movid); why the sql above can't work? Shall I use a sub-select instead? select * from table_name where movid = (select max(movid) from table_name) ? Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: I NEED HELP ON 'SOURCE(\.) MYSQL

2010-02-01 Thread John List
here are multiple mysql directories in most configurations.) --John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Is there a better way than this?

2009-12-27 Thread John List
On 12/27/2009 06:04 PM, Tim Molter wrote: I'm new to MySQL and I'm looking for some guidance. I have a table A, with two columns X and Y with the following data: | X|Y| 1 24 1 25 2 25 2 26 3 27 I want my SQL query to

Re: Temp file issues on Ubuntu 9.10

2009-11-08 Thread John List
mkdir /tmpfs mount -t tmpfs -o size=1g tmpfs /tmpfs mkdir /tmpfs/mysql chown mysql:mysql Probably should be: chown -R mysql:mysql /tmpfs/mysql john -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Sun and mysql

2008-01-17 Thread MySQL List
now 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? --

About charset

2007-08-27 Thread Jeff list
Hello list, I have a table whose 'default charset=utf8'. I insert a record into it with non-utf8 charset,like GBK.Then I select this record,it print GBK characters correctly. Then I insert a utf8 record into it,and read this record in scripts and decode it with utf8_decode,the resu

BUG in UNION implementation?! Confimation or Explaination please

2007-07-11 Thread list account
Hi all, I believe to have found a bug in MySQL's union implementation. Can someone confirm this, please or convince me that this is not a buggy behaviour of mysql : UNION seems to behave like DISTINCT by default: mysql> select 2 c1 -> union -> select 1 c1 -> union -> select 2 c1 -

SELECT data FROM two tables into outfile

2007-02-05 Thread List User
Hello list: Need some help with the following query: mysql> SELECT header.date_in,header.pid,header.status,body.body_data from header,body where header.date_in='1170705152' and body.date_in=header.date_in and header.pid='26878' and body.pid=header.pid into outfile '/t

Re: 'Not a valid MySQL result resource' error

2006-10-18 Thread List
Philip Mather wrote: List, Without getting into the specific problem the general debug path I'd follow would be: - 1. Make sure you are actually connected to the database, you say it's the admin area? Does the admin area login with different details? try eching the result of

'Not a valid MySQL result resource' error

2006-10-17 Thread List
com/viewevents.php?rid=$re[id]')\">$re[title]\n"; } $rcount = mysql_num_rows($r); if (($rcount == 6)) { print "href='http://www.website.com/specialevents.php'>continued...\n"; } ?> Any and all help is much appreciated, thanks. -- Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

What happened to left join under version 5?

2006-09-21 Thread Mailing List Receiver
| NULL|| | country | varchar(40) | YES | | NULL|| | rowid| int(11) unsigned | NO | PRI | NULL| auto_increment | +--+--+--+-+-++ Server version 5.0.22 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 1045 access denied after granting all privs

2006-02-08 Thread dan+mysql-general-discussion-list
the privilege tables directly. When you use GRANT and REVOKE, this isn't necessary. --df -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Re: Dump/restore - lost data!

2005-09-08 Thread Mailing List Receiver
qldump is for? There is no such option to mysqldump in version 4.1.11. Todd Merriman [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Dump/restore - lost data!

2005-09-08 Thread Mailing List Receiver
prised! Our solution, restore the dating by putting the version 3 isam file into the version 4 directory. Todd Merriman [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Update Query with special conditions.

2004-11-24 Thread list 123.
Sessions| | Staff | | StaffAttendance | +-+ 6 rows in set (0.00 sec) ____ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: confirm subscribe to mysql@lists.mysql.com

2004-11-04 Thread List Account
On Thursday 04 November 2004 01:13, [EMAIL PROTECTED] wrote: > To confirm that you would like > > [EMAIL PROTECTED] > > added to the mysql mailing list, please click on > the following link: > > http://lists.mysql.com/s/mysql/4189d686a90fba48/lists=buddhalinux.com >

[mysql] Question about the reference manual

2004-08-04 Thread rdo mail list address
al Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Equijoin on non-equality barfs!

2004-06-01 Thread Mailing List Receiver
mysql> select bademail.email from bademail,noemail where bademail.email <> noemail.email; bademail has about 30,000 rows and noemail has 13,000. This, by the way, does a good job of bringing your system to its knees! Todd Merriman mailist @ toolz.com -- MySQL General Mailing List

Need to know how many current connections

2004-05-02 Thread Mailing List Receiver
Todd Merriman eTotalHost.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

condense mulitple tables....

2004-02-04 Thread MySQL List
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

2004-01-08 Thread mysql-list
MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

encrypt() call on Win32

2003-08-03 Thread List User
While I found some information on this subject: http://groups.google.com/groups?q=mysql+win32+encrypt&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=be3g14%24ulu%241%40FreeBSD.csie.NCTU.edu.tw&rnum=1 I can't make much sense of it. Is there a *clear* way to have encrypt() call working on mySQL running on Wi

Re: select part of a field into another field

2003-07-24 Thread Mysql List
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: Huge Server configuration

2003-07-24 Thread Mysql List
ic. 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: Huge Server configuration

2003-07-24 Thread Mysql List
= 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

2003-07-24 Thread Mysql List
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

Huge Server configuration

2003-07-24 Thread Mysql List
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

add users for single database

2003-06-21 Thread Mailing List
I have a user who has permissions for a single database. The user wants to be able to add/delete users for the database. Can this be done? Thanks GNH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Just a doubt.....

2003-05-28 Thread Leander (mySQL-list)
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.mysq

Insert using placeholders....

2003-04-05 Thread MySQL List
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]

2003-03-31 Thread MySQL List
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

2003-03-30 Thread MySQL List
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

2003-03-30 Thread MySQL List
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

2003-03-30 Thread MySQL List
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.

2003-03-22 Thread MySQL List Administrator
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.

2003-03-21 Thread MySQL List Administrator
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

2003-03-17 Thread mySQL list
mid; # --- MySQL 4.011g, WinXP Prof -- Ian Wall - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (

Re: support question (win98_se) (auto)

2003-02-10 Thread mysql-list
_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

Re: How to Archive and restore the data in MySQL database.

2003-02-10 Thread mysql-list-bot
e 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/

Re: Reading fixed column format file

2003-02-10 Thread mysql-list-bot
s 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 &l

Re: MySQL and Windows XP (Pro)

2003-02-10 Thread mysql-list-bot
uld 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 unsub

Re: [BUG] Seg fault on REPLACE into large table

2003-02-10 Thread mysql-list-bot
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 r

Re: How to build Relay Replication system ?

2003-02-10 Thread mysql-list-bot
eedbacks, 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

Re: BUG: InnoDB ORDER BY DESC may hang in 4.0.10

2003-02-10 Thread mysql-list-bot
0'. 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 arch

Re: Test

2003-02-10 Thread mysql-list-bot
rected 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-

Re: InnoDB foreign keys bug

2003-02-09 Thread mysql-list-bot
ints 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 <[E

Re: converting MS SQL to MySQL

2003-02-09 Thread mysql-list-bot
php (the manual) http://lists.mysql.com/ (the list archive) 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 query construction problem

2003-02-09 Thread mysql-list-bot
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 PROTE

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

2003-02-09 Thread mysql-list
http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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)

2003-02-09 Thread mysql-list
(the manual) http://lists.mysql.com/ (the list archive) 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: speedup 'alter table' for large tables (auto)

2003-02-09 Thread mysql-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

Re: SQLyog 3.02 Released (auto)

2003-02-09 Thread mysql-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

Re: Sorting with null values (auto)

2003-02-09 Thread mysql-list
sql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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)

2003-02-09 Thread mysql-list
ng, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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)

2003-02-09 Thread mysql-list
nual) http://lists.mysql.com/ (the list archive) 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)

2003-02-09 Thread mysql-list
sql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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

2003-02-09 Thread mysql-list
laints 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 P

Re: converting MS SQL to MySQL

2003-02-09 Thread mysql-list
e 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 unsubscrib

MySQL on large server

2003-01-09 Thread mysql list
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:

Re: General question about rotating growing tables

2002-12-04 Thread Qmail List
But there would be no way to variably create the newtable table name correct? Thx - Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: "Qmail List" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, December 04, 2002 10:49

Re: General question about rotating growing tables

2002-12-04 Thread Qmail List
MySQL can do embedded SQL like that? I'm using 3.23. If so, can the embedded query have a WHERE clause as well (something like WHERE datetime > date_sub(NOW(), interval 1 month). Thx a lot - Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: "

General question about rotating growing tables

2002-12-04 Thread Qmail List
mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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()

2002-11-29 Thread Jay \(MySQL 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://lis

FULLTEXT search against a query result

2002-11-28 Thread Jay \(MySQL List\)
t 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: h

Replication Relay Fails.

2002-11-21 Thread MySQL List - Echo
nual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

date_sub, must use a datetime column type?

2002-10-28 Thread Qmail List
Hello List, Is it true that the date_sub function(s) will only work on datetime column types? SELECT count(id) as id FROM messages WHERE client_id = '2' AND datetime_col > date_sub(NOW(),interval 1 day) To get the above query to work, I had to change my datetime_col column from

Problems with LOAD DATA LOCAL INFILE

2002-10-07 Thread Mailing List Receiver
sure has caused a lot of trouble. Todd Merriman [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

RAND slowness?

2002-06-27 Thread MySQL List
check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Rand slowness.

2002-06-27 Thread MySQL List
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.

2002-06-27 Thread MySQL List
://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.

2002-06-16 Thread mySQL list
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.

2002-06-16 Thread mySQL list
sting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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

2002-06-07 Thread mySQL list
/__ MySQL AB, Developer > /_/ /_/\_, /___/\___\_\___/ California, USA ><___/ www.mysql.com > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (t

MyODBC DSN Configuration Dialog Hidden

2002-06-07 Thread mySQL list
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 u

UPDATE-ing a table with keys to a related table?

2002-05-18 Thread mySQL list
te 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]>

last_insert_id() query

2002-04-24 Thread mysql mailing list user
/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Error message

2002-03-20 Thread mysql mailing list user
. Howard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]>

Explanation of error message

2002-03-20 Thread mysql mailing list user
. Howard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]>

Re: MySQL Server Installation Problem

2002-03-20 Thread mysql mailing list user
--- > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe

Mystery files

2002-03-20 Thread mysql mailing list user
from my applications. What is going on can I delete them? Cheers Howard Miller - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Re: Table RAID

2002-03-19 Thread mysql mailing list user
] > /_/ /_/\_, /___/\___\_\___/ 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 requ

Re: Optimization And Memory Size

2002-03-19 Thread mysql mailing list user
??? Howard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail &

Re: Table RAID

2002-03-19 Thread mysql mailing list user
/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

drop down list using php and mysql

2002-03-15 Thread mailing list
Hello, I am trying to build a drop down list using php and mysql. Does anyone have any examples of this? Regards, Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

adding administrative users in mysql

2002-03-13 Thread mailing list
x27; (Using password: YES)' anyone have any ideas? Regards, Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this th

Basilix and MySQLhelp

2002-02-04 Thread Lionlike MySQL Email 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

Re: Problem with MySQL and SMP?

2002-01-10 Thread Lionlike MySQL Email List
17 kernel and MySQL 3.23.47 > > Gavin > > > - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request

Re: Question

2001-12-12 Thread Mysql List
ying the best one? > > Thanks for any hint > > Ivo > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > &g

Re: User issues in installation. New beginner

2001-12-05 Thread Mysql List
> 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-m

Help with Auto Increment

2001-12-05 Thread Mysql List
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

LEFT JOIN fails to correctly join tables

2001-11-30 Thread dale-list-mysql-bug
03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 RAID question

2001-11-29 Thread Lionlike MySQL Email List
rn is loss of data due to a drive going bad. At least that what I've heard could happen. Thanks, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Cannot get server to honor configuration settings

2001-10-01 Thread Mailing List Receiver
What gives? Todd Merriman [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]&g

  1   2   >