On Mon, Dec 23, 2002 at 02:41:03AM -0500, Michael She wrote:
> Hi,
>
> Is the \ character a delimited in MySQL? I noticed in text inserts I have
> to double slash even if it is enclosed in single quotes. I find this
> behaviour a bit odd.
>
> Are there other delimited characters I should be a
Hi,
Is the \ character a delimited in MySQL? I noticed in text inserts I have
to double slash even if it is enclosed in single quotes. I find this
behaviour a bit odd.
Are there other delimited characters I should be aware of?
Thanks.
--
Michael She : [EMAIL PROTECTED]
Mobile : (519)
Joseph D wrote:
Is it possible for you to tell me where I should add my indexes? I
have read the manual but can't figure out where I must add them to my
tables.
If you have lots of disk space, add them to every column that is in your
query(ies). Then see what the EXPLAIN output says, and de
I'm in a bit of a tough spot -- My innodb table of WebActionLogs (which
has 1 million rows spread out over the last year and a half) has suddenly
stopped using 'TimeInitiated' to select only the last 24 hours of data
(usually less than 7,500 rows), and now wants to copy all 1 million rows to
a te
On Sun, Dec 22, 2002 at 10:43:49PM -0500, Michael T. Babcock wrote:
> Jeremy Zawodny wrote:
>
> >It's a sad day when confidence is built by a company's PR budget
> >rather than the product's track record.
> >
> >
>
> You mean like Microsoft?
Yeah, they are one of the worst offenders. :-)
> Oh
Joseph Dietz wrote:
I think I'll throw in the towel. Here is the slow performance I'm
getting when joining 13 tables. The query simply takes too long.
Did you E-mail the MySQL staff to ask how much it would cost to have
them look at this problem? Or perhaps one of the other paid consultants
Jeremy Zawodny wrote:
It's a sad day when confidence is built by a company's PR budget
rather than the product's track record.
You mean like Microsoft?
Oh, sorry to bring that up ... :-)
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd. ... sql ... for this one :)
http://www.fibrespeed.net/~mba
Michael She wrote:
The gravity is a great analogy. It works with databases too. People
are confident in gravity because it is an observable fact of our
planet. For millennia people have experienced gravity and have grown
accustomed to it. The same can be said of DB2 and Oracle. People
ha
Good day,
We're having difficulties with a database table of one varchar
column that has 130,000,000 records. It is around 3.3gbs.
We want to select unique results from the table and have been using a
variety of commands to attempt to do so (ideally we'll insert results into a
table but
I am having problems getting mysql working. I used the rpm packages to
install the mysql and mysql-max. It seems like they are running because
when I use telnet to try to connect to the port 3306 all I get is a message
saying E Host 'ip' is not allowed to connect to this MySQL
server. Howeve
hi:
I will use Mysql 4.0 to store RTP data stream.
How I can get a handle for controlling longblob field? I will put the
received real-time data into the longblob field by the handle
continually.Would you like to write a demo for me?
Thanks for you help.
-
Hello, I have FULLTEXT Indexes on 2 columns, Entry and EntryCountry. ( See
Below )
mysql> show index from entries\g
+-++-+--+---+---
+-+--++--+
| Table | Non_unique | Key_name| Seq_in_index |
Hello, I have FULLTEXT Indexes on 2 columns, Entry and EntryCountry. ( See
Below )
mysql> show index from entries\g
+-++-+--+---+---
+-+--++--+
| Table | Non_unique | Key_name| Seq_in_index |
On Sun, 2002-12-22 at 17:25, Michael She wrote:
> Hi all,
>
> Does MySQL's ODBC v2.50 driver support Bookmarks?
MySQL doesn't support bookmarks, so no means that the drivers will
support this either :)
--
Regards, Venu
For technical support contracts, go to https://order.mysql.com
__ ___
Hi all,
Does MySQL's ODBC v2.50 driver support Bookmarks?
I can only get ADO bookmarks to work with a Client Side Cursor.
Here is some sample code:
strSQL = "SELECT * FROM IMAGES WHERE `CATID` = " & CatID
rs.CursorLocation = 3 'Client Side Cursor
rs.open strSQL, objConn
rs.PageSize = 1
rs.abso
I had used MySQL's myisampack utility to pack my tables, which makes
them read-only, but now I want them to be write-able again.
I have used "myisamchk --recover --unpack" (tried -ru as well) and the
table is still read-only.
What is the actual incantation one must use here? I can backup and
Hi all:
I am sending a perl program I am trying to run which
doesn't connect to the database. The error message is
at the bottom of the e-mail. I think the program is
going to the sock file and not TCP/IP and I don't know
how to change this, but I'm not sure whether this is
the error, so any help
Hi all ...
our db server is attackt by a root kit,
from our old db server the only thing we have are the log files
knows someone a little script or app to filter all the querys out of the
standard log
format of the mysld.log file ..?!?
thx a lot 4 all kind of support
best regards
andreas
.
With about 400 records total - as I said in my original post - , I should
imagine that any elapsed time will be more a function of my connection
speed than a true measure of database/query speed.
At 11:56 22/12/02 -0400, Adolfo Bello wrote:
Create 2 tables with identical columns definition,
Iain Lang wrote:
.
But that is my question! *When* do they provide a performance
difference?
Obviously my (fairly simple) question ("...and beyond what number of
records might indices provide faster extraction/presentation?... ) has
not been understood. Can anyone else help, please?
Its
>Description:
The unpacked source differs from the source tree after a
./configure && make && make distclean. This should be considered
as Makefile bug, as e.g. package maintainers like me depends on
a souce that cleans up it self so that we can easyly produce diffs
>Description:
gcc -O3 -DDBUG_OFF -rdynamic -o mysqltest mysqltest.o -lstdc++ ../libmysqld.a
-lrt -ldl -lpthread -lz -lcrypt -lnsl -lm -lpthread
../libmysqld.a(lib_sql.o)(.text+0x2736): In function
`handle_connections_sockets':
: undefined reference to `request_init'
>Description:
http://www.mysql.com/doc/en/Linux-x86.html
says what to do to start MySQL on system boot in "Debian GNU/Linux".
I don't know if this holds true for some of your binary packages
under Debian, but the official Debian package is configure by
debcon
On Thursday 19 December 2002 21:29, Arun kumar R wrote:
> I want to run mysqldump through a batch process, in
> order to do that what prive do i need to give to the
> user. It will be running as a cron job, i don't want
> to give any creation or deletion authorization. Your
> help will be greatly a
On Friday 20 December 2002 15:31, Imran Khan wrote:
> I'm using solaris 8 with mysql v 3.23.54.
>
> I want to enable a solaris user - 'user1', to use the mysqlimport command
> without using a password.
>
> I've run, as root, the following sql command:
> mysql>grant all on db1.* to user1@localhost
>Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 +
Please someone email me at [EMAIL PROTECTED] how to do this as well...I
am lost on how to ad data to MYSQLCC
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (
>Description:
gcc -O3 -DDBUG_OFF -rdynamic -o mysqltest mysqltest.o -lstdc++ ../libmysqld.a
-lrt -ldl -lpthread -lz -lcrypt -lnsl -lm -lpthread
../libmysqld.a(lib_sql.o)(.text+0x2736): In function
`handle_connections_sockets':
: undefined reference to `request_init'
>Description:
The unpacked source differs from the source tree after a
./configure && make && make distclean. This should be considered
as Makefile bug, as e.g. package maintainers like me depends on
a souce that cleans up it self so that we can easyly produce diffs
>Description:
http://www.mysql.com/doc/en/Linux-x86.html
says what to do to start MySQL on system boot in "Debian GNU/Linux".
I don't know if this holds true for some of your binary packages
under Debian, but the official Debian package is configure by
debcon
You're right.
I have already posted a 3 tables solution: recipes, ingredients and
recipeingredients.
Adolfo
On Sun, 2002-12-22 at 14:10, Jeff Snoxell wrote:
> > > I'm designing a delivery program with php and mysql, and I'm
> > > having troubles with some tables, my problem is with the
> > > rec
On Thursday 19 December 2002 21:29, Arun kumar R wrote:
> I want to run mysqldump through a batch process, in
> order to do that what prive do i need to give to the
> user. It will be running as a cron job, i don't want
> to give any creation or deletion authorization. Your
> help will be greatly a
On Friday 20 December 2002 15:31, Imran Khan wrote:
> I'm using solaris 8 with mysql v 3.23.54.
>
> I want to enable a solaris user - 'user1', to use the mysqlimport command
> without using a password.
>
> I've run, as root, the following sql command:
> mysql>grant all on db1.* to user1@localhost
Hello Victoria,
Is there any plan to make operators work with phrase searches.
something like: against ('"comput* scie*"') in boolean mode
I have tested 4.0.6-gamma and I can see that the bug is fixed:
Empty set is returned when truncation operator is used :-)
Regards
Salam
Victoria Reznichenko
> I'm designing a delivery program with php and mysql, and I'm
> having troubles with some tables, my problem is with the
> recipes, the recipes are divided into two tables one with a
> recipe id and description the other detailing the
> ingredients, of each particular recipe, that's where my
> p
Hi,
I hope this is the right place to post this.
I have a simple C program that uses libmysqlclient and it works great,
up to the moment a connection with my remote mysqld breaks, for whatever
networking related reason, then I can see that such errors are not
handled softly within the mysqlcli
service mysql start
> -Original Message-
> From: bruno peracchio [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, December 22, 2002 12:41 PM
> To: mysql-list
> Subject: mysql.sock
>
>
> Hi
>
> how can I do to restore mysql.sock?
>
> Thank in advance
>
>
>
>
> ---
On Friday 20 December 2002 11:01, azerbinati at libero dot it wrote:
> I'd a /etc/hosts misconfigured, it told that the machine name was linux200
> with IP 192.168.0.3 but eth0 was configured to use IP 192.168.0.16. In this
> enviroment executing this command "mysql -h 192.168.0.16" cause a
On Sunday 22 December 2002 05:16, Dr. Poo wrote:
> On Friday 20 December 2002 08:42 am, Victoria Reznichenko wrote:
> > On Thursday 19 December 2002 21:29, Arun kumar R wrote:
> > > I want to run mysqldump through a batch process, in
> > > order to do that what prive do i need to give to the
> > >
On Friday 20 December 2002 22:08, John Chang wrote:
> I e-mailed the list but haven't received a response. I have win2k w/
> 3.23.53 and need to update it to 54. Is there a patch or do I have to do a
> reinstall or install on top of it?
You can just install 3.23.54 over 3.23.53, but backup of t
Sorry to be a bother, but I've been working on this problem for three days with no
succcess.
I store the result(s) of a multiple select listbox in a MySQL version 4.0.2 varchar
field
i.e. 2,3,4,5,6 as a selection example. -> these results are stored in the table
category under the field nam
.
> I can't do it by ID because what if a row in the middle somewhere gets
> deleted? I need to do it by the position in the table, and a static
> numbering column won't work. This is a solution someone on EFNet came up
> with:
>
> SET @rowcount=0;
> select docid,@rowcount:=@rowcount+1 as num
.
> I can't do it by ID because what if a row in the middle somewhere gets
> deleted? I need to do it by the position in the table, and a static
> numbering column won't work. This is a solution someone on EFNet came up
> with:
>
> SET @rowcount=0;
> select docid,@rowcount:=@rowcount+1 as num
Bruno,
Restart mysqld.
Peter.
- Original Message -
From: "bruno peracchio" <[EMAIL PROTECTED]>
To: "mysql-list" <[EMAIL PROTECTED]>
Sent: Sunday, December 22, 2002 4:40 PM
Subject: mysql.sock
> Hi
>
> how can I do to restore mysql.sock?
>
> Thank in advance
>
>
>
>
> -
Hi
how can I do to restore mysql.sock?
Thank in advance
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
I can't do it by ID because what if a row in the middle somewhere gets
deleted? I need to do it by the position in the table, and a static
numbering column won't work. This is a solution someone on EFNet came up
with:
SET @rowcount=0;
select docid,@rowcount:=@rowcount+1 as num FROM documents HAVIN
Create 2 tables with identical columns definition, one with index and
the other without.
Start adding records to the two tables and querying them.
This way you'll find out the number of recors for which the performance
is about the same. After that, you can decide wich way to go.
Adolfo
> -
> -Original Message-
> From: Ricardo Fitzgerald [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, December 22, 2002 11:22 AM
> To: [EMAIL PROTECTED]
> Subject: Help with database Design
>
>
create table recipes(
rid int not null primary key,
rname ) ;
create table ingredient(
iid int not
Ricardo, you're asking how to normalise your database. There are links to
some good intro tutorials at http://www.artfulsoftware.com/dbresources.html
PB
-
[filter fodder: sql, mysql]
> Hi,
>
> I'm having problems trying to figure which is the best way to solve a
design
> :
>
> I'm designing
Ricardo, you're asking how to normalise your database. There are links to
some good intro tutorials at http://www.artfulsoftware.com/dbresources.html
PB
-
> Hi,
>
> I'm having problems trying to figure which is the best way to solve a
design
> :
>
> I'm designing a delivery program with php
Hello.
On Sun 2002-12-22 at 08:56:43 -0500, [EMAIL PROTECTED] wrote:
> I really don't want to do this client side (I'd have to execute
> approximately 10 queries for every page load just for this small task).
> Selecting the entire table into a temp table to number the rows also
> seems rather ine
Hi,
I'm having problems trying to figure which is the best way to solve a design
:
I'm designing a delivery program with php and mysql, and I'm having troubles
with some tables,
my problem is with the recipes, the recipes are divided into two tables one
with a recipe id and description the other
I really don't want to do this client side (I'd have to execute
approximately 10 queries for every page load just for this small task).
Selecting the entire table into a temp table to number the rows also
seems rather inefficient. I was reading in a book at Barnes and Noble
yesterday which said to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Iain Lang wrote:
.
But that is my question! *When* do they provide a performance difference?
Obviously my (fairly simple) question ("...and beyond what number of
records might indices provide faster extraction/presentation?... ) has
not been under
.
But that is my question! *When* do they provide a performance difference?
Obviously my (fairly simple) question ("...and beyond what number of
records might indices provide faster extraction/presentation?... ) has not
been understood. Can anyone else help, please?
At 11:22 22/12/02 +1100, A
On Fri, Dec 20, 2002 at 09:01:21PM -0800, JamesD wrote:
> Jeremy,
>
> mySql has no brand recognition compared to Oracle, Sybase, MS, IBM.
Well, it doesn't have as much, that's for sure. But to say it has
none is an over-simplification.
> that is why there is not enough confidence.
> people buy
Dear All,
we have developed a web-based application for a client
and now in its testing phase by next week...
It uses Linux/PHP 4/MySQL 3.23
As the volume of user will be more, we are very much
concerned about the server efficiency and our
application efficiency/performance...
Following are the
57 matches
Mail list logo
