Hello,
why these db names created fail but the last one gets success?
mysql create database 3208e1c6aa32;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '3208e1c6aa32' at line 1
mysql
Hello,
When connecting to mysql, sometime I got this error:
# mysql -ucdn -h113.108.22x.xx -p
Enter password:
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading
initial communication packet', system error: 0
But most time it's correct.
What's the reason? Thanks.
I am running
sorry the problem has been resolved.
it's the reason of open_files_limit too small.
I increased it and the problem resolved.
2012/12/22 Doug d...@hacks.perl.sh:
Hello,
When connecting to mysql, sometime I got this error:
# mysql -ucdn -h113.108.22x.xx -p
Enter password:
ERROR 2013 (HY000
Hello,
can you tell me why my this query doesn't use the index?
mysql explain select * from iploc where 1902800418 between start_ip
and end_ip;
++-+---+--+---+--+-+--+---+-+
| id | select_type | table | type | possible_keys |
is up again, how will I restore those data new updated
into slave to master?
Thank you.
Regards,
Doug
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
.
My implementation question is about specifying the user. Apparently the
following are different:
1) user@localhost
2) 'user@localhost'
3) 'user'@'localhost'
I have not tested all this, but I did grant file privileges to #1 but could not
use them logging into with 'mysql -u doug
Got it - thank you, I did not think about the meaning of file except as it
relates to MySQL. Re syntax - thanks.
On Sun, 31 Jul 2011, Claudio Nanni wrote:
Hi Doug,
1.FILE is GLOBAL because it refers to the ability of the user to read/write
files on the server host filesystem (where
| | NULL | |
| status| varchar(20) | YES | | NULL | |
| Start | date| YES | | NULL | |
+---+-+--+-++---+
I am using 4.1.20. As always thank you for your insights.
Doug
Thank you.
On Wed, 21 Jan 2009, c...@l-i-e.com wrote:
The natural join will JOIN on *all* the fields whose names match, not just the
ones you want it to.
In particular, the JOIN is matching up .expires and .expires with =
You then use WHERE to get only the ones with
This is a tautology:
It works for me, I used your code:
Field =mycol Type=254 Length=20
so at least your code is fine, and the problem must be somewhere
else. I am using RH EL3.
cheers,
Doug
On 6 Oct 2008, at 19:52, Mike Aubury wrote:
I'm probably being a bit stupid - but I'm trying to determine (in
code
. Is it definitely mysql,
or php/apache, a slow disk, etc..
In terms of your stats below, I have (on a fairly average spec
server) 500 queries per second and 2000 open tables. So, unless it's
a PC or very badly tuned, it should be fine.
cheers,
Doug
On 23 Sep 2008, at 14:16, Rene
-Sep-08, at 3:47 PM, Doug Bridgens wrote:
it's all a bit too general, we could be asking continual questions
until someone asks the right one.
However, I would put some debugging into the 30% scripts to check
they complete before the next one starts, as if one script takes
slightly longer
if you switch the default engine type any new tables would be created
with that new engine type. it does not convert existing tables to
your new format.
if you have existing innodb tables you need to have the innodb
settings active, in my.cnf
On 15 Aug 2008, at 06:01, [EMAIL
. So you will know if it is a mysql
problem or not.
cheers,
Doug
On 13 Aug 2008, at 05:39, Krishna Chandra Prajapati wrote:
Hi all,
Connecting to mysql server (Production) is taking 5 to 6 seconds.
Production
has 16Gb ram. Previously it was using only 6GB ram. The details are as
follows
I have the following table:
explain domain_payments;
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-+---+
| Invid | int(11) | | | 0 |
It's possibly a DNS problem (reverse DNS exactly).
You know, I'm feeling a bit stupid here... That was indeed the problem,
as the new server hadn't been moved on DNS yet.
I put the IP address into the windows hosts file on the DB server, and
the problem cleared up immediately.
Thanks!
-Doug
on this one...
-Doug
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the extra benefit of the traffic being encrypted, plus you don't
have to worry about changing the permissions every $x hours when your IP
changes.
-Doug
--
Douglas Phillips
Programmer / Database Engineer
Cybergroup, Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
I'm a total newbie working through the tutorial in DuBois's _MySQL_.
I've got MySQL running on my PowerBook. In Terminal, I can use the
mysql client to get responses to things like SELECT NOW(). But the
command CREATE DATABASE sampdb; results in the following error.
ERROR 1044 (42000):
I have a php application that connects with MySQL using:
$SvrConn = @mysql_connect($MySQLServer, $MySQLUser, $MySQLPassword)
where: $MySQLServer='127.0.0.1'
$MySQLUser='dbuser'
MySQLPassword='dbpasswd'
and I can login using the above values. However connect fails:
mysql
should be
like accessing mysql from the command line.
On Tue, 17 Jan 2006, Logan, David (SST - Adelaide) wrote:
Hi Doug,
It is probably failing because you changed the ip address. The security
system in MySQL is based around where a user is coming from. There is
good documentation
through this document for the last week rewritten code based on the
suggestions and still get the error.
Regards,
Doug
oug Dalton wrote:
I am running mysql 4.1.13 on Suse 10 and I get an error on a simple
select query, I have checked the threads on lost connection and my
connection times
Gleb,
I watched the server during this error, the server continued to run...
it didnt crash... and no warning or logged error?
Regards,
Doug
Doug Dalton wrote:
Gleb Paharenko wrote:
Hello.
Check that MySQL doesn't die during the query. See:
http://dev.mysql.com/doc/refman/5.0/en/gone
,
Doug
Doug Dalton wrote:
Gleb,
I watched the server during this error, the server continued to
run... it didnt crash... and no warning or logged error?
Regards,
Doug
Doug Dalton wrote:
Gleb Paharenko wrote:
Hello.
Check that MySQL doesn't die during the query. See:
http
I am running mysql 4.1.13 on Suse 10 and I get an error on a simple
select query, I have checked the threads on lost connection and my
connection times as well as making sure my calls are all made from non
forking processes etc... I cannot seem to resolve this error? can
someone point me
First - thank you. I want to again thank this list, which in general is the most
tolerant to people new to database use and theory in general, and me in
particular. I mostly got your point from an earlier answer. Hopeful your example
quashes my ignorance, relative to NULL at least.
I think I
Thanks Martijn - that is a clear explanation of the philosophy. I did not get it
from the examples and the manual.
Doug
On Mon, 19 Sep 2005, Martijn Tonies wrote:
Hello Doug,
My question question from MySQL 4.0.22: is it okay that a null interger
tests as
equal to any value. I am
My question question from MySQL 4.0.22: is it okay that a null interger tests as
equal to any value. I am not sure the table structure matters but in case it is
I included it.
I did not expect that null was not not-equal to 1. Cursory testing seems to
indicate that a null integer field is not
Thanks but I still do not get why this does not merit a, you might want to
think about this.
So in the following query:
select * from new_payments where closed1;
it is desired that null=1. DeMorgan's law takes a vacation here.
Correct behavior, in that it is a feature, I expected that;
Belay my comments on true and false. I got mixed up. That works as documented.
On Mon, 19 Sep 2005, Roger Baklund wrote:
[EMAIL PROTECTED] wrote:
I did not expect that null was not not-equal to 1.
Any comparison with NULL returns NULL:
mysql select null1,null1,null1,null=1;
I am using MySQL 4.0.22 and have a question about an efficient way to calculate
a running balance as part of the select. The natural way to do this would seem
(to me) to be something like:
set @balance:=0;
select payid,Custid,Paid,@balance:[EMAIL PROTECTED] from payments;
This does indeed
When I do a SELECT using STRAIGHT JOIN against multiple tables where the
main table has about 200k rows, it is very fast retrieving the latest rows,
ie LIMIT 0, 10, but extremely slow retrieving older rows, for example,
LIMIT 18 , 10. Doing an EXPLAIN shows that no filesort or temporary
Hi,
I have tried to simply the problem and it exists without any JOINs.
have you given the query ?
SELECT id FROM stuff ORDER BY stuffed_date DESC LIMIT 18, 10 - .43 sec
SELECT id FROM stuff ORDER BY stuffed_date DESC LIMIT 0, 10 - .0007 sec
have you described your tables ?
Just in case you did not follow this suggestion, if you are using 4.0.x this is
very simple. I was looking for this:
set @total:=0;
select f1,f2,...,@total:[EMAIL PROTECTED] as Total from table where ...;
is pretty simple.
On Wed, 25 May 2005, Dan Bolser wrote:
On Wed, 25 May 2005,
Thank you for the clear statement of policy. I had in fact forgotten
about the manual that comes with the installation. It however is
packaged as one rather large html or text file (my system is FreeBSD).
The web site is a far superior reference because of the file format.
Doug
On Thu, 21 Apr
Is the online documentation for 4.0.x available? I was working with
dates a while back. As it happens 4.1 added the very function I wanted.
But that was not marked as added in 4.1, nor should be be as that would
be an unbelieable amount of cruft.
I would be nice however if maybe one level back
I have read the MySQL Cookbook and the last 6 months (or so) of threads
on this. I have a slightly different problem. I use a billing system
implemented in filemaker. Happily they are going a rewrite in MySQL/PHP,
but for the present I maintain a MySQL database so I can track things
otherwise not
Yes - thanks. I did not define the data with keys because it does not
come out of the source that way. Keys and replace does it nicely.
Probably my question defined me as a newbie, if not well...
Thank you very much for you help.
On Wed, 20 Apr 2005, Duncan Hill wrote:
On Wednesday 20 April
[mysql.server]
basedir=/usr/bin
Any assistance is greatly appreciated.
Doug
this,
just perhaps suggest where I can look.
BTW, I searched for this and got a reference to the perl-DBD-Mysql module,
which I do not have installed.
D
-
PresenterNet
The Interactive Presenters' Network
Doug Wolfgram - CEO
949.248.0439
http
..
_
Doug Wolfgram
GRAFX Group, Inc.
Cell: 949.433.3641
http://www.gfx.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
or if you don't need this service,
Doug Freeze
A resident of Glendora CA.
(626) 290-0908
http://wirelis.com
P.S. You'll never receive another message from me so there's no need to write me back
and ask to be removed from my mailing list nor will your e-mail address ever be given
away or sold
I have a question about the multiple table delete syntax. First the
documentation on the website is very clear. My question is why not how. The
'delete from using' is not ambiguous (to me). My question is about the form:
delete t1 from t1,t2 where ...
I would take this to mean remove matching
I have no problem understanding the syntax, or how to do what I want (at least
after my first mistake). It is more about if this is a consistant grammar. For
example, unix commands have the form verb src object, except for ln -s
(IMO).
From a lexical view, I do not think the two forms are
Using INNER JOINs with the STRAIGHT_JOIN option so that the main table
displayed first in the EXPLAIN eliminated the temporary table being created
and the query speed went from 2.3 seconds to 0.2 seconds. Note that this
only works for queries where the offset in the LIMIT is small. As the
Thank you for your detailed response.
You might get better performance just from using the explicit INNER JOINS
but I make no assumptions.
I tried INNER JOINS and did not see any difference in speed.
You may also get better performance if you had
composite indexes (not just several individual
A query which is constantly being run takes about 3 seconds when not cached,
and I was wondering if there were any way to speed this up. There are
several tables being joined and sorted by latest date with a LIMIT of 10.
All fields being joined by are indexed. So I'm not sure what else I can
Not using perl or php I came up with:
mysqlshow -u user --status db_name | awk -F| '{print $2,$5}' | grep -i pattern
Is there a query to do the same thing?
_
Douglas Denault
[EMAIL PROTECTED]
Voice: 301-469-8766
Fax: 301-469-0601
--
MySQL General Mailing List
For list archives:
REVOKE ALL PRIVILEGES FROM [EMAIL PROTECTED] seems to be a 4.1 form of the command
(I have 4.0.15) but adding '@localhost' did the trick. Thank you.
On Wed, 17 Mar 2004, Michael Stassen wrote:
[EMAIL PROTECTED] wrote:
I was trying to allocate a new user and I typed something like:
I was trying to allocate a new user and I typed something like:
grant all privileges on pail to [EMAIL PROTECTED] identified by 'hill';
I realized I made a mistake needing to specify (at least) 'pail.*', intending to
grant the user access to a database I created. So to clean up I tried:
I have a system running FreeBSD 4.9 four jails. MySQL is running in two of the
jails and I am trying to add it to a 3rd jail. Starting the server gets the
message:
040302 19:34:15 mysql started
040302 19:34:15 Can't start server : Bind on unix socket: Permission denied
040302 19:34:15
Thank you for the replies. Jail is a FreeBSD construction that provides a
chroot'ed environment that allows you to create another instance of the entire
OS. So in my case the physical server running the jails appears to the world
like 5 hosts. Each jail has its own IP and is running an independent
. Not a problem in the system I used as
a template because /tmp is a UFS there.
Doug
On Wed, 3 Mar 2004, Michael Stassen wrote:
This error usually occurs for one of two reasons:
1. There is already a /tmp/mysql.sock. You've ruled this out.
2. The user mysqld runs as, typically mysql, does not have
at /usr/local/msql. I could find
no such path. I searched my local drive for all occurrences of mysql,
but it found only those that occur within the Lasso package. Can
someone help me out?
Thanks,
Doug
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
My question is how to improve an update. I had a set of records from an external
source to add to a table. In the new data one of the key values was not known.
It turns out that another key can be matched to key values in the old data
(extracted to the table temp).
The relation between the keys
The db in question is a shopping cart and I was looking for products I added
that might have been duplicated in another category. My first attempt that
worked.
select prodid,count(groupid) as cnt from products
where (groupid=65 or groupid=66)
group by imgsml order by cnt;
The thing wrong
blush ouch /blush
To Jimmy and Chris and the list in general. This list is particualiarly kind to
question of this nature. I for one appricate it. In this case it is amazing how
many wrong things I came up with.
On Tue, 13 Jan 2004, Chris Elsworth wrote:
On Tue, Jan 13, 2004 at 02:03:26AM
This has to be something silly, but I can not see it. Any help greatly
appreciated:
use newshop;
insert into products set storeid=2, deptid=5, groupid=66, prodid='C2BUWS1028',
prodtitle='bAntique Circle 6/20; 1/2inches-lg Pearl Buttons Novelty
Buttons/b',
proddesc1='3 buttons per card;
:(
Thank you - my only defense - it was 04:00, I think I looked at it too
long and got hung up on the line 2.
Doug
On Mon, 12 Jan 2004, Johan Hook wrote:
Hi Doug,
I think you need to quote imgsml=C2BUWS1028.jpg, like
imgsml='C2BUWS1028.jpg',
take care,
/Johan
[EMAIL PROTECTED
Hi:
I am new to MySQL and can not find how to do this. I am running 4.0.16. Table1
has the correct values for a common field. Table 2 (the real one) needs to be
updated from t1 via a common field.
Can this be done with joins. And if not what is the best way.
Thanks for any suggestions.
_
connections over an ssh tunnel, or setup an ipsec tunnel.
--Doug
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
easier to
setup (especially if you're already using unix-like machines on both the client and
server) and definately more secure. IPSEC would also be significantly more difficult,
but you wouldn't have to worry so much about the secure session going down.
--Doug
On Thu, Nov 06, 2003 at 12:12:14PM
On Mon, Sep 01, 2003 at 11:09:02AM -0700, Martin Gainty wrote:
Doug
I copied this from an SAP integration with Orace site
http://saphelp.cob.csuchico.edu/OraHelp/Darwin36/inst36fhp/html/5-odbc.htm
5.5.3 tsnames.ora File
the file
ORACLE_HOME/network/admin/tnsnames.ora must point
(JOracleDump) and am modifying that to do what I need.
--
Regards,
Doug
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
tnsnames.ora. Those do not exist on the system I am using. Is it
possible to still use oracledump in this case?
--
Regards,
Doug
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
anything.
The oracle thin JDBC driver implements
SQL*Net for java only, but the other Oracle jdbc drivers require SQL*Net
Thanks for the reply. Looks like I'll have to roll my own in Java.
--
Regards,
Doug
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
-Original Message-
From: Nathan Simms [mailto:[EMAIL PROTECTED]
The problem is that I need my statement to search the
product_name and
description fields as well. However when I add them to my
statement, it
doesn't work???
The statment below does not work:
SELECT
the invoice total,
but that seems like a step backwards. is there a way to do what i was
doing with v3.23, given the new NULL behavior?
thanks in advance.
doug
At 02:53 PM 7/17/2003 +, [EMAIL PROTECTED] wrote:
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent
Description:
I'm running mysql in a 3 server configuration, with 2 servers being slaves
to the first. I'm running vpopmail, which means a connection every incoming
mail and every check. I woke up this morning to a mysql that wasn't
answering connections, and that had left this in the log:
030716
|
+-+--+-+
| 10001 | NULL |NULL |
+-+--+-+
1 row in set (0.00 sec)
NULL values in this result are not expected, nor are they helpful in
determining the invoice balance.
thanks again for any suggestions,
doug
--
MySQL General Mailing List
Is there any easy way to create this type of QUERY?
I am trying to get a list of usernames from table A who do NOT have a
linked record in Table B.
D
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
that WORKS.
___
Doug Wolfgram
CEO
GRAFX Group, Inc.
949.433.3641
http://www.gfx.com
http://www.aimprojects.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
It is all disinformation to confuse Micro$oft. 8-)
On Mon, 31 Mar 2003 09:45:09 -0700, Martin Gainty wrote:
Michael et al-
I am trying to locate ONE working MySQL example for windows. Is this a myth
or is there WORKING source example out there somewhere?
Thanks,
Martin
- Original Message
Very close.
Only one table may be updated per UPDATE statement.
Doug
On Sun, 23 Mar 2003 00:52:59 -, [EMAIL PROTECTED] wrote:
Hi
I may be way off base here but - why do you reference IMPORT_USERS in your
UPDATE statement? You aren't updating any columns in that table.
Regards,
Sal
it as 'SK22' into ProdKeywords column for the same record.
How would I go about removing the '-' and placing the remainder in the
ProdKeywords column.
Thank you,
Doug Coning
sql,query,queries,smallint
-
Before posting, please
PHP Database Mailing List (http://www.php.net/)
Mostly MySQL with a smattering of other db's from time to time.
hth,
Doug
On Fri, 28 Feb 2003 13:30:40 -, Andrew wrote:
Using MySQL and PHP
PS. Do any of you knw of a forum specifically out there for PHP and MySQL?
Andrew
length fields to another table. However, the varchar() type
reduces storage requirements without a performance penalty. If the
retrieved/displayed length is the issue, you can use the LPAD or RPAD
functions as appropriate.
Doug
On Wed, 12 Feb 2003 09:21:31 +0100, Ulla Wensman wrote:
Hello!
When I
Am I the only one that equates these robot replies with spam? Most of
them are as meaningful as talking to micro$oft.
Yeah, I filter them on input and they go to trash, but silence can be
taken as consent which might be construed as endorsement. Who knows
what would come next?
My $0.02,
Doug
program.
You can specify a relative or absolute path to filename.sql such as
../sql/filename.sql or
/local/mysql/sql/filename.sql
Please help.
Hope this does.
Doug
-
Before posting, please check:
http://www.mysql.com
I attempted to search various places for my answer but with no luck. So I'm posting
here.
I create the following table:
create table t1 ( id varchar(5) not null, name varchar(5) not null );
I insert the following row:
insert into t1 ( id ) values ( 1234 );
I do the following selects:
I love it!!! 8-))
You are correct that it does sound a bit rude, even when English is
your first language and you stop to think about it. However, what the
statement means is identical to The sex of the animal can be
represented... and it is acceptable grammar.
Thanks for making my day.
Doug
See DROP DATABASE
Doug
On Wed, 5 Feb 2003 22:50:25 +0800, Calvin Lam wrote:
Hi,
I am a newbie with this and I need help with Mysql
How can I delete a database in Mysql
thanks!
-
Before posting, please check:
http
help greatly appreciated
Your inquiry will receive more detailed help on one of the lists at
www.php.net.
Regards,
Doug
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
FLUSH PRIVILEGES
On 29 Jan 2003 07:05:29 +0800, Jon Miller wrote:
When granting someone permissions are these permissions dynamic or do I
have to reload mysql?
Also we have a developer who stated he cannot access the database
remotely. I've granted him privileges as follows since he works on
You need to include the (correct) Root password in mysql_connect(h,u,p)
On 29 Jan 2003 07:42:37 +0800, Jon Miller wrote:
Warning: Access denied for user: 'root@localhost' (Using password: NO)
in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255
Warning: MySQL Connection Failed: Access denied
Assuming you logging in from the same server on which mysqld is
running, you need a dmiller@localhost user. The % wildcard is valid
only for tcp connections. This is thoroughly explained in the MySQL
manual, chapter 4.3.5.
hth,
Doug
On Mon, 27 Jan 2003 15:03:35 -0500, Devin Miller wrote:
I am
on the surface for web-based tutorials.
Enjoy,
Doug
On Sun, 26 Jan 2003 11:00:18 -, Scott Lewis wrote:
As you can tell - very new to Mysql.
I was wondering, has anyone some links to howto or even better examples of
databases and webpages that I can install, and see the web interaction
You state that you searched the web and the documentation, but did you
search the MySQL manual?
4.2 General Security Issues and the MySQL Access Privilege System
http://www.mysql.com/doc/en/Privilege_system.html
4.3 MySQL User Account Management
You mean like your inquiry which took 8:01:27 between the time you sent
it and when it hit my mail server?
Doug
On Thu, 23 Jan 2003 20:44:56 -0800, Jeremy Zawodny wrote:
Is anyone else seeing it take 4-8 hours for mail to get thru this list
recently?
Jeremy
--
Jeremy D. Zawodny | Perl
- Original Message -
From: [EMAIL PROTECTED]
To: Doug Coning [EMAIL PROTECTED]
Sent: Thursday, January 23, 2003 9:15 AM
Subject: Re: Is this possible?
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must
having to use a temporary table...
Thanks,
Doug Coning
-
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
You might find something at
http://www.linuxapps.com/
Doug
On Tue, 21 Jan 2003 00:06:32 -0800, Ed Reed wrote:
Does anyone have a list of manufactures of financial packages that will run with
MySQL?
We need to move from Intuit Quickbooks to something that can potentially scale to as
many
Certainly.
http://www.mysql.com/doc/en/User_Account_Management.html
On 22 Jan 2003 06:50:27 +0800, Jon Miller wrote:
Is there a way to check or view in mysql what permissions users have to certain
databases?
--
Jon Miller [EMAIL PROTECTED]
MMT Networks Pty Ltd
modify this query to return all the items from Category,
Category2, Category3, Category4 and Category5 and then group them all by
similarities?
Thank you,
Doug Coning
-
Before posting, please check:
http://www.mysql.com
is a very superficial description of the mysql Access
Privilege system. You need to read a lot more in the manual in section
4.2, General Security Issues and the MySQL Access Privilege System.
Doug
On Thu, 16 Jan 2003 01:15:03 -0600, Addison Ellis wrote:
hello,
how can i view privileges
It's my understanding that embedded selects are NOT allowed in MySql. Is this correct?
Example:
SELECT t1.*
FROM table1 t1
WHERE ( t1.Id IN ( SELECT t2.Id FROM table2 t2 ) )
Doug Beyer
SAS Research and Development
503-617-7103 (Portland)
[EMAIL PROTECTED]
SAS... The Power to Know
@localhost and
monty@%.
hth,
Doug
Thanks,
Neil.
--
Neil Aggarwal
JAMM Consulting, Inc.(972) 612-6056, http://www.JAMMConsulting.com
Custom Internet DevelopmentWebsites, Ecommerce, Java, databases
-
Before posting
To paraphrase Yogi Berra: You can see an awful lot just by looking.
http://www.mysql.com/doc/en/Can_not_connect_to_server.html
Doug
-- For Happy Filters, use SQL, query
On Sat, 11 Jan 2003 12:50:29 -, alan.keith.simons wrote:
Hi
I have installed a downloaded version of mysql on my pc
Hi:
Go look in the section where they keep the O'Reilly books and pick up
MySQL Cookbook by Paul DuBois ISBN 0-596-00145-2.
It is fair to say that Paul has an above average grasp of the topic.
He is often quoted on this list.
Regards,
Doug
On Wed, 08 Jan 2003 08:34:18 -0500, Charles Mabbott
1. This is a PHP syntax question.
2. The PHP manual gives a specific example in the MySQL Functions.
$link = mysql_connect(localhost, webuser, webpass)
Doug
On Sun, 29 Dec 2002 20:11:14 +0200, Pikasz Gyorgy wrote:
Hi all!!!
Red Hat 7.3, MySQL, PHP
I tried to connect to MySQL
1 - 100 of 184 matches
Mail list logo