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
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
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...)
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
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
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
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
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)
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.
SELECT *
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
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
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:
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
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
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
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
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
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
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:
[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:
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:
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 there is
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
[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]
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
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
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
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
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
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
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: mysql@lists.mysql.com
Sent: Friday, July 07, 2006 1:12 PM
Subject: Re: Rekall
On
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
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
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
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 -
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
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,
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 to set up
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 the table create and data for
each:
20060707.DB1.TBL1.sql
20060707.DB1.TBL2.sql
20060707.DB2.TBL3.sql
-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
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
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
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
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
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
45 matches
Mail list logo