Re: [PHP] Because you guys/gals/girls/women/insert pc term here are a smart lot

ctual length, lots of rows, or both, then varchar > columns may be faster. I still think a CHAR field would be faster than a VARCHAR because of the fixed row length (assuming every thing else is fixed). Perhaps someone from the MySQL list could clarify...? -- Richard Heyes HTML5 Graphing for

Re: Data files from 4.1.13 with 5.0.x

> Would data files from 4.1.13 work with 5.0.x or will I have to use an SQL > dump? Well, not to worry, I managed to start 4.1.13 and got an SQL dump. Cheers. -- Richard Heyes http://www.phpguru.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Data files from 4.1.13 with 5.0.x

Hi, Would data files from 4.1.13 work with 5.0.x or will I have to use an SQL dump? Thanks. -- Richard Heyes http://www.phpguru.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Table aliasing

> I think what you want is "CREATE VIEW test.v AS SELECT * FROM t;" That will do the job, thank you. -- Richard Heyes http://www.phpguru.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Table aliasing

No, the net effact would be that the table would have two names. -- Richard Heyes http://www.phpguru.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Table aliasing

Hi, Is there a way in MySQL to define an alias for a table, so in effect it has two names? For migration purposes. Thanks. -- Richard Heyes http://www.phpguru.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Migrate HUGE Database

How very inconsistent and obnoxious. But yet far more secure. FWIW, if you're transferring between machines you can gzip the output of mysqldump to compress it, resulting in far less transfer time. Eg. mysqldump -u username -p database_name | gzip -c > dump.sql.gz IIRC -- Richa

Re: Backup table structure, not data

, might take some time) - but there's gotta be an easier way to do it... mysqldump has a --no-data option. Try "man mysqldump" (assuming your MySQL server is Unix based. -- Richard Heyes http://www.websupportsolutions.co.uk Knowledge Base and Helpdesk software hosted for you -

Re: failed queries

ce just to catch > that occasional failed update. Use your abstraction layer to log queries that pass through it. -- Richard Heyes http://www.websupportsolutions.co.uk Knowledge Base and Helpdesk software that eases your support burden and helps increase your sales. ** NOW OFFERING FREE ACCOUN

Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject

Will this bring good things to MySQL? $800,000,000 tends to bring good things. Hopefully. :-) -- Richard Heyes http://www.websupportsolutions.co.uk Mailing list management service allowing you to reach your Customers and increase your sales. ** NOW OFFERING FREE ACCOUNTS TO CHARITIES AND NON

Re: Bigint

I think it's the same. I seem to remember that a BIGINT id two INTs tacked together, so how is that possible? -- Richard Heyes http://www.websupportsolutions.co.uk Mailing list management service allowing you to reach your Customers and increase your sales. ** NOW OFFERING FREE ACCOUN

Bigint

Performance wise, what is a BIGINT like in comparison to an INT on a 32 bit machine? Thanks. -- Richard Heyes http://www.websupportsolutions.co.uk Mailing list management service allowing you to reach your Customers and increase your sales. ** NOW OFFERING FREE ACCOUNTS TO CHARITIES AND NON

Index text without Match/against

_text FROM articles WHERE article_text LIKE '%protocol%' Am I missing something? Or is it due to my limited dataset (~20 articles in the TEXT field, indexing ~15,000 words). Ie. if the dataset was scaled up to 1000s would the join still be as slow? Cheers! -- (A rather drunken) Rich