RE: seoparator help

2007-08-24 Thread Terry Riley
Learn something every day. TFT - Original Message - > *From:* "Andrew Braithwaite" <[EMAIL PROTECTED]> > *To:* "coolcoder" <[EMAIL PROTECTED]>, > *Date:* Thu, 23 Aug 2007 14:19:25 +0100 > > mysql> select format(300,0); > +---+ > | format(300,0) | > +

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

2007-08-24 Thread Rudy Lippan
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 archives

Re: Removed ibdata1

2007-08-24 Thread Adriano Ceccarelli
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

Re: Removed ibdata1

2007-08-24 Thread Adriano Ceccarelli
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 > > > O

Re: Removed ibdata1

2007-08-24 Thread Olaf Stein
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

2007-08-24 Thread Adriano Ceccarelli
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

Re: Removed ibdata1

2007-08-24 Thread Olaf Stein
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

2007-08-24 Thread Stut
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 th

bitwise logic

2007-08-24 Thread Wagner, Chris (GEAE, CBTS)
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 stri

Removed ibdata1

2007-08-24 Thread Adriano Ceccarelli
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 t

thread_concurrency in linux

2007-08-24 Thread Andrew Braithwaite
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 f

RE: Column type suggestions

2007-08-24 Thread Rhys Campbell
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 tha

Re: Seriously Disruptive DBA

2007-08-24 Thread Mark Schoonover
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 >

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

2007-08-24 Thread Michael Dykman
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, f

Re: Column type suggestions

2007-08-24 Thread Baron Schwartz
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 for

Column type suggestions

2007-08-24 Thread Benjamin Wiechman
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]

James Benjamin - Seriously Disruptive MySQL DBA

2007-08-24 Thread james benjamin
hi, if anybody wants to reach me please try this account - [EMAIL PROTECTED] or call me on 0044 750 408 9783 = Weather Almanac, Weather Folklore Books Buy Eric Sloane weather almanac, books on weather vanes & more today. http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=5e9d5c58760ae9512db1d28

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

2007-08-24 Thread Martijn Tonies
> >> 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

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

2007-08-24 Thread hardc0d3r
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 arch

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

2007-08-24 Thread Martijn Tonies
> > 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 thi

Re: Seriously Disruptive DBA

2007-08-24 Thread Jonathan G. Lampe
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

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

2007-08-24 Thread hardc0d3r
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 t

problem for partition expression ---floor(col_name)

2007-08-24 Thread xian liu
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 range(floor(b))

ANN: Database Workbench 2.8.10 released

2007-08-24 Thread Martijn Tonies
hat's 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 Expre