I'm sure this is in the manual somewhere or in the archives, but
I'm not finding it and I bet someone easily knows the short answer:
Using 3.23
setting a varchar field to PASSWORD(secret)
Having altered nothing regarding encryption in the server
what is the default encryption type for PASSWORD?
Egor Egorov wrote:
Colleen Dick [EMAIL PROTECTED] wrote:
Is it possible to JOIN the results of a DESCRIBE TABLE to some other
query? The semantics of what I would like to do is the following:
SELECT d_fldcomment from desc LEFT JOIN DESCRIBE footable ON
desc.d_table = 'footable
Is it possible to JOIN the results of a DESCRIBE TABLE to some other
query? The semantics of what I would like to do is the following:
SELECT d_fldcomment from desc LEFT JOIN DESCRIBE footable ON
desc.d_table = 'footable' AND desc.d_field = Field;
so the resultset would look like a regular
Hello Dusan:
MS Access is actually a user front end and not a database engine at all.
Many people don't understand this. A front end talks to a database
engine, known as a data source in the lingo. MS Access defaults to
using one of Microsoft's databases, I believe it is called jet or
try find / -name mysqld
landon kelsey wrote:
landon (root) /usr [632]find / -name mysql.server -print
find: /proc/1437/fd: No such file or directory
_
Working moms: Find helpful tips here on managing kids, home, work ? and
What version you using?
Subselects are not supported in any except the latest
Nuno Mendes wrote:
The sql bellow is giving a sql sintax error:
select
cities.id,
cities.name,
(
select
count(*)
from images
where ( images.city_id = cities.id )
) as number_of_images
from cities
Can you point
phpmyadmin is not reliable enough?
joffrey leevy wrote:
Hi all:
Anyone know a RELIABLE software program for
administering to a mysql database on a webhosting unix
server?
Thanks
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
I would mysqldump it, tar it up and send it as an attachment
(hope it isn't too big.) Make sure to tell him to delete the
illegal line of --- before he tries to import it.
michael johnson wrote:
Dear All
I want to send a MySQL database to a client by email. Which is the best way
to do it?
There could be a number of things going on.
It would help troubleshoot your problem if your
script check for errors and print them if there are any. You cant
just assume a connection is being made just because phpmyadmin connects.
Your web app has to make its own connection.
So how about showing
this rather than using php to do essentially the
same thing afterwards (which is what I did).
Roger Baklund wrote:
* Colleen Dick
This stumped them in PHPbuilder...
I have a table lets call it moms
each row in the moms table can have many kids,
and some kids have 1 mom. I have a kid table
and I
This stumped them in PHPbuilder...
I have a table lets call it moms
each row in the moms table can have many kids,
and some kids have 1 mom. I have a kid table
and I have a mxk map table to relate them.
what I want to do is select all the moms and for each mom I want a
random one of its kids to
if it just can't be done with a query please somebody
like Paul DuBois say so...
Colleen Dick wrote:
This stumped them in PHPbuilder...
I have a table lets call it moms
each row in the moms table can have many kids,
and some kids have 1 mom. I have a kid table
and I have a mxk map table to relate
Have anybody ever set up MS Access as a frontend to mysql?
the dB is an already established mysql db running on linux
I don't want to convert it, just use access to get to it.
I have followed the recipe at
http://www.washington.edu/computing/web/publishing/mysql-access.html
I can see the tables
Mike At Spy wrote:
How could I write a statement that uses something like 'OR' as a case. Like
this:
SELECT * FROM list WHERE name = '$this1' OR name = '$this2' OR name =
'$that1'
?
Thanks for any help,
-Mike
u just like that looks good to me.
--
MySQL General Mailing List
For list
I am building a SELECT using a left join and I almost have what I want.
One of the fields that gets sucked in from the left join is either null
or has a value in it.
if it is null I only want to include the rows from the main table where
the field isdemo=1
if that field has a value in it I
Mike Tuller wrote:
I am trying to create a script that will insert data. Right now I am just
using something simple to test this out, but I can't get it to work. Here is
what I have.
mysql --user=root --password= Database_Name;
INSERT INTO table_name (column_name) VALUES (value);
After I
I have a table let's call it (old) containing items of interest
index field (id)
another field (data)
I want the data colum to move to a normalized table (normal) that
uses id as part of a multifield primary key. So I created a data
column in the normalized table. How can I now
17 matches
Mail list logo