At 01.01.2002 23:12, you wrote:
>OK... let's say I have two tables. Let's say one is an inventory
>table, a bunch of items. One of the fields is for the inventory
>items that have been sold, and are keys to the second table, which
>is a list of customers; names & addresses.
>
>So let's say I w
v.v.simple
download the window binary of version of mysql(latest) and go
next,next,next..:-)
only thing if install on anywhere else other than C:\mysql you'll have to
place a file called my.cnf in you C:\ directory, there'll be a line there
asking you to pint to the installation directory.
T
Hi Jaime and all,
Thanks Jaime to reply me message so fast !
I would like to set 2 different user to maintance MySQL machine.
1st user can maintance the Unix box and MYSQL program
2nd user ONLY can maintance the MySQL program
That's why I need to set another user to run MySQL program ( Now only
OK... let's say I have two tables. Let's say one is an inventory
table, a bunch of items. One of the fields is for the inventory
items that have been sold, and are keys to the second table, which
is a list of customers; names & addresses.
So let's say I want to pull out all inventory items acq
Dear All,
I'm new comer,
I want to ask about Installation MySQL for Windows
Family.
Thanks
Ardian
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
I have one single table, logging site activity as a security precaution.
I want to generate a report, including items of a certain type, but only if a seperate
type has not taken place
after the timestamp within the first type.
log_data_sig
++-+---++
My question pertains to the implementation of stored procedures in MySQL.
According to the MySQL documentation, this is scheduled for the 4.1 release.
Is this still accurate?
When will we be seeing the first downloads of 4.1 available?
Thanks,
Dennis
***
Hi,
Wasnt MySQL supposed to run as SU or ROOT or Administrator and
then create users within MySQL with restrictions?
What you trying to do was give "RUN MySQL rights" to your unix
users. What if 3 unix users tried running mysql independently
of each other and each mySQL process were trying to o
Dear all,
How I can set a different user to run MySQL (only root can run this program
now) ?
Error message when run the program from user:
bash-2.03$ ./mysql --host=192.10.0.113
bash: ./mysql: Permission denied
Is it something have been change on the usr/group setting for the mysql
directory?
psm 996 --
The real question is:
Does MySQL support "sub query", the short answer is 3.x.x does not,
4.x.x is supposed to.
The longer answer(and work arounds) to the 3.x.x question can be found here:
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
David
*
Julian --
There is the generic WHERE keyords ='%string%', but more to the
point here the link to the docs for regrex goodies:
http://www.mysql.com/doc/manual.php?search_query=regular+expression&submit=S
earch&depth=0
David
> Hi,
>
> I have recently gained access to mysql (new isp), and am co
Hello mysql,
I've found the following problem often happens to me:
Then mysqld restarted unclear (sigsegv or server reset) the mysql
client library may hang during the automatic reconnect. The backtrace
is similar to this and does not changes other time (at least 2 hours
is not enough for it)
Richard --
Did you set the --prefix=/usr/local/mysql when you ran config? If not
Your bin are located in /usr/local/bin maybe /usr/local/sbin?
The start script is saying the either the programs not ther or you
have a permissions problem?
Did you create user and group mysql,
Install as above
Hi folks,
I am still new in the mysql world. I have just installed mysql but it
when I try to start it (/usr/local/mysql/bin/safe_mysql &) I get the
following error massages in the linux.err file:
020101 19:51:58 mysqld started
^G/usr/local/mysql/libexec/mysqld: File './linux-bin.1' not found
Hi,
I have recently gained access to mysql (new isp), and am converting my old
text databases to sql ones. I had a text database with a field 'keywords'. I
have entered them as one field, What I want to do is submit a query where I
can ask if this field CONTAINS rather than equals a string. Can y
Would anyone know how the query below could be written to support MySQL?
my $stmt = qq{select distinct p.symbol, i.name
from portfolio p, stockinfo i
where p.symbol = i.symbol };
$stmt .= qq{and p.symbol in
(select distinct symbol from portfolio where $res)
Hello I receive message from :
the 31/12/2002 and then from the 01/01/2003 and now seems to works from the
01/01/2002.
?
sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
David J Jackson wrote:
>
> database,mysql,sql
>
> ALL --
>
> For reason unknown I seeing the unsubscribe information, for any
> email I read or reply, here's what I'm talking about:
> NOTE: I don't have this problem on the other list I subscribe to?
>
> Thanks,
> David
>
David:
This behavio
Is there a why to append a feild in mysql as apposed to
updating? For event log table for a datacenter.
Or is this something that would be better handled at
the script level?
Thanks
David
-
Before posting, please check:
htt
database,mysql,sql
ALL --
For reason unknown I seeing the unsubscribe information, for any
email I read or reply, here's what I'm talking about:
NOTE: I don't have this problem on the other list I subscribe to?
Thanks,
David
> Before posting, please check:
> http://www.mysql.com/manual.ph
Here's what I use (a little different):
use DBI;
use diagnostics;
use strict;
my ($dbh,$sth);
my ($dbname)="pickle";
my ($login)="picklesql";
my ($password) ="pi56fb";
my (@ary);
#
$dbh = DBI->connect("DBI:mysql:$dbname",$login,$password)
or die "Can't connect to $dbh: $dbh->errstr\n";
$s
Here's what I use:
use DBI;
use diagnostics;
use strict;
my ($dbh,$sth);
my ($dbname)="pickle";
my ($login)="picklesql";
my ($password) ="pi56fb";
my (@ary);
#
$dbh = DBI->connect("DBI:mysql:$dbname",$login,$password)
or die "Can't connect to $dbh: $dbh->errstr\n";
$sth = $dbh->prepare("SE
Here's what I use it should tell you exactly what your problem is:
Also check out tutorial on http://www.porlmonks.org.
-- David Jackson
use DBI;
use diagnostics;
use strict;
my ($dbh,$sth);
my ($dbname)="dataase_name";
my ($login)="login_name";
my ($password) ="your_pasword";
my (@ary);
#
$d
You are executing, $dbobj the database object. You should execute the statement
handle.
The code should be:
$query = "SELECT UserID,Name FROM test";
$sdb = $dbobj->prepare($query);
$sdb->execute();
Placed At :
"Clinton Hesse" <[EMAIL PROTECTED
The $dbh connect code should be like this:
$dbh=DBI->connect("DBI:mysql:datrtabase=radio';host=localhost",root,"password",
{RaiseError=>1});
If there is an error, you can catch it using, die statement.
Placed At :
John Mayson <[EMAIL PROTECTED]
On Tue, Jan 01, 2002 at 04:49:29PM +0200, Barak Dotan wrote:
> Hi.
hey!
> i tried (without any success to check if the table "user1" was allready
> created in the SQL database.
you can do a "show tables" query, and see if table "user1" is one of the
results.
grtz, Tijn
--
4:25PM up 104 day
Hi!
Ok, the appropriate parameter
mysqld --defaults-file=your_path_to_my_cnf
already exists with which you can explicitly specify what my.cnf file mysqld
reads in.
Regards,
Heikki
>Date: Sun, 30 Dec 2001 23:23:18
>To: [EMAIL PROTECTED]
>From: Heikki Tuuri <[EMAIL PROTECTED]>
>Subject: Re: Mu
Hi.
i tried (without any success to check if the table "user1" was allready
created in the SQL database.
can you please send me a function (or a little code in c) that check this
issue
thanx allot
Dotan Barak
Tel: +972-(0)4-8321303
Email : [EMAIL PROTECTED]
---
>Description:
When dumping a database with mysqldump using the "--opt"
parameters, certain databases fail being dumped:
/usr/bin/mysqldump: Got error: 1017: Can't find file: './db33862090/CKNPRJ.frm'
(errno: 24) when using LOCK TABLES
By replacing "--opt" with
"--
29 matches
Mail list logo
