So I can do something like SELECT * FROM . $tablename . WHERE _rowid=
$id (I'm using PHP and the primary key is a unique integer column in each of
the tables).
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Primary keys
Date: Wed, 24 Mar 2004 13:28:58 +0200
JOHN MEYER
Is there a way to do a SQL Select and get a record without specifying the
primary key. Example. I have two tables CANDLE and VOTIVES. Can I define
a select that says SELECT * FROM TABLE WHERE PRIMARY_KEY=...
John Meyer
_
FREE
Brian,
You can go either way (PHP, Perl, or JSP) for querying the database. My
personal preference is PHP. What is a lot more important, however, is to do
some serious database analysis and design. From a guy who's working with a
database wtih only one field for address where there need to be
AFAIK, MySQL doesn't have any sort of referential integrity checks with
fields. conceptually, you can do it, and write your program to force it,
but the database itself doesn't have it.
John Meyer
P.S. shouldn't it be table1.fieldA
-Original Message-
From: R. Hannes Niedner
-Original Message-
From: [EMAIL PROTECTED] [mailto:mysql;lists.mysql.com]
Sent: Sunday, November 10, 2002 6:53 PM
To: John Meyer
Subject: Re: 4.0 as a production relese?
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass
I'd suggest that he's just trolling.
-Original Message-
From: R. Hannes Niedner [mailto:hannes.niedner;gmx.net]
Sent: Saturday, November 09, 2002 9:27 PM
To: MySQL Mailinglist
Subject: Re: PHP bias
On 11/10/02 5:12 AM, Robert Macwange [EMAIL PROTECTED] wrote:
I am bothers me.
It
You could use an integer (0 or 1) or an enum with the values 'y' or 'n'
-Original Message-
From: Tony Roberts [mailto:troberts;momuk.com]
Sent: Friday, November 08, 2002 4:26 AM
To: [EMAIL PROTECTED]
Subject: True/False
I am new to MySQL and I am attempting a new project to help me
sql,query
How do I do that? The contaxt is that I want to get somebody's age based
upon the current date.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
: Thursday, November 07, 2002 1:58 PM
To: John Meyer
Cc: [EMAIL PROTECTED]
Subject: Re: getting the number of years between two dates
John Meyer wrote:
sql,query
How do I do that? The contaxt is that I want to get somebody's age based
upon the current date.
There are several examples in the mailing
in php
?php
$result = mysql_query($sql);
$row = mysql_fetch_array($result,$sql);
?
input type=textbox name=email value?=$row[email]?
-Original Message-
From: John Coder [mailto:jcoder;insightbb.com]
Sent: Tuesday, November 05, 2002 7:04 PM
To: Ben C.
Cc: [EMAIL PROTECTED]
Subject: Re:
oops,
I meant mysql_fetch_array($result,MYSQL_ASSOC);
-Original Message-
From: John Meyer [mailto:johnmeyer_1978;yahoo.com]
Sent: Tuesday, November 05, 2002 7:10 PM
To: John Coder; Ben C.
Cc: [EMAIL PROTECTED]
Subject: RE: Using Query Results in a Form
in php
?php
$result = mysql_query
How do I create users for a specific database using SQL?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
Hi, I've got a client that I'm trying to convince to store the file path in
the database rather than the file itself into the database. Is there any
statistical data to show how much of a hit you take doing it as a BLOB vs. a
filepath?
sql,query
Try again.
-Original Message-
From: [EMAIL PROTECTED] [mailto:mysql;lists.mysql.com]
Sent: Sunday, October 27, 2002 9:17 PM
To: John Meyer
Subject: Re: RE: plz help...tables getting corrupted...
Your message cannot be posted because it appears to be either spam or
simply off topic
Can I have different instances of winmysqladmin start instanciating
different mysql's? i want to run one for the stable version, and one for
mysql 4.0
-
Before posting, please check:
http://www.mysql.com/manual.php (the
database,sql,query,table
Haven't been able to solve the File DSN problem yet (running into the
same
thing as you), but I'm able to connect using a system dsn. is there any
reason why you need a file based one?0.
-
Before
At 06:41 PM 12/19/2001 +0100, Sven Hammann wrote:
Hello,
I'm new in the world of MySQL and have a question:
What Software can I use to programm MySQL clients for HTML(XML) or Java
? Is there a
Software which is easy to use ?
I usually use PHP solutions for HTML. Java, you can use the JDBC
At 11:45 AM 12/12/2001 -0500, Christopher Schreiber wrote:
Actually I setup a vBulletin forum for MySQL over at www.mysqlforums.com
and I am the moderator of the MySQL and Server Configuration forums over
at www.vbulletin.com/forum/
Would it be too much to suggest that mysql.com host its own
LAST_INSERT_ID()
At 08:48 AM 10/18/2001 +0100, you wrote:
Hi,
I've just started with MySQL. I want my table to have a column
containing
an ID which is an integer that gets incremented on each insert, just like
Autonumber in Microsoft Access. How do I do this in MySQL ?
Thanks
Dave
If I'm using MySQL for an intranet site within my corporation, is there any
licensing required?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
In Oracle, I remember working with roles that I could assign to a user. Is
there such a mechanism, or are there plans to implement such a mechanism,
in MySQL.
-
Before posting, please check:
At 09:57 AM 8/28/01 -0700, you wrote:
In Oracle, I remember working with roles that I could assign to a user.
Is
there such a mechanism, or are there plans to implement such a mechanism,
in MySQL.
This sounds a lot link granting a user certain privileges. Here's the part
of the
At 12:54 PM 8/27/01 -0700, you wrote:
Hello -
I'm very new at this, so please pardon the very beginner questions...
I'm attemtping to install MySQL to my local machine running Win98. The
install seems to go alright, but when I try mysqld--standalone it
gives me an error. Then I tried mysqld
At 09:15 AM 8/28/01 +1200, you wrote:
Hi there,
I treat image data type as text, does anyone know how to insert an image
into the table?
the image data type is actually a BLOB, not text. Usually, it's more
efficent to have the field be text, and just store the path to the image
At 10:48 AM 8/22/01 -0400, you wrote:
For example if my table has the fieldfirstname, lastname, telephone,
movie1, movie2, movie3..
You haven't done a good job of database normalization. Those movies should
be broken out to their own table.
Onto what you were talking about, I know
Here's the error message that I am getting:
[911] [2] [0] [Microsoft][ODBC Driver Manager] Invalid string or buffer
length
And here is the code
my $sqlcommand = INSERT INTO
EMAILS(PERSONALITY_ID,EMAIL_HEADER,EMAIL_EMAIL,EMAIL_FROM,EMAIL_SUBJECT)
VALUES( . $personalid . ,\ . $headerlines
At 11:02 PM 8/12/01 -0300, you wrote:
I read that MySQL doesn't support the referential integrity, so i wan to
know if you recommend to use it in systems with complex relationated
tables in a database.
If yes, where can i find helpfull documentation about that.
thanks
PD: sorry about my grammar
database, and run from there. Then,
click on Data-Export Database, and export the data that you just uploaded
to your mysql server.
John Meyer
[EMAIL PROTECTED]
Programmer
If we didn't have Microsoft, we'd have to blame ourselves for all of our
programs crashing
At 12:30 PM 7/20/01 -0400, you wrote:
on 7/20/01 12:32 PM, Erich Kolb at [EMAIL PROTECTED] wrote:
When you query a MySQL Database, how do you set the order alphabetically?
If it's a text field just say DESC
Susan
isn't that reverse alphabetical
ASC is (default) alphabetical
John Meyer
a unique ID, couldn't you do it this way:
SELECT * FROM TABLE WHERE ID=!LAST_INSERT_ID();
John Meyer
[EMAIL PROTECTED]
Programmer
If we didn't have Microsoft, we'd have to blame ourselves for all of our
programs crashing
in
functions to access MySQL.
John Meyer
[EMAIL PROTECTED]
Programmer
If we didn't have Microsoft, we'd have to blame ourselves for all of our
programs crashing
-
Before posting, please check:
http://www.mysql.com
At 02:13 PM 7/15/01 +0300, Sinisa Milivojevic wrote:
Multi-table updates should come in 4.0, while sub-selects will come in
4.1.
Not to be a nag, but when will 4.x be here?
John Meyer
[EMAIL PROTECTED]
Programmer
If we didn't have Microsoft, we'd have to blame ourselves for all of our
= false;
}
delete CheckAuthor;
return retVal;
}
This way, it retrieves the recordcount exactly, but if I use
CheckAuthor-RecordCount
instead of:
CheckAuthor-FieldByName(AUTHORCOUNT).AsInteger
I get a nonsense answer.
John Meyer
[EMAIL PROTECTED]
Programmer
If we didn't
been using DBTools and it
works for me.
John Meyer
[EMAIL PROTECTED]
Programmer
If we didn't have Microsoft, we'd have to blame ourselves for all of our
programs crashing
-
Before posting, please check:
http
.
John Meyer
[EMAIL PROTECTED]
Programmer
If we didn't have Microsoft, we'd have to blame ourselves for all of our
programs crashing
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
completely around how I am going to do this, so I
am looking for suggestions on how other sites manage this need.
Why not just split on the newlines? You could conceivably, say that you
will limit yourself to 5 newlines (paragraphs) per page. T
John Meyer
[EMAIL PROTECTED]
Programmer
If we
://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
John Meyer
[EMAIL PROTECTED
or external command, operable program or batch file.'
I think the commands for windows are not the same as in linux. any ideas?
C:\mysql\bin\mysqladmin.exe create test
--
John Meyer
[EMAIL PROTECTED]
Programmer
Those who sacrifice liberty for security deserve neither -- Ben Franklin
On Friday 22 June 2001 09:22, [EMAIL PROTECTED] wrote:
MySQL has is used by alot of major players and there are pre made setup for
building database driven websites like PHP-Nuke. Unsure on the strings
I use Win2K and Mysql PHP and PHP Nuke with Apache for my site and it's
working great! My
It only corrupted your database twice?
On Friday 22 June 2001 09:50, Patrick Calkins wrote:
MySQL can handle infinately more concurent connections to it, and handle a
much bigger load than MDB can even dream of doing. A few years back I used
to write database apps in visual basic and MDB. It
On Thu, 21 Jun 2001, you wrote:
I currently have MySQL-3.23.38-1.i386.rpm installed and I want to upgrade to
the new version 3.23.39 what steps or precautions should I take when doing
this.
Do I just download the new RPM and run a rpm -i MySQL-3.23.39-1.i386.rpm
and thats it or is there more
On Thu, 21 Jun 2001, Laura La Marcello wrote:
I need to know if there is a way to create a searchable database that
returns results as a web page...
As you can see, I'm just begining, so I would really apreciate an answer,
even if it's short.
Thanks!
Yes, but the web page will more than
is an MDB, even with the proper file
sharing.
John Meyer
[EMAIL PROTECTED]
Programmer
If we didn't have Microsoft, we'd have to blame ourselves for all of our
programs crashing
-
Before posting, please check:
http
this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
John Meyer
[EMAIL PROTECTED]
Programmer
If we didn't have Microsoft, we'd have to blame ourselves for all of our
programs crashing
is availible from the site in PDF format.
John Meyer
[EMAIL PROTECTED]
Programmer
If we didn't have Microsoft, we'd have to blame ourselves for all of our
programs crashing
-
Before posting, please check:
http://www.mysql.com
At 09:54 PM 6/10/2001 -0400, Jeffrey L. Fitzgerald wrote:
Howdy Hi,
Any word on how to select distinct database records using PHP code?? Thanks in
advance...
mysql_query(SELECT DISTINCT * FROM BLAH;);
-
Before posting,
101 - 146 of 146 matches
Mail list logo