Like Syntax

Hi; I remember vaguely how to do this but don't know how to google it: show tables like categories$; such that it will return tables such as: categoriesProducts, categoriesPrescriptions, etc. TIA, Victor

Re: Like Syntax

On Sat, Dec 5, 2009 at 11:09 AM, Michael Dykman mdyk...@gmail.com wrote: show tables like 'categories%'; Thanks. V

Challenging Select Statement

Hi; I need to write a select statement that enables me to select column 'ID' from a table where a certain value is found in an enum of a specific column. For example... select column_type from information_schema.columns where table_name='products' and column_name='Categories'; will give me the

Auto Increment Problem

Hi; mysql insert into categories (Category, Parent) values ('test', NULL); ERROR 1062 (23000): Duplicate entry '0' for key 1 mysql describe categories; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra |

Re: Auto Increment Problem

Oops. Never mind. V On Sat, Dec 5, 2009 at 1:19 PM, Victor Subervi victorsube...@gmail.comwrote: Hi; mysql insert into categories (Category, Parent) values ('test', NULL); ERROR 1062 (23000): Duplicate entry '0' for key 1 mysql describe categories;

Re: MySQL shutting down because of Operating system error 1784

Hi all, Thanks for your suggestions. The problem is solved I guess, no problems reported after I made the changes. As suggested, increased the log file sizes. Changed innodb_buffer_pool_size from 128M to 256M. Changed innodb_log_file_size from 5M to 64M. Also changed innodb_thread_concurrency

who knows the difference between INSERT and UPDATE

hi all, Someone told me that UPDATE equals DELETE old row + INSERT new row. Anybody clarify it? thanks, -Oscar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org