I've created a test table with two columns. The first
one is a varchar type for inputting first names. The
second column is datetime. The table will eventually
expand to include a timestamp column, so I am not
interested in getting that to work at this time.
If I use MySQL monitor, I can use
Description:
The command
GRANT ALL ON dbname.* TO larry@% IDENTIFIED BY 'larry123';
FLUSH PRIVILEGES;
properly changes the mysql.user table. However, if I subsequently
attempt to use the mysql client like this
mysql -h myhostname -u larry -p dbname
and enter 'larry123'
On Tuesday 24 December 2002 10:30, [EMAIL PROTECTED] wrote:
I've created a test table with two columns. The first
one is a varchar type for inputting first names. The
second column is datetime. The table will eventually
expand to include a timestamp column, so I am not
interested in
Hi
I am using MySQL version 3.23.49 with one master and one slave that can
change of course. Lately I've been using the option to not replicate
certain tables (replicate-ignore-table) and it is not working for
inserts.
My my.cnf file in the slave looks like:
[mysqld]
log-bin
server-id=2
Hi,
I have installed mysql max 4.0.4 beta on a Suse (ver. 8.0) linux server and
I have created a database with this schema:
CREATE TABLE ecoras (
rsnum tinyint(4) NOT NULL,
rsori tinyint(1) NOT NULL,
rscod int(11) NOT NULL,
rsid int(11) NOT NULL auto_increment,
rsdat date NOT NULL
Well, I don't really agree with that.
I've tried to load data in file with a datetime field and it worked very
well.
Obviously, I could advice you to create a field with datetime type and
don't forget to format your input datetime in your file like that:
-mm-jj hh:min:ss (without the
Hello
when using mysqlcc and adding for russian symbols into database fields,
it represents as ??
When using other client - all is o'k.
the repeatable steps are:
1. open mysqlcc
2. open some table
3. enter in the field of type string some russian letters
4. uddate this record
5. see the
It's not a true daemon...Mike's comment on using a wait or waitpid is
valid. If you're interested, read up on daemon processes in APUE (chap.
13) from Stevens. Your process is still associated with a terminal and
is not the process group leader and is not the session leader.
I highly recommend
What type of reports you want ?
Probably you will have to develop your customized app to get the reports you
want.
Insane
- Original Message -
From: geeta varu [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 24, 2002 12:25 PM
Subject: reports
sir,
i would like to
Hello,
I'm a beginner with mysql and i installed it with linux.
I'm getting this message when i tried to be connected :
Error 2002 : can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111).
Can you help me by finding how to be connected to the database ?
service mysql start
Search the list for more information
Adolfo
On Tue, 2002-12-24 at 09:07, Amitié Plus wrote:
Hello,
I'm a beginner with mysql and i installed it with linux.
I'm getting this message when i tried to be connected :
Error 2002 : can't connect to local MySQL server through
mysql:ÄúºÃ!
http://www.zgda.net/index.asp?id=265
50ÔªÈËÃñ±Ò£¬¶ÔÄúÀ´ËµÒâζ×Åʲô£¿
Ò»²ÍÂôµ±ÀÍ£¿¶þÕŵçӰƱ£¿»¹ÊǼ¸°üÏãÑÌ£¿
µ±È»£¬ÄúÓÐÄúµÄÑ¡Ôñ£¡
¿ÒÇëÄú¸øÎÒÒ»·ÖÖÓ£¬ÈÃÎÒ˵˵50ÔªÔÚÕâ¸öÐÂÐ˶øÕýÔÚѸËÙ·¢Õ¹µÄMLMÍøÕ¾
http://www.zgda.net/index.asp?id=265
Òâζ×Åʲô£º
Larry,
GRANT ALL ON dbname.* TO larry@% IDENTIFIED BY 'larry123';
FLUSH PRIVILEGES;
properly changes the mysql.user table. However, if I subsequently
attempt to use the mysql client like this
mysql -h myhostname -u larry -p dbname
and enter 'larry123' at the
Hello all,
I'm quite newbie with MySql, so i apologize if this is a trivial question.
I did a small database, but fortunately not yet in production.
This Week-End happened a power cut and I didn't made any backup of my
databases :(
When i restarted Mysql, i could not log in as any user i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 19 Dec 2002, Michael Widenius wrote:
With 'DROP DATABASE database_name'.
Through the depricated client function 'mysql_drop_db()'.
The first case works correct but in the second case the grant check
is not done. I tracked this down
I have the following problem:
I use Delphi 7 in combination with TADOquery and MyODBC 3.51.
I got unspecified error when i run the next query:
- qry.SQL.Add('select * from lokalen');
- qry.open;
if i define the query on design time (in the property SQL of
TADOQuery), it works fine.
-
Hi.
It's Christmas and I'm sending my wish list to Santa Claus...
;o)
1. hierarchical queries
I've seen an interesting patch to PostgreSQL to implement
hierarchical queries similar to those available with Oracle
(http://gppl.terminal.ru/readme.html).
This kind of query makes handling trees
Hi people,
I have a problem running mysql 4.0.4 using mostly innodb tables: mysql
starts without any problems, then after about a half-hour it returns
queries with errors that databases are not found. And indeed, show
databases command shows the single database with a name vi.recover. The
system
Hi
Subject says all, is everything fine when I just flush-logs every
morning and remove every logfile that is older than 30 days?
Or do I have to delete the corresponding line from the index file as
well? Whatfor is it needed, btw?
bye,
-christian-
# for the bot: mysql php query
On Sunday 22 December 2002 08:06, wrote:
Mysql,
Selecting from `dual` with a simple query works fine,
mysql select 1 x from dual;
+---+
| x |
+---+
| 1 |
+---+
but within a derived table,
mysql select * from (select 1 x from dual) s;
ERROR 1146: Table 'test.dual' doesn't
On Monday 23 December 2002 22:21, Gordon wrote:
DID DELETE FROM XXX with no where clause stop acting like truncate in
4.0.5?
In 3.23.51 and earlier versions of 4.0.x
mysql delete from product_order_main;
GIVES THIS
Query OK, 0 rows affected (0.10 sec)
AND RESETS THE AUTOINCREMENT
On Tuesday 24 December 2002 15:07, AmitiИ Plus wrote:
I'm a beginner with mysql and i installed it with linux.
I'm getting this message when i tried to be connected :
Error 2002 : can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111).
Can you help me by
I wish to get a count of records contained in 1 table as compared to the
contents of a different table. What I have is a list of realtors in 1
table (agents.name) The listings are contained in a different table
(listings) and each can be identified by their agent by listings.agent.
Here's the
Hello.
I'd like to report a bug I've found with MySQL. MySQL, as shipped with Mandrake
9, gets hanged when starting it with safe_mysqld or service mysql start
or /etc/rc.d/init.d/mysql ALWAYS WHEN NSS_LDAP IS ENABLED! I'd like to report
this so that you can try if it's a bug from mysql or
I had the same problem. I fixed it by realizing that when the program was
installed it put the mysql.sock file in the /var/libs/mysql dir however
when it starts it looks for the file in /tmp You can either change the
folder it looks in, or do what I did and just copy the mysql.sock from
multiple database connection
on windows 98 , mysqld running with pws
here is some confusion with the multiple database
connection variables
i am executing the same code in three different ways
it gives me diffrent output
all the database and table are exsists
method 1
--
?php
On Tue, 2002-12-24 at 12:11, [EMAIL PROTECTED] wrote:
I wish to get a count of records contained in 1 table as compared to the
contents of a different table. What I have is a list of realtors in 1
table (agents.name) The listings are contained in a different table
(listings) and each can be
Hi, ladies and gentleman!
Well, I have solved my problem, though it was not actually a problem,
I just wanted things to look cool :)
1. Download Time::HiRes perl module
http://search.cpan.org/CPAN/authors/id/J/JH/JHI/Time-HiRes-1.39.tar.gz
2. Install it: perl Makefile.PL; make; make test; make
Victoria,
I pulled that latest updates to the 4.1 tree to make sure I had the most
recent version and I still have the same problem. Here is a log of my
actions.
# cd /usr/local/mysql-4.1
mysql-4.1 # bin/mysql --defaults-file=etc/my-small.cnf -u root
Welcome to the MySQL monitor. Commands
I'm a beginner with mysql and i installed it with linux.
I'm getting this message when i tried to be connected :
Error 2002 : can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111).
Can you help me by finding how to be connected to the database ?
Make sure
Hi: How do you increase the cache size in MySQL? Which parameter should I
tweak, and also how do I find out the current default cache size?
If there are multiple caches in MySQL, I would welcome suggestions
pertaining to all or any of them. Thanks!
Geetika
In the last episode (Dec 24), Richard Clarke said:
Victoria,
I pulled that latest updates to the 4.1 tree to make sure I had the most
recent version and I still have the same problem. Here is a log of my
actions.
# cd /usr/local/mysql-4.1
mysql-4.1 # bin/mysql
To start the server run the following...
service mysqld start
once it is started you can check to see if it running by using...
ps aux
which will show the processes running and look for mysql
Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388
-Original Message-
From: Scott Pippin
Dan,
According to http://www.mysql.com/doc/en/News-4.1.0.html
SELECT ... FROM DUAL is an alias for SELECT (To be compatible with
some other databases).
Your example does work however.
mysql select * from ( select 1 ) d;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)
At 12:37 +0300 12/24/02, [EMAIL PROTECTED] wrote:
Description:
The command
GRANT ALL ON dbname.* TO larry@% IDENTIFIED BY 'larry123';
FLUSH PRIVILEGES;
properly changes the mysql.user table. However, if I subsequently
attempt to use the mysql client like this
mysql -h
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Richard Clarke wrote:
Dan,
According to http://www.mysql.com/doc/en/News-4.1.0.html
SELECT ... FROM DUAL is an alias for SELECT (To be compatible with
some other databases).
Your example does work however.
mysql select * from ( select
Fellow MySQL'ers,
I've been trying to install MySQL ver. 3.23.54a on NetBSD 1.6 on an i386
platform.
The difficulty I've been running into is that the thing complains that it
can't change directory to pthreads during compile. I've tried installing the NetBSD
pthreads package
Geetika,
If there are multiple caches in MySQL, I would welcome suggestions
pertaining to all or any of them. Thanks!
SHOW VARIABLES will show you what caches are set for your MySQL
installation. E.g., I do:
mysql select version(); show variables like '%cache%';
+---+
|
Thanks very much, Stefan. Merry Christmas! :-)
Geetika
On Tue, 24 Dec 2002, Stefan Hinz, iConnect (Berlin) wrote:
Geetika,
If there are multiple caches in MySQL, I would welcome suggestions
pertaining to all or any of them. Thanks!
SHOW VARIABLES will show you what caches are set for
help!
i have a table which is 1GB and 5 mio records. i must add new index
to live table but every time i try to do it, it takes 15 minutes,
mysql is working, then it dies saying it ran out of available
connections. if i increment them, same result. i am doing this through
phpMyAdmin but i think
Hello mysql,
Hello mysql,
shell#resolve_stack_dump -s mysqld.sym -n mysqld.stack
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be
I portaded my Application from the MS SQL Server 7.0 to MySQL 3.23.54 and
i'm having problems with the both syntax.
How can i do this query in MySQL Server Syntax:
select sld_vlprov,hist_lanc from sld_lanc,lanc
where sld_lanc.sld_user *= lanc.user_usuario and
dt_movlanc '02/12/03'
mysql, query, sql
(B
(BHello folks
(B
(B Is there any way I can insert Chr(13) Chr(10) along with string
(Bcharacters in a blob field using *insert* or *update* statements.
(B
(B
(B
(BThanks for any suggestions
(B
(BKayambooSuresh
(B
(B
mysql, query, sql
(B
(BHello folks
(B
(B Is there any way I can insert Chr(13) Chr(10) along with string
(Bcharacters in a blob field using *insert* or *update* statements.
(B
(B
(B
(BThanks for any suggestions
(B
(BKayambooSuresh
(B
(B
44 matches
Mail list logo