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> cre
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 :
> Hello,
>
> When connecting to mysql, sometime I got this error:
>
> # mysql -ucdn -h113.108.22x.xx -p
> Enter password:
>
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 mysql
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 | k
aster 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
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 the
a csv file to 'insert value' statements.
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 gran
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 tautolo
0) | YES | | NULL | |
| status| varchar(20) | YES | | NULL | |
| Start | date| YES | | NULL | |
+---+-+--+-++---+
I am using 4.1.20. As always thank you for your
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
own MySQL and restart, it's normal again.
Weird, no?
On 23-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 complet
the system resources. 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
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 PROTECTED]
ll. 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 a
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 immediate
ences?
Thanks much in advance - I'm scratching my head on this one...
-Doug
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
u
get 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.mysq
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): Acce
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 docume
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> sele
y isnt malformed
Regards,
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 di
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
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
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 in
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 under
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
&
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 null<>1,null>1,null<1,null=1;
> +
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 closed<>1;
it is desired that null=1. DeMorgan's law takes a vacation here.
Correct behavior, in that it is a feature, I expected that; des
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 not-
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 see
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 ?
stuffed
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
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, Russel
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
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 2
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 a
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 was
ysql/mysql.sock
[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
not in business.."
_____
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]
ks and I'm sorry if I bothered you 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
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 " ", except for "ln -s"
(IMO).
>From a lexical view, I do not think the two forms are parallel. My que
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
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 offset
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 field
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 do.
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: http:/
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:
revo
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, typic
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
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 Do
ys that it's 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/
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 ca
ouch
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 -0500, [EMAIL
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 with
:(
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',
>
> t
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='Antique Circle 6/20; 1/2inches-lg Pearl Buttons & Novelty
Buttons',
proddesc1='3 buttons per card; 1/2
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.
_
Do
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
nnel your 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]
java-based application
(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]
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/tnsna
as if oracledump requires Oracle's network layer
> (SQL*Net) and
> unless you have that you can't do 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&#
SID in a file called
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]
> -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:
>
> SELE
>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
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
JOIN billing_payment ON (
billing.invoice=billing_payment.invoice ) WHERE billing.invoice=10001 GROUP
BY billing_payment.invoice;
+-+--+-+
| invoice | paid | balance |
+-+--+-+
| 10001 | NULL |NULL |
+-+--+-+
1 row in set (0.00 sec)
NULL values in this result are no
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]
Media 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 Mes
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
d place 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
--
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 My
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!
>
at
the file be in the same directory as the mysql 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
--
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
On Thu, 6 Feb 2003 12:05:03 -0500, Doug Beyer wrote:
>
>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 s
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:
s
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!
>
>-
&g
ing my day.
Doug
On Wed, 5 Feb 2003 15:58:21 +1300, Defryn, Guy wrote:
>
>
>I was just reading through the Mysql manual section 3.32
>And came across a sentence that started like this
>
>Animal sex can be represented in a variety of ways
>
>My mother tongue is not
lity doesn't eliminate the
need to know javascript.
>Any 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://
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 denie
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
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
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
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
>--
>
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
http://www.mysql.com/doc/en/User_Account_Management
hout 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-
- 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 filt
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
---
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
ow would I 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
b='mydb';
The above 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 Elli
|
>
>Any ideas?
Yes.
See Chapter 4.3.5 of the mysql manual.
"Note that we must issue GRANT statements for both monty@localhost and
monty@"%".
hth,
Doug
>
>Thanks,
> Neil.
>
>--
>Neil Aggarwal
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
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
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
1 - 100 of 191 matches
Mail list logo
