Hi folks.
I'm wanting to provide some safety for a search. I'll be grabbing about
45 fields, and perhaps thousands of records, so that I can build an xml
file using my middleware. How can I structure an SQL statement so that
I can jump through records 100 at a time? Do I use offset or
Hi, Rich.
What is skip_count? I couldn't find any reference to it in mysql
documentation.
I'm not sure I understood your question, but I beleive you're asking for
LIMIT modifier.
SELECT * FROM $table LIMIT $offset, $record_count;
or
SELECT * FROM $table LIMIT $record_count OFFSET
*MySQL Manual - Chapter 12.7.4. Full-Text Restrictions* says: *Full-text
searches are supported for MyISAM tables only. *
You could try to do what i did... with some overhead... I also had InnoDB
tables for an application and also was in a great need of Full-Text
Searches.
I made a mirror MyISAM
yet just another multi-national gupling up its competitors, i stumbled
across this blog
http://golgote.freeflux.net/blog/archive/2005/10/08/oracle-buys-
innodb.html and had no idea, its just as bad the the latest Eola patent
case against microsoft and others its getting out of hand. What
select * from table where mytimestamp (unix_timestamp - 20) ??
Gregory Machin schrieb:
Hi
What, is the easest way to select all the records created in the last 20 min
stay based on a column that has a timestamp record.
Many Thanks
--
Gregory Machin
[EMAIL PROTECTED]
[EMAIL PROTECTED]
When setting up several instances in the instance manager, if you don't want
them all to start at once, but you want to
start instances on demand (like when you have instances of different MySQL
versions) the only way I found to achieve
this goal is is to set the option nonguarded.
Then, when
Hi, Gregory
Hmm.. I think you just should add something like 'create_time
DATE_SUB(NOW(), INTERVAL 20 MINUTE)' to a where clause of your query. Or
something similar..
You can find more at
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html.
Also consider creating of an
Hello Gregory,
What, is the easest way to select all the records created in the last 20
min
stay based on a column that has a timestamp record.
select * from mytable
where some_timestamp date_add(current_timestamp, interval -15 minute)
Martijn Tonies
Database Workbench - development tool
Hi
Thanks for you support hope you have a grate day ..
On 3/7/06, Martijn Tonies [EMAIL PROTECTED] wrote:
Hello Gregory,
What, is the easest way to select all the records created in the last 20
min
stay based on a column that has a timestamp record.
select * from mytable
where
Hi there,
How do you know what the sources are for a MERGE
table?
SHOW TABLE STATUS doesn't show it, as far as I
can see?
Is it really only available in SHOW CREATE TABLE?
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL
Server
Upscene Productions
Hi
Simple way is show table status; there is a column Type : value MRG_MyISAM is
the base table.
--Praj
On Tue, 7 Mar 2006 14:02:44 +0100
Martijn Tonies [EMAIL PROTECTED] wrote:
Hi there,
How do you know what the sources are for a MERGE
table?
SHOW TABLE STATUS doesn't show it, as
Resend,
Anybody please give me information about different insert performance
between MySQL 5.0.18 and MySQL 4.1.18
as my posting at
http://forums.mysql.com/read.php?22,74279,74279
Thank your
Heikki
Please see my testing result on MySQL Forum
Hi,
Simple way is show table status; there is a column Type : value MRG_MyISAM
is the base table.
No, that's not what I meant -- I meant, the merge
table uses a UNION clause to get signal where it
get it's data from.
Where can I get the sources for the merge table?
That is, what is used in the
Manuel Schmitt (manitu) wrote:
Hi,
I'am searching for a way to have mysqld log all passwords which clients
are using (trying) while connecting.
As to the documentation and to my trials neither the error log nor the
general query log contain passwords, only the usernames.
I already tried to
Im trying to select an IP from a TEXT (details) type field, which works if I do
this:
select id from `table` where `details` like '%192.168.0.1%' :
But If I want any record with an IP in that TEXT type field it seems a little
tricky.
I have tried:
select id from `table` where INET_ATON(details)
Dan Rossi [EMAIL PROTECTED] wrote on 03/07/2006 05:47:41 AM:
yet just another multi-national gupling up its competitors, i stumbled
across this blog
http://golgote.freeflux.net/blog/archive/2005/10/08/oracle-buys-
innodb.html and had no idea, its just as bad the the latest Eola patent
Hello,
my problem: I run a phpbb-Forum with a mysql database on a linux
server.
Every 5 - 7 days the mysql database runs in a vicious circle:
mysqladmin --user=x --password=y ping says that the connect failed.
The socket /var/lib/mysql/mysql.sock is there.
ps aux | grep mysqld shows me some
Hi, Ron.
I think REGEXP can help you..
http://dev.mysql.com/doc/refman/5.0/en/regexp.html
Im trying to select an IP from a TEXT (details) type field, which works if I do
this:
select id from `table` where `details` like '%192.168.0.1%' :
But If I want any record with an IP in that TEXT
Oh yeah got it u meant UNION clause .
Still i have no idea about that i usally see it in show create tables
statements .
Sorry :(
--Praj
On Tue, 7 Mar 2006 15:10:51 +0100
Martijn Tonies [EMAIL PROTECTED] wrote:
Hi,
Simple way is show table status; there is a column Type : value
Hi,
Anyone got a clue where to get a hold of insert_method
after creating the table?
Is the SHOW CREATE TABLE output the only way to
get it?
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL
Server
Upscene Productions
http://www.upscene.com
My thoughts:
Hello Guys,
I was able to connect to mysql database using perl DBI.
I was using the wrong version of Perl on HP-UX to install the DBI and DBD.
There were two versions , 32 bit and 64 bit perl. by default the 32 bit perl
was picked up. I changed the path to 64 bit perl interpreter and the DBI
Martijn Tonies [EMAIL PROTECTED] wrote on 03/07/2006 09:57:17 AM:
Hi,
Anyone got a clue where to get a hold of insert_method
after creating the table?
Is the SHOW CREATE TABLE output the only way to
get it?
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL,
Hello Shawn,
Thanks for replying.
INSERT_METHOD is an option valid for merge tables.
See http://dev.mysql.com/doc/refman/5.0/en/create-table.html
From what I can see, the only way to get it, is parse the
SHOW CREATE TABLE output.
Martijn Tonies
Database Workbench - tool for InterBase,
On 07/03/2006, [EMAIL PROTECTED] wrote:
insert_method ??
I thought I knew a little about databases and table design but that's
a new term for me. What does it mean and how would I apply it in
order to modify a table's contents?
From
Heikki:
All servers have the auto upgrade on, so all the windows upgrade has been
install.
We have a raid 5 on all servers. Could that give a random error? We can try
a give a low format to the disks.
Osvaldo Sommer
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent:
Osvaldo,
Osvaldo Sommer wrote:
Heikki:
All servers have the auto upgrade on, so all the windows upgrade has been
install.
this is interesting. Error 995 might then be a hardware problem.
We have a raid 5 on all servers. Could that give a random error? We can try
a give a low format to the
May be the mysqld server has exceeded max-connections, and is therefore not
able to serve any clients ( but you should have a log for that), is this
your server, and does this happen at peak times, and what happens after the
circle, mysqld just dies
Kishore Jalleda
On 3/7/06, Karl Schock
Martijn Tonies [EMAIL PROTECTED] wrote on 03/07/2006 10:46:58 AM:
Hello Shawn,
Thanks for replying.
INSERT_METHOD is an option valid for merge tables.
See http://dev.mysql.com/doc/refman/5.0/en/create-table.html
From what I can see, the only way to get it, is parse the
SHOW CREATE
1. Support for N-types for the future. UNICODE support for NCHAR, NCLOB and
NVARCHAR datatypes
2. Support for UCS-2 or UTF-16 for future.
3. Support for N-types in Stored Procedures
4. Automatic translation of N-type to SPs Unicode
5. Embedded database server within a client
J A [EMAIL PROTECTED] wrote on 03/07/2006 12:31:57 PM:
1. Support for N-types for the future. UNICODE support for NCHAR,
NCLOB and
NVARCHAR datatypes
2. Support for UCS-2 or UTF-16 for future.
3. Support for N-types in Stored Procedures
4. Automatic translation of N-type to SP’s
On 3/7/06, Karl Schock [EMAIL PROTECTED] wrote:
Hello,
my problem: I run a phpbb-Forum with a mysql database on a linux
server.
Every 5 - 7 days the mysql database runs in a vicious circle:
mysqladmin --user=x --password=y ping says that the connect failed.
The socket
Am Dienstag, den 07.03.2006, 11:30 -0500 schrieb Kishore Jalleda:
Hello Kishore,
May be the mysqld server has exceeded max-connections, and is therefore not
able to serve any clients
how can I see the value of max-connections and how can I see how many
connections are active at the moment?
The web applications below will allow you to connect to and
monitor and administer MySQL databases.
http://www.phpmyadmin.net/home_page/index.php
Check out the DEMO link in the top menu bar, RHS.
Or there is the MySQL Administrator at:
no ideas?
--
Sebastian Mork
[EMAIL PROTECTED]
--
On Mon, 06 Mar 2006 19:46:53 +0100
Sebastian Mork [EMAIL PROTECTED] wrote:
Hi,
is it not possible to lock federated tables (creating a lock on the remote
machine to lock the table on the machine containing the data?)
I've a situation where
Hello,
how can I see the value of max-connections
I found it in phpmyadmin. It is 100.
Can I set max-connections? If so: where can I set it? In /etc/my.cnf?
I found the answer in the mysql-documentation. RTFM I know. ;-)
Bye
Karl
--
MySQL General Mailing List
For list archives:
Hello Keith,
The web applications below will allow you to connect to and
monitor and administer MySQL databases.
http://www.phpmyadmin.net/home_page/index.php
it helps a lot when MySQL is running. Thank you.
But when mysqladmin --user=x --password=y ping says that
the connect failed even
Hi Folks,
We've got a Single Master/Multiple Slave environment.
Recently, we had some corruption on one of the slaves and I had to
repair the affected tables.
After the repair completed, some of the rows on the slave had been
deleted - so the Master and the Slave weren't exactly in synch.
Hello Daniel,
To find the reason causing the problem I started mysqld with the
--log-option and the --log-error-option ...
Try --log-warnings, so you know about ...
I will have a look at the documentation and - if possible - I will
even try --log-everything. ;-)
Also try lowering the
What else can I do to observe myslqd?
mytop may be of some use: http://jeremy.zawodny.com/mysql/mytop/
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Check this GUI out for monitoring running processes.
http://www.student.nada.kth.se/~f91-men/qps/
It will show you the connection parameters passed to the
mysqld daemon.
I've had a terrible time trying to work out whether mysqld
was actually running or not.The error messages are not too
an rsync with the right options from the unaffected slave to the corrupt
one might prove to be an elegant technique
Kishore Jalleda
On 3/7/06, Michael Jeung [EMAIL PROTECTED] wrote:
Hi Folks,
We've got a Single Master/Multiple Slave environment.
Recently, we had some corruption on one of
Hi Kishore,
That's an interesting idea. However, given that the healthy slave
and the corrupt slave now have different values for
Exec_Master_Log_Pos, would restoring the tables from the healthy
slave necessarily be a good move?
I would be worried that the corrupt slave's counter
Hi,
I have a table of directories. Each row represents a directory, which
holds his name and desc. Another table lists sub-directories from each
directory source to its sub-directories targets.
dirs:
+--+--++
| dir_id | dir_name | dir_desc |
kalin mintchev a écrit :
hi all...
what's the best way to periodically back up mysql data?
so that databases and tables can be still usable even after a mysql upgrade?
thanks...
The only absolutely portable way is the dump in text file...
Good luck
--
Mathieu Bruneau
aka ROunofF
On 3/7/06, Mathieu Bruneau [EMAIL PROTECTED] wrote:
kalin mintchev a écrit :
hi all...
what's the best way to periodically back up mysql data?
so that databases and tables can be still usable even after a mysql upgrade?
thanks...
The only absolutely portable way is the dump in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 07 Mar 2006 19:54:02 -0500
Mathieu Bruneau [EMAIL PROTECTED] wrote:
kalin mintchev a écrit :
hi all...
what's the best way to periodically back up mysql data?
so that databases and tables can be still usable even after a mysql
http://sourceforge.net/projects/jtds docs say
jTDS does not need any special installation. Just drop the jar file into your
application's classpath
How do I figure out where that is on a win box?
I am trying to connect it to MsSql using http://java.com/getjava and
What I am trying to do here is have 3 separate primary keys.
Creating a mysql select on either of the Logon_id, email_addr,
or last_name fields will do a single read to the matching value.
Like having 3 different indexes into the same table.
I don't want those 3 field concatenated together as
In the last episode (Mar 07), fbsd_user said:
What I am trying to do here is have 3 separate primary keys. Creating
a mysql select on either of the Logon_id, email_addr, or last_name
fields will do a single read to the matching value. Like having 3
different indexes into the same table.
Eli,
Example: I want to search on all the directories under 'd4' that
contain the word music.
I got several solutions, but not satisfying:
A) Loop from 'd4' to sub-dirs in first level, and use buffer list for
next iterations
when going deeper into levels. [not good: there can be many
- Original Message -
From: fbsd_user [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, March 07, 2006 11:40 PM
Subject: Table with multiple primary keys - How
What I am trying to do here is have 3 separate primary keys.
Creating a mysql select on either of the Logon_id,
Been wondering this for a while now, I can explain how I do it, but I am
sure there are better ways.
I have products and attributes, for example:
Product A
nice
sweet
fast
funny
Attributes are arbitrary, attributes are in a separate table. Yes, I could
add fields for the
Dear all:
I use Tomcat 5.5.9 and Mysql Server 5.0 (with the driver
mysql-connector-java-3.1.12-bin.jar)
to run my Application on Windows XP.
It run smoothly many times throughout the whole Application without any problem
!
But in an unexpected time, I get the following Error messages.
I
Your method is wrong because if you are looking for 5, then 56 will
match and also everything that has 5 in it.
Unless you include the spaces and look for : '% 5 %' but then you need
to add a space at the beginning and at the end of your attributes field.
That method is way too cumbersome and
Hi,
If mysql database server installed on Linux without problem, but on
win2000/XP:
select substring_index(user(),_utf8'@',-1) return the local windows
station computer name instead of IP ?
Best regard!
Shuming Wang
Hi all,
Just want to share and confirm my findings on a performance issue I've
been experiencing.
My database is strictly non-transactional, but it's got about 200,000
records in this particular table. The table has a primary index, and 2
integers - one for the date and the other for the
As far as i know, using IN( SUBQUERY ) will give very poor performance,
especially if the record set returned by the large query is really large.
try to use a join instead of WHERE IN( XXX )..
Im not sure why its that much better in INNODB though...
Foo Ji-Haw wrote:
Hi all,
Just want to
57 matches
Mail list logo