ANN: Database Workbench 2.8.10 released

new?: http://www.upscene.com/products/dbw/whatsnew.htm Full list of features and fixes: http://www.upscene.com/news/20070824.htm Database Workbench supports: - Borland InterBase ( 4.x - 8.x ) - Firebird ( 1.x, 2.0 ) - MS SQL Server/MSDE ( v6.5, 7, 2000, 2005, MSDE 1 2, SQL Express ) - MySQL 4

problem for partition expression ---floor(col_name)

hi guys, I'm researching the method of partition when partition key/column is not INT type. I create a table t3(a int,b decimal(10,4)) and want to create partition by b column. So I use a function floor() for b column, partition type is range: alter table t3 partition by

what if i need the primary key of a row that is to be inserted?

what if i need the primary key of a row that is to be inserted? that primary key will be used to insert another row from another table.. what i was doing was after inserting the row, i get the primary key by select statement and use that value to insert a row from another table.. is this ok? are

Re: what if i need the primary key of a row that is to be inserted?

what if i need the primary key of a row that is to be inserted? that primary key will be used to insert another row from another table.. what i was doing was after inserting the row, i get the primary key by select statement and use that value to insert a row from another table.. is this

Re: what if i need the primary key of a row that is to be inserted?

yup, that's it.. thanks for the reply.. -- View this message in context: http://www.nabble.com/what-if-i-need-the-primary-key-of-a-row-that-is-to-be-inserted--tf4323900.html#a12313942 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list

Re: Seriously Disruptive DBA

Hello, Here's 4 easy steps that show how you too can be a Seriously Disruptive DBA: 1) Sign on to MySQL as root 2) Perform a show databases; 3) For each entry you see, issue a drop database X; command 4) Sign out and disavow any knowledge of your actions At 03:22 PM 8/23/2007, james

Re: what if i need the primary key of a row that is to be inserted?

what if i need the primary key of a row that is to be inserted? that primary key will be used to insert another row from another table.. what i was doing was after inserting the row, i get the primary key by select statement and use that value to insert a row from another table.. is

James Benjamin - Seriously Disruptive MySQL DBA

hi, if anybody wants to reach me please try this account - [EMAIL PROTECTED] JAMES dot BENJAMIN at GRAFFITI dot NET or call me on 0044 750 408 9783 = Weather Almanac, Weather Folklore Books Buy Eric Sloane weather almanac, books on weather vanes more today.

Column type suggestions

I recall there is a command that will display suggested optimal columns types for a given table based on the data stored in the table, but I haven't been able to figure out what it is. Help! Thanks. Ben Wiechman Wisper High Speed Internet [EMAIL PROTECTED]

Re: Column type suggestions

Search the manual and the web for PROCEDURE ANALYSE() and some examples of how to use it. (It's not obvious how to get good results). I think Ronald Bradford has a good blog post on it. Benjamin Wiechman wrote: I recall there is a command that will display suggested optimal columns types

Re: what if i need the primary key of a row that is to be inserted?

On 8/24/07, hardc0d3r [EMAIL PROTECTED] wrote: yup, that's it.. thanks for the reply.. -- More typically, you would use the last_insert_id() function which will return the value of the most recently created auto-increment key... CREATE TABLE mytable ( id int auto_increment primary key, foo

Re: Seriously Disruptive DBA

Jonathan, On 8/24/07, Jonathan G. Lampe [EMAIL PROTECTED] wrote: Hello, Here's 4 easy steps that show how you too can be a Seriously Disruptive DBA: 1) Sign on to MySQL as root 2) Perform a show databases; 3) For each entry you see, issue a drop database X; command 4) Sign out and

RE: Column type suggestions

SELECT * FROM tablename PROCEDURE ANALYSE() Anyone know of a way to get the size of a row in bytes? -Original Message- From: Benjamin Wiechman [mailto:[EMAIL PROTECTED] Sent: 24 August 2007 16:18 To: mysql@lists.mysql.com Subject: Column type suggestions I recall there is a command

thread_concurrency in linux

Hi, Does anyone know if thread_concurrency works in linux or is it just limited to Solaris and Windows? I know the general rule is number of CPU's*2 but will this actually have any effect with Linux's threading model? Thanks for any help :) Andrew Mysql, query This message has been scanned

Removed ibdata1

Hi, I removed accidentaly the files : /var/lib/mysql/ibdata1 /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile1 how can I remover them from data files note show tables list all tables OK desc wiki_text ERROR 1146 (42S02): Table 'intranet.wiki_text' doesn't exist this erro in all tables

bitwise logic

Hi. I've got IP addresses stored in the database as packed binaries. i.e. binary(4). I put them in there that way so that I could do bitwise logic on them to do subnet searches. e.g. ...WHERE `ip` 'mask' = 'network'. Only it turns out that as far as I can tell MySQL can't do bit logic on

Re: Removed ibdata1

If you use default configuration (meaning all innodb data in one idata file) you just deleted your data. If you have a recent dump, drop all innodb tables and use the dump to restore On 8/24/07 3:20 PM, Adriano Ceccarelli [EMAIL PROTECTED] wrote: Hi, I removed accidentaly the files :

Re: Removed ibdata1

Adriano Ceccarelli wrote: I removed accidentaly the files : /var/lib/mysql/ibdata1 /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile1 how can I remover them from data files note show tables list all tables OK desc wiki_text ERROR 1146 (42S02): Table 'intranet.wiki_text' doesn't exist

Re: Removed ibdata1

It's problem. I don't have dump data :-S 2007/8/24, Olaf Stein [EMAIL PROTECTED]: If you use default configuration (meaning all innodb data in one idata file) you just deleted your data. If you have a recent dump, drop all innodb tables and use the dump to restore On 8/24/07 3:20 PM,

Re: Removed ibdata1

Then see if you can recover the deleted files from your filesystem I think there is a tool called e2undel for ext2 filesystems, not sure how easy this is on journaling fs olaf On 8/24/07 3:41 PM, Adriano Ceccarelli [EMAIL PROTECTED] wrote: It's problem. I don't have dump data :-S

Re: Removed ibdata1

humm... I'm use ext3... I'm see tool and try recover tks 2007/8/24, Olaf Stein [EMAIL PROTECTED]: Then see if you can recover the deleted files from your filesystem I think there is a tool called e2undel for ext2 filesystems, not sure how easy this is on journaling fs olaf On 8/24/07

Re: Removed ibdata1

thanks for help.. mas no success.. 2007/8/24, Stut [EMAIL PROTECTED]: Adriano Ceccarelli wrote: I removed accidentaly the files : /var/lib/mysql/ibdata1 /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile1 how can I remover them from data files note show tables list all

Re: what if i need the primary key of a row that is to be inserted?

On Fri, 24 Aug 2007, Michael Dykman wrote: calculating the max key + 1 , as it has been noted, must be done transactionally and will therefore require a transactional table And with a transaction isolation level greater than Read Commited... -r -- MySQL General Mailing List For list

RE: seoparator help

Learn something every day. TFT - Original Message - *From:* Andrew Braithwaite [EMAIL PROTECTED] *To:* coolcoder [EMAIL PROTECTED], mysql@lists.mysql.com *Date:* Thu, 23 Aug 2007 14:19:25 +0100 mysql select format(300,0); +---+ | format(300,0) |