I want to run a commercial product based on MySQL. I have one centralized
server running MySQL in replication mode (master server). I have five
clients running MySQL (each slave is running one MySQL daemon).
Do I have to acquire only one commercial licence for my master server or do
I have do get
Ligaya Turmelle [EMAIL PROTECTED] wrote:
Can I use LIKE in an UPDATE statement when it is not in the WHERE clause?
I only know what the attribute name will end with (may be prefixed).
Example:
UPDATE table SET LIKE '%donut' = valueColumn1 WHERE condition1 = value1;
Find column names
Indeed, I am running the server in Windows. I'll take a look at
Troubleshooting 4.4 in depth.
Thanks,
Eric
Mark Matthews [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Eric B. wrote:
Hi,
I've recently upgraded from 4.0.8a to
kavitha kutty [EMAIL PROTECTED] wrote:
I am a student currently doing my final year MCA project.My project is in JSP and
MySql.I have not studied MySql before.But I got more information about this database
from
MySql.com.But I have a doubt
How many number of tables are possible in one
Bessares, Bob [EMAIL PROTECTED] wrote:
Hello MYSQL Genii,
I am trying to run a query that returns results to a .csv file using mysql's 'INTO
OUTFILE'.
The problem is whenever I write the file I lose my the field names for each
column. For example, when I run the query at command line mysql:
neal [EMAIL PROTECTED] wrote:
I need to backup a mysql 4.1 database with UTF8 characters using InnoDB
and then restore the backup on another machine
I tried the following (same machine - Windows XP)
mysqldump.exe -u root stp2 city d1.sql# backup
stp2.city
mysql.exe -u root
[EMAIL PROTECTED] wrote:
I would like to do the following:
mysqldump -w users.user_id=enews.user_id sotx users
c:/enews_users.sql
Ideally this would dump all records in table users
where the user_id field value is also present in the
enews table. Is this possible?
You can't do it only
Dear Pierre,
I would suggest you to contact directly MySQL AB for such a question at
[EMAIL PROTECTED]
My guess is that you will need to buy a license for the master and the slaves.
Regards,
Bernard
On Wednesday 10 March 2004 03:19, Pierre Luguern wrote:
I want to run a commercial product
Hello together,
I'm getting the following error every few hours. I can force it by
trying to dump the db.
Even if I drop the named table and create an empty one the error still
occurs after some time.
I tried both, raw-device and normal. But nothing solves this problem.
The data is stored on a
Are you running a web server (or ftp server) as well? Because if you are,
then you can upload the files to a separate directory using perl and just
store the links to that file into a table in your database...
If you're not running a webserver (or ftp)... then lemme konw if you get a
viable
I guess the easiest way to do this would be to index all transactions
with a user id number or something identifying the user. When they log in
to the site have the scripts only access the records for that person using
a WHERE clause in the queries. You would have to be able to keep track of
does the questions counter equate to the number of queries ran against the
database? or then number of questions a query may have to ask the database
for one query?
if I do a
select * from table1;
and table one has 100 records does that equate to 100 questions or one
question?
Dean-O
Use the BLOB, Luke!
See your local MySQL manual for details.
We're using BLOBs to store PDF in our database, and through the use of
HTTP headers, we're able to let user download the PDFs without having to
store a local copy on disk, directly from the database
(content-disposition header).
James Tichenor said:
Hello --
New to mysql and the cocoa development environment. I wonder if anyone
can point me in the direction of documentation for mysql support for
webobjects. The webobjects page says that it will support JDBC 2 and 4,
whereas mysql says it supports JDBC 3? Not sure
Hi All;
Sorry to repost, but it appears this announcement was dated 2001 and
probably fell through some email systems:
VBMySQL.com is pleased to announce the launch of a new projects page at
http://projects.vbmysql.com.
The first
Please help! :)
I've got 2 workstations and a server on which i have Mysql 3.23.52 - nt.
The clients are build in Visual FoxPro and use MyODBC for connecting to
server.
From both WKS statements like select, insert, update, delete work just fine,
but when i want to 'LOAD DATA local INFILE' it
Stan Sebastian [EMAIL PROTECTED] wrote:
Please help! :)
I've got 2 workstations and a server on which i have Mysql 3.23.52 - nt.
The clients are build in Visual FoxPro and use MyODBC for connecting to
server.
From both WKS statements like select, insert, update, delete work just fine,
Hi Cliff,
Either way for a production system I recommend using Linuxthreads
with FreeBSD4 (also works on 5 but threads are much improved on 5).
Please use the ports and make WITH_LINUXTHREADS=yes and others that
use (see make pre-fetch in
/usr/ports/databases/mysql-favorite-version)
or
Ok, that's what I thought. Standard backwards compatibility - figured
it had to be that way, since 99.9% of everything else works that way.
Any documentation I might get into describing issues/concerns with
WebObjects and mySQL?
James
On 10-Mar-04, at 5:29 AM, Mark Matthews wrote:
James
I am using mysql 4.0.17 on Red Hat Linux.
I am using the C API to access mysql
The application I am writing should parse a xml file and write details to
the mysql database.
The xml elements as they are read are fed into a simple data structure. On
the completion of the structure details the
Philip Markwalder [EMAIL PROTECTED] wrote:
I have a few questions concerning stored procedures:
1. If I create a stored procedure (like the one below), why does the
returned values not change, though in the stored prcoedure the id has
been generated?
2. Is there any better way to hand
Hi,
I am new to using MySQL and SQL queries. I have in the past only carried out simple
queries. I am trying to write a query for use in our Helpdesk/Audit software.
I want to compare the values in one table (Keywords) to the values found in another
table (Software) so that I can get
in the show status there is a line that says
Questions and it shows a number
The manual says this is the number of questions asked the mysql database.
what I want to know does one query equal one question or if I did the
select * and it brought back 100 rows... does that equate to 100
At 12:35 -0500 3/10/04, Rochester, Dean wrote:
in the show status there is a line that says
Questions and it shows a number
The manual says this is the number of questions asked the mysql database.
what I want to know does one query equal one question or if I did the
select * and it brought
- Original Message -
From: Rochester, Dean [EMAIL PROTECTED]
To: MySQL (E-mail) (E-mail) [EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 12:35 PM
Subject: what does show status 'questions' refer to?
in the show status there is a line that says
Questions and it shows a number
I am fairly new to MySQL and I need a little assistance. In our diff scripts, I need
the output to string all the mods for a given table together in a single query, which
will reduce the number of times the larger tables are copied.
So what modifications would I need to make to my diff script
At 13:15 -0500 3/10/04, Rhino wrote:
- Original Message -
From: Rochester, Dean [EMAIL PROTECTED]
To: MySQL (E-mail) (E-mail) [EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 12:35 PM
Subject: what does show status 'questions' refer to?
in the show status there is a line that says
Thanks guys... I think questions does it. I just want to know how many
queries hit the database. I am getting ready to unleash our company
phonebook, with 10,000 plus listings and just want to make sure that it can
handle it. I have a jndi connection pool established and have the max used
At 13:35 -0500 3/10/04, Rochester, Dean wrote:
Thanks guys... I think questions does it. I just want to know how many
queries hit the database. I am getting ready to unleash our company
phonebook, with 10,000 plus listings and just want to make sure that it can
handle it. I have a jndi
At 13:50 -0500 3/10/04, Rochester, Dean wrote:
Does max used connections value ever go down? Or is this a high water mark
on the server... stating that since the server has been up, at one time you
had this many users connected at a given time.
It's a high water mark. It'll be reset to zero when
Hi All
I have read through some previous threads on this topic and I was unable to find any
to answer my question...
Can I install MySQL on a NFS mount and use its executables on multiple machines
simultaneously? The data will be NOT be on a NFS mount, just the install.
Thanks
Gabe
HI!
yes you can! as long as the data is no on a nfs volume go ahead! =)
Best Regards!
On Wed, 2004-03-10 at 15:16, Tucker, Gabriel wrote:
Hi All
I have read through some previous threads on this topic and I was unable to find any
to answer my question...
Can I install MySQL on a NFS
Sasha Pachev wrote:
This so-called moron is Miguel Soloranzo - the guy in charge of
MySQL Wind ows
builds. So blocking his posts to the list would be a bad idea.
The problem is that somebody got infected with a virus that picked up
his address, as well as the address of the list, and keeps
Mr. Izzard,
We have these tables:
Table software
- pcname char(..)
- product char(..)
Table keywords
- id int(..)
- seachname char(...)
and you want to pick out the pcname from the software table, where the
If those servers are yours, it sounds to me that you can run it GPL.
Read this:
http://www.mysql.com/doc/en/Using_the_MySQL_software_for_free_under_GPL.html
Stephen
- Original Message -
From: Pierre Luguern [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 7:19 PM
The short answer is no, not using MySQL built in transaction system. What I
do for things like this is add a field to the table that indicates whether or
not the record is locked. It is usually a Tiny Int that I just set to 1 or
0.
Hope that helps.
j- k-
On Tuesday 09 March 2004
How can I select the last record that was inserted? An ASP/VB example would
be great too!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi, Folks!
I get a MySQL 4.0.18 server running on a Conectiva Linux Kernel 2.4.5.
The MySQL server supports datum for a C apliccation which everybody in the company
uses.
The problem is that huge mysqld processes come up as people loads their programs,
which connect to the mysql server.
Each
Aaron wrote:
How can I select the last record that was inserted? An ASP/VB example would
be great too!
I believe you have it already.
I use:
select last_insert_id() as MyID
but from memory @@identity is a synonym of last_insert_id()
Dan
--
sig
Daniel Kasak
IT Developer
NUS
My Aaron,
I don´t know any means to get the last inserted record into a MySQL table,
as built-in command.
What I would do to get this record is to have a timestamp field in the
record (mmddmilisecsinday) to solve the problem.
That´s it.
Leandro Neves.
- Original Message -
From:
Judging from the times on the clock (03:00 to 07:00) I would guess that the
server on which MySQL is running is doing some scheduled activity. Cron jobs
for backup, slocate updates, security checks, etc. MySQL doesn't do
scheduled maintenance, especially not for four hours.
j- k-
On
Only being able to see certain rows is not a function of MySQL, it is a
function of the application you write for the user to access the database.
If a user has permission to read a table, they can read all rows. It is up
to your application to make sure they are only seeing rows that apply
Rough example. Assuming that you are using the same connection since
last_insert_id() is connection specific.
rset.open INSERT INTO table1 values(someValue)
rset.open SELECT last_insert_id() as identity
identity = rset.fields(identity)
-Original Message-
From: Aaron
To: [EMAIL
Hi Patrick,
No, you can't get per database statistics in MySQL. :-(
Matt
- Original Message -
From: Patrick Gelin
Sent: Wednesday, March 10, 2004 1:45 AM
Subject: 3 000 000 requests for last 14 days...
Hi,
I've got very astonished to see with phpMyAdmin my MySQL database has
Are you looking at ps -aux | grep mysql (or some variant) to determine this?
-Original Message-
From: Rocar Peças
To: [EMAIL PROTECTED]
Sent: 3/10/04 4:19 PM
Subject: Serveral mysqld instances
Hi, Folks!
I get a MySQL 4.0.18 server running on a Conectiva Linux Kernel 2.4.5.
The MySQL
Great - thanks!
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: March 10, 2004 5:36 PM
To: 'Aaron '; '[EMAIL PROTECTED] '
Subject: RE: @@identity
Rough example. Assuming that you are using the same connection since
last_insert_id() is connection specific.
When I go online to access my bank account I only see transactions pertain to my
account only. I think when ever I make a transaction the database records my account
number in the transaction table. When I log-in using my account number and password
the system checks whether it is correct or
From: Maru, Mulugeta [mailto:[EMAIL PROTECTED]
When I go online to access my bank account I only see
transactions pertain to my account only. I think when ever I
make a transaction the database records my account number in
the transaction table. When I log-in using my account number
and
Folks,
We've been running a fairly high-traffic mysql server for some time,
and we've been occasionally seeing messages like this in the logs:
InnoDB: Error: semaphore wait has lasted 600 seconds
InnoDB: We intentionally crash the server, because it appears to be
hung.
040309 18:20:36 InnoDB:
Matt W wrote:
Hi Patrick,
No, you can't get per database statistics in MySQL. :-(
May be there is a tool to get this information examining log file, or
hooking requests send by clients??? By the way, it is possible to rotate
log files?
Matt
- Original Message -
From:
Yes, you make sense. But when you go in to access your bank account, you are
not directly accessing the database. The web application is opening the
database and only returning rows in the table that pertain to you. The web
application can read all the rows; your user name has *no* read or
[I checked with the a list admin before posting a job here, so ping me
off-list if this bugs you...]
Do you have a working knowledge of MySQL in a production environment?
Can you configure and debug replication in your sleep? Do you know the
differences between MyISAM and InnoDB tables? Do you
An equivalent, but slightly simpler, query would be
SELECT sw.pcname, sw.product
FROM software sw, keywords kw
WHERE sw.product RLIKE kw.Searchname
RLIKE is for regular expression pattern matching. Regular expressions,
unlike LIKE patterns, don't have to match the whole string, so there
Rochester, Dean wrote:
does the questions counter equate to the number of queries ran against the
database? or then number of questions a query may have to ask the database
for one query?
if I do a
select * from table1;
and table one has 100 records does that equate to 100 questions or one
Melanie Ware wrote:
I am using mysql 4.0.17 on Red Hat Linux.
I am using the C API to access mysql
The application I am writing should parse a xml file and write details
to the mysql database.
The xml elements as they are read are fed into a simple data structure.
On the completion of the
Torrance Hill wrote:
I am fairly new to MySQL and I need a little assistance. In our diff scripts, I need the output to string all the mods for a given table together in a single query, which will reduce the number of times the larger tables are copied.
So what modifications would I need to make
Patrick GELIN wrote:
Matt W wrote:
Hi Patrick,
No, you can't get per database statistics in MySQL. :-(
May be there is a tool to get this information examining log file, or
hooking requests send by clients??? By the way, it is possible to rotate
log files?
Turn on full logging (log option),
ZenShadow wrote:
Folks,
We've been running a fairly high-traffic mysql server for some time,
and we've been occasionally seeing messages like this in the logs:
InnoDB: Error: semaphore wait has lasted 600 seconds
InnoDB: We intentionally crash the server, because it appears to be
hung.
040309
Hi Mike,
I am sorry for the confusion I might have caused. May be it would help to
give a clear example.
Table - Customers (CustomerID, CustomerName, Address, etc)
Table - Transaction(TransactionID,CustomerID,Date,Amount)
Note: CustomerID in Customer Table is a Primary Key. TransactionID is a
At 20:39 -0600 3/10/04, Mulugeta Maru wrote:
Hi Mike,
I am sorry for the confusion I might have caused. May be it would help to
give a clear example.
Table - Customers (CustomerID, CustomerName, Address, etc)
Table - Transaction(TransactionID,CustomerID,Date,Amount)
Note: CustomerID in Customer
I have a question about connecting to MySQL. I have MySQL both on my box for
development and on my Web host's machine. Can I use my domain name of my web
host as a host so I can write a program to load data into MySQL.
Christopher J. Noyes
At 23:03 -0500 3/10/04, [EMAIL PROTECTED] wrote:
I have a question about connecting to MySQL. I have MySQL both on my box for
development and on my Web host's machine. Can I use my domain name of my web
host as a host so I can write a program to load data into MySQL.
What does that mean?
--
Paul
I wonder if he means that he wants to pull data from one db into another
using a script of some kind.
If that is what you mean, why not give phpMyAdmin a try, unless your hosting
company already has it. Many do now a days...
Please clarify.
-Original Message-
From: Paul DuBois
How exactly are you doing it with phpMyAdmin? Not sure if it would be save
to a temp dir, I usually get a save as option.
Sorry I can't see your batch file because Outlook blocked it, since it was a
batch file. I'll be checking my email from my Linux machine later, I'll
take a look at it
Dear Lists,
We moved to 4.1.0 when it was first launched, and twice a month or so, we
get access denied commands to one particular database for one particular
user. The privileges are correctly set, and the only way to restore access
for the user, is to revoke and re-apply the privileges and all
Thanks for all the answers!!!
I have been trying the longblob's and it seems to work!
Now all I have to is to figure out how to read it out.. but how hard can it
be ;)
thanks again for all good suggestions!
/isa
From: Kurt Haegeman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Saving
Hi,
As I declared that COBOL can able to communicate with MySQL via it's C API routines.
Currently i have used MySQL 5.0.0-alpha and involved in the usage of prepared
statement C API.
When I implement this calling from COBOL shows this error and reset the MySQL server.
(reset --
stop).
Stan Sebastian [EMAIL PROTECTED] wrote:
Please help! :)
I've got 2 workstations and a server on which i have Mysql 3.23.52 - nt.
The clients are build in Visual FoxPro and use MyODBC for connecting to
server.
From both WKS statements like select, insert, update, delete work just
68 matches
Mail list logo