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) |
> +
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
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
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
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
>
>
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
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 :
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
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
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
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
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
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
>
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
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
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]
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
> >> 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
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
>
> 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
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? 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
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))
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
24 matches
Mail list logo