Afshad Dinshaw wrote:
Hi
Im using the latest version of mysql.
When I run the following query :
select last_insert_id()
if get the error message:
function vcontacts.last_insert_id does not exist
note: vcontacts is the name of my database.
anyone know why?
thanks
I can run it both upperca
Hi
Im using the latest version of mysql.
When I run the following query :
select last_insert_id()
if get the error message:
function vcontacts.last_insert_id does not exist
note: vcontacts is the name of my database.
anyone know why?
thanks
On 7/7/06, Duhaime Johanne <[EMAIL PROTECTED]> wrote:
Thank you
Of course this is a bad new. Much easier to upgrade to Mysql 5 than to change
the Kernel.
Yeah, unfortunatelly it is...
uname -a
SunOS mercure 5.9 Generic_118558-04 sun4u sparc SUNW,Ultra-80
Not so good news, I'm not an ex
Thank you
Of course this is a bad new. Much easier to upgrade to Mysql 5 than to change
the Kernel.
uname -a
SunOS mercure 5.9 Generic_118558-04 sun4u sparc SUNW,Ultra-80
I do not have fstab but vfstab
mercure{root}171: more vfstab
#device device mount FS fsck
Yes, I agree, it looks like there are indexes on the columns in
question in both tables.
As to when to use a temporary table - I haven't got a clear answer for you.
I wrote an app once that used temp tables, and it gained quite a speed
advantage due to my requirement to first insert a bunch of d
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Friday, July 07, 2006 15:48
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: How does one speed up delete.
Raymond, I would expect that adding an index on 'cid' column in your
'sidtemp' table would help
SQL file per table,
> rather than single massive SQL file with all tables from all
> databases.
>
> In other words, if I have database DB1 with tables TBL1 and TBL2, and
> database DB2 with tables TBL3 and TBL4, I'd end up with files named
> something like this, containing just th
with tables TBL3 and TBL4, I'd end up with files named
something like this, containing just the table create and data for
each:
20060707.DB1.TBL1.sql
20060707.DB1.TBL2.sql
20060707.DB2.TBL3.sql
20060707.DB2.TBL4.sql
This would make selective restores a lot easier, and would also allow
us
Raymond, I would expect that adding an index on 'cid' column in your
'sidtemp' table would help quite a bit.
Out of curiousity, why use a temp table in this situation? Why not
DELETE data
FROM data, event
WHERE data.cid = event.cid
AND event.timestamp < "2006-05-01"
Dan
On 7/7/06, Jacob, Raym
Env: Freebsd 6.0
MySql 4.1.18
Mem: 1GB(?) can not tell without rebooting
Disk Avail: 4GB
Problem: the table data is 4.5GB.
I created a temporary table sidtemp in the database snort by typing:
CREATE TEMPORARY TABLE sidtemp
SELECT cid FROM event
WHERE timestamp < '2006-05-01';
Query OK, 7501376
On Friday 07 July 2006 18:28, Nicholas Vettese wrote:
> If you are using an apt-based system, type 'apt-cache search mysql' That
> should bring up some programs you can install from.
I'm actually running Fedora.
I did say "yum install *mysql*"
which installed everything with mysql in its name -
Hi all,
I'm trying to figure out how much space would be necessary for the mysqldump
with the -opt option.. The inodb tablespace is using roughly 130 G, plus maybe
5 G for various myisam files.
Is it possible to get even a rough estimate?
Thanks in advance.
--
MySQL General Mailing List
For
On 7/7/06, Duhaime Johanne <[EMAIL PROTECTED]> wrote:
Thank you to both of you.
Just a add-on, already mentionned to Michael:
My file system allows illimited files size.
I have a file of 11G on my partition.
mercure{root}120: du -kh mercure.log.jui2006
11G mercure.log.jui2006
The owner of th
Addison, Mark wrote:
From: Chris W Sent: 07 July 2006 09:23
It's late and I just gave up reading the manual. Can someone please
tell me the easiest way to do a query that will return all
rows with a
time stamp that is X number of seconds older than the current time?
Something like this
If you are using an apt-based system, type 'apt-cache search mysql' That
should bring up some programs you can install from.
nick
- Original Message -
From: "Daniel da Veiga" <[EMAIL PROTECTED]>
To:
Sent: Friday, July 07, 2006 1:12 PM
Subject: Re: Rekall
On 7/7/06, Timothy Murp
On 7/7/06, Timothy Murphy <[EMAIL PROTECTED]> wrote:
I've used the KDE program rekall to a small extent in the past,
in order to set up and populate MySQL tables on a remote machine.
It has recently been seg-faulting:
[EMAIL PROTECTED] ~]$ rekall
KBLocation::setCacheSize: set to 0MB
Segmentation
Thank you to both of you.
Just a add-on, already mentionned to Michael:
My file system allows illimited files size.
I have a file of 11G on my partition.
mercure{root}120: du -kh mercure.log.jui2006
11G mercure.log.jui2006
The owner of this file is mysql (it is the log file).
Also the sysad
I've used the KDE program rekall to a small extent in the past,
in order to set up and populate MySQL tables on a remote machine.
It has recently been seg-faulting:
[EMAIL PROTECTED] ~]$ rekall
KBLocation::setCacheSize: set to 0MB
Segmentation fault
In any case, I didn't find it very easy to use.
At 11:25 AM 7/7/2006, you wrote:
I think you meant ORDER BY `registers`..
He may have meant that but then you lose the randomness.
I think it has to be done in 2 steps. I don't see any way of doing it
without creating a temporary table.
The SQL might look something like this:
drop temporary
Hi Jay, thanks a lot for your help.
I tried it and it don´t work, but i tried other way that works fine. I´ll
put it here because it could help other people.
select * from ( select g.grade_id as grade_id, concat(p.nome,"
",g.grade_subtitulo) as nome from grade g inner join produto p on
g.pro
I think you meant ORDER BY `registers`..
Jay Blanchard пишет:
[snip]
I´ve got a page where a ought to get 20 registers in ramdom order but i want
to display it in an alphabetical order.
Someone knows if there is a way to get that 20 random registers in
alphabetical order?
[/snip]
SORT BY `
[snip]
Excuse me, but i don´t understand your answer.
Could you explain it?
[/snip]
Add it to the end of your query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Vittorio - assuming the two databases exist within the same database
server, do this:
select a.campo1, b.campo2
FROM db1.table1 a INNER JOIN db2.table2 b ON a.campo1=b.campo2;
Dan
On 7/7/06, Vittorio Zuccalà <[EMAIL PROTECTED]> wrote:
Hello,
mysql 4.1.11 on debian.
I've db1 with table1 a
Excuse me, but i don´t understand your answer.
Could you explain it?
""Jay Blanchard"" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
[snip]
I´ve got a page where a ought to get 20 registers in ramdom order but i want
to display it in an alphabetical order.
Someone knows if t
No matter what I do, it fails at the step where it's supposed to install
and start the 'Windows service with an error 0. Is this a known issue?
It sure would be nice to get more information about the failure from
the wizard.
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
[snip]
I´ve got a page where a ought to get 20 registers in ramdom order but i want
to display it in an alphabetical order.
Someone knows if there is a way to get that 20 random registers in
alphabetical order?
[/snip]
SORT BY `registers`
--
MySQL General Mailing List
For list archives: http:/
Hi everyone,
I´ve got a page where a ought to get 20 registers in ramdom order but i want
to display it in an alphabetical order.
Someone knows if there is a way to get that 20 random registers in
alphabetical order?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.m
Is there somewhere I can find the exact differences between the contents of the
'essential' and 'complete' Windows MySQL distributions?
I've tried the source code and searched all over the website but can't find it
anywhere.
--Rob
___
On 7/6/06, Santiago del Castillo <[EMAIL PROTECTED]> wrote:
Hi, i'm having a bit of a headache with PHP and MySQL, i've some questions:
1) I've a database in UTF-8 and when i connect to it with mysql_connect,
and exec a query with mysql_query, the results are in latin1. (i proved
this with mysq
Folks,
I'm trying to import a sql dump of a database which is taking an age.
I've disabled foreign key constraints, unique checks and set autocommit
to 0 but this is still slow.
My data file has a number of tables, one of which has circa 3.5 million
tuples taking up about 500MB of data with 900MB
Hello,
mysql 4.1.11 on debian.
I've db1 with table1 and db2 with table2.
How can i make a join into table1 and table2?
If each table are into the same db i can write:
select a.campo1, b.campo2 FROM table1 a INNER JOIN table2 b ON
a.campo1=b.campo2;
But what about my problem?
Thank you very
Has anyone successfully compiled MySQL 5.0.22 from source on any IRIX
version? We are running IRIX 6.5.25 and have tried cc and gcc compilers
with a variety of parameters. All generate errors after an hour or
more. If you have been successful, would you mind sharing the parameters
used and IRIX
Hello,
I get an error message when I start Query Browser.
Could not fetch Catalogs/Schema data.
The following error occured: Access denied; you need the SHOW DATABASES
priviliege for this operation.
My hosting provider has started their server with --skip-show-database.
Is it possible to get
The INTERVAL command is what you are looking for. It doesn't have to be SECOND
(with no S), you could use day, hour ,week, etc.
SELECT * FROM t WHERE TimeCol<(now() - INTERVAL X SECOND)
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html
- Original Message -
From: "Chr
Try this:
SELECT * FROM t
where TimeCol < date_sub( now(), INTERVAL x SECOND )
Dan
On 7/7/06, Chris W <[EMAIL PROTECTED]> wrote:
It's late and I just gave up reading the manual. Can someone please
tell me the easiest way to do a query that will return all rows with a
time stamp that is X num
Lubomir Host 'rajo' wrote:
Description:
Migration problem from 4.0.22 to 5.0.x. I can't create following table on 5.0.x
version of mysql. Problem does't apper on 4.0.x version:
CREATE TABLE `PHONESlog_uniq` (
`user_agent` varchar(80) default NULL,
`http_x_wap_profile` varchar(255) default
From: Chris W Sent: 07 July 2006 09:23
>
> It's late and I just gave up reading the manual. Can someone please
> tell me the easiest way to do a query that will return all
> rows with a
> time stamp that is X number of seconds older than the current time?
> Something like this.
>
> SEL
>Description:
Migration problem from 4.0.22 to 5.0.x. I can't create following table on 5.0.x
version of mysql. Problem does't apper on 4.0.x version:
CREATE TABLE `PHONESlog_uniq` (
`user_agent` varchar(80) default NULL,
`http_x_wap_profile` varchar(255) default NULL,
`pid` smallint(5) uns
OK, fair enough. In that case I would think that filing a report on
bugs.mysql.com would be your best way forward.
At 8:32 am + 7/7/06, SciBit MySQL Team wrote:
>While you are not wrong, James, is the length member suppose to denote the
>maximum length of data contained in result's specified
Hi DÆVID,
Thanks for your feedback. What version of IE are you using?
You got a point about the style. I'll look into it...
Please reply to me directly, or write to [EMAIL PROTECTED]
Thanks,
Paul
On Jul 6, 2006, at 9:17 PM, Daevid Vincent wrote:
Your site has a bunch of JS errors (using IE)
While you are not wrong, James, is the length member suppose to denote the
maximum length of data contained in result's specified column. NOTE: The
result's. I.e. why give such an arbitrary number of bytes/length when no
ENUM's or SET's are even in the result. The point being, even if you cr
It's late and I just gave up reading the manual. Can someone please
tell me the easiest way to do a query that will return all rows with a
time stamp that is X number of seconds older than the current time?
Something like this.
SELECT * FROM t
WHERE TimeCol < (now() - 60*60*24*3)
Yes I
Andy Ford ha scritto:
> Can I do it with DBD::Perl
>
DBD::Mysql is a good module and you can control mysql status...
You can do a lot of select and you can send them functions as createdb,
shutdown or reload.
I use this module in my mysql databases (i've only one server not many
as you have...)
Martin Jespersen schrieb:
Does anyone havea clue of how mysql optimizes empty fields and how
query speed is affected?
Why don't you read the part in the mysql documentation about the
opimization?
what will be better for queryspeed/size: adding them with NULL using
NULL as default or with N
Gabriel Mahiques schrieb:
Friend, I need to see if a table is locked by some application or some
user. Do you know some tools for this? (gpl license better). Or some
sentence?
When a table is locked, how can i unlock this table?
My problem is that some applications cause an error and the user c
45 matches
Mail list logo
