text mode listing

Hi Can you remind me how to tell mysql to list vertically instead of horiz in text mode? Ex: select all * from a_tablesends field1 field2 . I want field1 field2 field... Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:htt

Re: text mode listing

Hi obed I looked many times in the commands list and maybe I didn't wat to see it !!! The answer is a '\G' appended at the end of the line. Thanks for the help Bill >> Can you remind me how to tell mysql to list vertically instead of horiz >> in >> text mode

MysqlI

Hi Did someone use MySQLI in production environment ? Is the transactions aspect reliable ? (bugs etc) Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MysqlI

> Hi > > Did someone use MySQLI in production environment ? > > Is the transactions aspect reliable ? (bugs etc) > > > Thanks. > > Sorry I should have specified that it's in the PHP environment. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: MySQL

Hi Shawn > The short answer is "Yes". Do you want a list of companies from the > "Fortune 100" or are you interested in a particular business area? There > are some huge names (http://www.mysql.com/customers/) that use MySQL for > critical, public-facing, and infrastructure applications. Many of

Re: MySQL

Hi Shawn, > Are transactions stable and supported (production ready) in MySQL? Yes, > with one caveat. You must keep your data in InnoDB tables in order to get > full commit/rollback support. MyISAM does not support automatic rollbacks. > Is mysqli_xx written to properly use the built-in transacti

Re: Backups

Hi I'd say that you have an ideal situation to use a Raid level 1 system. "Rick Dwyer" <[EMAIL PROTECTED]> a écrit dans le message de news: [EMAIL PROTECTED] > Hello all. > I am looking into the different back up methods available for > safeguarding my MySQL databases. > Ideally, I would like to

LOAD DATA INFILE

INFILE '/var/tmp/php4oNadA' INTO TABLE `session` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' Please help Bill

Live in Puget Sound?

person to be willing to come to my home in Des Moines, WA. I will pay travel time also. If interested contact Bill Cory at 253-946-0114

Batch mode and stored procedures ?

ow to pass parameters to the batch file. Can a MySQL batch file receieve input parameters? If so, how? Or do I need to wait until stored procedures are implemented in a future version of MySQL? (I understand this is being worked on). Thanks in advance, Bill Brownrigg Project Manager DSL Hol

Batch mode / stored prodecure question?

e. This is what I need. I see that MySQL has a "batch mode", but I do not see any mention of how I could pass parameters to a MySQL batch file. Can I do this, if so, how? I see that stored procedures are being added in a future release of MySQL, do I need to wait for this? Thanks in adv

Re: Batch mode / stored prodecure question?

Hmm, I thought this question I posted last weekend was a pretty good one, however, no replies have been posted :-( I am new to MySQL and this mailing list, is the the proper place and format for questions of this type? Regards, Bill > Hi all: > > I am building a database c

Re: phpMyadmin

vailable in phpmyadmin. I'm not sure what the current state of phpmyadmin is (it may or may not offer the features found in mysqltool). mysqltool is a perl based product and is available at http://www.dajoba.com/projects/mysqltool/ Regards, Bill -- "If Verisign is the 'Value of

MySQL CC & Mandrake 8.2

matches up with the documented directory locations in MySQL documentation? I hate to start the install from an incorrect location and cause conflicts along the line. Any and all help would be appreciated. -*-Bill - Before

is there a MySQL 'field contains' function

ur, ram, processor etc...? Thanks, Bill - 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 <[EM

Re: mysql Digest 26 Feb 2001 14:06:36 -0000 Issue 1161

easy to use. Try Mysqltool. It now has multi-user support which will probably make it exactly what you are looking for. http://www.dajoba.com/projects/mysqltool/ -Bill - Before posting, please check: http://www.mysql.co

Re: XML interface to MySQL

> does anyone know of an XML interface to MySQL which would enable me to > import or export data using the XML language definition? Try http://www.xml.com/pub/a/2000/12/13/perlxmldb.html (note that I have slept and done other things a few times since reading the above, but I think it discusses

Re:

> How do I add a new user?? How do permission work?? I've spent an hour > now and I still get: > ERROR 1044: Access denied for user: '@localhost' to database 'mysql' It's all explained in the MySQL Manual: http://www.mysql.com/documentation/index.html

Re: phpMyAdmin equivalent

> Was wonder if any knows of a Perl equivalent to the PHP's version of > phpMyAdmin?? We use phpMyAdmin but have a project that server doesn't > have PHP installed, and frankly, to lazy to do all the typing thru telnet > session! :) I'm currently comparing MySQLTool to phpMyAdmin. http://dajoba.

getting frequent signal 11 after upgrade from 3.23.28 to 3.23.34

stack limit or frame pointer, aborting backtrace. The db is working otherwise and the system seems otherwise unaffected, there are just errors now and again. >How-To-Repeat: It's happening intermittently. >Fix: none know at this time. >Submitter-Id: >Originator:B

Re: MySQL and XML?

> I know Oracle has been modified to use XML files as the database, > making queries directly to a flat file No, thats not how it works. They format the *output* with XML making it easier for an application that can parse XML to import the data. --

Re: question

>We are going to buy a cobalt req i4 server as a dedicated hosting >server. It has MySQL software and a control panel. Do you know if this >control panel can manage the MySQL or not (For creating and removing DBs >and tables not more)? Prior versions of Cobalt's control panel don't--they also do

Re: web-based interface for manipulating MySQL tables?

We used to use phpmyadmin, but moved on to mysqltool last January. You might want to check it out. http://dajoba.com/projects/mysqltool/ - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Need A book for dynamic website

Sorry, I can't help with PHP books, however for Perl books, "MySQL and Perl for the Web" by Paul Dubois is good. > I need a book to teach me how to make a database driven website, I think > php mySql is the way to go and have seen some on amazon and fat brain > but don't know if any are any good

mysql client exits with core dump segmentation fault

>Description: ## After building mysql and installing the GRANT tables I start the daemon ## and then try to run the mysql client to alter the GRANT tables to a ## useful configuration. Subcommands like connect and use seem to work ## ok, but if I try entering anything else, ev

RE: MySQL Book

>> MySql & mSQL O'Reilly press isbn 1-56592-434-7 is probably the worst book about mysql. Please note that the O'Reilly book was originally suppose to be about msql but near the end of the project they noticed that mysql was gaining popularity on msql so they threw in some information on mysql.

Re: mysql Digest 24 Jun 2001 00:58:59 -0000 Issue 1353

993401594/sr=1-6/ref=sc_b_6/102-6228011-7382510 P.S. I would have given bookpool.com links since they usually have better prices, however their site appears to be down this morning. If you are going to buy your books online, I would suggest visiting bookpool.com first. -Bill --

Re: Front End Needed

rface that is available. I haven't checked it out yet, but here is a link to it: http://dajoba.com/projects/mysqltool Regards, Bill - Before posting, please check: http://www.mysql.com/manual.php (the manua

RE: SELECT counting chars with LEFT()

You know, this works just fine for me -- when you say it is NOT working, what do you mean exactly? Are you getting an error? Or results that you don't expect? Bill Tantzen University of Minnesota Libraries [EMAIL PROTECTED] 612-626-9949 (office) 612-250-6125

Client being locked out by aborted connections

.3-RELEASE-p37 php5-pgsql-5.1.6_1 mysql-client-4.1.21 Server: FreeBSD 5.3-RELEASE-p37 mysql-server-4.1.21 -- Bill Moran Collaborative Fusion Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Client being locked out by aborted connections

In response to "Dan Buettner" <[EMAIL PROTECTED]>: > Bill, you can up the value of 'max_connect_errors' (default is 10 it > appears) to make this problem appear less frequently while you > troubleshoot. Thanks for the thought, Dan. Before I do that, I

Re: Client being locked out by aborted connections

In response to Bill Moran <[EMAIL PROTECTED]>: > In response to "Dan Buettner" <[EMAIL PROTECTED]>: > > > Bill, you can up the value of 'max_connect_errors' (default is 10 it > > appears) to make this problem appear less frequently while you

Default Column Value

date, 1, 4),substr(start_date,6,2)). Something like ALTER TABLE events ALTER start_yr_mo start_yr_mo SET = concat(substr(start_date, 1, 4),substr(start_date,6,2)); -= Bill =- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

