Laercio Xisto Braga Cavalcanti wrote:
Hi all,
I'm using mysql 3.23.54 under RedHat9 trying to update a field named
pac_fone in a table named paciente with the value of a field named
ita_fone from a table named italica as follows:
update paciente
SET pac_fone= (select
Hi Folks,
Here are some easy questions I hope you can answer.
I have been creating innoDB tables in mysql, creating contraints and foreign keys and
it runs swimmingly.
The server I am now doing mySQL on won't allow me to create other than myISAM tables.
Is it true that only innoDB tables
When it will be avalaible to download ?
regards
massimo
-
Massimo Petrini
c/o Omt spa
Via Ferrero 67/a
10090 Cascine Vica (TO)
Tel.+39 011 9505334
Fax +39 011 9575474
E-mail [EMAIL PROTECTED]
--
MySQL General Mailing List
For
A couple of questions for any Mac users willing to help:
I have created an application for OS X.3 that talks to the MySQL server with
shell commands. In order for those commands to work, I have to include a
proper username and password to access the MySQL database designated for my
app within
I have two tables one is the gallery and the other one is table for
events so I can categorise the images.
Now I wan't to get all the rows from events (id, event, date) in
cronological order by date. But I also wan't a random row (id, , ext,
*_nail) from the gallery where gallery.event is
On Sat, 22 May 2004, John Mistler wrote:
do shell script kill cat /usr/local/mysql/bin/mysql/data/localhost.pid
The kill command takes a numeric PID as its argument. You need to get
the pid out of the pidfile. So to get the above to work you have to
enclose cat and the filename in backticks:
amd64f# ./run-all-tests --server=mysql --cmp=mysql --user=root
--password=theword --log
Warning: Can't execute create. Check the file
'output/create-mysql-FreeBSD_5.2_CURRENT_amd64-cmp-mysql'
^CWarning: Can't execute insert. Check the file
Have you tried dbmonster?
http://dbmonster.kernelpanic.pl/index.html
It generates random data for you.
-Messaggio originale-
Da: Greg Willits [mailto:[EMAIL PROTECTED]
Inviato: venerdi 21 maggio 2004 21.17
Cc: MySql
Oggetto: Large sample data sets for testing
Anyone know of
Hi Michael,
Thank you very much. It works good.
Regards,
Laercio.
Laercio Xisto Braga Cavalcanti wrote:
Hi all,
I'm using mysql 3.23.54 under RedHat9 trying to update a field named
pac_fone in a table named paciente with the value of a field named
ita_fone from a table named italica as
On May 22, 2004, at 2:12 AM, John Mistler wrote:
In the larger picture, I am wondering if there is a way to avoid all of
this. Ideally, I would like for the application to come packaged with
MySQL, to install MySQL automatically (not sure what happens if MySQL
already exists on the system), and
Aysun Alay wrote:
Our application needs to support both solaris 8 and solaris 9. I was
wondering if mysql has a backwards compatibility in terms of operating
systems. Can I use mysql-pro-4.0.20-sun-solaris2.9-sparc.tar file to
install mysql on Solaris 8?
Not sure, but it is usually not too hard
Hi all,
Have a query that used to work on one server but then MYSQL version was
upgraded and now it no longer works. Here's the query:
SELECT *, SUM(quantity)*100/ AS percentage FROM CartTable WHERE company
='1' AND submitted='1' AND dateinserted='946702800' AND
dateinserted='1085247047' AND
I'm having trouble getting this line to work. I have tried:
kill `cat /usr/local/mysql/bin/mysql/data/localhost.pid`
- Not a directory
kill `cat /usr/local/mysql/data/localhost.pid`
- Permission denied
I'm not sure if I have the wrong hostname, or if the command is more flawed
than that.
I'm surprised it ever worked, if it was exactly as you gave us. You have
SUM(quantity)*100/ AS percentage
It looks like you intended to divide SUM(quantity)*100 by something, but
there's nothing there to divide by.
Michael
Aaron Wolski wrote:
Hi all,
Have a query that used to work on one
John Mistler wrote:
I'm having trouble getting this line to work. I have tried:
kill `cat /usr/local/mysql/bin/mysql/data/localhost.pid`
- Not a directory
kill `cat /usr/local/mysql/data/localhost.pid`
- Permission denied
I'm not sure if I have the wrong hostname, or if the command is more flawed
Aha, this revealed the .pid:
/usr/local/mysql-standard-4.0.18-apple-darwin6.8-powerpc/data/John-Mistlers-
Computer.local.pid
Now, this brings up a new question. Is there a sudo find command I can
use to locate the proper .pid on any given computer? I am hard coding this
into an application
At 09:55 AM 5/22/2004, you wrote:
Have you tried dbmonster?
http://dbmonster.kernelpanic.pl/index.html
It generates random data for you.
-Messaggio originale-
Da: Greg Willits [mailto:[EMAIL PROTECTED]
Inviato: venerdi 21 maggio 2004 21.17
Cc: MySql
Oggetto: Large sample data sets for
Paul West [EMAIL PROTECTED] wrote:
Here are some easy questions I hope you can answer.
I have been creating innoDB tables in mysql, creating contraints and foreign keys
and it
runs swimmingly.
The server I am now doing mySQL on won't allow me to create other than myISAM tables.
Is it
John Mistler wrote:
Aha, this revealed the .pid:
/usr/local/mysql-standard-4.0.18-apple-darwin6.8-powerpc/data/John-Mistlers-
Computer.local.pid
Now, this brings up a new question. Is there a sudo find command I can
use to locate the proper .pid on any given computer? I am hard coding this
into
How's that for alliteration in a subject line?
Got a simple table that contains records which are made up of only three
fields - ID, quote and author. These are inspirational quotes that I want
to appear at the bottom of the pages of my website. I want them to come up
randomly with every page
Robb Kerr wrote:
Got a simple table that contains records which are made up of only three
fields - ID, quote and author. These are inspirational quotes that I want
to appear at the bottom of the pages of my website. I want them to come up
randomly with every page load. How do I randomly access
At 04:42 PM 5/21/2004, you wrote:
Forenote: I have no wish to start an OS debate.
Hello,
Once I wiped this and tried Linux (both gentoo, with their
patched-to-the-hilt 2.6.5 kernel, and Debian, with a stock 2.6.6 which
had just been released by the time I installed) this figure jumped to
35,000
mos wrote:
At 04:42 PM 5/21/2004, you wrote:
Forenote: I have no wish to start an OS debate.
Hello,
Once I wiped this and tried Linux (both gentoo, with their
patched-to-the-hilt 2.6.5 kernel, and Debian, with a stock 2.6.6 which
had just been released by the time I installed) this figure jumped
mos wrote:
At 05:08 PM 5/22/2004, you wrote:
Robb Kerr wrote:
Got a simple table that contains records which are made up of only three
fields - ID, quote and author. These are inspirational quotes that
I want
to appear at the bottom of the pages of my website. I want them to
come up
randomly
24 matches
Mail list logo