Thanks, Rick!
I had forgotten all about variables for some strange reason...
The subselect isn't nearly as nice as variable, because I'd have to repeat it
several times.
On 5 Oct 12, at 20:19, mysql-digest-h...@lists.mysql.com wrote:
> From: Rick James
>
> One way:
>
> SELECT @foo := this
One way:
SELECT @foo := this + that,
more_stuff + @foo
FROM ...;
Another way:
SELECT foo,
more_stuff + foo
FROM (
SELECT this + that AS foo
FROM ... ) x;
> -Original Message-
> From: Jan Steinman [mailto:j...@bytesmiths.com]
> Sent: Wednesday, Oc
Do you have skip networkin in my.cnf ?
No, no skip-networking is in the my.cnf file.
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Do you have skip networkin in my.cnf ?
--Original Message--
From: Jesse
To: Curtis Maurand
Cc: MySQL List
Sent: Jul 17, 2008 16:54
Subject: Re: Accessing remote machine (Ubuntu) from Window
My settings are the same, except I have the bind-address set to my local IP
of 192.168.1.128. I
L PROTECTED]>
Cc: "MySQL List"
Sent: Thursday, July 17, 2008 5:41 PM
Subject: RE: Accessing remote machine (Ubuntu) from Window
I just checked my ubuntu config and I have:
Port = 3306
Bind-address = 0.0.0.0
Pid-file = /var/run/mysqld/mysqld.pid
Socket = /var/run/mysqld/mysqld.sock
Nothig
"Curtis Maurand" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: 7/17/2008 4:46 PM
Subject: Re: Accessing remote machine (Ubuntu) from Window
I was wondering how I get it to listed on all ports. When I try 0.0.0.0,
and try to restart, the restart fails, and when it tries
and" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Thursday, July 17, 2008 4:31 PM
Subject: Re: Accessing remote machine (Ubuntu) from Window
I cannot. Are you trying to connect via the localhost. It may still be
trying t
I cannot. Are you trying to connect via the localhost. It may still be
trying to connect to localhost.
You might try changing the bind-address statement to
bind-address = 0.0.0.0 so that it also listens to localhost as well.
Also if you're trying to connect to an ip address instead of
Obvious question: Did you restart MySQL? netstat -l should show you
what's listening for connections. you'll want to see if its listening on
port 3306.
Yes. When that didn't work, I re-started the whole server.
netstat -l tells me that 192.168.1.128:mysql is listening. It lists a
foreign a
I dont think so, but I might be wrong.
I belive in your case u have to write a custom app
that listens on port 3306 and checks for every data
transfer.
Karam
--- Sheraz <[EMAIL PROTECTED]> wrote:
> Hello
>
> I need to access the mysql's connection handling ,,
> are there any exposed API's tha
Fred,
> >> This list is not a great place to ask about Firebird.
>
> But then, since I'm wondering whether to use MySQL or FireBird, they'll
> probably tell me the same thing over at the FB mailing list :-)
Feel free to send me a personal email with questions
about Firebird.
With regards,
Mart
David Griffiths >> Look at the documentation regarding the users table in
the mysql database.
Thx David, but I wasn't asking about limiting access to a database, but
rather how to set things up so that users at a branch office can have
read/write access to a database located at the main office.
Look at the documentation regarding the users table in the mysql database.
You can specify an ip address (or subset of an ip address) on which users
are allowed to connect; others are rejected, via the hosts column.
IE if you specify 192.168.1.%, any user on the 192.168.1 portion of the
network (
Hi Fred,
>
> Some of our customers have remote offices. I was wondering if it'd be safe
> to have a DBMS running at their central office, and have our client
> application running on hosts in the branches connect to it through a VPN
> via the Net?
If the connection is reasonably stable, and you ca
> I have recently installes mysql -4.0.0.1 on my redhat 7.1 machine . After
> installing when enter into mysql it gives me message " Access denied for
> user [EMAIL PROTECTED] host ...using password yes"
>
> i have tried all the options like
>
> #mysql -u root -h localhost
> #mysql -u root -h
ge -
From: "mathan" <[EMAIL PROTECTED]>
To: "sanjay gupta" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, August 13, 2003 4:04 PM
Subject: Re: Accessing Mysql after fresh installation
>
> > I have recently installes mysql -4.0.0.1 on my redha
"sanjay gupta" <[EMAIL PROTECTED]> wrote:
> When i type the command
> # mysqladmin -p password ''
>> Enter password:
>> #
> it asks for password. I don't remember the password any more . So it gives
> the same message
> "Access denied for user [EMAIL PROTECTED] using password np"
Run mysqld with -
"mathan" <[EMAIL PROTECTED]>
To: "sanjay gupta" <[EMAIL PROTECTED]>
Sent: Wednesday, August 13, 2003 5:20 PM
Subject: Re: Accessing Mysql after fresh installation
> > When i type the command
> > # mysqladmin -p password ''
> > > Enter p
LAST_INSERT_ID is held for the database connection, not agaist the
server
So, as long as you do not do another insert using the same database
connection, LAST_INSERT_ID will be fine.
(for database connection, $dbh=DBI->connect. )
No table locking required.
Regards
M
On Wed, 18 Dec 2002
Jeff Snoxell wrote:
> At 09:46 19/12/02 -0500, you wrote:
> >Jeff Snoxell wrote:
> >
> >>Nope. That doesn't do it either!
> >>
> >>I go:
> >>
> >>TRUNCATE TABLE my_table
> >
> >Are you using InnoDB tables? You'll have to do something akin to ALTER
> >TABLE my_table AUTO_INCREMENT=1 ... at least ac
At 15:13 + 12/19/02, Jeff Snoxell wrote:
At 09:46 19/12/02 -0500, you wrote:
Jeff Snoxell wrote:
Nope. That doesn't do it either!
I go:
TRUNCATE TABLE my_table
Are you using InnoDB tables? You'll have to do something akin to
ALTER TABLE my_table AUTO_INCREMENT=1 ... at least accordin
At 09:46 19/12/02 -0500, you wrote:
Jeff Snoxell wrote:
Nope. That doesn't do it either!
I go:
TRUNCATE TABLE my_table
Are you using InnoDB tables? You'll have to do something akin to ALTER
TABLE my_table AUTO_INCREMENT=1 ... at least according to Paul ... :)
No, I'm using MyISAM I belie
http://www.mysql.com/doc/en/SET_OPTION.html
last option(s)
maybe you can do somehting with that
Gr
At 10:54 19-12-02 +, Jeff Snoxell wrote:
I'm working with MySQL 3.23.36 so, according to "MySQL, Paul Dubois, New
Riders" running the query:
"DELETE FROM my_table_name"
should reset the a
I'm working with MySQL 3.23.36 so, according to "MySQL, Paul Dubois, New
Riders" running the query:
"DELETE FROM my_table_name"
should reset the auto-increment value... but it doesnt'.
What SQL do I use to reset the val.
You can't believe anything that book says. The author didn't even incl
At 15:31 + 12/18/02, Jeff Snoxell wrote:
Hi,
I've got that sussed now and am happily using the aquired ref to
subsequently play with the record etc. One other related problem and
I recon I'm sorted
How do I reset the auto-increment value?
I'm working with MySQL 3.23.36 so, according t
At 12:21 + 12/18/02, Jeff Snoxell wrote:
Hi,
I'm adding records to a db using the Perl DBI. Subsequent to adding
a record I need to know the value of the auto-incrementing 'Ref'
field so that I can place a copy of the relavent details into a log
file.
I could query for the "LAST_INSERT_ID
Jeff Snoxell wrote:
"DELETE FROM my_table_name"
should reset it... but it doesnt'.
I'm glad the DELETE FROM doesn't, or else my foreign keys would all get
screwed up :)
TRUNCATE should do what you want (as someone else pointed out).
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd. ... SQL
ht
At 15:31 18-12-02 +, Jeff Snoxell wrote:
Hi,
I've got that sussed now and am happily using the aquired ref to
subsequently play with the record etc. One other related problem and I
recon I'm sorted
How do I reset the auto-increment value?
I'm working with MySQL 3.23.36 so, according t
Hi,
I've got that sussed now and am happily using the aquired ref to
subsequently play with the record etc. One other related problem and I
recon I'm sorted
How do I reset the auto-increment value?
I'm working with MySQL 3.23.36 so, according to "MySQL, Paul Dubois, New
Riders" running th
On Wednesday 18 December 2002 14:21, Jeff Snoxell wrote:
> I'm adding records to a db using the Perl DBI. Subsequent to adding a
> record I need to know the value of the auto-incrementing 'Ref' field so
> that I can place a copy of the relavent details into a log file.
>
> I could query for the "L
mysql_connect() is deprecated function. Try using mysql_real_connect().
I've used and haven't experience any problems with it.
http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql
_real_connect
Sean
-Original Message-
From: Rahul Amaram-RollNo.286 [mailto:rah
Hi,
Take a look in mysql.h.
#ifdef USE_OLD_FUNCTIONS
MYSQL * STDCALL mysql_connect(MYSQL *mysql, const char *host,
const char *user, const char *passwd);
int STDCALL mysql_create_db(MYSQL *mysql, const char *DB);
int STDCALL mysql_drop_db(MYSQL *mysql, const char *DB);
#define mysql
At 22:04 +0530 11/8/02, Rahul Amaram-RollNo.286 wrote:
whenever i try to execute a C file which uses the mysql_connect method
i get the following error.
mysql_connect() is obsolete. Use mysql_real_connect() instead.
undefined reference to mysql_connect
Please note that I have tried th
have a look at the HAVING clause:
mysql> SELECT user,MAX(salary) AS sum FROM users
->group by user HAVING sum>10;
http://www.mysql.com/doc/S/E/SELECT.html
> Okay, I thought I'd done this before but maybe not. I can't figure it
> out now.
>
> What I want to do is:
>
> SELECT column
Dean,
Friday, August 02, 2002, 3:36:44 AM, you wrote:
DH> Okay, I thought I'd done this before but maybe not. I can't figure it out
DH> now.
DH> What I want to do is:
DH> SELECT column AS something FROM table WHERE something > 5
You can use aliases and HAVING clause for them:
http://www.
Orr,
Friday, July 26, 2002, 12:13:17 AM, you wrote:
O> It's my understanding that MySQL will only use one index per table on a
O> given query. For example...
O> SELECT * FROM
O> WHERE =
O> AND <
O> AND > ;
O> If col1, col2, and col3 are indexed the query can only use one index, right?
e selected; Click OK
> - You will get a Driver connect screen (which looks like the configuration
> screen above) - Click OK
> - You will get a list of tables. Select those you want to see through
> Access.
> - Voila! You can now access the tables through the Access database screen.
&
john" <[EMAIL PROTECTED]>
> To: "MySQL Lists" <[EMAIL PROTECTED]>
> Subject: RE: accessing MySQL database from Access
> Date: Fri, 5 Apr 2002 08:33:56 -0600
>
> You know this sounds like a good idea, and I know this is what the
utilities
> are for that come
John
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 8:42 PM
To: Bill Easton
Cc: [EMAIL PROTECTED]
Subject: Re: accessing MySQL database from Access
In the last episode (Apr 04), Bill Easton said:
> I have a bunch of users with a MySQL database on the
In the last episode (Apr 04), Bill Easton said:
> I have a bunch of users with a MySQL database on their local
> machines.
>
> Life would be simpler if they were able to access the MySQL database
> (read only) from Microsoft Access.
>
> Can this be done through an ODBC connection? Can somebody
On the other hand, you can also try OLEDB downloaded from www.mysql.org.
- Original Message -
From: "A. Clausen" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, January 30, 2002 3:36 AM
Subject: Re: Accessing MySQL Usin
- Original Message -
From: "sdfine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 28, 2002 12:06
Subject: Accessing MySQL Using ASP
>
> Does anyone have a good example of accessing and displaying data in a
MySQL
> database using ASP and displaying it on a web page? I
At 03:24 PM 1/28/2002 -0500, [EMAIL PROTECTED] wrote:
>Does anyone have a good example of accessing and displaying data in a MySQL
>database using ASP and displaying it on a web page? I'm a VB programmer and
>I'm new to accessing databases from the web and just need one good example
>to tie ever
IL PROTECTED]>
Sent: Monday, November 12, 2001 1:05 AM
Subject: Re: Accessing mysql database from a servlet
> It is exactly what I do. But in a normal java application it works,
> while in a servlet it doesn't.
> Luigi Fonti
>
> Nguyen Trong Phuc wrote:
>
> > this i
> PROBLEM 2
> I have developed several Applications in Delphi 4 based upon Paradox
Tables
> and am now re-engineering everything (using Delphi 6) to be based upon a
SQL
> DataBase instead. For which I hope to use MySQL Server to access the
> DataBase.
>
> What Components/Objects should I be using
On Fri, 17 Aug 2001, Grigory Bakunov wrote:
> echo "select * from test;"|mysql test;
Actually, for one liner commands you don't have to use echo| to mysql.
You could use the -e command line switch, e.g.:
mysql -e"SELECT * FROM test" test
Here is the definition for the -e switch:
-e, --execu
August 17, 2001 2:35 AM
To: Munish Malhotra
Cc: [EMAIL PROTECTED]
Subject: Re: Accessing MySql database using Bash shell Script
Date |17 Aug 2001 06:13:08 -
>From |"Munish Malhotra" <[EMAIL PROTECTED]>
Hello!
M M> Dear Sir,
M M> Can you please tell me how to acc
ED]
Sent: Friday, August 17, 2001 2:28 AM
To: Munish Malhotra
Cc: [EMAIL PROTECTED]
Subject: Re: Accessing MySql database using Bash shell Script
Munish Malhotra wrote:
>
> Dear Sir,
> Can you please tell me how to access data from a MySql database using a
Bash Shell Script i.e. how t
Date |17 Aug 2001 06:13:08 -
>From |"Munish Malhotra" <[EMAIL PROTECTED]>
Hello!
M M> Dear Sir,
M M> Can you please tell me how to access data from a MySql database using a Bash
Shell Script i.e. how to connect to a MySql database and retrive records and to
disconnect from database.
M M
Munish Malhotra wrote:
>
> Dear Sir,
> Can you please tell me how to access data from a MySql database using a Bash Shell
>Script i.e. how to connect to a MySql database and retrive records and to disconnect
>from database.
> I shall be very thankful to you.
>
On 17 Aug 2001 06:13:08 +, Munish Malhotra wrote:
> Dear Sir,
> Can you please tell me how to access data from a MySql database using a Bash Shell
>Script i.e. how to connect to a MySql database and retrive records and to disconnect
>from database.
> I shall be very thankful to y
Dear Ganesh,
if you can connect to the MySQL server with mysql, you can create new
users with the GRANT command.
> Is it possible for me to access a database on a remote machine by
giving
> the IP address of the remote machine as the host???
For such a user, a GRANT statement would look like th
>I have mysql installed on two linux boxes.
>How can i access one system's mysql db from the other system
grant access to the user on the other system. COnnect to the remote system
just like you would on the local.
Bye,
B.
---
hello all,
thanks for the replies regarding why problems using msqry32.exe. ultimately, my
flaw was that i had created a GRANT for the database "cat" while the ODBC DSN
connection was trying to use the database "CAT". uppercase got me, a common
problem of mine.
thanks again.
>Can anybody tell me if my VB5 programs can query an MySQL DataBase on a
Remote server?
>If so, what should I distribute with my software?
I have done some things like that, and since VB unses standard ODBC
connections the
only thing you need to include in your dist is the MyODBC API
/roger
--
Runs like a charm here. Just need myodbc from the mysql website.
- Original Message -
From: "licita" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 18:53
Subject: Accessing MySQL remote DB from VB5
Can anybody tell me if my VB5 programs can query an MySQL D
ac Martine [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 26, 2001 11:31 AM
To: Dominggus Andy A; [EMAIL PROTECTED]
Subject: Re: accessing
would you mind going into a little more detail...i'm near clueless about all
this..thanks-
mac
- Original Message -
From: Dominggus Andy A <[E
would you mind going into a little more detail...i'm near clueless about all
this..thanks-
mac
- Original Message -
From: Dominggus Andy A <[EMAIL PROTECTED]>
To: 'Mac Martine' <[EMAIL PROTECTED]>
Sent: Friday, January 26, 2001 12:38 AM
Subject: RE: accessing
58 matches
Mail list logo
