Hi Heikki,
Thanks for the response.
I assume that the row level privileges can not be implemented
in application only. There is some dependency involved in masking direct
mysql database access (using mysql client tools).
Please let me know if there is any the default alternative availa
hi everyone,
I have problem call database.Its unable to call database below, but rest of
database can be call.Can anybody help me.
mysql_connect($host,$user,$passwd) or die ("Can't connect to server");
$db = mysql_select_db("dictionary") or die("unable to call db") ;
thanks in advance
_
>From the DBI manual:
$dbh = DBI->connect($data_source, $username, $auth, \%attr);
You're not telling DBI what the DSN is (Data source name)
John Mayson wrote:
>
> I've decided to graduate to the next step and access my mySQL databases with Perl. I
> am attempting this on a Win2000 ma
I've decided to graduate to the next step and access my mySQL databases with Perl. I
am attempting this on a Win2000 machine.
Here's my code...
#!C:/perl/bin/perl.exe -w
use strict;
use CGI qw(:standard);
use DBI;
my $dbh = DBI->connect('Radio', 'root', '');
I get this error message...
Can
http://www.mysql.com/doc/n/o/node_365.html
> Can anyone tell me how many characters a MySQL TEXT field can hold? What's
> the limit?
--
Steve Rapaport
World Citizen
-
Before posting, please check:
http://www.mysql.com/ma
Hello All!
Can anyone tell me how many characters a MySQL TEXT field can hold? What's
the limit?
Thank you,
Carlos Fernando.
Linux User #207984
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I have an application with fairly typical locking requirements: 99% of
the requests are read-only (with an exception that I will specify).
Update requests are relatively rare. There's a half-dozen tables, and
since the inter-relationships are a little complex. I found it easiest,
given the perform
Good old copy and paste an error.
Thanks, will make sure the next time i have a problem, not to waste your
time for something silly.
It's funny, i can call method prepare on the database object but not
execute, error on line 3.
1. my $query = "SELECT UserID,Name FROM test";
2. my
try $sdb->execute()
Clinton Hesse wrote:
>It's funny, i can call method prepare on the database object but not
>execute, error on line 3.
>
>1. my $query = "SELECT UserID,Name FROM test";
>2. my $sdb = $dbobj->prepare($query);
>3. $dbobj->execute;
>
>where $dbobj is a reference to the database o
It's funny, i can call method prepare on the database object but not
execute, error on line 3.
1. my $query = "SELECT UserID,Name FROM test";
2. my $sdb = $dbobj->prepare($query);
3. $dbobj->execute;
where $dbobj is a reference to the database object
I get error
Can't locate object method "exe
Hello Martin,
Yes, in the meantime, this has been confirmed as a problem with
Windows/MySQL.
I'm enquiring about a remedy.
BTW, I removed the socket option, but still same anomaly.
Kind regards
Emmanuel
> -Original Message-
> From: Martin Waite [mailto:[EMAIL PROTECTED]]
> Sent: 31 De
where can I find man pages about c api functions?
MySQL-client-3.23.41
MySQL-devel-3.23.41
MySQL-shared-3.23.41
MySQL-3.23.41
but I can't man to mysqlfunctions!!
===
¿ì¸® ÀÎÅͳÝ, Daum http://www.daum.net
- 2002 ´ëÀ
Hello All,
I am using Linux, with Apache, mysql among other things.
I am root, user, owner, etc.
Other than getting up there in age, I can't seem to remember the
mysql passwords that I set up for root, users, etc.
is there a way to remove/recover the password I set up for
mysql for root and sta
database,sql,query,table
> 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 include
> one of the following words in your message:
>
> database,sql,query,table
>
> If you just reply to this message, and include
i'm using DBI (use DBI;) but I still get this error. Any Ideas.
Can't locate object method "execute" via package "DBI::db" (perhaps you
forgot to load "DBI::db"?)
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Clinton Hesse" <[EMAIL PROTECTED]>
Sent: Monday, December 31, 2001 2:04
Richard --
You could do both, I would be a lot quicker to import data than restore
from tape. Say do an incremental dump back to your last level 0. Which
would be helpfull to developers as well as youself. You could also use
a seperate partition for the data directory and back that up.
The subj
Clinton --
It's saying you password is incorrect or wasn't entered.
I believe. Did you set username and password in script?
Also http://www.perlmonks.org have some tutorials on
DBI/DBD, you would find helpfull.
-- david
> I get this error when trying to connect to a mysql database
>
> DBI->co
I am running mysql on a linux box RH 6.2. I backup all the filesytems
with:
/sbin/dump 0ubf 800 /dev/npt0
to a COLORADO 8gig. travan tape drive. Is this sort of backup regimen a
good one -- compatible with MySQL -- or should I instead be backing up
with FLUSH and (or) mysqldump?
Any h
SELECT REPLACE(DIRECTIONS, '#', 'No.')
FROM shpr_rcvr
WHERE etc.
-- Greg Johnson
-Original Message-
From: Richard Reina [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 31, 2001 1:23 PM
To: [EMAIL PROTECTED]
Subject: unique problem?
I have a table shpr_rcvr that stores info about loc
I have a table shpr_rcvr that stores info about locations where things
are shipped to and from. Each record has a text field called DIRECTIONS
that contains directions on how to get to the location. Often in the
directions column the "#" sign is used to help describe and exit number
off the
I get this error when trying to connect to a mysql database
DBI->connect(database=baggs) failed: Access denied for user:
'baggs@localhost' (Using password: YES)
I added the user 'baggs' to the user table and to the db privilege table
and used mysqladmin reload to refresh the tables.
Any Ideas.
Hi!
Sorry, I think there is no row-level privilege setting in MySQL. You have to
code the logic in your application.
Regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB
Julian,
The "as" field is just setting the name of the field or column. For example
in PHP, if you don´t use the "as somename", you must use array[2] (I just
use 2 as an example) instead of array['datefield'] to get the information.
Regards,
Ingvar G
Web accounting & CRM
us.logiledger.com
Thanks this works
the difference was the 'AS datefield'
what is this bit doing? I searched for AS (in the SELECT description in my
book) but it does not mention it; though I have seen it in examples. I like
to understand why I use the code I do...
I looked at http://www.mysql.com/ but can fi
On Mon, 2001-12-31 at 14:01, Emmanuel van der Meulen wrote:
> Hello Martin,
>
> [snip]
> > Ok. Try to explicitly set the host on the command line:
> >
> > eg: mysqladmin -h 127.0.0.1 -P 2000 .
> >
> >
> > Note that you should use the ip address of your host or its network
> > name. Using '
Are you using mysqlimport utility? If not that may be you answer?
If so what flags are you setting?
david
> HI ALL: Happy New Year ;)
> I have a text file generated from MSAccess database, one of the
> fields (Long Text) have Carriage returns within the text, So
> the data of some records f
James --
You haven't done enough "book work" this is basic db design stuff,
covered in Dubois book and evey other, the short answer is:
Primary Key -> foriegn Keys i.e
People table:
person_id, # Primary key, unique and auto increment
fname
lname
...
Food
person_id # pulled from People table vi
Hello Martin,
[snip]
> Ok. Try to explicitly set the host on the command line:
>
> eg: mysqladmin -h 127.0.0.1 -P 2000 .
>
>
> Note that you should use the ip address of your host or its network
> name. Using 'localhost' won't do what you want.
I include commands of two instances which I
I have a php file with (shorten):
1. CREATE TEMPORARY TABLE on tableA;
2. REPLACE into ... tableA;
3. CREATE TEMPORARY TABLE ... on tableA;
4. REPLACE into tableA;
Can i be sure that the REPLACE in step 2. will be finished before the
TEMPORARY table in step 3. is made(or do i need to use som
On Mon, 2001-12-31 at 10:50, Emmanuel van der Meulen wrote:
>
> As suggested, I used -S instead of -P, but still the first instance shuts
> down.
>
> I'm running on Win2K Pro. Is there a different way for Windows?
>
> Please advise any further pointers?
>
Ok. Try to explicitly set the host
HI ALL: Happy New Year ;)
I have a text file generated from MSAccess database, one of the
fields (Long Text) have Carriage returns within the text, So
the data of some records falls in more than one line in the
text file, when I'm using the SQL statement LOAD DATA INFILE...
I have only the fir
Hi!
I want to solute a hanging problem and I want to upgrade to a newer
version. Actually I'm using the 3.23.39 on a SunOS 5.6 sparc Ultra-5_10
Should I wait to the 4.x version? How long will a stable version take
to be published?
Or should I upgrade to 3.23.47?
Thank you!!
---
Didier Brisebourg writes:
> It seems that "INSERT" is blocking my process when there is no more free
> space in the file system that contains my databases.
>
> Can anybody clarify this point, and tell me how to prevent this blocking
> point ?
For info on full disks, see the manual:
http://www.
Trevor,
Thanks for the tip...This is probably what I should have done in the first
place. I can't now though, at least not at the moment, this is a Cobalt
RAQ4 web server set up at a hosting service in Atlanta, GA.
I went ahead and used a symlink at the compiled data directotry pointing
back to
Jose,
thank you for the bug report. You are right: if there are several NULLs in a
unique secondary index, CHECK TABLE will report table corruption because of
a duplicate key in the index. I forgot to ease the check in CHECK TABLE.
I have now fixed this for 3.23.48.
Regards,
Heikki
Innobase O
Hi Heikki,
I have proven this in MySQL 3.23.47 and I have found a problem with
"CHECK TABLE", that reports "error - corrupted table" if there are
several NULL's in a UNIQUE index.
Happy end of year to all!,
José Ceferino Ortega
-Mensaje original-
Hi!
I will change InnoDB so that it all
Hi,
Can anybody help me ?
It seems that "INSERT" is blocking my process when there is no more free
space in the file system that contains my databases.
Can anybody clarify this point, and tell me how to prevent this blocking
point ?
Thanks
---
Dear members,
Wish you a Happy New Year 2002
I created FullText Index and in the sql using 'where match(...,,)
against ('searchstring')'. It is working fine for exact full words. How to
operate for pharses i.e.
The query should fetch even if the search string is substring of a column
value
Hello,
I have a relatively simple question to ask. Any help is
great appreciated.
Let us say that I want to create a classic table
that would have columns for a persons name, eye color,
age, etc.
However, I also want to store a list (somewhere) of that particular
persons favorite foods (
Thanks, now I got that working... When I used MyODBC I had to use
"option=16386;" in the connectionstring to set the change bigint to int
option when i use count(*) and Group By queryes. How do I set this in
MyOLEDb???
- Original Message -
From: "Fredrick Bartlett" <[EMAIL PROTECTED]>
To:
Hello Sammy & Martin,
Thank you for your notes and assistance.
** Martin;
> Try using the -S option to select the instance via the Unix domain
> socket rather than the port number (assuming this is a Unix
> installation).
** Sammy;
> use --socket instead of -P would solve your problem.
>
> with
use --socket instead of -P would solve your problem.
without -h, socket file is used for connection. since you've not specified the socket
file, the default socket file path is used (in some case, /tmp/mysql.sock). that's why
you're always shutting down the first one.
Happy new year.
On Mon,
On Mon, 2001-12-31 at 10:08, Emmanuel van der Meulen wrote:
> Hello all,
>
> I'm in a spot, I'm managing to successfully run several instances of MySQL,
> say on port=3306 and port=3308.
>
> When I use shutdown, the instance which started first shuts down.
>
> To shutdown the instance started o
Hello all,
I'm in a spot, I'm managing to successfully run several instances of MySQL,
say on port=3306 and port=3308.
When I use shutdown, the instance which started first shuts down.
To shutdown the instance started on port 3306, I use;
mysqladmin -P 3306 -u root -p2000 shutdown
And to shutd
Hi,
Please I need help.
I am a new to the Mysql, and want to know if is it
possible to get or update database managed with
oracle.
In our dept (of University institute) we want to use
Mysql for many reason, one of them we use linux
system, Unfortunatley we need to get some informations
from anothe
45 matches
Mail list logo
