Hi,
I get this error when trying to create newtables in a cluster.
I just created about 27 tables using ndbcluster-engine without a problem.
trying to create any more tables fails with this error.
anybody knows?
thx
--
Sebastian Mork <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list
Can someone help point me in the right direction for this. This isnt
exactly what I want but once I have the solution to this I can work out the
permutations I need.
How do I select from 3 tables into a single table (consequtive rows not
joined ones) and include a two new columns which is the nam
I've now figured out that the error occurs when I try to create any
table that has a primary key. creating tables without the primary key
works.
hmm.. is there any limitation in the mysql (ndb)-settings that I've to
change?
Its the standard-installation of 4.1.21-max...
--
Sebastian Mork
[EMAIL PR
Can anyone tell me how can I import the *.gra (oracle db file) files to
Navicat or Acess. Pls let me know in steps as I am v new to this field.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thank u so much. It woked now!
- Original Message -
From: "Visolve DB Team" <[EMAIL PROTECTED]>
To: "Visolve DB Team" <[EMAIL PROTECTED]>; "Renish"
<[EMAIL PROTECTED]>;
Sent: Tuesday, October 10, 2006 1:42 PM
Subject: Re: Query Help plss
Hi,
Hope this link will you.
http://mysql.b
Hello,
you can do it in two ways I guess:
one is to do a second select (which you don't want):
SELECT LAST_INSERT_ID().
another way is to use java.sql.Statement.RETURN_GENERATED_KEYS
when you create your Statement, something along these lines:
java.sql.PreparedStatement pstmt =
myconnec
Hello Chris,
Chris <[EMAIL PROTECTED]> writes:
> Surendra Singhi wrote:
>> I am using mySQL 5.0 and I have 2 tables with few hundred millions of
>> records. To optimize things, I am using MyISAM tables, using the
>> smallest possible data
>> type and have set indexes.
>> Now, the problem which
>Also, when a query takes too long I kill it by shutting down the
server, is this safe or is there a better alternative (MyISAM tables)?
Use show processlist to see the query that taking more time and use "
kill ; " for terminating the query .
--
Praj
Surendra Singhi wrote:
Hello Chris,
C
Thanks Phil
It gives me a solution and some reading.
Kerry
-Original Message-
From: Philip Mather [mailto:[EMAIL PROTECTED]
Sent: 11 October 2006 10:02
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: How to build a single temporary table from 3 tables on the
fly
How can i do if i want to drop tables with the same predix?
For example, there is a database including a lot of tables,such as
tableA,tableB(table*)
Now,how can i drop those tables by using only one single statement?
_
与联机的朋
You could do that. You must also create a blank T1.MYI.
Even then, MySQL will still go through its death-defying
series of copies and index rebuilds anyway.
You could look into the myisam_repair_threads system variable.
Current MySQL installations have it set to 1. If this is greater than 1,
MySQL
hi,
currently using mysql 4.0.18. want to move to 5.0 (latest stable version
for commercil use). is there anytihng I have to be considered DB will not
work?
thanks.
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
Hi,
I have the following data:
mysql> select Dealername,pc from ford_gb where pc='LE4 7SL';
+-+-+
| Dealername | pc |
+-+-+
| CD Bramall Ford - Leicester | LE4 7SL |
| CD Bramall Ford - Leicester | LE4
Kerry,
It gives me a solution and some reading.
No probs, here's some actual code that I hacked together on a
4.1-sommat-or-other database, an important thing to note is to be
careful of any Unique keys selected from the three individual tables as
they may no longer be unique of course once
Hi,
Take a look at the answer written by Peter Brawley to Jason Chan at Oct
10, 2006, ~04:34 PM. Answer included below:
Jason
following statement works in 4 but not 5
SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as
cat_state, c.name as cat_name, c.description as cat_desc,
Never mind.
mysql> select Dealername,pc,group_concat(pc) from ford_gb where pc='LE4
7SL' group by 1;
++-+--+
| Dealername | pc | group_concat(pc) |
++-+--+
| CD Bramall - Leicester | LE
Andrew, very possible, have a look at the GROUP_CONCAT function:
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html
Dan
On 10/11/06, Andrew Braithwaite <[EMAIL PROTECTED]> wrote:
Hi,
I have the following data:
mysql> select Dealername,pc from ford_gb where pc='LE4 7SL';
+---
Hey
方外 醉月 wrote:
>
> How can i do if i want to drop tables with the same predix?
>
> For example, there is a database including a lot of tables,such as
> tableA,tableB(table*)
>
> Now,how can i drop those tables by using only one single statement?
>
> __
I'm having some trouble setting a future date within a table. I have one
column 'this_date' which is a DATE field and I'm trying to add 90 days to
it and set a column named 'future_date', also a DATE field.
I don't know if the problem is that I'm trying to write the value into
the 'this_date' and
Ed Curtis wrote:
I'm having some trouble setting a future date within a table. I have one
column 'this_date' which is a DATE field and I'm trying to add 90 days to
it and set a column named 'future_date', also a DATE field.
I don't know if the problem is that I'm trying to write the value into
t
Why you don´t try this?
UPDATE this_table SET
this_date = $this_date,
future_date = (DATE_ADD($this_date) INTERVAL 90 DAY)
"Ed Curtis" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
>
> I'm having some trouble setting a future date within a table. I have one
> column 'this_da
Your sql has more error.
I´ll put the right way below.
UPDATE this_table SET
this_date = $this_date,
future_date = DATE_ADD($this_date, INTERVAL 90 DAY)
It´ll works fine.
""João Cândido de Souza Neto"" <[EMAIL PROTECTED]> escreveu na
mensagem news:[EMAIL PROTECTED]
> Why you don´t try th
Please check your syntax.
It should look like this:
UPDATE this_table SET
this_date = $this_date,
future_date = DATE_ADD($this_date,INTERVAL 90 DAY);
Don't forget your WHERE clause or else you populate every row.
- Original Message -
From: João Cândido de Souza Neto <[EMAIL PROTECTED]>
T
On Wed, 11 Oct 2006, Mark Leith wrote:
> Ed Curtis wrote:
> > I'm having some trouble setting a future date within a table. I have one
> > column 'this_date' which is a DATE field and I'm trying to add 90 days to
> > it and set a column named 'future_date', also a DATE field.
> >
> > I don't kno
On Wed, 11 Oct 2006, Rolando Edwards wrote:
> Please check your syntax.
> It should look like this:
>
> UPDATE this_table SET
> this_date = $this_date,
> future_date = DATE_ADD($this_date,INTERVAL 90 DAY);
>
> Don't forget your WHERE clause or else you populate every row.
Tried it, this is what
Please put the 2008-10-20 in single quotes
if you r are doing this in PHP
UPDATE this_table SET
this_date = $this_date,
future_date = DATE_ADD('$this_date',INTERVAL 90 DAY);
- Original Message -
From: Ed Curtis <[EMAIL PROTECTED]>
To: Rolando Edwards <[EMAIL PROTECTED]>
Cc: João Cândido d
Oops, also the $this_date
UPDATE this_table SET
this_date = '$this_date',
future_date = DATE_ADD('$this_date',INTERVAL 90 DAY);
- Original Message -
From: Rolando Edwards <[EMAIL PROTECTED]>
To: Ed Curtis <[EMAIL PROTECTED]>
Cc: João Cândido de Souza Neto <[EMAIL PROTECTED]>, mysql@lists
On Wed, 11 Oct 2006, Rolando Edwards wrote:
> Oops, also the $this_date
>
> UPDATE this_table SET
> this_date = '$this_date',
> future_date = DATE_ADD('$this_date',INTERVAL 90 DAY);
Got it going guys, thanks again
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
Ed Curtis wrote:
UPDATE this_table SET
this_date = NOW(),
future_date = NOW() + INTERVAL 90 DAY;
This is probably along the lines of what you want..
Actually I'm setting the DATE via drop down menus using PHP and creating
the date by hand via variables. NOW() won't work in this instance.
Our pleasure. Good day !!!
- Original Message -
From: Ed Curtis <[EMAIL PROTECTED]>
To: Rolando Edwards <[EMAIL PROTECTED]>
Cc: João Cândido de Souza Neto <[EMAIL PROTECTED]>, mysql@lists.mysql.com
Sent: Wednesday, October 11, 2006 12:48:29 PM GMT-0500 US/Eastern
Subject: Re: date_add func
Still don't get it
:(
> Hi,
>
> Take a look at the answer written by Peter Brawley to Jason Chan at Oct
> 10, 2006, ~04:34 PM. Answer included below:
>
>> Jason
>>
>> following statement works in 4 but not 5
>>
>> SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as
>> cat_state, c
>Still don't get it
Did you read the section of that manual page headed "Join processing
changes in MySQL 5.0.12"? It explains why and how to rewrite all such
queries using explicit JOIN ... ON | USING syntax.
PB
-
[EMAIL PROTECTED] wrote:
Still don't get it
:(
Hi,
Take
Mysqlhotcopy can copy the files anywhere. Just have it copy under ur
MySQL data directory and the new copy will be visible instantly. e.g.
/var/lib/mysql/data/offline_copy U will instantly see a new database
named "offline_copy" with the copy of ur table in it.
Brian Dunning wrote:
>
> Thanks
Is it possible to have a transaction automatically write the IP
adress of the client
to a field of a record?
-
This sig is dedicated to the advancement of Nuclear Power
Tommy Nordgren
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http:
Hi
I want to store jpeg images in a mysql database from php in the form of 'blob'
types.
Is this possible and can you detail for me the steps to achieve this?
Regards and thanks
Rodney Courtis
On 10/10/06, Rodney Courtis <[EMAIL PROTECTED]> wrote:
I want to store jpeg images in a mysql database from php in the form of 'blob'
types.
Is this possible and can you detail for me the steps to achieve this?
For a nice size performance hit, yup:
http://www.zend.com/zend/trick/tricks-sept-2
Does anyone know why a mysql alias would not display in the return a result?
When I try to access say the first name with it's alias f_name, it is blank? ,
but it works for its column name first_name? This becomes more of a problem
with subselects because how does one alias it?
Thank you,
A
I have an update operation where I am able to update 10 million records in
approx
2.5 mins.
But when I tried to do the same update on say 40-50 million records, mysql
takes forever to finish. Its the same table, and same update operation, i am
just changing the range of ids using where claus
Hi,
I have 2 identical Linux machines setup with identical my.cnf files
(except for server-id) and both running 5.0.26.
On server A, I run,
mysqldump -h localhost -u root -p... --single-transaction --flush-logs
--delete-master-logs --master-data=1 --databases db1 db2 > dumpfile
I copy dumpf
On Wed, 2006-10-11 at 13:12 -0500, Peter Brawley wrote:
> >Still don't get it
> Did you read the section of that manual page headed "Join processing
> changes in MySQL 5.0.12"? It explains why and how to rewrite all such
> queries using explicit JOIN ... ON | USING syntax.
>
This works in 4.x but
Anyone here uses OLAP, running in MySQL? Any OpenSOurce OLAP query
tools?
How does one goes about doing OLAP? Is there any documentation w/ MySQL
anywhere. (I'm currently looking at Pentaho and Mondrian etc but the
Pre-configured demo didn't work as it should, meaning it doesn't run for
X reasons)
Ian, those backticks are standard stuff for mysqldump.
A couple of thoughts -
1, are you sure your 'create database' succeeds?
2, long shot, but are you FTPing in ASCII mode? This *might* mess up
the backtick character.
3, instead of cat file.sql | mysql, try this
mysql -u root -p < file.sql
HT
On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
> Hey
>
> 方外 醉月 wrote:
> >
> > How can i do if i want to drop tables with the same predix?
> If you are using 5.0:
>
> DELIMITER //
> DROP PROCEDURE drop_table_prefix//
>
> CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHA
On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
> Hey
>
> 方外 醉月 wrote:
> >
> > How can i do if i want to drop tables with the same predix?
> If you are using 5.0:
>
> DELIMITER //
> DROP PROCEDURE drop_table_prefix//
>
> CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHA
On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
> Hey
>
> 方外 醉月 wrote:
> >
> > How can i do if i want to drop tables with the same predix?
> If you are using 5.0:
>
> DELIMITER //
> DROP PROCEDURE drop_table_prefix//
>
> CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHA
On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
> Hey
>
> 方外 醉月 wrote:
> >
> > How can i do if i want to drop tables with the same predix?
> If you are using 5.0:
>
> DELIMITER //
> DROP PROCEDURE drop_table_prefix//
>
> CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHA
Hi,
yes, the create database succeeds. It's in a show databases. The error
message is complaining about "`db1`" (i.e. quotes followed by backtick).
I'm actually using rsync to copy the file (faster than ftp for some
reason). But it also failed when I originally ftp'd it.
I've also tried the mys
Sorry for the multiple post screw up.
My Bad
On Thu, 2006-10-12 at 11:43 +0800, Ow Mun Heng wrote:
> On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
> > Hey
> >
> > 方外 醉月 wrote:
> > >
> > > How can i do if i want to drop tables with the same predix?
>
> > If you are using 5.0:
> >
> > DEL
48 matches
Mail list logo
