>
>> > Also check permission for 'foo' user though command
>> >
>> > select * from mysql.user where 'foo';
>> >
>> >
>> >
>> >
>> > On Thu, Aug 21, 2014 at 6:53 AM, Augori wrote:
>> >
>
oo'@
> > 'localhost
> > ' (using password: YES)")
> >
> > I have granted all on all databases to this user.
> > I attempted to run mysql_upgrade.
> >
> > I am stymied because according to another guy, he is successfully
> accessing
> > the same database with the same credentials as I am (but in a PHP
> script).
> >
> > Can any of you suggest an explanation for this?
> >
> > Thanks in advance!
> >
>
to this user.
> I attempted to run mysql_upgrade.
>
> I am stymied because according to another guy, he is successfully accessing
> the same database with the same credentials as I am (but in a PHP script).
>
> Can any of you suggest an explanation for this?
>
> Thanks in advance!
>
e granted all on all databases to this user.
I attempted to run mysql_upgrade.
I am stymied because according to another guy, he is successfully accessing
the same database with the same credentials as I am (but in a PHP script).
Can any of you suggest an explanation for this?
Thanks in advance!
Hi Abhishek, Yes I can do that.
On Tue, Dec 11, 2012 at 12:50 PM, abhishek jain
wrote:
> Can you ping ip 192.168.1.9 from other machines?
> On Dec 11, 2012 11:21 AM, "Girish Talluru"
> wrote:
>
>> Hi Guys,
>>
>> I have environment as specified below.
>>
>> Main server: Windows Server 2008
>> Vir
Can you ping ip 192.168.1.9 from other machines?
On Dec 11, 2012 11:21 AM, "Girish Talluru" wrote:
> Hi Guys,
>
> I have environment as specified below.
>
> Main server: Windows Server 2008
> Virtual Box: Oracle VM
> VM OS: Ubuntu
>
> Inside Ubuntu I downloaded and configured Apache, MySql, PHP
Steinman [mailto:j...@bytesmiths.com]
>>
>> I would like to refer to calculated columns in other columns. I thought
>> a column alias would do it, but apparently they're only for
>> aggregation, like GROUP BY.
>>
>> Other than repeating the entire calculat
Wednesday, October 03, 2012 4:09 PM
> To: mysql@lists.mysql.com
> Subject: Accessing Column Aliases In Other Columns?
>
> I would like to refer to calculated columns in other columns. I thought
> a column alias would do it, but apparently they're only for
> aggregation, like GRO
I would like to refer to calculated columns in other columns. I thought a
column alias would do it, but apparently they're only for aggregation, like
GROUP BY.
Other than repeating the entire calculation, what techniques are available for
accessing such a calculation?
I'm calc
I could do that, but I was hoping I wouldn't have to specify the
individual fields, and just pass the collection for parsing.
If I were to add any fields I would have to re-write the trigger which
is something I was trying to avoid.
On 13/09/11 09:53, Claudio Nanni wrote:
Hi,
Just quick r
Hi,
Just quick reading your email, forgive me if I'm mistaken
what about serializing using *concat(old.f1,'|||',old.f2,'|||',old.f3)
('|||' = any separator that works for you)*
and deserialize inside the function?
does this make any sense to you?
Cheers
Claudio
2011/9/13 Chris Tate-Davies
>
Thanks,
I kinda guessed that, but I'm not sure how to pass the OLD object to it
as MySQL cannot handle a rowset datatype.
Has anyone had any experience with this? Not sure where to start or how
to proceed.
Chris
On 13/09/11 07:40, Luis Motta Campos wrote:
On 8 Sep 2011, at 16:23, Chris T
On 8 Sep 2011, at 16:23, Chris Tate-Davies wrote:
> Hello. I want to know if there is a special way I can access all the data in
> the NEW/OLD data?
>
> I realise I can access it by referencing NEW.fieldname but I want to
> serialise the NEW object so I can save as a string. Is this possible or
Hello. I want to know if there is a special way I can access all the
data in the NEW/OLD data?
I realise I can access it by referencing NEW.fieldname but I want to
serialise the NEW object so I can save as a string. Is this possible or
do I need to write a function?
Thanks, Chris
*Chris T
Manasi Save schrieb:
> Hi All,
>
> I am needing to access a sub databases through main database.
>
> I have one main database and serveral sub databases. For accessing those
> databases I am using mysql prepared statements, But the performance I am
> getting becaus
Hi All,
I am needing to access a sub databases through main database.
I have one main database and serveral sub databases. For accessing those
databases I am using mysql prepared statements, But the performance I am
getting because of this is very low.
Can anyone suggest me any alternate way
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 have a Ubuntu 8.04 Server VM set up that I'm using for replication for a
WS2003 machine (which is the master).I have used a checksum utility that
someone recommended to check if the tables are in sync, but I don't have a
GUI installed on Ubuntu, so trying to interpret the selected columns that
> You SELECT statrment
> SELECT
> (s.server_disk_space * s.server_load * s.server_ram),
> s.server_fqdn,
> s.server_url,
> s.server_id
> INTO
> L_server_load,
> L_server_fqdn,
> L_server_url,
> L_server_id
> FROM clientdev.servers s
> WHERE s.active = 1
>
TECTED]>
To: mysql@lists.mysql.com
Sent: Thursday, March 1, 2007 9:49:10 PM (GMT-0500) Auto-Detected
Subject: Stored process accessing tables in different database
I'm having trouble with a stored proc. The problem is that the first
table is in a different database. Here is the test store
I'm having trouble with a stored proc. The problem is that the first
table is in a different database. Here is the test stored proc below.
Where I run this I get " ERROR 1327 (42000): Undeclared variable: s". I
have tried it by declaring "clientdev.servers s" and just by using
"clientdev.server
line and I can access it from
> mysql Administrator. When I run a php program I get an error.
> I also I am ahving problems accessing the DB from phpmyadmin
>
> I am running php 4.4.2
> Client API version 3.23.49
> mysql 5.0.18-nt
> apache 2.0.55
>
> Help?
>
>
also I am ahving problems accessing the DB from phpmyadmin
I am running php 4.4.2
Client API version 3.23.49
mysql 5.0.18-nt
apache 2.0.55
Help?
Nestor :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Tom Brown wrote:
Hi, I am trying to run mysqldump on a bugzilla database that is stored
on a remote server. I have access to that shared folder
and I have no problem backing up with MySQL Admin. With mysqldump
using a batch file (Windows) I get the following:
mysqldump: Got error: 1045: Acce
Hi, I am trying to run mysqldump on a bugzilla database that is stored on a
remote server. I have access to that shared folder
and I have no problem backing up with MySQL Admin. With mysqldump using a batch
file (Windows) I get the following:
mysqldump: Got error: 1045: Access denied for use
Hi, I am trying to run mysqldump on a bugzilla database that is stored on a
remote server. I have access to that shared folder
and I have no problem backing up with MySQL Admin. With mysqldump using a batch
file (Windows) I get the following:
mysqldump: Got error: 1045: Access denied for user '
Hi:
I would like to use the DALP libraries
(http://solutions.mysql.com/software/?item=145) to access a MySQL server
4.1.10 on Linux, from my PocketPC (iPAQ 3100 WM 2003 SE). I would appreciate
it if somebody could provide me with a minimal sample that would just connect
to a database so I can
Hi,
is it or will it ever be possible to access
an embedded data base and a remote server with the
same binary?
That would make installation of our software simpler
because we now have to offer two variants
--
Wolfgang
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
Tom,
I am running 'WinMySQLadmin 4.1". Can I use this tool to change anything?
Jerry
-Original Message-
From: Tom Crimmins [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 06, 2005 11:24 AM
To: Gerald Preston
Cc: mysql@lists.mysql.com
Subject: RE: first time accessing
Tom,
I am still getting access denied when I try ',mysql -u root'.
Jerry
-Original Message-
From: Tom Crimmins [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 06, 2005 11:24 AM
To: Gerald Preston
Cc: mysql@lists.mysql.com
Subject: RE: first time accessing
If you are usi
unty, Iowa
-Original Message-
From: Gerald Preston [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 06, 2005 3:08 PM
To: 'Tom Crimmins'
Cc: mysql@lists.mysql.com
Subject: RE: first time accessing
Tom,
I still get access denied. I just reinstall the latest version yesterday.
Wha
: first time accessing
[snip]
DBI connect<'test:GJWPP88','Jerry'> failed: Access denied for user
'Jerry'@'gjwpp88' at line 17
[/snip]
I would try your connection from a command line ie. 'mysql -u Jerry -h
GJWPP88 -p'.
The problem is n
n change the host in your perl script to localhost, and
you should be ready to go.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Gerald Preston
Sent: Thursday, January 06, 2005 5:25 AM
To: 'Tom Crimmins'
Cc: mysql@lists.mysql.com
Subjec
wanting to do is connect and create a new table.
Any ideas?
Thanks,
Jerry
-Original Message-
From: Tom Crimmins [mailto:[EMAIL PROTECTED]
Sent: Monday, January 03, 2005 3:52 PM
To: Gerald Preston
Cc: mysql@lists.mysql.com
Subject: RE: first time accessing
Try something like t
08 4259 - Fax
-Original Message-
From: Gerald Preston [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 4 January 2005 12:10 PM
To: mysql users
Subject: first time accessing
I am making my first attempt to access MySQL with Perl
#!/perl
use warnings;
use strict;
use dbi;
my $dbh=DB
--
From: Gerald Preston
Sent: Monday, January 03, 2005 7:40 PM
To: mysql users
Subject: first time accessing
I am making my first attempt to access MySQL with Perl
#!/perl
use warnings;
use strict;
use dbi;
my $dbh=DBI->connect( 'dbi:MySQL, 'user', 'pass
I am making my first attempt to access MySQL with Perl
#!/perl
use warnings;
use strict;
use dbi;
my $dbh=DBI->connect( 'dbi:MySQL, 'user', 'pass' ) or die "Cannot connect
-> !$DBI::errstr";
and I get the following error:
Can't connect to data source dbi:MySQL, no data driver
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
Hello
I need to access the mysql's connection handling ,,
are there any exposed API's that can allow me to see
what is being received on 3306 for serverand can i
hold that data for some checks so that if my check
goes perfrect ill let allow that data to pass on to
server for further request
Hi,
I am really pleased with the new unicode features of MySQL4.1.2 alpha release. I am
just a little surprised that there is still only one API call which returns the
character set??? (And it returns the collating encoding instead of the real character
set?)
I was wondering if there is a way
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.
This list is not a great place to ask about Firebird.
David.
- Original Message -
From: "The masked marvel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, May 01, 2004 4:52 PM
Subject: Accessing DBMS remotely: MySQL? FireBird?
> Hi,
>
> Some
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
Hi,
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?
What happens if the connection goes south while a branch offi
Hi,
I've succesfully connected to MySQL from a VB .NET application using a
MySQLDriverCS, I'm now looking for the same thing but on a Visual Basic
6 environment.
For a number of reasons ( the first is that the application should
start from a cd without installation ), I don't want to use ODBC.
t
Hi,
I've succesfully connected to MySQL from a VB .NET application using a
MySQLDriverCS, I'm now looking for the same thing but on a Visual Basic
6 environment.
For a number of reasons ( the first is that the application should
start from a cd without installation ), I don't want to use ODBC.
t
üngliche Nachricht-
> Von: Arunachalam [mailto:[EMAIL PROTECTED]
> Gesendet: Montag, 16. Februar 2004 13:15
> An: [EMAIL PROTECTED]
> Betreff: Is it correct, for DB accessing
>
>
> Hi all,
>
> I have installed the MySQL 5.0.0a-aplha for Windows
>
> Previously
Hi all,
I have installed the MySQL 5.0.0a-aplha for Windows
Previously I have some Database in 4.0.17-max, to access
those database now from current version MySQL Server, I have
just Copy the C:\mysql\Data\myDB folder into current server's
Data file path. Is this enough to integrate thoes Databa
At 2:45 -0400 10/4/03, Kenneth Lichtenberger wrote:
I would like to know how feasible it would be to have more than one
mysql server accessing the same data dir.
Not recommended.
e.g. having two different computers accessing the data dir over a nfs mount
And *especially* not recommended over NFS
I would like to know how feasible it would be to have more than one
mysql server accessing the same data dir.
e.g. having two different computers accessing the data dir over a nfs
mount
my logic tells me that it will work correctly seeing that mysql spans a
new process for each query
dose
> 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
Hi All,
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 localh
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
On April 1, 2003 07:50, Klepetka, Tom wrote:
> Hi -
>
> I would like to access a mysql database server from a NUMA-Q Sequent
> platform running Dynix/ptx v4.5.2. Does any of mysql's connectivity
> products (Connector/ODBC, Connector/C++) run under this platform/OS?
I am afraid that I don't know
Hi,
I've been facing problem while trying to access remote MySQL database
using PHP. It is working fine with the local database.
I did in the following way:
Created a user on the database with [EMAIL PROTECTED] identified by
'password';
Warning:
Warning: Lost connection to MySQL server duri
I'm trying to write a Delphi program that accesses a MySQL database via
MyODBC. It's going pretty well except for a sticky problem I'm having with
an unsigned integer column.
I have a column named 'IP', type unsigned integer, that will hold IP
addresses. However, Delphi seems to assume this colu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Prasad Budim Ram wrote:
Hi,
I have a JDBC application connecting to MySQL database. It was working
fine for the queries that retrieve small amounts of data. But when the
database contains 600,000 records and the query SELECT * is fired it
gives
Java
Hi,
I have a JDBC application connecting to MySQL database. It was working
fine for the queries that retrieve small amounts of data. But when the
database contains 600,000 records and the query SELECT * is fired it
gives
Java.lang.outofMemoryException. Can any of you help me out what could
be the
Dec 2002, Jeff Snoxell wrote:
> Date: Wed, 18 Dec 2002 12:21:14 +
> From: Jeff Snoxell <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Accessing last_insert_id problem.
>
> Hi,
>
> I'm adding records to a db using the Perl DBI. Subsequent to adding a
&g
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
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" but what if another process has
added anothe
No.286 [mailto:rahul@;gdit.iiit.net]
Sent: Friday, November 08, 2002 11:34 AM
To: [EMAIL PROTECTED]
Subject: accessing mysql from C
whenever i try to execute a C file which uses the mysql_connect method
i get the following error.
undefined reference to mysql_connect
Please note that I have tried the
ddress : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Rahul Amaram-RollNo.286" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 08, 2002 6:34 PM
Subject: accessing mysql from C
> whenever
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
whenever i try to execute a C file which uses the mysql_connect method
i get the following error.
undefined reference to mysql_connect
Please note that I have tried the following options.
gcc -lmysqlclient file.c
gcc -L /usr/lib/mysql -lmysqlclient file.c
gcc -L /usr/lib/mysql -I /usr/incl
Lazics,
Tuesday, October 22, 2002, 10:03:25 AM, you wrote:
>Description:
L>I've installed mysql 3.23.52 from source on RedHat Linux 7.3 ... when I try to
access the server from a non-local host, it gives the following error:
L> /usr/local/mysql-3.23.52/bin/safe_mysqld: line 273: 5979 Segme
>Description:
I've installed mysql 3.23.52 from source on RedHat Linux 7.3 ... when I try to
access the server from a non-local host, it gives the following error:
/usr/local/mysql-3.23.52/bin/safe_mysqld: line 273: 5979 Segmentation fault
$NOHUP_NICENESS $ledir/$MYSQLD $defaults --bas
I was wondering, what happens if two programs use the embedded mysql
library and try to access the same database?
Or, what happens if you run the mysql database server on the machine and
use the embedded mysql library to access a database?
how does the mysql lib require the application writer
I have the idea, to store complete xml-files in a tablefield and make it
accessible for an editor (e.g. XMetaL) on a client.
The retrieval in the database is done e.g. by php connections via browser.
After selection of a specific row, the db-server should send the (xml) field
content to the cl
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.
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 AS something FROM table WHERE something > 5
Basically I'm creating a new column called something and I want to use it to
compare with in the WHERE condition. Is this possible?
U
TECTED]>
> > Reply-To: [EMAIL PROTECTED]
> > To: [EMAIL PROTECTED], [EMAIL PROTECTED]
> > Subject: Write Conflict when accessing MySQL tables in Access (link table)
> >
> > Hi,
> >
> > Can anyone help me with this problem? Sort of related, I think, to my
&g
Jones wrote:
> Date: Fri, 26 Jul 2002 16:31:43 +0100
> From: Nathon Jones <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: Write Conflict when accessing MySQL tables in Access (link table)
>
> Hi,
>
> Can anyone
It's my understanding that MySQL will only use one index per table on a
given query. For example...
SELECT * FROM
WHERE =
AND <
AND > ;
If col1, col2, and col3 are indexed the query can only use one index, right?
Single index access is a problem when you very large tables. What if you
h
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?
Hello!
Troy Hickey wrote:
>Hi,
>
>I am pretty new to perl and am currently involved in setting up MySQL
>database using Perl. My setup includes MySQL running on Win95.
>I have a simple program which writes a few values to a database. The
>file works fine when using the Command Line interface
Troy Hickey wrote:
>Is there a different method of logging onto a DB when using it in a
>cgi-bin script rather than running the script from the DOS prompt? This
>would indeed explain a not connecting problem.
>
>My code snippet is:
>
>#
>
Is there a different method of logging onto a DB when using it in a
cgi-bin script rather than running the script from the DOS prompt? This
would indeed explain a not connecting problem.
My code snippet is:
#
$db="employees";
$host="localh
Hello!
Troy Hickey wrote:
>Hi,
>
>I am pretty new to perl and am currently involved in setting up MySQL
>database using Perl. My setup includes MySQL running on Win95.
>I have a simple program which writes a few values to a database. The
>file works fine when using the Command Line interface
Hi,
I am pretty new to perl and am currently involved in setting up MySQL
database using Perl. My setup includes MySQL running on Win95.
I have a simple program which writes a few values to a database. The
file works fine when using the Command Line interface and the database
gets the correc
1 - 100 of 173 matches
Mail list logo
