I tried to upgrade from 4.01 to 4.03 -apparently I did something wrong and
now got a bad server. Anyone can givew advice on how to cleanly unistall
now(e.g. rm /usr/bin/mysql*)?
linux:/home/db/TMPOUT # rpm -e MySQL-4.0.3-0.i386.rpm
error: package MySQL-4.0.3-0.i386.rpm is not installed
linu
H,
> >>> Suppose I have a field named title that contains
> >> one
> >>> of these
> >>> I am a Man
> >>> I am a Woman
> >>> We are Men
> >>> We are Women
Why not split this into two fields:
pronoun enum('I','WE')
gender enum('MAN','WOMAN')
OR a SET
title SET("I","WE","MAN","MEN","WOMAN",
I got this and I think You must have it.
You seem to have found a bug in the SQL parser.
Please submit a bug report with the data chunk below:
--BEGIN CUT--
JElkOiBzcWxwYXJzZXIubGliLnBocCx2IDEuMTUgMjAwMi8wNy8yNiAxODozMDo1OSBsZW05IEV4
cCAkPGJyIC8+CldoeSBkaWQgd2UgZ2V0IGhlcmU/IDQ2OSA0NzAgODE3PGJy
I see. What about something like this, then:
Where title=VAR or left(title,length(VAR)+1)=concat(VAR," ") or
right(title,length(VAR)+1)=concat(" ",VAR) or title like "% VAR %"
Does that one work?
Jed
On the threshold of genius, Rob Gambit wrote:
>> WHERE ((title like '%man%') or (title like '%
> Hi Rob. Give this a shot.
>
> SELECT * FROM YourTable WHERE title LIKE '% Man' Or
> title LIKE '% Men'
>
> J. Ptak
That comes very close to working for everything. Only
thing is the word can be at the beginning of the
title, the middle of the title, or the end.
WHERE (title LIKE '% man') or
>Description:
I must be missing something terribly obvious, but I cannot get
my client program to link. I get messages like this:
ild: (undefined symbol) mysql_free_result -- referenced in the text
segment of dbinterface.o
The reference manual says
> Hi,
>
> I am using 4.0.2 with Innodb in Windows 98 platform, and I have downloaded
> 4.0.3 and install it without uninstalling 4.0.2. However, when I start the
> winmysqladmin.exe, it takes several minutes without any response, then a
> general failure error dialog box appears. I could not even
Hi, Rob,
Easily resolved. Use 'not like' in conjunction with 'like':
WHERE ((title like '%man%') or (title like '%men%')) and title not like
'%woman%' and title not like '%women%'
Does that work? HTH!
Jed
On the threshold of genius, Rob Gambit wrote:
> Hello MySQL mailing list.
>
> I am havi
Hello MySQL mailing list.
I am having trouble creating a SQL statement for
searching.
Suppose I have a field named title that contains one
of these
I am a Man
I am a Woman
We are Men
We are Women
Now I am trying to search that field using keywords,
for example, I want to return any that contain
Restart mysqld with --skip-grant-tables option and reset password and
flush privileges..
See: http://www.mysql.com/doc/en/Resetting_permissions.html
Hope this helps..
Gurhan
On Fri, 2002-09-06 at 10:37, Adam Cripps wrote:
> I'm locked out of mysql database - it seems that all my users can't acce
Thanks.
I will try to relax now.
But I didn't do any work today. :)
--Clemson
Do you know the answer to my BLOB/TEXT question I posted earlier.
I altered a BLOB column to TEXT, but FULLTEXT still thinks it's a BLOB.
What do I do to use this column in FULL TEXT? Thanks.
-Original Message---
Clemson Chan wrote:
> The MySQL 3.23.52-nt (FTP image) I just downloaded from USA [UUNET]
> (appointed by MySQL.com).
> http://www.mysql.com/downloads/download.php?file=Downloads/MySQL-3.23/mysql-
> 3.23.52-win.zip
>
> I realized that these two html (manual.html and manual_toc.html) files in
> th
Clemson Chan wrote:
> =
>
> =
>
> Is MySQL creating these documentation using a hacked version of software?
Just because it says it's been 'hacked
Hi,
First time here, hope someone can understand me and help me.
I have a field wich type that is int(4), and I'm updating it from a form. it
is working ok, unless the formfield is empty. When it's empty I'm receiving
an SQL error number 51().
In the db the field is setup to receive empty value
'Body' column was converted from BLOB to TEXT as it shown in the
description.
How come the FULLTEXT still thinks it is a BLOB?
Please tell me if you know any work around. Thanks,
--Clemson
mysql> desc message1;
+-+-+--+-+-++
| Field | Type
an indexed column cannot have null values, so it must be defined as 'not
null'
To fix alter the table so the two fields are not null
ALTER TABLE `message1` CHANGE `Title` `Title` varchar(64) NOT NULL
etc
then run your alter table
hth
Peter
---
Exc
What I also not understand is that one can also compile Mysql with
MIT-Pthreads. What is a MIT-Pthread? Where can I read more about this?
Thanks
ilyas
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
At www.mysql.com I can download the source or the binary for macosx.
My question is what is the difference between the source and the
binary? I haven't found a description of the installation with the
binary or with the sourcecode.
Thanks for any help...
ilyas
---
I see. Is there a way to avoid the query queue and wait for a commit on
each insert, or must I guess at it and insert a few, sleep, repeat ?
TIA
Monte
Gerald Clark wrote:
> With many indicies, inserts can be slow, and since you are queueing
> them up as fast as possible, no other queries have a
What is the following error? how do I fix it?
Thanks,
--Clemson
mysql> alter table message1 add FULLTEXT (Title,Body);
ERROR 1121: Column 'Title' is used with UNIQUE or INDEX but is not defined
as NOT NULL
mysql> desc message1;
+-+-+--+-+-++
|
Sorry, user mysql and group mysql already exist, and permissions were
already set correctly. It didn't work.
Any more ideas?
Thanks again.
Tony
> From: Gerald Clark <[EMAIL PROTECTED]>
> Organization: Supplier Systems Corporation
> Date: Fri, 06 Sep 2002 13:30:29 -0500
> To: Tony Butcher <[EMA
Another Mac OS X problem... verified in 10.1 and 10.2
I'm guessing that the mysql client libraries don't support the port
option (-P or --port=)... On both 10.1 and 10.2, I can't get mysql,
mysqladmin, or mysqlshow (the on three I've tried) to connect to a mysql
server on any port other than 3
With many indicies, inserts can be slow, and since you are queueing
them up as fast as possible, no other queries have a chance to get in.
Monte Ohrt wrote:
> Thanks for the quick reply Gerald.
>
> What specifically is being loaded? The system load certainly isn't the
> problem. Is it a buffer
Well, you can't overwrite the data files while the server is running.
Mark Hennessy wrote:
>Shutting down the servers is not an option unfortunately, is there any
>program to run that can force the files to be rechecked without shutting
>down the entire server and restarting it?
>
>--
> Mark P.
I don't want to use replication as IIRC it would require that the sending
MySQL server be listening externally.
--
Mark P. Hennessy [EMAIL PROTECTED]
On Fri, 6 Sep 2002, Jeremy Tinley wrote:
> Date: Fri, 6 Sep 2002 15:26:45 -0500
> From: Jeremy Tinle
Thanks for the quick reply Gerald.
What specifically is being loaded? The system load certainly isn't the
problem. Is it a buffer that fills, or a lock queue, or something else?
Although the inserts are done in rapid succession, there is only one
connection at a time so it shouldn't be a # of
Is there any way to just force the MySQL server to reload from the table
data on disk? The recipient servers are read-only, and the sending server
has a relatively infrequent rate of change, but just enough that it's important
to make sure that things are flushed on the recipient servers every ti
Shutting down the servers is not an option unfortunately, is there any
program to run that can force the files to be rechecked without shutting
down the entire server and restarting it?
--
Mark P. Hennessy [EMAIL PROTECTED]
On Fri, 6 Sep 2002, Gerald
Just shut down all the servers before copying the files.
Check out live replication.
It may be a better solution.
Mark Hennessy wrote:
>I have a Master MySQL server which does not listen publicly, and it
>distributes a database to my publicly accessible MySQL servers via
>rdist/ssh every 15 min
Wouter,
now that I read the query log more carefully I notice that it was thread 23
who was holding the row locks.
>From the query log wee see that thread 23 says 'Quit' around 14:47.
Could it be that you have some 5 minute timeout for a silent connection?
When the connection is terminated, MyS
You need to throttle back the inserts.
You are doing 5-10 inserts per second, but
that is fully loading the server.
Do 1 or 2 inserts, and sleep a second.
Monte Ohrt wrote:
> Hi,
>
> I have hundreds of mysql databases on a server, mostly filled with
> newspaper articles for web sites.
>
> Fo
I have a Master MySQL server which does not listen publicly, and it
distributes a database to my publicly accessible MySQL servers via
rdist/ssh every 15 mins or so by copying the table files. Is there any
flushing that has to be done for the newly rdist'd files to be used by
the public MySQL ser
I have tables as follows
Work
zoneday
1 Tue
2 Thr
3 Mon
4 Thr
5 Thr
ZoneZip
zonezip
1 98006
1 98007
Hi,
I have hundreds of mysql databases on a server, mostly filled with
newspaper articles for web sites.
For one particular database, I have about 10,000 archived articles I
want to load in. I want to do this without affecting the performance of
the live site (or any other sites using this db
Hi there, I am pretty new on MySQL. I am running a website, it needs a
fulltext search on the message board.
The message board table is setup without the fulltext column now. So when I
ALTER TABLE to add a new column FULLTEXT(title, body)? The index will be
created?
In my table, the 'body' colum
Hi,
You could do the partitioning logic on the application side.
For example you can create a new table every month with a
different suffix corresponding to the year/month number.
Then you add the info about this new table into a master
description table, which holds one row per created table,
t
I have seen this post 3 times today.
The message is telling you it can't find
libz.so.1
Obtain and install zlib.
( I run Linux, so I can't tell you where to get it. )
Shravan Durvasula wrote:
>Hi all,
>I am completely new to MySQL. I am trying to install
>MySQL on SUN SPARC Solaris 2.8.
>I down
Try the manual.
It has a section on resetting the root password.
Basically you restart the server with --skip-grant-tables option
Check out chapter 20.11
Adam Cripps wrote:
>I'm locked out of mysql database - it seems that all my users can't access
>it, through lack of privileges, even root. T
You have to create a mysql user and
chown -R mysql /usr/local/mysql
then run
./scripts/mysql_install_db --user=mysql
Tony Butcher wrote:
>Hi,
>
>I have compiled 4.0.3-beta onto SuSE Linux 7.0. The configure, make and make
>install go fine, but then when I try to run the mysql_install_db scr
Perhaps your array items don't have quotes? For example...
Is this what your array looks like: $toTxt = array("a","b","c")
Or is it this: $toTxt = array("\'a\'","\'b\'","\'c\'")
For this to work, it needs to be the second one. If necessary, you can just
walk through the array, adding the quotes
Might want to look at writing either a shell script or doing it in C, if it
has to be non-interactive. Escapade can also do thos sort of thing
interactively, and it's as simple as 4 lines of code.
- Original Message -
From: "Keith Burke [Experience IT]" <[EMAIL PROTECTED]>
To: "'Michael T
Hi,
If you don't wish to use ODBC you can try GMySQL Type Library(Extension
library for libmysql.dll).Interface between VB or VBA and MySQL API
functions.
You can download it from :
http://www.a1vbcode.com/app.asp?ID=1764
or
http://www.simtel.net/pub/pd/59731.html
Regards,
Gelu
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 that is executed a
Thanks very much Jed,
I did as you suggested but theres a problem somewhere
I implode like so
$toString = implode($toArray, ",");
then perform query...
$result = mysql_query("SELECT emailAddress FROM subscribers_html WHERE
mailingGroup IN ('$toString')");
I have checked that $toString has the
If you're in VB and want to connect to a mySQL database then why not use
myODBC? it's what it's there for.
A simple connection string would be:
strConnectionString="DRIVER={MySQL}; SERVER=server;
DATABASE=database; UID=username; PWD=password;"
To access and manipulate the data use ADO:
Hi list,
I am developing a program in visual basic, ans as I am brand new to mysql
database, I would like to know from you which are the proper ways to access
the database from my vb program. I know there could be using odbc, but I
would rather not to use it at all.
We´re working for windows, but
Hi,
If you use another library for linking with your code and the library is not
in the right place(after compiling)...this error occur.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
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 that is executed anywhere from
1-3 times per u
Wouter,
the Lock Monitor output tells that trx 370099 has been committed or rolled
back by the user. That is why the locks have disappeared.
Have you taken into account the following:
8.5 When does MySQL implicitly commit or rollback a transaction?
a.. MySQL has the autocommit mode switched on
Hi Keith,
It's very simple.
type from console : mysql -u root -h your_hostor whatever you need to
start mysql client and after this just type :
mysql>\P mail root@localhost;
mysql>select User,Host,Password from mysql.user;
mysql>\n;
...after this you can look in the root e-mail box and you c
Dear list,
I have a version of a shared lib, say udf_test.so, written in C, that
loads using "mysql> CREATE FUNCTION ..." without a problem. Now say I
create another lib, udf_test1.so, that's written in C++ and includes code
from udf_test.so (declared using extern "C"{}), MySQL complains ERROR 11
Hi,
Does the next MySQL 4.x version will support cross replications between several
master servers in cluster ?
Thanks in advance.
Sam.
--
Sam Przyswa - Chef de projet
Arial Concept - Intégrateur Internet
36, rue de Turin - 75008 - Paris
Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01
Web: http://www
Sorry, my bad.
What is this PAGER and where do I run your test script from?
Regards
**
* K e i t h B u r k e*
**
* Experience IT Lt
...
> I'll also have to read up on those UDF's. Sounds interesting.
...or PAGER.
Try to do a test:
\P mail root@localhost;
select User,Host,Password from mysql.user;
\n
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL
Heikki,
Yep. That's why I use seperate connections for holding the lock and
to do the subsequent locking attempts. Besides, if that were the
problem, I would see the lock disappear at the very first failed
locking attempt, but that's not the case.
I thought it might be a connection timeout, but
http://www.entropy.ch/software/macosx/mysql/remove-old-mysql.html
--
* Stephen Rosenberg
* http://www.lifug.org
* [EMAIL PROTECTED]
* [EMAIL PROTECTED]
On 9/6/02 11:02 AM, "Ilyas Keser" <[EMAIL PROTECTED]> wrote:
> Mysql creates over 900 files at an installation.
>
> I want to reinstall
I don't have a master.info file in my /usr/local/mysql/data dir, only 2
directories: mysql and test, neither of which contain master.info.
What is supposed to be in the master.info file? I don't recall any reference
to a master.info file in the replication setup procedure described in the
MySQL o
Hello!
You must use version 1.0.0 of MySQL and 0.6 of PHP, since I assume you
are using ZX-81 machine
OK, was a joke, but without information I can say: Use the stable
version for your machine (3.23.x), if you don't need the features of the
unstable ones (4.x). I think migrating should be
Hi all,
I am completely new to MySQL. I am trying to install
MySQL on SUN SPARC Solaris 2.8.
I downloaded
mysql-3.23.52-sun-solaris2.8-sparc.tar.gz
and did "gunzip" to unzip the file and then did
"gtar".
When i try to run mysql_install_db, i get the
following error :
**
Michael T. Babcock wrote:
>May I rephrase your comment?
>
>"I need to send E-mails to people from MySQL data".
>
>I recommend just doing a SELECT on the data in question and generating
>the E-mails from PERL or PHP or whatever other language you are using.
No you may not ;-)
*joke*
It needs
Mysql creates over 900 files at an installation.
I want to reinstall my Mysql. How can I remove all these files?
Where does Mysql creates files?
Is it possible to install 2 versions of mysql on the same machine?
ilyas
-
Befor
Please forgive me if this has been addressed (please refer me to the
docs and I will rtfm) or if I'm just being a bobo.
I am running a 3.23.39 client/server on FreeBSD 4.6S system. I am
getting a very peculiar query behavior.
I have a cgi program using the Perl DBI. The programin in question
hi
What version combinations of mysql and php should be used?
regards
anil
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request th
I'm locked out of mysql database - it seems that all my users can't access
it, through lack of privileges, even root. This means that I can't get
through and change the privileges.
How can I start with a fresh users database?
I'm only setting the database up at the moment, so there's no data to
...or a good alternative is PAGER.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Gelu Gogancea" <[EMAIL PROTE
Walt,
Sorry, let me explain in a little more detail.
I have an Access front end ODBC'd to a Foxpro database [I hate
Foxpro :-p No choice, another company developed it for our customer.] on
a Windows server. I get it to export the data to couple of files, tar,
gzip, then ftp to my
Hello!
walt wrote:
>"Keith Burke [Experience IT]" wrote:
>
>
>
>>Greetings,
>>
>>I'm new to this list but not to MySQL. I've been using MySQL on
>>Linux with PHP for the past year or two. I've always managed to sort out
>>any problems by looking at the documentation on the website but
Hi all,
I am completely new to MySQL. I am trying to install
MySQL on SUN SPARC Solaris 2.8.
I downloaded mysql-3.23.52-sun-solaris2.8-sparc.tar.gz
and did "gunzip" to unzip the file and then did
"gtar".
When i try to run mysql_install_db, i get the
following error :
*
Keith Burke [Experience IT] wrote:
> I need to be able to send Emails to people from MySQL command
>line.
>
>
May I rephrase your comment?
"I need to send E-mails to people from MySQL data".
I recommend just doing a SELECT on the data in question and generating
the E-mails from PERL or
Hi,
I have compiled 4.0.3-beta onto SuSE Linux 7.0. The configure, make and make
install go fine, but then when I try to run the mysql_install_db script I
get a failure.
Here's the error:
backup:/usr/local/mysql-4.0.3-beta # ./scripts/mysql_install_db
Preparing db table
Preparing host table
Pre
Hi,
I think youd should make an UDF which that execute in shell what you need.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Mess
Hi Daniel,
So what would be a good solution within MySQL to store large amounts of data if they
have to go into a single table?
InnoDB seems to be the right table type to use (especially as they support
transactions as well) but you do not have controll over the used tablespace. They are
just
Write it in perl.
Perl has modules for MySQl and Email.
Keith Burke [Experience IT] wrote:
>Greetings,
>
> I'm new to this list but not to MySQL. I've been using MySQL on
>Linux with PHP for the past year or two. I've always managed to sort out
>any problems by looking at the documentatio
Put the server on the machine with the data.
You don't want your server doing full table scans
across the network.
Jaime JLO. López Ortega wrote:
>Hi!
>I have just installed MySQL 3.23.52 in a Windows2000. This machine is connected in a
>network.
>I would like to now if it is possible to instal
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Friday 06 September 2002 11:15, Chugh Shalini wrote:
> I need to download source distribution package of mysqlmax version 3.23.52
> for solaris 2.8
>
> but on the www.mysql.com site I always find the binary package version for
> mysqlmax for
"Keith Burke [Experience IT]" wrote:
> Greetings,
>
> I'm new to this list but not to MySQL. I've been using MySQL on
> Linux with PHP for the past year or two. I've always managed to sort out
> any problems by looking at the documentation on the website but my
> current problem has me pe
On Thu, 5 Sep 2002, Darryl Hoar wrote:
> Greetings,
> I downloaded the mysql-max-3.23.42-pc-sco3.2v5.0.6-i386 from MySQL website.
> I installed it per the INSTALL-BINARY readme file.
>
> When I try (from /usr/local/mysql) issue:
> bin/safe_mysqld --user=mysql &
>
> It starts and immediately stops
I've got apache in Win32 system and MySQL 3,32...
intall also.
As far as i know mysql admin needs a server (loclhost)
to work. The ODBC@localhost apears to me when i havn't
give permisions to a user to select a database. You
should check mysql database where you choose
permisions.
Nikos
--- Kev
Alex,
- Original Message -
From: "Varshavchick Alexander" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, September 06, 2002 11:49 AM
Subject: Re: Performance Problems with InnoDB Row Level Locking...
> Heikki, thank you for the answer. S
Hi,
You have to use LOAD_FILE() function to load a file into a blob column.
See:http://www.mysql.com/doc/en/String_functions.html
Gurhan
On Fri, 2002-09-06 at 04:57, navarra/mail.satori.fr wrote:
>
> Hello,
>
> How can i stocking pictures in mysql database ?
> i've tried to open a file as bin
Hi,
What you request i think it can become like this :
SELECT SUM(IF(HOUR(start)>'02:00:00' AND
HOUR(stop)<='08:00:00',50*sessiontime,0)+IF(HOUR(start)>'08:00:00' AND
HOUR(stop)<='14:00:00',100*sessiontime,0)+IF(HOUR(start)<'14:00:00' AND
HOUR(stop)<='02:00:00',150*sessiontime,0)) from YOUR_TABL
Hi,
There's no table size limit, but if you use InnoDB, maybe you need to
extend the size of your tablespaces, because they CAN be full. Check out
your my.cnf
Good luck,
Daniel
At 08:21 2002.09.06._ -0300, you wrote:
> Im inserting 6.000.000 records on a table... but in 3.500.000
I´m inserting 6.000.000 records on a table... but in 3.500.000 the
mysql print:
The table is full.
The tables of mysql have a "record limit to insert" ?
My system is MySQL 3.23.52/InnoDB
My table handler is InnoDB but in MyISAM the mysql print the message
too...
tnks.
JF,
You could try this, if I understand you correctly
===
SELECT count(field_name), field_name
FROM table_name
GROUP BY field_name
HAVING count(field_name) > 1
===
or HAVING count(field_name) = 2 , to find records that are
hello,
i have a table with 10 500 000 rows on a mysql database
how can i find doubles ?? i know how to do it using php, but maybe there
is a way using only queries?
tks
JF leoni
-
Before posting, please check:
http://ww
Greetings,
I'm new to this list but not to MySQL. I've been using MySQL on
Linux with PHP for the past year or two. I've always managed to sort out
any problems by looking at the documentation on the website but my
current problem has me perplexed.
I need to be able to send Emai
Hi!
I have just installed MySQL 3.23.52 in a Windows2000. This machine is connected in a
network.
I would like to now if it is possible to install the datadir directory in another
machine but the one that I have installed the MySQL Server.
I have tried using in the my.cnf file the option datadir
Pierrot:
Do a search on the archive (http://lists.mysql.com/) for this list ... look
for images and blobs ... you should find numerous topics with the info you
are looking for.
Gerald Jensen
- Original Message -
From: "navarra/mail.satori.fr" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Thank you very much for your answer.
I am sorry to have misled you by my incomplete question. I asked you about
build MySql from src earlier and that message was mistakingly associated
with the previous one.
I meant building not dll containing UDF, but MYSQL itself.
I built it as specified in
ht
A number of people have asked about this, and some have figured it out
and posted info somewhere, but not in the www.mysql.com docs.
Perhaps, I need to report it on this list for it to get into a distro,
yes?
In configure, there is a bit that starts at line 7514:
*darwin*)
if test "$a
query, mysql, sql
A very basic question as I have no other options left but to ask.
I need to download source distribution package of mysqlmax version 3.23.52
for solaris 2.8
but on the www.mysql.com site I always find the binary package version for
mysqlmax for solaris.
Please let me
Hi!
Is it's possible to execute such query in MySQL?
update table_name set table1.field1=table2.field2 where
table1.key=table2.key
Thanx
Andis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
Hello,
How can i stocking pictures in mysql database ?
i've tried to open a file as binary, i've replaced ascii(0) by '\O', etc.
i've done an 'insert into table set field='datas'' but doesn't work
please help me
Pierrot
Heikki, thank you for the answer. So on the systems other than Linux or
Solaris the best flush method should be fdatasync, is it correct? In this
case, if I don't specify innodb_flush_method option, fdatasync will not be
used - it'll be fsync be default instead? My system is FreeBSD, so which
valu
here instructions how to use udf_example.cc on VC++.
Assuming that the user has VC++ 6.0, the Windows MySQL source and
running a MySQL server with the same version.
- Open the mysqld.dsw workspace.
- Add New project to the workspace
- Project name: udf_example
- Select Win32 Dynamic-Link Librar
for a gui running on your local system the ISP has to open a remote connection which is
already security problem.
Also the data-flow between your client and the server is not encrypted.
Tools like phpMyAdmin run on the ISPs webserver with a local connection and so there
is no problem with a remot
Hi!
- Original Message -
From: "PR" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, September 05, 2002 5:31 PM
Subject: innodb questions about message board apps
> Hi all, I've been reading a bit on the innodb table type for mysql here
and
> on the site and some o
Amy,
- Original Message -
From: "Amy" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, September 06, 2002 1:14 AM
Subject: lost connection when modifying indexes
>
> Hi -
>
>I'm using MySQL Max 4.0.1-alpha. Whenever I create or drop
> an index on a table that is
Joe,
- Original Message -
From: "Joe Shear" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Sent: Friday, September 06, 2002 2:13 AM
Subject: Re: Performance Problems with InnoDB Row Level Locking...
> Hi,
> On a side note, are there any plans to backport the spurious insert
Alexander,
- Original Message -
From: "Varshavchick Alexander" <[EMAIL PROTECTED]>
To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, September 06, 2002 10:08 AM
Subject: RE: Performance Problems with InnoDB Row Level Locking...
> Hi Heikki,
>
> one more ques
100 matches
Mail list logo
