oopsthat's my Apache version. I am using MySQL 4.0.1 and have used
md5() with MySQL 3.23.49-max-nt
- Original Message -
From: "MikeParton" <[EMAIL PROTECTED]>
To: "Ki Mien" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, Ju
I have MySQL 2.0.39 on Win NT and I use md5() to create a digest of the
password. Perhaps not the highest level of password encryption, but works
for the level of security I need.
- Original Message -
From: "Ki Mien" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 06, 2
Outline what you want to join and your table structures and perhaps someone
can give you an example or two.
- Original Message -
From: "Dillon, John" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 05, 2002 11:49 AM
Subject: JOIN specific fields from two tables
> Can I/h
You need to determine if your MySQL is reading it's directives from my.ini
or my.cnf. In the correct one, make sure you have commented out or removed
any line that reads "skip-innodb". then make sure you have directories set
up for the innodb files and that you've edited the paths to point to th
t
the need to support open source dbs.
Mike
mysql,sql,query
- Original Message -
From: "Bill Bernat" <[EMAIL PROTECTED]>
To: "MikeParton" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, July 01, 2002 6:46 PM
Subject: RE: er diagramming
Yea
http://www.datanamic.com/
DeZign for Databases...
- Original Message -
From: "Bill Bernat" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 01, 2002 3:25 PM
Subject: er diagramming
ERwin, in which I did the logical data model for a MySQL database,
doesn't support MySQL d
Somewhere within www.mysql.com is a link to a site that has an ERD tool that
supports MySQL...think the name is Dezigner or EasyDezign or something like
that. Search through the MySQL site and you'll find it. Free trial version
(limited entities) and the full tool isn't very expensive.
- O
L database than in a data
database.
- Original Message -
From: "Ed Carp" <[EMAIL PROTECTED]>
To: "MikeParton" <[EMAIL PROTECTED]>; "Peter Lovatt"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, Ju
what did I miss?
Mike
- Original Message -
From: "Ed Carp" <[EMAIL PROTECTED]>
To: "MikeParton" <[EMAIL PROTECTED]>; "Peter Lovatt"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002
ittle philosophical exchange...good to break the monotony of real life
from time to time.
Cheers to all and hope ya find the answers you seek.
Mike
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "MikeParton" <[EMAIL PROTECTED]>
Cc:
On the other hand, proclaimed "native" XML databases (eg, Software AG's
Tamino, Ixiasoft's TEXTML) store the "XML-wrapped" data in the database...no
need to wrap and unwrap the metadata, document/data structure from the data.
- Original Message -
From: "Ed Carp" <[EMAIL PROTECTED]>
To: "
Does the user (or do the users) you are trying to connect as from the Win98
machine(s) have the proper access set up in MySQL?
- Original Message -
From: "Efren Pedroza" <[EMAIL PROTECTED]>
To: "MikeParton" <[EMAIL PROTECTED]>; "MySQL List1"
You might want to take a look at using dbtools 1.1.13 from
www.dbtools.com.br
mysql, query, sql
- Original Message -
From: "savaidis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 16, 2002 5:38 PM
Subject: about MySQL CC
> I have install MySQL CC (control center) after
Get a different client to load on the other machine.
Some options: MyCC (www.mysql.com) (this is currently version 0.8.4 and is
an alpha
dbTools 1.1.13 (www.dbtools.com.br) this is pretty
slick
- Original Message -
From: "JamesWang Home" <[EMAIL PROTECTED]>
To:
WHAT is not starting? MySQL or innodb?
Is there another directive in your my.ini under [mysqld] like: skip-innodb?
If so, delete it or comment it out.
- Original Message -
From: "Silmara Cristina Basso" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 14, 2002 5:12 PM
Su
- Original Message -
From: "MikeParton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 13, 2002 8:21 PM
Subject: [PHP-INST] Search Field
Environment:
Win NT 4.0 SP6a
Apache 2.0.36
MYSQL 4.0.1a
PHP 4.2.1
I'd l
should it not be:
SELECT date, substring(text,1,30) as
string length starts at position "1". substring, therefore, would consider
the first character of the string as position 1, not 0.
- Original Message -
From: "Nick Wilson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thur
Where in the MySQL docs does it discuss DES_ENCRYPT/DES_DECRYPT support?
Alternatively (and I am posting this to the php lists), anyone know where,
or if, I can get pre-compiled libmcrypt library for php 4.2.1?
TIA
- Original Message -
From: "Tonu Samuel" <[EMAIL PROTECTED]>
To: <[EMAI
I haven't used Python...I use PHP and MySQL...I've found PHP does everything
I have asked it to do (and I have a lot more to work with). And, it has
been incredibly easy to pick up and use.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "R Talbot" <[EMAIL PROTECTED]>; <[
I think most of the data modeling tools (ERwin, SilverRun RDM, for example)
will reverse engineer your schema into them. Have not tried the two I
specifically mention with MySQL, but they have reverse engineering
functionality.
HTH
Mike
- Original Message -
From: "Yegor N. Bryukhov" <[E
What is it you are trying to accomplish with MySQL?
I have MySQL 4.0.1a running on WinNT 4.0 SP6a with Apache 2.0.36 and PHP
4.2.1. So far, in a development environment, MySQL 4.0.1 has done all I
have asked it to do (granted I am not doing anything at the edge of the
envelope).
Mike
- Orig
I am keen to here a response to this as well!
TIA
Mike
- Original Message -
From: "Williamson, David" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 4:38 PM
Subject: Ibdata1 file thats just too big...
> Hi there,
>
> My Ibdatafile is set too big (the disk is
See the MySQL Documentation section on sub-selects, section 1.7.4.1
Sub-selects.
Gives examples of rewriting sub-select queries that MySQL does not support.
- Original Message -
From: "Inbal Ovadia" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 10:59 AM
Subject
What are you trying to accomplish with the query? What results do you
EXPECT to be returned?
Can you not do what you're trying to do with:
SELECT id FROM Table WHERE (nr=3D123 AND nr=3D456)
?
- Original Message -
From: "Spielberg Micha" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent:
A file with extension .sql is an SQL set of statements. Perhaps it is the
CREATE TABLE query to create the table in MySQL.
You can open the .sql file with any trxt editor and examine the query it
contains.
HTH
Mike
- Original Message -
From: "Doug Coning" <[EMAIL PROTECTED]>
To: "MySQL
Haven't found any open source ERD editors out there. BUT, realized that
Visio has ERD diagramming capability, out of the box. Visio seems pretty
prevalent around enterprises. If you look, you might find it and can
describe your data model using one of several de acto standard
methofologies.
-
As an addendum to my last message:
If you want to do db dev through the GUI, I would suggest the MyCC from
MySQL AB over dbTools. MyCC provides more in the way of server process and
variable exposure within the GUI itself.
Mike
- Original Message -
From: "Anne Hall" <[EMAIL PROTECTED]
Without knowing what you need to be able to do in a MySQL GUI:
I have MyCC 0.8.2 from MySQL AB and dbTools 1.0.13 from www.dbtools.com.br.
I like both. MyCC is alpha and a little finicky at times...but easy to use.
dbTools is interesting and has a lot of potential.
HTH
Mike
- Original
> >> message, time
> >> FROM
> >> visitors
> >> WHERE
> id='$id'
> >> as I'm guessing your id is the primary
> >> key.
> >>
> >>
> >>
> >> > I want an
> OR
> >> test. If someon
gt; the record(s).
> >
> > The part I realize I am missing is to first
> test to see which fields
> >
> have been filled in. Need some pointers on how to start
> that.
> >
> > Thanks!
> >
> > Mike
> > -
> Original Message -
> > F
in. Need some pointers on how to start that.
Thanks!
Mike
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "MikeParton" <[EMAIL PROTECTED]>
Sent: Tuesday, May 14, 2002 3:49 PM
Subject: RE: query for search on
I have a similar query in a PHP script. I want to allow users to use fields
in a page to search for the records. BUT, I want them to be able to enter
the first few characters. I would think my query, below, would do it (the
entire search works when the WHERE statement has first='$first' OR
last
32 matches
Mail list logo
