or the pointers, Galen.
Erik
PS: to any who respond to this thread, please CC me as I have
temporarily unsubbed the list.
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before pos
tch. Just chop off the contents if you
only want the CREATE TABLE statements.
Erik
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysq
t way to
do 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
>
>> -Orig
mysqld ended
Are you really only using 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 post
"sub1other" column is NULL in one record, 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?
T
project_id = 8 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 Develo
e best way to sort your data. Most likely you'd
do a similar thing as above in PHP, so why not just save the extra
processing cycles by doing it in the database?
Erik
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
fic socket location at compile time? 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]
--
e person, though you're correct -- this does not reassure
them that their problem was heard.
Erik
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before posting, please check:
http
unless
you're using it for an all-Mac OS X network, in which case NetInfo is
admittedly powerful.
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.co
ED]>
>> To unsubscribe, e-mail
>> <[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>
>
> -
> Before posting, please check:
>http://www.mys
used it on 10.1.3, but there is
hardly any difference between 10.1.3 and 10.1.4 for these purposes.)
I recommend you just use a binary.
Erik
PS: if you have any other questions please don't hesitate to ask.
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
to
/usr/lib/libSystem.dylib, which is a link to /usr/lib/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
ill
end up with a result for each row in that table, unless you use a WHERE
clause.
Erik
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.m
hy this function is better than doing 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 ma
uot; file_id or a "user"
file_id. It doesn't seem very smart to have a setup like this.
So I think I should go with the big "files" table and just have some
columns that apply to some kinds of files and not to others. Is this
done? I'm just hesitant to have a l
edfiles" 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
Media Lab, H.H. Brown
[EMAIL PROTECTED]
---
ed
"prefix" and the new bumped-up "base" value, telling user what to label
the CD (i.e., "45:109").
This seems like a lot of steps, and almost a kludge to me. But then,
this is the first web application I have written ever, and up until now
all of the database
they were talking, but kept
> insisting 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 Develop
ing.
Thanks,
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/ (the list archive)
To
d compatible with a
version of PHP that -might- pay attention.
Hope all is well with you,
Erik
Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.co
ySQL processes data.
But now 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.
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
a
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
Here's a solution:
Send mail to <[EMAIL PROTECTED]>
Doing this will generate an auto-reply. When you get it, hit "reply"
and "send"
in your mail client.
That way you won't get any more spam.
Erik
On Thursday, January 10, 2002, at 12:15 PM, Patrick Crowley wrote:
> I have to say I'm shock
he way that "mysqlshow" outputs the data. In reality,
each column is a UNIQUE index (-not- a PRIMARY KEY). For some reason,
that's what mysqlshow gives instead of UNIQUE.
Thanks for the input, though!
Erik
>
> -Original Message-
> From: Erik Price [mailto:[EMA
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
But until
the PHP 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: Frida
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
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'
my_usernam
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, division
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 |
+-+
localhost
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 persona
I haven't used it but a lot of people recommend PHPMyAdmin. Especially
if your MySQL server is hosted by a company that doesn't give access to
a shell account.
Erik
On Thursday, December 6, 2001, at 08:07 PM, René Fournier wrote:
> Does anyone know if such a thing exists? (Especially a fr
On Thursday, December 6, 2001, at 08:35 PM, Arjen G. Lentz wrote:
> There is also the one part that limits your selection (shoeshine.com).
> So that
> is very important. I've quoted the table structure of the subprojectweb
> table
> above, and the 'subproject_name' field is not indexed. There
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 muc
Or am I doing
something weird, am I "not getting" this relational database concept?
I hope I haven't gone about this all wrong!
Thank you so much to any who can give me some advice, or confirm that
I'm doing okay.
Sincerely,
Erik Price
---
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
In 3.23 or later: Just specify an ID of 1000 when you insert your first
record. If every record thereafter is INSERTed with ID = NULL (or just
not specified), then AUTO_INCREMENT will automatically bump up each ID
field by one after the first one. If you are loading data from
mysqlimport or
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
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
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 bot
gt; | bar | jpeg image | jpg |
> | bar | jpeg image | jpeg|
> +--++-+
> 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
>
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 residen
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
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 sta
It has a command prompt, and is virtually identical to Linux or any
POSIX-compliant Unix system (from a user's point of view), but the big
difference (from a user's point of view) is that instead of using text
files such as /etc/passwd (and numerous other configuration files), this
information
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 probab
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
editi
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
> q
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 ins
Some defense for the Mac,
I have been learning MySQL from my tiny little G3 PowerBook. And doing
development on it seems to be a logically sound idea, as I'll be
migrating the data to a HP/UX server when the project is ready to go
"public".
I like Mac OS X because I finally have a fully-supp
On Monday, November 26, 2001, at 02:38 PM, Ben Ocean wrote:
> But I have a backup, if I just knew how to restore it! The instructions
> read:
> #mysqldump --opt database_name > database_name_File.txt
> To restore database:
> #cat database_name_File.txt | /path/to/mysql -u username -p
> databa
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 co
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)
ickalo)Blezien wrote:
> Try here:
> ftp://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 <
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) mirr
--- Michael Collins <[EMAIL PROTECTED]> wrote:
> 1) Will there be a binary for MySQL 3.23.45 for MacOS X 10.0.x
> (Darwin 1.3.x)?
Isn't there one there? On the "Downloads" section of the site? I just
wish my local mirror was updated to include it
> 2) How do I find out what options are c
ere you compiling php against the mysql source rather than using
> the
> built-in mysql 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
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
hp4.so did not get built during 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
hat it is '--with-mysql=/usr/local/mysql' , 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
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. I
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
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 righ
--- 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
amchk first, every time I wish to re-load ("refresh") the
information? I understand 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 thi
stable a release as is available.
--- Sinisa Milivojevic <[EMAIL PROTECTED]> 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 exec
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).
Originally, I had compiled MySQL 3.23.44 from source code, specifying
the following optio
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
--- 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 D
--- "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 /usr/local/
--- 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 debug
--- 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
> > hangi
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 do
> 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 becau
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 configur
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 the
ket option?
-- 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.
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
80 matches
Mail list logo
