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
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
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
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
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)
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
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
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
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
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
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
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:
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
>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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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?
>
> __
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';
+---
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
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,
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,
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
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/[
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
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?
_
与联机的朋
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
>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
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
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
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
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]
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 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
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
48 matches
Mail list logo