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

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

"date format"

2001-04-09 Thread 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

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

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

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

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

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

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

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

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 -

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

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]

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

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]

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

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

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

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

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]

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

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

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

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

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

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.

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 >

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,

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

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

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

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

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

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

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

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

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

2001-07-23 Thread Mysql List
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

RE: permissions, Help for Newbie, Nicole

2001-07-30 Thread admin-list
mission > for me. Please inform me if my thinking is wrong here. > > If so, would this script be what I should > recommend that they try?? > > mysql> GRANT SELECT, INSERT, UPDATE ON client_db.* > TO db_user@localhost IDENTIFIED BY 'password'; > > Thanks

Question

2001-09-07 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]

Re: Question

2001-09-07 Thread Mysql List
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

Re: Question

2001-09-07 Thread Mysql List
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]> >

How many OR, AND in a query?

2001-09-26 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: How many OR, AND in a query?

2001-09-26 Thread Mysql List
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

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

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

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

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

Query failing

2001-04-15 Thread List Box
any light on why MySQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mai

Where to get a list of explanations for Errcodes?

2001-06-02 Thread mysql list
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)

How to start mysql server as user mysql

2001-06-02 Thread mysql list
/ (the list archive) 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 & '

2001-06-06 Thread mysql list
ahoo.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 unsu

DuBois's book's scripts - where to get them?

2001-06-07 Thread mysql list
sonal.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

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]

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]

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]

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]

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

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

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

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

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

[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

[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

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

Re: MySQL on NFS?

2001-06-29 Thread Web Mailing List
mings" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 29, 2001 3:21 PM Subject: MySQL on NFS? > I'm sure this is been covered before but I couldn't find any > list archives. I've just aquired a pair of clustered NetApp > 740's for a stea

Please help with this!

2001-06-29 Thread Web Mailing List
Hi, everybody here, Anybody can help with telnet to Linux and login to mySQL, show information about current mysql setting, create new DB, and table? Since, I am using MSSQL under NT platform, it is pretty much different.. Thanks lot Amy

Help please, create table, and set Auto field

2001-07-04 Thread Web Mailing List
I move from MDB to mySQL, I got a question concern how to create a auto digital number field in mysql table, create table namelist ( name char(60), ID auto, date date());

  1   2   >