getLong() vs getInt() result differs on unsigned field

l public static void main(String[] args) { long theLong = 4294967298L; System.out.println("(int) 4294967298L = " + (int) theLong); } } C:\javabox>java TestLong (int) 4294967298L = 2 HTH Bill == original message follows == Date: Mon, 11 Jul 2005 13:54:12

SELECT vs SET for creating variables

enter, CONCAT(@neededStep, ' <= ', @startOfCenter), CONCAT(@neededStep, ' > ', @startOfCenter) ); It would seem that SET is a better way to create variables from constant values, but I would like to understand why. Does anybody know what is happening here? Thanks for y

MySql hanging

| | innodb_thread_concurrency | 8 | | interactive_timeout | 28800 | I tried this in MySQL 4.1.8, 4.1.12, and 4.1.14. Any help would be appreciated, Bill -- MySQL General Mailing List For list archives: http://

Re: MySql hanging

circumstances though, I think rewriting it is the way to go. Thanks again, Bill Quoting [EMAIL PROTECTED]: Bill Duffy <[EMAIL PROTECTED]> wrote on 08/31/2005 11:32:02 AM: When I run a query like this DELETE FROM test_P_Cookie WHERE ViewID IN (SELECT ViewID FROM test_x_RM_4508_48875

Newbie MySQL/PHP question re output formatting

e cell where I would expect to get $ 7,842,554.24 Any idea what I'm doing wrong? Clearly, I don't understand arrays very well. Thanks VERY much for any help on this. bw --- Bill Whitacre [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How do you set a Primary Key when uploading data into a table?

How do you load data into a table and generate a primary key which increments by 1. I want to end up with a primary key value of int 1, 2, 3, 4, and so on. My table has three rows, Id, Code, Description. I'm loading data from a text file into the table like this: load data local infile '/U

How do you set a Primary Key when uploading data into a table?

How do you load data into a table and generate a primary key which auto increments by 1. I want to end up with a primary key value of int 1, 2, 3, 4, and so on. My table has three rows, Id (pri_key), Code, Description. I'm loading data from a text file into the table like this: load data l

'GROUP BY' behavior

) < timestamp GROUP BY qtreename,hostname My questions: >From which of the several averaged rows do 'allocated' and 'available' come in the results? Can I control this? I would like the row with maximu

RE: 'GROUP BY' behavior

Shawn, That's a very reasonable answer. Thanks for pointing me to the examples. This one addresses the second question: http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row. html . There is no example answering both questions in one query. Regards,

Re: Hijackers?

me fields I also use the HTML conversion functions to convert " to " etc. I found this helpful: http://www.unixwiz.net/techtips/sql-injection.html -- Bill Dodson Parkline, Inc. http://www.parkline.com phone: 304-586-2113 x149 fax: 304-586-3842 email: [EMAIL PROTECTED] Email Disc

Re: temporary table issue

anks in advance. Xiaobo -- Bill Dodson Parkline, Inc. http://www.parkline.com phone: 304-586-2113 x149 fax: 304-586-3842 email: [EMAIL PROTECTED] Email Disclaimer The information in any email is confidential and may be legally privileged. It is intended solely for the addressee. Access to the e

Re: Converting decimal to binary

inary and have the result be returned as a separate field for each bit? For example, what I'd like to do is, Select ConvertToBin(245); And have a result that looked like this +---+---+---+---+---+---+---+---+ | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 | +---+---+---+---+---+---+---+---+ | 1 | 1 | 1 | 1 |

Upper Limit to max_join_size? (4.1.18)

to avoid using SET SQL_BIG_SELECTS=1. I know in earlier versions (perhaps 4.0.x?) I could increase the value to what I wanted. I will happily add the output from "show variables" if that will help. Thanks in advance for your help. --Bill Welcome to the MySQL monitor. Commands end

Re: innodb in 4.1.18

Marten Lehmann wrote: I had a lot of trouble today because the InnoDB integration in MySQL is lousy. I read the manual and worked with innodb_per_file_table. So when I shutdown mysql I should be able to delete ib_logfile0, ib_logfile1 and ibdata1, because all table-data should be stored in th

Re: innodb in 4.1.18

InnoDB always needs the shared tablespace because it puts its internal data dictionary and undo logs there. The .ibd files are not sufficient for InnoDB to operate. well, thats what I found before. But it doesn't explain why InnoDB does need a logfile even when all transactions are committ

Re: copy one field value to another

UPDATE table SET field_a=field_b; b. Ravi Malghan wrote: Hi: is there a way to copy all field values from one field to another from the mysql prompt? Thanks Ravi __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around

Re: Limit characters in a long text

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html I recommend "LEFT( )". If you are looking to do it in PHP then this is the wrong email list. Good luck. b. CodeHeads wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello all, Have a question: I would like to limit the amou

Query Question

I am in need of some help for the following: Say I have a table with 1M rows. Users are being added constantly (not deleted) during the queries that I am about to explain. The pk is uid and appid. I need to run queries in increments of 100K rows until reaching the end without duplicating row

How can I see the query from a remote session against my server

ovide on this as I've got people that expect miracles in the next 5 minutes here! Bill

RE: How can I see the query from a remote session against my server

log working if possible as it sounds pretty useful, so thanks again. Bill -Original Message- From: Jerry Schwartz [mailto:je...@gii.co.jp] Sent: 09 June 2010 16:43 To: 'Anirudh Sundar'; mysql@lists.mysql.com Subject: RE: How can I see the query from a remote session against my s

Re: Is there any workbench or development studio available for Linux?

From the download page: Please note that at this point only the Windows Beta version is available. Linux and OS X releases will be available in 2008. It looks nice, I was looking for a similar tool 5 -6 years ago. It looks like what I would have wanted at the time. legolas wrote: Is ther

Re: Auto Fill blank Rows

To get a blank line instead of NULL you could simply wrap the reference in an IFNULL function: select dummy.row_id,IFNULL(real.reference,'') as Reference from dummy left join real on real.row_id=dummy.row_id; Phil wrote: you could do something like select dummy.row_id,real.reference from

Re: LEFT JOIN problem

Hi Jerry, I think the problem is that NULL is not less than or greater than your prod_published date. So you probably have eo_pub_date set to NULL in 56 of your rows. so for eo_name_table.eo_pub_date > prod.prod_published or eo_name_table.eo_pub_date <= prod.prod_published mysql will rer

Re: Find two sets of records

Try using the sub query as a derived table ala: SELECT eo_name_table.eo_name, eo_name_table.eo_pub_date FROM eo_name_table LEFT JOIN (SELECT prod.prod_title FROM prod WHERE prod.prod_discont = 0) fake_prod on eo_name_table.eo_name = fake_prod.prod_title WHERE prod.prod_title IS NULL I'm not

Re: Why people don't use engine named BDB?

th this: *BDB support will be removed. * Note that, as of MySQL 5.1, BDB isn't supported any longer. http://dev.mysql.com/doc/refman/5.0/en/bdb-storage-engine.html But you're right that as a storgage engine, there have been very few questions related to it, on this mailing list anyw

Re: MySQL Sort by Array

-- No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.8.2/1739 - Release Date: 10/22/2008 7:23 AM -- Bill Newton Network Merchants Inc. http://www.nmi.com (847) 352-4850 ext 141/ T

Re: normalised designs: customer database

fake company. If I had to choose one of those, I"d go with the dual foreign keys. #3 Thanks for the meaty question, Bill metastable wrote: Hello all, I have a question that's been bugging me for quite some time. Let's say we have a small business that has both private and co

Re: Finding not quite duplicates

that would accomplish that would be: SELECT IF(a.prod_num IS NOT NULL,IF(a.prod_discont = 0,a.prod_num,"discontinued"),"") as prod_num FROM b LEFT JOIN a ON b.prod_pub_prod_id = a.prod_pub_prod_id ORDER BY b.prod_pub_prod_id; You can nest IF statements in mysql queries. Hope it he

Re: Finding not quite duplicates

.prod_discont < a.prod_discont WHERE alias_for_a.prod_num IS NULL ORDER BY b.prod_pub_prod_id; US Data Export wrote: -Original Message- From: Bill newton [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 18, 2008 6:49 PM To: Jerry Schwartz Cc: 'mysql' Subject: Re: Findin

www.innodb.com

What happened to the Innodb web pages? What comes up for be is a search page with a bunch of related links on it. I wanted to pull down a copy of ibbackup documentation and it isn't there anymore. Bill +--- | Bill MacAllister, S

Re: www.innodb.com

--On Thursday, November 09, 2006 08:37:01 PM +0200 Onur <[EMAIL PROTECTED]> wrote: Bill MacAllister wrote: What happened to the Innodb web pages? What comes up for be is a search page with a bunch of related links on it. I wanted to pull down a copy of ibbackup documentation and it

Re: www.innodb.com

nature makes me think that it still should, and it doesn't now. That is the issue that I raised. I am guessing, given Reimer's insight, that the domain name registration has expired and someone needs to renew it. I hope they plan to do that because I found the site useful. Bill

using DISTINCT after the ORDER BY clause has been applied

could retrieve the above data ? Thanks. Yashesh Bhatia. It looks to me as if your query returned exactly what you asked for. It found the first two rows (other rows are not distinct), and then ordered them in descending order by time stamp. Descending is largest to smallest. TS for

Order By and Ignore Punctuation

I would like to perform a query of a personnel database with an ORDER BY clause that ignores punctuation. For example, O'shea would sort after Osbourne, not to the beginning of the Os. Is this doable in the query? -= Bill =- -- You can tell a lot about a man by th

Re: MySQL 5 et les charset sur debian etch

problème s'est produit dans le transfert des données à partir d'une base de données à l'autre. Comment avez-vous copié les données ? Vous pourriez examiner insérer de nouvelles données dans chaque base de données et voir si elle semble correcte. Bill Gilles MISSONNIER wrote: He

Re: it doesn't return from the mysql_query processing

Hi Koki, You have to re- establish the database connection in each child process. Otherwise the packets get mangled and you get the errors you're seeing. Koki Takeda wrote: I hope that my contacting you is not an imposition in any way. My name is Koki Takeda. This time, I made the php progr

mysql-table-checksum with mixed storage enginges

Will mysql-table-checksum from mysql toolkit work with setups that have different Master/ Slave storage engines? Are there any things to consider when using it between two different engines ( say Innodb master and MyIsam slave)? Thanks in advance, Bill Newton -- MySQL General Mailing

Re: global object-id

Well, the answer is "no"--there's no magic way to have an auto_increment do what you want. You could use a GUID--basically a pseudo-random number such the expected time to pick a duplicate is on the order of the lifetime of the universe. But GUID's are big and ugly, and it would be nice to just ha

EBCDIC collation sequence

Hi There doesn't appear to be any info. on the archives regarding this, so does anyone know what character set/collation sequence to use for EBCDIC rather than ASCII collation? Cheers Bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: EBCDIC collation sequence

Bill Maidment wrote: Hi There doesn't appear to be any info. on the archives regarding this, so does anyone know what character set/collation sequence to use for EBCDIC rather than ASCII collation? I discovered the /usr/share/mysql/charsets directory and added a latin1_cp500_ci collation

the new Connector J

DispatchThread.pumpEvents(EventDispatchThread.java:145) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137) at java.awt.EventDispatchThread.run(EventDispatchThread.java:100) SQLException: SQLState(S1009) Thanks bill -- MySQL General Mailing List For list archives: http://lists.mysql

Re: Need help coverting MDB > SQL

#x27;#' in literals when you specify them. The good think about using perl is that you can handle all of these problems. Hope that helps, Bill +--- | Bill MacAllister | 14219 Auburn Road | Grass Valley, CA 95949 --On Saturday, March 26, 2005 10

mysqldump, --single-transaction and --flush-logs

If I use the options --single-transaction and --flush-logs with mysqldump and InnoDB tables, does the new log file start at the same time as the transaction? If not, is it known for sure if the log file is switched before the transaction starts or if it is switched after the transaction starts? I

db/mysql rookie request

the time to develop some SQL to get the data I would like to get. However, I want to do this with a Korn shell script that emails the report to a list of internal customers. Any help you can provide would be greatly appreciated. Thanks in advance, Bill

[Stats] MySQL List: November 2003

7 gone 6 -- ----- Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/

"undefined reference to `errno'"

he server are as follows; mod_auth_mysql 1.11-12 mysql 3.23.54a-11 MySQL-devel 4.0.0-2 mysql-server 3.23.54a-11 perl-DBD-MySQL 2.1021-3 php-mysql 4.2.2-17 Thank you, -- Bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to include count(*) in selection criteria

use having N > 10 The having clause takes the results of the query AFTER all of the rows have been read and aggregated by the group by clause and further reduces the set of rows that gets returned. - original message - Date: Wed, 17 Dec 2003 12:52:08 -0500 (EST) From: Gaspar Bakos <[EMAI

Connector/J 3.0.9 Unexpected end of input

I upgraded to Connector/J 3.09 from 2.0.14. After some hours, the driver looses it's connection and will not reconnect (despite setting reconnect=true). The error starts as follows below. I rollback to 2.0.14 and everything is stable again. This is using mysql 4.0.16-standard. Is connector/j 3.0x p

transactions and create table (was Questions about MySQL implementation)

What is the official word on doing a CREATE TABLE inside a transaction? Can I do one without causing the transaction to commit? By experiment, it appears that 4.0.14 allows this, although, even if the CREATE TABLE is for an InnoDB table, a ROLLBACK doesn't remove the created table. It appears th

RE: Connector/J 3.0.9 Unexpected end of input

ndle stale connections. -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, December 18, 2003 12:34 PM To: Bill Ataras Cc: [EMAIL PROTECTED] Subject: Re: Connector/J 3.0.9 Unexpected end of input -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bill Ataras wrote: >

RE: 100 million row limit (Part 2)

Can't resist... or 100 million rows won't run with a real db, like oracle, rather that the designers were thinking mysql when they built it... Sorry ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, December 28, 2003 6:56 PM To: [EMAIL PROTECTED] Subj

[Stats] MySQL List: December 2003

5 self 5 -- ----- Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ -

Re: Recreating InnoDB tables -WITHOUT- .frm

ly by patching the InnoDB .frm file to look like a MyISAM .frm file. I understand that it worked pretty well. Good luck. Adam, This probably doesn't do anything for you. Sorry. Regards, Bill > From: "Heikki Tuuri" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> &

RE: select count from three tables

Thanks for the suggestion but unfortunately this seems to produce the product of the two tables `lghyperlink` and `lgsearch`. e.g. if user bill and 10 entries in `lghyperlinks` and 15 entries in `lgsearch` then what is returned is username clicks searches == bill

RE: select count from three tables

thanks for taking the time to look best bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 20:19 To: [EMAIL PROTECTED] Cc: Bill - compuserve Subject: Re: select count from three tables * Bill - compuserve > Thanks for the suggestion

In replication, can you have a slave act as a master to a different slave?

Here is my scenario: I have 3 linux boxes - 2 with mysql 4.0.16 and 1 with 4.0.17. I have a 4.0.16 master (sys1) replicating a database (db1) that is roughly 1.5GB to a slave system (sys2) running 4.0.17. For the sake of a formal representation I'll say that (sys1,db1) --> (sys2,db1) repre

JOIN 10 times quicker than LEFT JOIN on big tables and simple queries?

.p_id. -- This takes some work, but it might speed up other queries, if you frequently need to select all of the children for a particular parent. HTH Bill > Date: Thu, 22 Jan 2004 20:09:42 +0100 > From: Benjamin PERNOT > To: [EMAIL PROTECTED] > Subject: JOIN 10 times quicker than

UNION equivilent required for 3.23.37

Andy, Does this scratch the itch? select col1, col2, date from root_table left join table_one on root_table.table_one_id = table_one.table_one_id left join table_two on root_table.table_two_id = table_two.table_two_id where table_one.table_one_id is not null and table_one.table_

More Left Join problems

gnored your earlier question for that reason; I usually just skip messages where it would take too long to decipher the question--I'd assume that other people do the same. HTH Bill > Date: Thu, 29 Jan 2004 08:03:25 -0800 > From: "Jacque Scott" <[EMAIL PROTECTED]> > To

Re: More Left Join problems

JOIN BOM ON Products.ProductID = BOM.ProductID GROUP BY Products.NSIPartNumber, Products.Obsolete HAVING ((NSIPartNumber Like "%02-001%") AND (Obsolete<>-1)); Hopefully this will be easier to decipher. >>> "Bill Easton" <[EMAIL PROTECTED]> 1/29/2004 10:3

Re: More Left Join problems

Well setting indexes of both tables helped. The query now runs at 0.38 seconds. What a difference. Is this the way to set Indexes? Set a 'Unique' index for the PK of each table and just an 'Index' for the foreign keys in each table. Bill, You have been a life

[Stats] MySQL List: January 2004

reset5 -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Bui

MyISAM Table Corruption

Hassan, By Murphy's law, they WILL get corrupted if you don't have a backup. You need a current backup, or you need an older backup and a way to redo the updates. That said, if you do a FLUSH TABLES after your update, then corruption is unlikely--no more likely than for any other OS file. After

Re: Unique IDs

terval 1 second, but it may give different results some day if MySQL changes the precision of timestamp. HTH Bill Easton > Subject: Re: Unique IDs > From: Craig Jackson <[EMAIL PROTECTED]> > To: "Keith C. Ivey" <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > D

Setting "PACK_KEYS=1" on existing tables

Is there a way to set "PACK_KEYS=1" on existing tables without doing a dump and load? I didn't find it in the "ALTER TABLE" syntax. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ib* files in /var/lib/mysql

I noticed these files in my mysql data directory: -rw-rw1 mysqlmysql 5242880 Feb 15 20:54 ib_logfile0 -rw-rw1 mysqlmysql10485760 Feb 15 20:54 ibdata1 -rw-rw1 mysqlmysql 25088 Jun 3 2003 ib_arch_log_00 -rw-rw1 mysqlmysql 52

OR in query doesn't use keys?

er1Key (User1), KEY User2Key (User2) ) TYPE=MyISAM PACK_KEYS=1; Anyone know a trick to do OR queries faster? Thanks in advance, -bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

  1   2   3   4   5   6   >