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

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 f

Re: Auto Increment Problem

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

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

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 co

Re: Like Syntax

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

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