unsubbed the list.
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
, then I'll use the value
of sub2other to do what I want to do, and vice versa).
But this just doesn't seem possible. I can always do it with two
separate queries if need be, but it would be elegant to do it with one.
Any advice?
Thanks very much,
Erik
Erik Price
Web Developer Temp
Media Lab
one hyphen before user? Try using two:
[root]# safe_mysqld --user=root
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php
it.
Erik
On Friday, June 14, 2002, at 04:05 PM, Luc Foisy wrote:
How bout
SELECT main.id, sub1.other, sub2.other FROM main LEFT JOIN sub1 ON
main.sub1fk = sub1.id LEFT JOIN sub2 ON main.sub2fk = sub2.id
Luc
mysql,sql
-Original Message-
From: Erik Price [mailto:[EMAIL PROTECTED
the CREATE TABLE statements.
Erik
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
AND projects.canceler_id = people.people_id, or
projects.finisher_id = people.people_id, depending on whether the
project was finished or canceled. But I also need to be able to
determine from the query whether the project was finished or canceled.
Thanks!
Erik
Erik Price
Web Developer Temp
Media Lab, H.H
/libSystem.B.dylib
I'm running 10.1.3, with the Dec2001 Developer Tools installed. Perhaps
it was provided by those, do you have them installed?
Erik
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED
questions please don't hesitate to ask.
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
.
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
that their problem was heard.
Erik
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
? If
so, use that.
It would look something like:
/usr/local/mysql/bin/safe_mysqld --socket=/path/to/socket
Good luck
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before posting, please check
save the extra
processing cycles by doing it in the database?
Erik
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
of null values in my table. What
do you think?
Thanks for reading! Thanks even more if you can help me.
Erik
On Thursday, April 18, 2002, at 03:52 PM, Erik Price wrote:
Hello,
I was hoping to solicit some advice on the structure of the database I
am building. Here
SELECT MAX() on that column.
Erik
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
if this is really a good idea --
when I need to query for all records in printedfiles and categorize
them, will I be able to use this source column? Or is there a better
way I could be going about all of this...
Thanks for any insight you can provide.
Erik
Erik Price
Web Developer Temp
or UPDATE
statements -- nothing this big yet. Is it normal to have a script that
does all of this in different steps? Could I make better use of MySQL's
resources?
Thanks for your advice on these questions.
Erik
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED
on their point. But I did not have a second look, so I am
not sure if I am mis-remembering.
Yes, there was a lot of back-and-forthing.
Thanks,
Erik
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
Hello, everyone.
I have a slight dilemma, and was wondering what the standard workaround
is. I have three tables: owners (auto_increment primary key is
owners_id), objects (auto_increment primary key is objects_id), and
owners_objects (which is a foreign key table that I created, under
I know about both options!
Much appreciated,
Erik
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
There is a utility called daemonic which is designed to deal with this
as well, but works for more than just MySQL -- it's intended to be used
for all server daemons.
http://daemonic.sourceforge.net/
It is Mac OS X-specific at this time, but according to the web site is
designed for future
Hello, everyone --
I have received a great deal of help from many members of this list, so
I'd like to acknowledge that now. Someday, when I have my head wrapped
around this stuff, I hope to return the favor. In the meantime,
however, I have come across my worst brainbuster yet. Any help on
!
Erik
-Original Message-
From: Erik Price [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 11:14 AM
To: [EMAIL PROTECTED]
Cc: Etienne Marcotte
Subject: INSERTing into joined tables?
Hello, everyone --
I have received a great deal of help from many members
Well, you could use a shell script to run mysqladmin status.
I.e. this bash script:
#! /bin/bash
# mystatus.sh is really just a simple alias for a
# longer command.
# Usage: 'mystatus.sh PASSWORD'
# replace values of $my_hostname and $my_username if needed
my_hostname='localhost'
A quick question --
If I have a table with an ENUM column, and the possible values are (0,
1, 2, 3), does the number qualify as an integer or a string?
I am working in PHP4 and intend to compare this value as such:
// dbaccess.access_level is ENUM(0, 1, 2, 3) column
// $user_id has been
is done, I can't test... conundrum?
Erik
On Friday, January 4, 2002, at 03:07 PM, Rick Emery wrote:
What happened when you experimented? What were your results?
-Original Message-
From: Erik Price [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 04, 2002 2:03 PM
To: [EMAIL
I'm trying to use mysqlshow to display the tables of a database on a
remote host. I enter the command:
localhost:/usr/local/mysql$ ./bin/mysqlshow -h 555.55.5.5 -p samp_db
Enter password:
Wildcard: samp_db
+-+
| Databases |
+-+
| samp_db |
+-+
Hello,
I'm having some trouble constructing my first INSERT statement into
multiple tables. I'm using PHP4. I have written the following INSERT
statement with no problems:
$sql = INSERT INTO main (name, ext, stor_pre, stor_base, width, height,
file_size, proj_id, date_cre, cre_by,
On Saturday, December 8, 2001, at 12:53 PM, Arjen G. Lentz wrote:
Re-order the list of tables in the FROM, and put the
subprojectweb.subproject_name = 'shoeshine.com' bit first
after the WHERE, that will also make it clearer for you to read.
Is this just for my own personal clarity? I
On Thursday, December 6, 2001, at 02:15 PM, Curtis Gordon wrote:
Hi, I have just setup a dedicated linux/php/mysql dev box in my office
and I am gearing up to move my databases from a windows box to the
linux box. There are a couple of things I would like to be clear on
before I start.
I haven't populated this database yet. There are actually many more
columns, this was kind of a rough draft -- I only featured the ones that
I needed to see if my JOINs were okay. I just got a little nervous when
I drafted a few sample queries and saw that much text !!
That makes me feel
On Wednesday, December 5, 2001, at 12:24 AM, René Fournier wrote:
I have to create a MySQL for my PHP scripts. How do I do this in Mac
OSX? There are a bunch of command line tools, but I'm not sure which
one[s] to use.
Well, if you already have MySQL installed, then just use them as
Oh, okay, you want to know how to use NetInfo.
Do man niutil and read the man pages on niutil. Also very useful, in
the following link is a brief description of how to use NetInfo Manager
to do the same thing if you prefer GUI:
http://developer.apple.com/internet/macosx/osdb.html
It tells
|
+--++-+
5 rows in set (0.00 sec)
I hope it's what you wanted
Etienne
btw, if you find any mailing list ont he web for general relational DB
design issues, let me know. I searched and could not find any:(
Erik Price wrote:
Hello,
I was looking for some advice on building my
On Tuesday, December 4, 2001, at 01:23 PM, Etienne Marcotte wrote:
CREATE TABLE filetypes (
fileID smallint unsigned not null,
typeID smallint unsigned not null,
unique index (fileID,typeID),
unique index (typeID,fileID)
)
One question, though. Do I have to construct indexes in both
I'm not sure, but you'd be in big trouble if your system lost power!
-- Erik
On Monday, December 3, 2001, at 10:50 AM, Banach, Timothy P wrote:
Hello,
Can mySQL be configured to run entirely in-memory? That is, can one
configure it so that all the tables, data, etc. remain resident in
Also, although the standard groupadd command doesn't work for adding
groups, you can use NetInfo Manager to add a group. This gives you a
GUI interface to managing your groups and users. If you don't like GUI,
use the command line tool niutil, which has its own man page.
You would probably
Hello,
I'm designing a database, and of course I have no formal training in
this area (I'm learning from DuBois's book). It's designed to keep
track of files. In my organization, we have a small design studio, and
the designers save their image files to CD-ROMs. As you can imagine,
the
Jens,
That is great news! You've made my day -- that means that the rest of
my tables should work with JOIN queries, as I am building them along the
same model -- using ID numbers instead of actual names to connect to the
main files table. Thanks for clearing that up for me.
And also for
On Wednesday, November 28, 2001, at 02:44 PM, john wrote:
pages every day. Things on the list are no way near how easy they can
be. I
cannot fathom why this is not a newsgroup, and why every person/eu has
to be
flooded with so much email that has nothing to do with them or their
John,
I know what you mean, to some extent. I bought a recently-published
book that served as an introduction to MySQL and PHP. I thought it
would be perfect -- it seemed to be engagingly written, and specifically
dealt with what I wanted to learn about. The only problem was that the
Hello,
[The contents of this email contain quite an annoying amount of output
from the command line, but please note that I have deleted most of the
unnecessary output and tried to comment the parts that I felt were
necessary.]
I am curious as to what the difference will be if I choose to
Hello all,
Can anyone tell me the official name of the MySQL 3.23.45 source code
file that is downloaded from the web site (www.mysql.com)?
I normally grab it with curl off of my local mirror but they didn't have
it yet so I used Internet Explorer to grab the file from another
(random)
://mysql.valueclick.com/pub/mysql/Downloads/MySQL-3.23/mysql-3.23.45.tar.
gz
I always find this FTP site with the most up-to-date files and is very
reliable!
:)
On Mon, 26 Nov 2001 10:17:22 -0500, Erik Price [EMAIL PROTECTED]
wrote:
Can anyone tell me the official name of the MySQL 3.23.45 source
On Monday, November 26, 2001, at 11:34 AM, Michael Collins wrote:
No, it is not found on Downloads for the 3.23 version at:
http://www.mysql.com/downloads/mysql-3.23.html
Look for:
MacOS X downloads
Binary packages (tar.gz)
MySQL 3.23.45 MacOS X Server 1.x (PowerPC) (4.7M)
MySQL
I have a rhetorical question.
I'm learning as much as I can about MySQL. There is one little detail
that I don't *have* to know the answer to, but I'm curious about. Don't
waste your time replying if you're busy.
It appears that the display width is an option for certain types of
numeric
support in php?
From what I've read, it's probably more trouble than it's worth on
OSX...
-ravi.
-Original Message-
From: Erik Price [mailto:[EMAIL PROTECTED]]
Sent: November 23, 2001 10:10 AM
To: [EMAIL PROTECTED]
Subject: does lmysqlclient.so exist in 3.23.44 ?
Well, I
Well, I asked a lengthy question earlier with all kinds of extraneous
information pertaining to my problem. Allow me to re-ask in a more
simple fashion --
does a file called 'lmysqlclient.so' exist in MySQL 3.23.44 ? I built
this distribution from source and cannot find it anywhere. I need it
the 'make'. And I
assume that this happened because the 'make' process could not find the
lmysqlclient.so . Am I very far off the mark in this guess?
Thanks to any who can help with this quandary!
Sincerely,
Erik Price
--- Ravi Raman [EMAIL PROTECTED] wrote:
You're right.
./configure --help
' , but I
wanted to make sure.
Thank you,
Erik Price
PS: Just to re-clarify about my system, it is:
Darwin 1.4.1 running beneath Mac OS X 10.1.1
Apache 1.3.22 with DSO capability enabled
MySQL 3.23.44 (source install) installed in /usr/local/mysql
=
Microsoft e[X]tra [P]roprietary
It looks like this site is designed to fool a newcomer into thinking
that they've stumbled onto the MySQL site -- there is a tiny mention on
the splash page that 'if you are looking for MySQL AB, click here'. I'm
sorry, but when I was first looking into MySQL, I had no idea what
'MySQL AB' was.
Bill,
Actually, there *is* a digest -- send mail to
[EMAIL PROTECTED]
the information about this and all other listserver commands is in the
welcome message that you should have received as your first
mysql@lists email. I have been using the digest.
BUT... All of Bernie's comments are right
Todd,
The arrow is like the PS2 prompt from your shell in Unix. That is,
the first line of your command says
Mysql
and every line thereafter is just a greater-than. This is because
the mysql client is waiting for more commands. You can enter more than
one command at a time this way, and not
] wrote:
Erik Price writes:
Hello all,
Some of you may recognize this post somewhat, I've asked about this
problem before:
I am unable to execute the shutdown command with mysqladmin,
running
on Darwin 1.4.1 (from Mac OS X 10.1.0).
Hi!
Our colleague Sasha Pachev has made some
that my database probably won't become
corrupted every single time from a kill -9 command, but it is likely
to happen at some point as I will be doing this daily.
Does anyone think that this is a viable solution to my problem? Thanks
very much for any input or thoughts!
-- Erik Price
PS: To all
--- Dan Nelson [EMAIL PROTECTED] wrote:
As long as there are no active connections, killing mysql will not
affect the database. If you kill mysql during an update, you risk
corrupting any indexes on the tables being modified. If your tables
are BDB or InnoDB format, you should be able to
Has anyone successfully set up MySQL on Mac OS X 10.0.4 yet? If so,
what distribution did you use? What special steps (if any) did you
have to take? Every tutorial on this topic that I've found on the
web so far, is either outdated or has simply has not worked for me.
That's because
When I was just starting to consider my database-driven web site, I
checked mysql.com and found this:
http://www.mysql.com/portal/books/html/index.html
The best-rated book is the one I chose to get:
MySQL
by Paul DuBois
New Riders
I think it's awesome.
(Although neither it nor the web site
--- Bill Adams [EMAIL PROTECTED] wrote:
One option is to use
/usr/local/mysql/bin:mysql$ mysqladmin -u root -p shutdown
But this one doesn't work for me, even though I am using the proper
password and am the proper user. Executing this command just
leaves me
hanging at the prompt
--- Bill Adams [EMAIL PROTECTED] wrote:
This seems like an OS bug to me. All of the things you mention in
your last
email should stop mysql from running.
What happens if you do (where safe_mysqld is running) 'fg' and
then CTRL+c? Does that just hang too?
Do you need the debugging for
--- Mike(mickalo)Blezien [EMAIL PROTECTED] wrote:
Have you tried ./mysqladmin -u root -p shutdown
when in the 'bin' folder otherwise typing mysqladmin, it will check
the server
PATH, to find the mysqladmin
Mike(mickalo)Blezien
Hmm... isn't this the same thing as
--- Sergei Golubchik [EMAIL PROTECTED] wrote:
What OS do you use ?
The behaviour you're describing I've seen two-three years ago on
FreeBSD
due to some bug/deficiency in FreeBSD threads.
Since then it was fixed (in FreeBSD I mean).
Regards,
Sergei
Interesting! I'm using Darwin
Dan,
Thanks for that comprehensive answer. It doesn't seem like the FreeBSD
solution will be one that I will try to implement into my installation
of Darwin, as it draws on skills and knowledge that I definitely don't
have -- though it would be educational to take a look into Darwin's
threading
All,
Well, I solved the mystery of the missing Unix socket. It needs to be
defined at the time the daemon is started with:
--socket=/path/to/socket. Well, at least in my installation it does.
But now I'm having the OPPOSITE problem -- shutting down the server
(the daemon). I've searched
I had this same error message yesterday when I first set up MySQL.
Two possible reasons:
1) Is mysqld running? I used
bash2.05$ ps aux | grep mysqld
to see if there is a process called mysqld.
2) In my installation (which I compiled from source, with the Unix
socket path option in
Hello,
Despite hours plumbing the MySQL documentation and Paul DuBois' book
MySQL (New Riders), I can't figure out what exactly creates the Unix
socket for local connections. For some reason no socket was created
during my setup, and I'm not sure how to go about making one.
I compiled 3.23.44
?
-- Erik
PS: the documentation at mysql.com is incredible.
--- Bill Adams [EMAIL PROTECTED] wrote:
Erik Price wrote:
for
some reason I assumed that the socket would be created dynamically
when
I started the mysql daemon.
It does.
Try chown mysql:mysql /usr/local/mysql/run
68 matches
Mail list logo
