mysqlÄúºÃ!
Ìì½òÊб±´óҽԺǿֱ¿Æ¼Ì³ÐÖйú´«Í³Ò½Ñ§µÄ¾«Ë裬·¢¾ò³öÁËÇ峯Ãñ¼äÌØЧ
ÖÎÁÆÇ¿Ö±ÐÔ¼¹ÖùÑ×µÄÎâÊÏÖÐÒ½ÁÆ·¨£¬ÓÐЧÖÎÁÆÇ¿Ö±¼¹ÖùÑס£
¸ÃÁÆ·¨²ÉÓöÀÌصĽ«Ö²¡Òò×ӰγöÌåÍâµÄ·½·¨,Ó¦ÓÃÏÊÖвÝÒ©Íâ·óÖÎÁÆ£¬ÎÞ
Ðè¿Ú·þ£¬ÎÞ¶¾¸¶×÷ÓÃ, ¸ü²»»áÉ˼°³¦Î¸, Ò»°ãÇé¿öÖ»ÐèÁ½¸öÁƳÌ15Ìì×óÓÒ¼´¿É
ʹ»¼Õß½â³ý²¡Í´¡£
Hi all, I'm a bit of a searching newbie,
What sql functions should I be looking at to return any rows containing a
search phrase [eg 'Bob Smith'] from a column which may contain 1 OR MORE
comma separated values?
Take this example table:
id
speakers
date
sample data:
1
Joe Blo, Jane Smith
Description:
table one has only 1 record (table one: ID, some_description; table two IDone),
table two has records but none matching one.ID=two.IDone (table two: ID,
IDone, some_text, some_int).
doing a query like SELECT one.ID,isnull(two.some_int) AS
Hello
I'm having a problem compiling the version of the subject, the problem is
with the gethotsbyname function and the message is the next:
libmysql.c: In function `mysql_real_connect':
libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer type
Hi all,
I've been playing with Fulltext, and for a while there, I though it was a
good solution, but I do need something that doesn't use stopwords... For
example, if Bob Smith was the primary speaker at MOST conferences, then I'd
need a search for Bob Smith to return accurate results, not be
For the one who need help about using Flush and Mysql,
there is a tutorial in the phpbuilder.com, which is
enough good.
Nikos
---
Do You Yahoo!?
@yahoo.grhttp://www.otenet.gr
Hi!
I am trying to install mysql 3.23.52 from source distribution. I
have given this command
shell ./configure --prefix=/usr/local/mysql --with-innodb
after sometimes it gives the following error
CONFIGURING FOR INNODB
NOTICE: I have to make the Innobase directory:
Hello Richard,
I just went through something similar with upgrading from 3.23.49 to 4.03.
The reason you can't connect to MySQL is
020908 15:53:33 mysqld ended
This should obviously not be here.
Check the error logs to see if they say anything important and/or helpful
there. Most likely found
Hello,
Is anyone using Borland's C compiler with Windows (XP) ? I am trying to
compile/link a very simple MySQL client written in C, using MySQL include
files and mysqlclient library, but it does not want to work. What command
line(s) should I use to have it compiled right ? By advance, thank
Hello all,
I am a new MySQL programmer and I have alot of problems
with Installing of new version of this package.
I installed Redhat 7.3 and mysql package from it.
when mysql running received a message base on no access to server.
I downloaded MySQL-3.23.52-1.i389.rpm and
I hope everyone grabs the headers from that message (and any other spam
they receive) and reports it to spamcop.net to help us all block these
people.
PS, this has nothing to do with MySQL, Databases or ACID compliance, but
this line should ironically get me past the spam filter :)
--
use
rpm -e --nodeps ...old package
rpm -i package
- Original Message -
From: mahdi samia [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 09, 2002 3:06 PM
Subject: Installing of MySQL
Hello all,
I am a new MySQL programmer and I have alot of problems
with Installing
Bonjour,
I configured two of my servers for replication.
On the master I added :
log-bin
master-host = xxx..
master-user = x
master-password = x
master-port = 3306
server-id = 14
master-connect-retry=10
binlog-do-db=db1
binlog-do-db=db2
Hello Everybody,
I am tring to install MYsql 3.23 on Solaris 2.5.1
AS there is no binary available . I have downloaded
the source code and compiling . I am running gcc 2.6
I am getting the following error (as below) while
compiling.
Any help is appreciated. I checked the line 126 in
file
Looks like there is a problem with 4.0.3 or I am doing
something wrong:
First I tried to upgrade from rpm,
linux:/home/me/TMPOUT #
rpm -e MySQL-4.0.3-0.i386.rpm
error: package MySQL-4.0.3-0.i386.rpm is not installed
linux:/home/me/TMPOUT # rpm -i MySQL-4.0.3-0.i386.rpm
package
Thanks. A cron job that runs mysqladmin that flushes the tables every
15 mins or so is now in place. A flush-only user has been created to do
this.
I wonder if any negative impact for other databases could be expected at
any point.
--
Mark P. Hennessy
See the FAQ; but basically, use symlinks.
/var/mysql/database1 - /disk1/database1
/var/mysql/database2 - /disk2/database2
... or just mount /var/mysql/database1 as another partition.
/etc/rc.d/init.d/mysql stop
cd /var/mysql
tar -czf database.tar.gz database1
rm -rf database1
mkdir database1
I think the point of a question is to get the correct answer.
The correct answer was given.
David Lloyd wrote:
Hmmm...
Specify the fields you want in your query.
example:
SELECT stat_id, stat_name, stat_data FROM build_stats
WHERE stat_date LIKE ...
I think you miss the point of the
The source is written in C.
Check out the mysql client program.
Many of the utilities listed on the MySQL site are
also 'C' programs. You can download some of them and
take a look.
I would not recommend this as your first exposure to 'C'.
You might want to hire a programmer to assist you until
Why is that a problem?
Chuck \PUP\ Payne wrote:
Well I am glad for the help :). I am get an old table clean up but need to
re-index my table. I think there is on small problem. It's is ISAM table and
not myISAM.
Chuck Payne
Magi Design and Support
Mysql and sql
Mark Sibly wrote:
Hi,
I'm new to this list, and have a few basic MySql questions:
* Is it safe to convert a timestamp field to a datetime one? ie: will this
'touch' each row and stuff up the ordering (hopefully not!).
What happend when you tried it on a test table?
* I'm building a BBS
insert ignore into select from
will skip duplicates.
Karl J. Stubsjoen wrote:
Hello,
How can I determin what erros occur from an Insert into select from
statement? Namely, I'm looking for any duplicate record errors. It is
important to inform the user (in a web browser) whether or not a
Any experienced database person will probably tell you that reaching
fifth normal form usually makes your database cumbersome to work with.
Though in theory is the best setup.
It looks like you are trying to create a cascading structure, which I
think is one of the harder database designs to
Hello all,
I'm hoping someone can confirm this for me.
We're using InnoDB, but when I set it up originally, I just specified the
size of the data file:
innodb_data_file_path = ibdata1:1000M
Being new to it and all at the time, I wasn't aware of the autoextend
capability. But now I'm being
I just installed the 4.0.3 binary of mysql on our
solaris 2.7 development box, and whenever I do a show variables,
mysql crashes... I can view some variables, and going through
the list is seems that querying 'log_slave_updates' is the one that
is killing mysql...
mysql show variables like
On Sun, 8 Sep 2002, David Lurie wrote:
Neither of the two binary mysql-max 3.23.41 from the MySQL website will run on
my system after installation.
Both configure and mysql_install_db fail due to missing dynamic link libraries
/usr/lib/libdl.so.1 and libnsl.so.1. The system does have
I don't even have a master.info file to remove.
The master.info file never gets written. It won't start replication at all.
It just keeps writing the same error to the log file:
Slave thread: error connecting to master: Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES) (0), retry
Hi,
Did the usual RPM install, got the usual message
[root@us-penguin MYSQL]# rpm -Uvh MySQL-4.0.3-0.i386.rpm
Preparing...###
[100%]
1:MySQL
Duane,
yes, you can change the last data file as auto-extending.
Shut down mysqld, edit the my.cnf file, and start mysqld again.
Another solution is just to add another file ibdata2:
innodb_data_file_path = ibdata1:1000M;ibdata2:10M:autoextend
Best regards,
Heikki
Innobase Oy
Copied
I think I have solved this - though what I had to do was weird.
In mysql-VERSION/support-files there's a program called comp_err.
You need to cd to the share/language directory and run
# comp_err errmsg.txt errmsg.sys
Then run scripts/mysql_install_db.
Why should I have to do this? Sounds
Mysql Query
---
Just out of interest, do you see the equivalent of a core file when this
happens? Or anything in the mysql logs?
DSL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Dear all,
I have installed mysql 4.0.2 alpha log (actually compiled by me) in a linux
box (Mandrake 8.2) and for 2 months was working perfectly. After migrating
some data from an other installation (Windows 2000 / mysql 4.0.1 alpha log)
my FULL-TEXT indexes stop functioning. I am issuing the
Just out of interest, do you see the equivalent of a core file when this
happens? Or anything in the mysql logs?
Don't see any cores... here is the error log entry
mysqld got signal 10;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was
walt wrote:
Derrell Durrett wrote:
I'm running server version: 3.22.32, on SunOS 5.6 Generic_105181-17.
The code is perl 5.6.1, using DBI and DBD::mysql as the interface. We
have code that prepares a group of statement handles for use in doing
various queries and inserts in a loop
This handles part of the problem but a true load balanced master
solution is needed. There's no real advantage in spending 5, 10 or
$20,000 on a failover master if you can't load balance and the spare
will just sit idle. Master servers should intelligently talk to each
other and determine
Hello,
Without giving me the RTFM, and in 25 words or less...
Can someone tell me what an index column is and does for a query?
Thanks,
Will
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
Will K. wrote:
Can someone tell me what an index column is and does for a query?
Extra data to make the query faster.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting,
No index:
Go to the library and find a book without using the card catalog.
Index:
Go to the library and find the book in the card catalog, it will tell
where the book is.
On Monday, September 9, 2002, at 01:40 PM, Will K. wrote:
Hello,
Without giving me the RTFM, and in 25 words or
I have a table
key1,key2,key3
or thereabouts.
Now I want to update the value of key1 with that of a reference record
for all values of key3.
In very non-sql terms:
for all r,s in key2,key3
if r.key3 == s.key3 AND r.key2 = reference value
AND s.key2 != reference value
then s.key1 =
Hi folks,
just wanting some headsup on the following question.
How does the index_priv catch in at all?
Does a missing index_priv also block me to create a table with indexes in the
create-statement?
Or does it only affect the later creating of indexes?
Thanks in advance,
Thomas
sql, query
On Mon, Sep 09, 2002 at 12:35:10PM -0500, Jeremy Tinley wrote:
This handles part of the problem but a true load balanced master
solution is needed. There's no real advantage in spending 5, 10 or
$20,000 on a failover master if you can't load balance and the spare
will just sit idle.
Sure
Hi,
I'm missing an answer to a topic which came up a couple of days /weeks ago.
For a database i'm administrating I would like to find out, which numbers
(of invoices)
are missing in our database. Is there a way to get this result set thru SQL?
Or do I have to do it with for example Java?
I think
It means mysql does not own its directories and files.
chown -R mysql
/usr/local/that-long-directory-name-that-should-have-been -symlinked
Richard W. Berriman wrote:
The contents of the error log in
mysql-3.23.49a-pc-linux-gnu-i686/data is:
020908 17:00:27 mysqld started
020908
At 12:40 PM 9/9/2002, you wrote:
Hello,
Without giving me the RTFM, and in 25 words or less...
Can someone tell me what an index column is and does for a query?
Thanks,
Will
Will,
Without an index the entire table has to be read to find the
results of the query. Even simple
Hi!
- Original Message -
From: Anthony R. J. Ball [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, September 09, 2002 7:52 PM
Subject: Re: SHOW VARIABLES bug in 4.0.3 on solaris 2.7?
Just out of interest, do you see the equivalent of a core file when this
Hi all,
We have just finished developing and application in C++ that uses a
mysql 3.23.52 database on Linux. It went into productions this morning and
now we are having problems with multiple select statements. When one user
runs a very learge select query, it locks the tables involved so
hi,
We noticed that a select statement using an order by that should
return 0 rows fails on large table (~11 million rows), due to the
following error:
Out of sort memory.
Increase daemon sort buffer size (becomes 3, Database error.)
We searched the lists and found the following reference to
This handles part of the problem but a true load balanced master
solution is needed. There's no real advantage in spending 5, 10 or
$20,000 on a failover master if you can't load balance and the spare
will just sit idle.
Sure there is. If your master blows up, you have a spare waiting to
I'm running mysql version 3.23.51 on Mac OS 10.2 and have administrator
access. The program that I am writing attempted to log in at least three
unsuccessful times and is now locked out. I am getting a 1044 error and
everything I've read shows the problem as being with the properties set up
Dear sirs or ladies
After changing releases from:
php-4.0b2 to php-4.0.3pl1 and
apache_1.3.12 to apache_1.3.14
using the same mysql
# mysql -V
mysql Ver 11.18 Distrib 3.23.52, for sun-solaris2.7 (sparc)
using php include file:
=
mysql_pconnect(localhost,nobody,) or die(Could not
I am unable to install either version My SQL 4.03 or the release My SQL 3.23
on a XP professional operating system. No error message is produced, double
clicking the setup.exe file only produces a flashing hourglass for a second
and then nothing, no error messages. Suggestions anyone.
Stange
I have a bit of a problem. I need to do something kinda odd that I'm
hoping to get help with...except for any suggestions of changing my
table structure. This might seem weird but I need to try and make it
work as it is.
I have a table called pwdata that looks like the following:
id
I am unable to install either version MySQL 4.03 or the release MySQL 3.23
on a XP professional operating system. No error message is produced, double
clicking the setup.exe file only produces a flashing hourglass for a second
and then nothing, no error messages. Suggestions anyone.
Stange
If it installed on Pro at home, it should do the same
on another pc running Pro.(in a perfect world maybe)
try these troubleshooting steps.
FIRST: check you Privileges. Make sure you are
authorized to install software on the system.
2ND: instead of double clicking the setup.exe, use
XP's
Hi all.
I've been using MySQL-4.0.3 (on Slackware-8.0) for a week or so now, and
have noticed that the command:
mysqladmin shutdown -ppassword
doesn't shut down all mysql processes.
I use the following script to backup our database and restart mysql:
---
cd /root/sql/backups
for I in
Hi,
I'm missing an answer to a topic which came up a couple of days /weeks ago.
For a database i'm administrating I would like to find out, which numbers
(of invoices)
are missing in our database. Is there a way to get this result set thru SQL?
Or do I have to do it with for example Java?
I think
Hi,
I'm missing an answer to a topic which came up a couple of days /weeks ago.
For a database i'm administrating I would like to find out, which numbers
(of invoices)
are missing in our database. Is there a way to get this result set thru SQL?
Or do I have to do it with for example Java?
I think
I'm just getting started with FULLTEXT indexes for a
table and am seeing some very off-base results. While
it may be something I'm doing, I didn't see anything
in the online manual to indicate why these results
would be so bizarre.
Here is a test table I've created:
create table ft_test
(id
58 matches
Mail list logo
