On Thursday, 7. March 2002 07:18, Josiah Wallingford wrote:
Would the command by mysql -u
username -p password dbname filename.sql(mysql)
No, just use
mysql dbname -uusername -ppaswwod filename.sql
Regards
Georg
-
On Wed, Mar 06, 2002 at 11:06:18AM -0800, Sam Iam wrote:
We have a very high volume site (3 million page views a day) that's
run on 16 Apache / PHP web servers 2 MySQL servers. We are using
PHP with persistent connections. Each MySQL serves 8 web servers
is supposed to act as a failover
Bonjour,
I have a problem with Mysql and access rights :
I have a user who has rights to access tables in the database
'membres' :
#/ mysqlaccess 192.168.0.1 myuser membres
Could not open outputfile
I record some stock data into MySQL, I'm looking for the correct
syntax for a SELECT statement.
SELECT min(Tmin) FROM quotes WHERE low=min(low)
In short, I want the time of the occurance of the low for the day,
Tmin is time column. Once the low is achieved, all the remaining data
for the day
please tell me how to install mysql for sco unix 5.0.5???
need file???
thank you !!!
__
===
ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn)
We have 10 of the 3ware cards, and while the drive is GPLd and in
the kernel, we have not been satisfied with the stability of the
system
Is there anything that I can avoid while still using the card (ie; specific
RAID config)?
We haven't had a chance yet to qual the
Erik,
Thursday, March 07, 2002, 12:58:26 AM, you wrote:
ES Trying to figure out how to convert Sybase ASA syntax to MySQL. Need to
ES select alpha ranges as in:
ES SELECT *
ES FROM table
ES WHERE name LIKE '[A-Z]%'
ES but this doesn't work.
You should use REGEXP instead LIKE. REGEXP has more
Josiah,
Thursday, March 07, 2002, 8:18:58 AM, you wrote:
JW I know how to inport a .sql file into mysql by using mysql -u username -p
JW password filename.mysql(sql) but how do you import one that is made to go
JW into a database you already have created? Would the command by mysql -u
JW
José,
Thursday, March 07, 2002, 3:08:13 AM, you wrote:
JHFT I've already installed MyODBC and configured the driver correctly
JHFT (accoriding a book I'm reading) at ODBC User DNS. But, when I run Database
JHFT Desktop and gonna make a New Table the option of MySQL does not appear
JHFT
ld99ba,
Thursday, March 07, 2002, 11:22:15 AM, you wrote:
l please tell me how to install mysql for sco unix 5.0.5???
l need file???
You can find info how to install MySQL binary distribution at:
http://www.mysql.com/doc/I/n/Installing_binary.html
Check also the following link. You can
The first query shown in the log is the one I actually tells ADO.Open to run...
however just after that one it runs two more (the
two tables includes in the first query) select * queries... Why??
This slows down the ADO a lot. Even Jet4.0 doesn't do that on the same query and is
therefore about
Rutledge,
Wednesday, March 06, 2002, 10:01:56 PM, you wrote:
Reoen In my application I would like to update a MySQL record where one
Reoen column
Reoen is the largest value. Do I have to create a separate SELECT sql query
Reoen statement
Reoen to get that value and then update it? Or, is
Hi
In mysql I found a problem with between query.
For example
select * from bugdetail where
dbugcreate_date between from_days(to_days('2002-03-01')) and
from_days(to_days('2002-03-04'))
this query shows only those records up to '2002-03-03' instead of
'2002-03-04'
pl. help
Manish
Hi
In mysql I found a problem with between query.
For example
select * from bugdetail where
dbugcreate_date between from_days(to_days('2002-03-01')) and
from_days(to_days('2002-03-04'))
this query shows only those records up to '2002-03-03' instead of
'2002-03-04'
Are all that date
Hi!
On Mar 07, Thomas Spahni wrote:
On Wed, 6 Mar 2002, Sergei Golubchik wrote:
mysql SELECT doc FROM plaintext WHERE MATCH(bgetxt) AGAINST('placi*' IN
BOOLEAN MODE);
Empty set (0.00 sec)
It is a bug.
You can - either create a repeatable test case, to be sure,
the bug
Hi there,
I am interested if there any URL I can read more about text type fields
in MySQL.
I had an argument with a friend who said that if I use text type in a
table it will make the system to work to slow.
But I realy needed this text field because I wanted to store text more
than 256 symbols.
Hi MySQL,
I record some stock data into MySQL, I'm looking for the correct
syntax for a SELECT statement.
SELECT min(Tmin) FROM quotes WHERE low=min(low)
In short, I want the time of the occurance of the low for the day,
Tmin is time column. Once the low is achieved, all the remaining
Hi!
How do i check if a column(name) do not exists in a table before i add it?
Like: alter table fruit add aple varchar(20) not null if aple do not exists
Best regards
Oyvind
mysql
-
Before posting, please check:
Hi Alexander,
I am interested if there any URL I can read more about text type
fields
in MySQL.
I had an argument with a friend who said that if I use text type in a
table it will make the system to work to slow.
But I realy needed this text field because I wanted to store text more
than
On Thu, 7 Mar 2002 12:03:05 -
DL Neil [EMAIL PROTECTED] wrote:
Hi Alexander,
I am interested if there any URL I can read more about text type
fields
in MySQL.
I had an argument with a friend who said that if I use text type in
a
table it will make the system to work to slow.
Alexander,
go ahead and use those fields of type TEXT. Retrieval works like a
charm.
Building the index on large tables may be slow, but the manual gives
some
tricks how to speed things up. As soon as you have VARCHAR fields you
are
into variable record lengths anyway. And you can even
On Wed, 6 Mar 2002, Sergei Golubchik wrote:
mysql SELECT doc FROM plaintext WHERE MATCH(bgetxt) AGAINST('placi*' IN
BOOLEAN MODE);
Empty set (0.00 sec)
It is a bug.
You can - either create a repeatable test case, to be sure,
the bug will be fixed in 4.0.2, ...
Hello Sergei,
here is
Hi Monty and Sasha,
Just a quick not to say that's such a great idea that Monty even
thought of it before! Monty and I discussed this last September, I
hope we could get something like this in 4.1
Just a vote!
Thanks Ken
- Original Message -
From: Sasha Pachev [EMAIL PROTECTED]
All,
How can I notify an application running on the slave server that the slave
database has just updated itself by means of replication. The reason I ask
is that I know MySql currently doesn't support triggers, but my application
needs to be notified when an update on the slave has just taken
Ok people, I'm desperate for the help. I'm going to try to be as detailed
as possible, because I need the two year old explanation. I recently
installed MySQL on my Cobalt Raq3. I was running fine, created a db, table
created a user, gave some permissions, and thought I was rolling along.
Hello,
I don't know if this is possible but I need to change the
ft_min_word_len variable from 4 to 2. The machine mysql is running on
is Debian so I would like to try to do this without recompiling it if
possible.
Thanks,
Keith
###
Hi, I want to lock a row in a table, and just the row I have selected
what's the solution under MySQL
Thank's
Dominique
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Thursday, March 07, 2002, 4:49:57 PM, you wrote:
d Ok people, I'm desperate for the help. I'm going to try to be as detailed
d as possible, because I need the two year old explanation. I recently
d installed MySQL on my Cobalt Raq3. I was running fine, created a db, table
d created a user,
InnoDB!
--Walt
-Original Message-
From: Dominique DUTENDAS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 8:02 AM
To: MySQL
Subject: Lock row
Hi, I want to lock a row in a table, and just the row I have selected
what's the solution under MySQL
Thank's
Dominique
* oe-ander
How do i check if a column(name) do not exists in a table before i add it?
Like: alter table fruit add aple varchar(20) not null if aple do not
exists
As far as I can see, you have two options:
- Do a describe fruit, and check the Field column
- Do the alter table..., and check for
At 12:06 +0200 3/7/02, Egor Egorov wrote:
Josiah,
Thursday, March 07, 2002, 8:18:58 AM, you wrote:
JW I know how to inport a .sql file into mysql by using mysql -u username -p
JW password filename.mysql(sql) but how do you import one that is
made to go
JW into a database you already have
At 9:35 -0600 3/7/02, Paul DuBois wrote:
At 12:06 +0200 3/7/02, Egor Egorov wrote:
Josiah,
Thursday, March 07, 2002, 8:18:58 AM, you wrote:
JW I know how to inport a .sql file into mysql by using mysql -u username -p
JW password filename.mysql(sql) but how do you import one that
is made to go
Can the data directory reside on a different machine than the mysql program
itself, such as on a maxattach storage device.
Thanks,
stephen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi members,
This is my first query :)
My query is about installing MySql on Solaris.
I am interested in downloading and installing the stable version of
MySql on solaris 2.6.
I downloaded mysql-3.22.25-solaris7-x86.pkg.tgz and MySQL 3.23.
I tried to install the first one (used GNU tar) . I
Ahmed,
Forget about it. I tried to do this, I tried for about two weeks, then got mad
and downloaded the src and compile it mysql. It works great.
-chad
if you do get it working let me know
On Thu, 07 Mar 2002 09:14:58 -0700
Ahmed S K Anis [EMAIL PROTECTED] wrote:
Hi members,
This
Could anybody please help:
In the query I have included a limit string which allows me to display
individual records page by page. The limit string variable is
incremented/decremented using hyperlinks. I feel it would be better if I
could somehow manually step through the returned
$query_data =
Bonjour,
I have a problem with Mysql and access rights :
I have a user who has rights to access tables in the database
'membres' :
#/ mysqlaccess 192.168.0.1 myuser membres
Could not open outputfile
Hello all,
I am new to linux. I was told that I need DBI::DBD to connect to Mysql
using perl. So I go to http://www.mysql.com/downloads/api-dbi.html and
downloaded DBI-1.18.tar.gz, Msql-Mysql-modules-1.2216.tar.gz. Using gunzip,
I unziped the two files. Now I have DBI-1.18.tar and
Bonjour,
Did you try to connect to the server from network ?
Try to force mysql client not to use the socket (what is does when
it's connecting to localhost).
Try to connect from another server or even from the same server but
with the --host=xxx.xxx.xxx.xxx where
$sql=select * from table where blah=$blah;
$x=mysql_query($sql);
while ($data=mysql_fetch_array($x)) {
echo $data[columnName];
}
I think is what your trying to do...
On Thu, 7 Mar 2002, Gavin Philips-Page wrote:
|Could anybody please help:
|
|In the query I have included
On Thu, Mar 07, 2002 at 08:37:00AM -0600, Thi Cao wrote:
All,
How can I notify an application running on the slave server that the
slave database has just updated itself by means of replication. The
reason I ask is that I know MySql currently doesn't support
triggers, but my application
I actually wound up pulling down a deb-src and changing
myisam/ftdefs.h
#define MIN_WORD_LEN 2
Compiled a .deb out of it and put it in. Seems to be working. Thank
goodness they made this a varible in 4.0.
K.
* Paul DuBois ([EMAIL PROTECTED]) wrote:
Date: Thu, 7 Mar 2002 09:33:09 -0600
Hi Gavin,
I didn't know if you knew this or not but there is a site which
provides lives PHP / MySQL support. Take a look at http://www.phphelpdesk.com . It
is a live PHP support site which helps you get real time answers to PHP problems.
Keith
* Gavin Philips-Page ([EMAIL PROTECTED])
Jeremy,
I'm not sure I follow. What information from that command would the app be
looking for specifically. Maybe you're saying the app should look at the
position of the master's binary log file. Is that what you suggest?
Thi
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL
On Wed, 2002-03-06 at 14:26, Thi Cao wrote:
When I grant privileges as follows, the slave gets updated:
GRANT FILE ON *.* to repl@'%' identified by 'some_password';
Could someone please tell me why I must grant the FILE privilege on all
databases for the repl (slave) to be able to update
On Thursday 07 March 2002 12:42 am, Jeremy Zawodny wrote:
My 4.0.2 slave has run through about 14 million queries and it's going
well.
Good news
Do you have any feel for how much slower a debugging version of MySQL
is compared to a normal version? ?I ask because my replication
heartbeat
ds,
If I understand you correctly, that also means that the user repl can access
the mysql database where all the privilege info is stored and see the
permissions, passwords, and such. Yes/No?
Thi
-Original Message-
From: ds [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002
On Thu, Mar 07, 2002 at 09:57:54AM -0700, Sasha Pachev wrote:
On Thursday 07 March 2002 12:42 am, Jeremy Zawodny wrote:
Do you have any feel for how much slower a debugging version of
MySQL is compared to a normal version? ?I ask because my
replication heartbeat monitor has noticed this
For $26 a month! That'll buy some excellent reference material instead :)
On Thu, 7 Mar 2002 11:47:51 -0500, Keith Elder [EMAIL PROTECTED] wrote:
Hi Gavin,
I didn't know if you knew this or not but there is a site which
provides lives PHP / MySQL support. Take a look at
Hi,
On Wed, 2002-03-06 at 15:50, Scalper wrote:
If I create a temporary heap table from a select statement, does the new
table also inherit the indexes (indices?) from the original table. Or will
I think that every CREATE [...] TABLE [...] SELECT does not inherit any
indexes (doesn't
Thank you all for your insight. Here's the query I'm using and it works
great!
mysql SELECT log.id,
if (empnum.fname '', log.id, 'No Record') AS 'fname',
if (empnum.lname '', log.id, 'No Record') AS 'lname',
SUM(log.hours) AS 'hours'
FROM log LEFT OUTER JOIN empnum
ON log.id = empnum.id
Hi
I am just installing a new MySQL server at the moment.
We are using PHPMyAdmin witch is ok as we can limit what each user can do,
but
some tables do not work with it.
We have 2.1.0 at the moment.
Do I
1. Just go for the latest PHPMyAdmin
2. Use MySQL GUI (can I restrict what each
Hi all,
I have just installed MySQL recently. I already set the root password and
some databases testing and everything worked fine. However, I accidentally
changed the root to anonymous yesterday. After that, I couldn't add new
users and do some administration tasks even change password myself.
Is there a way for me to NOT have a default value for a column in a table
that I define as NOT NULL?
EXAMPLE SQL:
mysql CREATE TABLE FOO (foo1 int NOT NULL);
Query OK, 0 rows affected (0.05 sec)
mysql DESCRIBE FOO;
+---+-+--+-+-+---+
| Field | Type| Null |
On Thursday, March 7, 2002, at 12:38 AM, Jeremy Zawodny wrote:
Are the Web servers doing write operations on the database, or
read-only?
read-only now.
Can you talk a bit about how Yahoo Finance does it as far as # of web
servers to MySQL servers ? Apache PHP tuning ?
- Sam.
Those of you using PHP with MySQL who may be looking for alternatives
may be interested in this white paper just released.
Enjoy!
CC
FOR IMMEDIATE RELEASE
March 7, 2002
BLUE WORLD ANNOUNCES LASSO VS PHP WHITE PAPER
Report highlights differences in
You have this table:
id data
3 2
2 1
1 3
This query:
SELECT @var, data, @var:=data+(IFNULL(@var,0)) FROM table
What would result would you expect the first time you execute the query?
I would expect this:
NULL, 2, 2
2, 1, 3
3, 3, 6
But this is what you get the first time:
NULL, 2, 2
NULL, 1,
rep1 would gain FILE access to all ( not sure what the really entails )
it would not have SELECT access, so can not read from it
mind you if they have enough info to get in with rep1 access, then they
could just replicate everything on thier own server and read till thier
hearts content
Hi,
I need help in turning on the slow query log option on the my.ini file.
I've tried uncommenting it and when I tried to run the nt-max it says it
couldn't recognize the option. Here's what I have for my.ini file, any
other way I have to type it? Please advise.
slow query
Situation: mass virtual website hosting, with php/perl/python. One
master mysql server, one or more replicated slaves.
Question: would it be possible/feasible to write a daemon that accepts
connections on behalf of mysqld, and depending on what type of query it
is (updating or selecting) farm
Dear sir
I have a problem to install MySQL for windows on my standalone PC.
When I run 'WINMYSQLADMIN.EXE' from dos prompt or windows explorer then it
did not run and gives and error message
'Access violation at address 00040298D in module 'WINMYSQLADMIN.EXE'. Read
of address '
when I
At 1:19 PM -0500 3/7/02, Chuck \PUP\ Payne wrote:
But who wants to pay. Get a clue that's why PHP, PERL, and other Open Source
Lang., are widely more used.
If you do a true comparison in features, you'll see that a PHP-based
solution (with commercial add-ons) costs over three times the cost of
Ok, that worked. I started MySQL. I still don't know how to shutdown
mysql, or if that was my problem. Unfortunately, that is the ONLY way
I can log into mysql. Anyway, that would be fine, only now I have an
ASP script but I am a privelegas idiot, so I don't know how to set a
UID and
Yep.. this is very feasible.. And there are some packages to do this
already.
http://www.firstworks.com/sqlrelay.html
Is a good package and library/API to implement what you want to do. We
have done this in the past for a large community based website.
-Original Message-
From: John
Can you provide a NON-BIAS so-called TRUE comparison? I would be
curious on what Blueworld has to say. Also, why do you think the TCO is
lower with lasso than PHP? I don't get it, there is no cost to own it,
just to develop it. And if you develop with PHP correctly, then the TCO
is low.
I think this is should be
Learning Lasso$2500 PHP $2500
Dosent matter if the product is free it still costs you time.
Can you provide a NON-BIAS so-called TRUE comparison? I would be
curious on what Blueworld has to say. Also, why do you think the TCO
is lower with lasso than
There is a point that if you buy APC-Cache and the encoder you are
spending a lot of cache.
However there is APC, PHPCache and others that do the job.. but not as
well. PHP is mildly flawed in the sense that it is somewhat
intentionally crippled so Zend can make a profit from sites that adopt
it
Does it run on Unix?
S
-Original Message-
From: Cathy Cunningham (Blue World Lasso Evangelist)
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 10:37 AM
To: Chuck PUP Payne; [EMAIL PROTECTED]
Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper
At 1:19 PM
Hi,
You are closer.This error is generated only if you wish to connect from
the localhost or 127.0.0.1 (i believe).To avoid this inconvenient, in
arguments of mysql client,you must put -S
path_of_the_mysql.socket.Usualy mysql create the socket file in tmp
directory.You can also, made some
Are there any documented reasons why mysql would only enter certain
fields and skip others?
I am having some strange problems where it seems that data are randomly
dropped from inserts via web forms.
Have posted before stating a possible cache or proxy problem, but I am
still at a loss...
You know I had wrote but my message was kick by mysql mail list server for
spamming, I didn't mean too and I am sorry to everyone on the list. I was
trying to express my thought on an e-mail. Again sorry for spamming, all I
did was hit reply to all to the Blue World Announces Lasso vs PHP White
On Thu, Mar 07, 2002 at 09:53:51AM -0800, [EMAIL PROTECTED] wrote:
Hi,
I need help in turning on the slow query log option on the my.ini file.
I've tried uncommenting it and when I tried to run the nt-max it
says it couldn't recognize the option. Here's what I have for my.ini
file, any
Ah, the keywords with commercial add-ons. Notice the plurality, as well. I
wonder which add-ons and how many total add-ons were considered in making
this cost estimate. I also wonder if most of us would even need more than
one commercial add-on at most.
- Jonathan
-Original Message-
Hi
It a Mac and Windows thing
At 11:35 07/03/2002 -0800, Dreamtime.net Inc. wrote:
Does it run on Unix?
S
-Original Message-
From: Cathy Cunningham (Blue World Lasso Evangelist)
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 10:37 AM
To: Chuck PUP Payne; [EMAIL
At 12:30 07/03/2002 -0700, [EMAIL PROTECTED] wrote:
I think this is should be
Learning Lasso$2500 PHP $2500
This may be true if you have no knowledge of either system, but most people
on this list have a great deal of experience using PHP and for them that
would be money down the
Never mind with that.. I don't know why it was there, it was created
automatically the 1st time you run the windows gui admin. And I had to
modify it to log-slow-queries=filename and it turned out ok. Thanks anyway.
Regards,
Martin
|-+
| |
You think Blue World getting the point yet? Maybe they are thinking
twice about spamming mailing lists with their products? Maybe a better
target is Microsoft's .NET boards since both products are about the same
price
-Original Message-
From: Jonathan Hilgeman [mailto:[EMAIL
On Wed, Mar 06, 2002 at 06:19:53AM +0100, Eberhard Lisse wrote:
Hi,
I run SuSe 7.2 and have upgraded to the current suse versions of
mysql.
Server version 3.23.41-Max-log
Protocol version10
Connection linux.lisse.na via TCP/IP
TCP port3306
The list has an automatic filter that blocks any message that doesn't
contain either sql or query in it. Pain in the butt sometimes -- that's
why you'll see sql query at the bottom of a lot of people's emails, or in
their signature.
--jeff
- Original Message -
From: Chuck PUP Payne
Hi,
Anybody running MySQL on Win 2000 server here?
I just installed MySQL 3.23.49-MAX (w/ InnoDB) on a 2000 Server (Dual 1.1
GHz - 1GB RAM - 15GB HD space) and I can run it without any problem from
the command line as a standalone. However I couldn't run it as a service
even though I already
What they need is a PHP-Lasso converter, or offer a dev person to
convert your application.
Similar to ASP2PHP
MYSQL CONTENT: And does Lasso offer MySQL connection pooling?
-Original Message-
From: John Dean [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 2:59 PM
To:
Another thread pointed out that this runs on doze and Mac, I would venture to
say a lot if not most, on this list are *nix people, so the have gotton bad
press and have not targeted the correct userbase. Myself, if you spam me, I
will not look at you products. spam kills!
John
On Thursday 07
From: Cathy Cunningham (Blue World Lasso Evangelist)
If you do a true comparison in features, you'll see that a PHP-based
solution (with commercial add-ons) costs over three times the cost of
Lasso.
I try to stay out of such discussions, but your marketing-oriented spiel
inspired me to point
At 01:40 PM 3/7/2002, you wrote:
Are there any documented reasons why mysql would only enter certain fields
and skip others?
I am having some strange problems where it seems that data are randomly
dropped from inserts via web forms.
Have posted before stating a possible cache or proxy problem,
At 1:47 PM -0700 3/7/02, Van wrote:
If you do a true comparison in features, you'll see that a PHP-based
solution (with commercial add-ons) costs over three times the cost of
Lasso.
I try to stay out of such discussions, but your marketing-oriented spiel
inspired me to point out that most
I have no problem running mySQL as a service on Win2k Server.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 2:35 PM
To: [EMAIL PROTECTED]
Subject: Running MySQL as Service on 2000 Server
Hi,
Anybody running MySQL on Win 2000
I don't know what you people are talking about. I have not one clue about
anything PHP.
But, if the software performs better. Is it not better?
If at this time I wanted to think about that course of action, if both were
going to cost me the same in time and money to learn, and I took that cost
All we're doing here is providing information on a report that was just
released and answering questions and clarifying mis-perceptions.
Don't you mean All we're doing here is marketing our product to an e-mail
list ... ?
Sharing information for the betterment of the community is good for us
Hmm
Isn't price one of the the factors in doing a comparision? No matter
what project size it is, cost plays a major role. If I can save a
client $3000 by using PHP versus using Lasso, I would. It doesn't seem
Lasso has a $3000(or more) advantage over PHP/mySQL combo.
The thing is that
Hi
Suppose we have the binary distribution already installed.
1. run mysq_install_db script
2. run mysql_setpermission
3.Go to in /etc/init.d and make 2(two) symbolic link from mysqld script to
...
- K12mysqld - OS kill the daemon when shutdown.
- S12mysqld - OS start the daemon on boot.
I tried using 'tee' in MySql but it's not working.
mysql tee file.txt;
ERROR 1064; You have an error in your SQL syntax near 'tee file' at line 1
I'm running version 3.22.34-shareware-debug on Win98. Is this a problem? Do
I need to pick up a more recent version?
Thanks,
Robbie
On Mon,
Hi,
I assigned rights to a user in mysql,
mysql grant all on books.* to bookorama@localhost identified by
'bookorama123';
Then I tried to access mysql in as a regular user,
[bookorama@a177 bookorama]$ mysql -u bookorama books -p;
Enter password: bookorama123
And I get the following error
I don't have a problem and I am using 3.23.47
-Original Message-
From: Robbie Martinez [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 3:51 PM
To: Gurhan Ozen
Cc: [EMAIL PROTECTED]
Subject: RE: MS-DOS Window
I tried using 'tee' in MySql but it's not working.
mysql tee
Yes ... just went to mysql.com and I think the tee functionality
was introduced in 3.23.XX
-Robbie
On Thu, 7 Mar 2002, Todd Williamsen wrote:
I don't have a problem and I am using 3.23.47
-Original Message-
From: Robbie Martinez [mailto:[EMAIL PROTECTED]]
Sent: Thursday,
Access can do it, I have queries in access that need to be able to read
the data I imported into Mysql from access.
Can it be done, if so how
TIA
Joseph
###
Any views in this message are those of the individual sender,
except
G'day Cathy
we feel it only
fair to be given the opportunity to correct said misinformation.
You're forgetting that your original mail was forced upon us by you - in my
eyes, your right of reply is dissolved with this action. If you don't like
the negative response, don't make the
Hi
I have installed RedHat 7.2 . with Apache and DNS as default. When trying to install
MySQL with kpaackage manager I get
rpmdepCheck() fialed. I cannot see any required modules missing. Can anyone tel me
what is wrong?
Olav
The lesson here is don't preach to those who might not want to be
converted.
W.W.J.D. - after Jesus cast the demon Legion out of that one guy, the people
in that area asked him to leave and he left without any arguments. Take a
hint from the Savior, Blue World.
grin
- Pastor Jonathan Reverend
Howdy -
I've posted this twice before - third time might be the charmer...
Can anybody help me?
I am using the C API and am returning a result set from a table with a BLOB
type item in it.
When I populate the BLOB fields initially (with all the same data) the
length is returned properly when I
Perhaps I misunderstand how the UNION statement is to be used, but the
following query doesn't work as I'd expect:
SELECT column_id, SUM(column_a) AS positive_a FROM table_a WHERE column_b =
'positive'
UNION
SELECT column_id, SUM(column_a) AS negative_a FROM table_a WHERE columb_b =
'negative'
1 - 100 of 164 matches
Mail list logo