I hope this question isn't too elementary for this list. I am brand new to
mysql. Working off redhat linux 7.0. I run "safe_mysql &" I get a message
saying it is connecting and then a message "mySql daemon ended." When I run
"./bin/mysqladmin create testDB" I get the following message:
On Thu, Apr 26, 2001 at 07:36:34PM -0700, Rodney D. Myers wrote:
>
> Is there a place to purchase the MySQL manual?
The folks at NuSphere will sell you one for $79 or so. You'll get a
CD, printed manual, and support for the software.
They're at http://www.nusphere.com/
Jeremy
--
Jeremy D. Zaw
Hello all,
I had a previous post. This one might be related, don't know. I just
installed mysql 3.23.37-win on a win2000 machine. The install went
fine. Mysql starts fine. I can execute any read (select) statements on
the default tables, but anything like insert or create I get Rea
Hello all,
I'm trying to use either the SWOW FIELDS or DESCRIBE TABLE COLUMN queries
so that I can interate the structure of my tables using ADO/MyODBC in VB
and I never get Columns that are either TIMESTAMP or Auto_Increment. I've
tried using the OpenSchema method of the ADO Connection object a
Patric de Waha Lists wrote:
> Try this
>
> $host = "localhost:/var/mysql/mysql.sock"; // focus here
Nope, no dice. Same error msg (except /var/mysql/mysql.sock instead of
/tmp/mysql.sock). I didn't think it would matter either since I have a second
machine that does work, b
HI,
Try this
regs, pdw
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To
hi--
firstly, I am relatively new to mysql.
I am having a problem getting text I enter into a perl script (for reasons
of parsing and sending to my mysql database) to consistently get entered
into the database.
the perl script takes a mail message and makes the body of the message
"$body". I
I have the following piece of code:
And when I load that up through the web, it tells me:
Warning: MySQL Connection Failed: Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (111)
Can't connect to MySQL.
However, MySQL is NOT using /tmp/mysql.sock at
Hi,
I have only just joined this list today any help would be greatly
appreciated.
I have implemented the new MERGE table feature as part of my new install
on version 3.23.
I am finding a few small problems with usage of this functionality as
follows.
There are 4 identical tables namely asic_cac
it means it allow multiple records have same value in a table. i.e. It allow
index to contain duplicates.
it really is not a key. it is a kind of index instead.
if you have a table using a primary key say table_a, try to use "SHOW INDEX
FROM table_a", then "SHOW INDEX FROM ACCOUNTING". you can s
Hello List,
I have recently installed mysql 3.23.33 on my windows 2000 machine. I
don't see anything in the documentation that I need to do to my machine for
setup (after the installation). I can run mysql fine, but it seems to be
only able to read. I want to create a new database.
Sorry if this is a little off topic.
I am trying to gather data concerning the use of database driven applications in a
business environment. Specifically, Intranet applications that are in use to increase
productivity and/or eliminate paper. Things like: meeting room scheduling, help desk,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Is there a place to purchase the MySQL manual?
I don't think my printer can handle printing that thing out.
Thanks
- --
Rodney D. Myers <[EMAIL PROTECTED]>
Member of Digital Freedom Alliance
Amateur: KG6ANXGMRS: WPOM592
ICQ# : 18002350
Hi,
I have been running MySQL 3.22.32 for some time, and all has been ok until a week ago.
Now mysqld seems to hang whenever I try to connect. I have checked the logs and
nothing is reported there, and I thought at first it might be a hostname problem, but
everything resolves ok.
I start my
So I think it is appropriate to post this here, as David and Monty are on
the advisory board for the conference. The web page for the previous show
is up on our site (osdn.com) and the site for the next one will be up
soon.
Anyhow, thanks!
Chris DiBona
--
2nd OSDN DB Summit Call For Paper
mysql> SELECT weekday, count(weekday) AS number FROM data WHERE type='x'
GROUP BY weekday ORDER BY weekday ASC;
+--++
| weekday | number |
+--++
| monday | 14 |
| thursday | 28 |
| friday | 44 |
| saturday | 13 |
+--++
4 rows in
Yep that worked! Yeah. Now I must go figure out the
count(1/(condition)) part to figure out how that works
exactly. Thanks for all the help.
-Davin
--- Braxton Robbason <[EMAIL PROTECTED]> wrote:
> howzabout
>
> SELECT Table1.id, Table1.name, count(1/(Table2.offon
> = 'off')) AS NOFF
> FROM
Hi,
here is
public void
String myQuery = "SELECT password from customerinfo where username=";
myQuery.concat(myQuery,
-
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
Nice query, Braxton. I was trying to do it with a left join, but that
required splitting Table2 into an OFF table and an ON table.
I must remember count(1/(condition)); it seems to be very useful.
Back to my real work...
---
David Block
[EMAIL PROTECTED]
http://bioinfo.pbi.nrc.ca/dbl
Hi,
I'm useing mysql php and SSL on a colbalt raq, the problem I'm having is
that when ever I use the update query it doesn't always update, say just
UPDATE table SET f1 = 'update' WHERE id = '2'
some times when I first run the page it works but then other times it doesn't
update, I also use
howzabout
SELECT Table1.id, Table1.name, count(1/(Table2.offon = 'off')) AS NOFF
FROM Table1 , Table2
WHERE Table1.id = Table2.id
GROUP BY Table1.id, Table1.name
HAVING NOFF=0;
works for me:
mysql> create table Table1 (id int, name varchar(10));
Query OK, 0 rows affected (0.01 sec)
mysql> crea
On Fri, 27 Apr 2001, Opec Kemp wrote:
> Hi,
> Have you tried:
>
> SELECT Table1.* FROM Table1 , Table2
> WHERE Table1.id = Table2.id AND Table2.offon = 'on'
That was my original idea as well, but that would return Red, where Davin
wants no Red since there is a Table2 row with an off correspond
Where does mysql get the date from? mysql seems to be 12 hours behind the
rest of my machine.
mysql> select sysdate();
+-+
| sysdate() |
+-+
| 2001-04-26 22:01:43 |
+-+
1 row in set (0.00 sec)
mysql> Bye
tight:~# date
Fri Ap
Diego Zabaleta wrote:
> mysql> select * from sist_adm;
> ++--+-+---+
> | id | nombre | so | descripcion |
> ++--+-+---+
> | 1 | master | AIX 4.2 | Equipo de
Hi,
Have you tried:
SELECT Table1.* FROM Table1 , Table2
WHERE Table1.id = Table2.id AND Table2.offon = 'on'
> Hello all!
>
> Here is what I am trying to do.
> I am trying to find only records
> that all have the same value for a
> specific field in a related table.
>
> A simplified example:
After kill mysql daemons and start again
mysql> select * from sist_adm;
++--+-+---+
| id | nombre | so | descripcion |
++--+-+---+
| 1 | master | AIX 4.2
At 4:44 PM -0400 4/26/01, Mikel wrote:
> > I'm trying to create a perl script that just produces a MySQL compliant
>> SQL file based on the tables from Oracle, but I can't get everything work,
>> like indexes etc..
Do you mean you cannot figure out how to find the index definitions from Oracle?
Look these select statments ¿?.
mysql> describe sist_adm;
+-+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-++
| id | int(11
Hello all!
Here is what I am trying to do.
I am trying to find only records
that all have the same value for a
specific field in a related table.
A simplified example:
Table1 has 2 fields - id, name
Table2 has 2 fields - id, offon
Given these sets:
Table1
id name
---
1 Red
2
just curious but can't you do a SQL dump of oracle...and if so (since I'm not
up on it) whats' the correct syntax, especially from the command line...
Cheers,
Mikel
Johan Andersson wrote:
> Anybody tried this? and hopefully got some good ideas of how to do it
> properly?
>
> I'm trying to creat
I think this is an interesting question. Note the following:
count(col1) will tell you the number of non-null occurrences of col1
col1=value will return 1 is col1=value, 0 if col1<>value
1/0 will return null
thus,
count(1/(col1=value)) will tell you the number of occurences of value in
col1.
t
OK, I have a perl script using mysql that pulls up a bunch of numbers
for a table. Problem is it's taking a long time because of the number of
select calls I'm making.
Basically, I have a sequence of calls of the form:
SELECT COUNT(*) FROM WHERE
(execute, get value of count, print out as cel
I've always used the following...
mysql -h -u -p
and it's worked pretty well for me.
Ron
[EMAIL PROTECTED] wrote:
>
> My goal is to be able to connect to the MySQL server on my web server from a local
>computer. I need to do this for something I'm developing for a client. When I
Okay... Since I modified the process_priv() stuff I was able to get in and
see what was going on when the server ran out of connections.
It had 257 threads, all executing select statements that were in a "Locked"
state. There was one Update at the top of the list.
I'm going to go back and read a
My goal is to be able to connect to the MySQL server on my web server from a local
computer. I need to do this for something I'm developing for a client. When I
connect to the database on the server itself I use localhost. What can I do to
connect from elsewhere?
I have granted the user per
At 9:31 AM -0700 4/26/01, Shane Gentry wrote:
> Does it help to put an Index on a column when you
> use a LIKE query.
>
> ex. SELECT * FROM users WHERE name LIKE '%tom%'
>
> Thanks in Advance!
>
In this case, It won't help, since you have a wildcard at the
beginning of your pattern. If you u
Here is the part of the processlist from when the server was full...
| Id | User | Host | db | Command | Time | State|
Info
|
+--+---+---+--+-+--+--+-
Hello
Can anybody answer me ?
my question was : is there a reason why mysql_data_home is set to '.' and not
'c:\mysql\data' ( for example ) ?
because windows is sometimes buggy and on some computers, the working directory is
changing on is own
( it migth be a virus... I can't tell... the
I had the same problem on with Red Hat 7 using mysql-3.23.33.
I installed from RPM and source. Never could get the darn thing working.
I just scrapped .33 and downloaded .36. Works like a charm now.
DG
>Description:
I am having a problem starting the mysql daemon from the command line.
I a
Somebody can tell me if the Text type is MySQL-specific or standard SQL?.
Thanks a lot.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Dear Sir :
MySQL 3.22.32 on my linux 486 PC seems work so good. When I compile
a simple C API program which catched from MySQL tutorial, it
chokes at the end of compile process . The program is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def_pa
>Description:
My Mysql server will not start properly.
I am attempting to start it from /usr/local/mysql, by typing the following
command :-
bin/safe_mysqld -u root &
The screen responds with :-
[1] 5848
# Starting mysqld daemon with databases from /usr/local/mysql/data
mysqld daem
Does it help to put an Index on a column when you
use a LIKE query.
ex. SELECT * FROM users WHERE name LIKE '%tom%'
Thanks in Advance!
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
[EMAIL PROTECTED] wrote:
>
> Hello, MySQL Experts,
Hello,
>
[.}
>
> Alternatively, is there any way I can safely generate a unique id without
> creating the master row?
> The I could put the slave rows in before I create the master row, and I
> wouldn't have a problem.
You can use one au
Hi!
InnoDB tables are often even faster than MyISAM tables for read access.
In updates and inserts it depends on whether you flush the log to
disk at a commit. A disk write takes some 10 ms. InnoDB does not lock
the rows it reads (a consistent read). Therefore the writes do not
block reads.
Rega
I was trying to sign up in order to leave a comment, and your application
crashed giving this message:
---Copied From Your Web Site---
Error: query insert into
web.user(email,pass,firstname,lastname,address,city,state,zipcode,id,phone,c
ell,fax,company,show_email,created) values
('[EMAIL PROTECTE
On Thu, Apr 26, 2001 at 04:31:40PM +0100, [EMAIL PROTECTED] wrote:
> Hello, MySQL Experts,
>
> I wonder if you could give me some advice on a database design problem.
>
> I have a table which will have many more reads than writes (between 10 and
> 100 times). I wish to make
> updates to that tab
I wonder how people use RDBMS w/o ever
reading manuals. Do they get paid for their
work?
- Original Message -
From: "Sheshadri YS" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 26, 2001 6:57 PM
Subject: Unable to Solve NOT IN Problem
Respected Sir,
We are facin
Hello, MySQL Experts,
I wonder if you could give me some advice on a database design problem.
I have a table which will have many more reads than writes (between 10 and
100 times). I wish to make
updates to that table and to a slave table transaction safe. The basic
structure is of a master slav
Hi!
I changed it to upcoming 3.23.38 so that it prints an error message
and calls exit(1).
Since you can run out of disk space inside InnoDB only when starting
the database after adding new data or log files to my.cnf, there is
not much need for interaction. If InnoDB would archive its log files
Hi!
This is the FreeBSD 100 % CPU hang reported on www.innobase.fi.
It is fixed in MySQL 3.23.37.
Regards,
Heikki
..
Hey,
I dunno whether it's a bug or just I don't know how to use transactions
properly.
I've got 3.23.36 on FreeBSD 4.2-STABLE, and when I do this:
Bit me a few weeks ago. It's a permissions problem- mysql doesn't have
permissions to read the file, therefore it does not exist.
cd /var/lib/mysql
chown mysql */*
chgrp mysql */*
Then it will work.
---
David Block
[EMAIL PROTECTED]
http://bioinfo.pbi.nrc.ca/dblock/wiki
NRC Plant Biote
HI all!
i use to work with php/mysql under windows NT,a nd now i've switched to
linux mandrake7.2! i have installed apache and php4 from CD2
then mysql but mysql service don't run it gives me this error:
/etc/r.d/init.d/mysql start is taking longuer then expected to complete.
THanks
_
Respected Sir,
We are facing problem in running this below given Query in mysql 3.23
SELECT COL1 FROM A WHERE COL1 NOT IN (SELECT COL2 FROM B WHERE COL3=001)
Table A (col1,col2 is of varchar )
Table B (col1,col2 is of varchar, col3 = numeric )
ALSO Table1.col1 == Table2.col1
SO Please let
Ashwin Kutty wrote:
>
> Anyone notice any high CPU Usage with the following versions of the Linux
> Kernel and MySQL
> mysql-3.23.32-1.7
> Linux 2.2.16-22smp
>
> Other info..
>
> Distro:- Redhat 7
> Machine:- Pentium III 450
> 256 MB Ram..
>
> I have gone through and edited my.cnf to
>Description:
I am having a problem starting the mysql daemon from the command line.
I am using the following command from /usr/local/mysql :-
bin/safe_mysqld -u root &
The resultant error file /usr/local/mysql/data/bon.err, has the following entries:-
mysqld started on Thursday April 26 14:2
Anyone notice any high CPU Usage with the following versions of the Linux
Kernel and MySQL
mysql-3.23.32-1.7
Linux 2.2.16-22smp
Other info..
Distro:- Redhat 7
Machine:- Pentium III 450
256 MB Ram..
I have gone through and edited my.cnf to see if that makes a difference,
but no go on
Dag Nygren writes:
>
> Hi,
>
> I have been using xmysqladmin successfully for quite
> some time to change the table structure of my databases
> (as I haven't been able to fugure out how to do this with
> mysqlgui...)
>
> After doing lots of upgrades here, Linux -> 2.4.3, glibc -> 2.2
> and mysq
Hi all,
I have some questions for you. How much bigger mysql database is?
And there some query or some api call to retrieve random record from a table?
Thank you very much for your support
Regards
-Filippo Fadda
-
Before p
I've had the same problem once.
Reading the manual I found out that MySQL is not SQL conform
and does not support sub-selects.
You'll have to rewrite the statement that you don't need a sub-select
or if not possible create a temporary table.
Regards,
Robert
- Original Message -
From: "B
As I understand it, you can only list distinct values in an IN clause -
MySQL doesn't yet support subqueries here - according to the manual.See
page 139 of the pdf manual.
-Original Message-
From: Bobby Chopra [mailto:[EMAIL PROTECTED]]
Sent: Thu, 26 April 2001 14:10
To: [EMAIL PROTEC
Johan,
I'm working on something similar at the moment.
Attached at two files I downloaded from somewhere. If you import/attach
the
Oracle tables to an access database you could give them a try - I haven't
used them.
If you want a more complete solution, the Oracle views: USER_TABLES,
USER_TAB_CO
Hi All
Problmes with mysql keys
When id do "show columns from ACCOUNTING;" in the Key field is see "MUL".
Looking at the tec docs I can not find which type of key this is referring
to. Can some one tell me.
Thanks Simon
-
Before
Probably a simple question:
I am returning back to SQL after a break, and I was sure that I could do the
following when using the IN function:
SELECT field1 FROM table1 where field1 NOT IN (SELECT DISTINCT field2 FROM
table2);
but clearly not.
Could anyone suggest what I am doing wrong, or is
James Bonham writes:
> Hello,
>
> I have made several attempts at compiling and installing MySQL 3.23.36 and MySQL++
>1.7.8 on Solaris 2.7 Ultra Sparc.
>
> I have included the latest versions of GNU binutils, libtool, make, gcc as indicated
>in the documentation in the proper path.
>
> I have
>I got a downloaded version of MYSQL installed.
>I am not able to create tables within in a database . I think some
>problem with the edit options.Any solutionbut i am able to create
>a new database.
manual www.mysql.com
several websites: www.devshed.com and others.
Book: MySQL writ
Hello,
I have the problem of the characters accetués (é è to..)
who are replaced by '?', I use TOMCAT and Apache
as web server, and I use mysql as server of
given the generation of the code html makes itself by
servlets java.
What I am sure is that the problem is not to the
level database becaus
Gary Huntress, who sometimes posts on this List, runs such a free system.
It is found in his signature line, as follows:
SNIP ==
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
SNIP ==
- Original Message -
From:
hi friends,
I got a downloaded version of MYSQL installed.
I am not able to create tables within in a database . I think some problem with the
edit options.Any solutionbut i am able to create a new database.
Hello
My udf function (inet_aton functionality for 3.21.33 server) does work in 99%
percent of all cases, just when I use it on the output of a outer join
where some fields are NULL it crashes the server - when giving NULL as
argument directly it works:
result of a join of 2 very simple tables
Bonjour,
J'ai le probleme des caracteres accetués (é è à,..)
qui sont remplacés par '?', j'utilise TOMCAT et apache
comme web server, et j'utilise mysql comme serveur de
données la génération du code html se fait par des
servlets java.
Ce que je suis sure est que le probleme n'est pas au
niveau
Hello,
I have just resolved a problem that I encountered for the first time 1 year
ago 8-) 8-)
My problem was to store strings with some "french" special characters inside,
like "é è à ç". When these characters were entered from a form written in
PHP, everything was OK but when they were
On Wed, 25 Apr 2001, arijit das wrote:
> Sir,
>
> I have downloaded the binary stable version of
> MySQL from the site www.mysql.com.The package I
> downloaded is ..
>
> mysql-3.23.37-pc-linux-gnu-i686.tar.gz
>
> After unzipping and untaring,I entered then
> directory
> mysql-3
On Wed, 25 Apr 2001, Hunter Hillegas wrote:
> As I'm having a lot of problems with the source distro, I'm considering
> moving to your RPMs.
>
> The manual suggests that there are a lot of problems with Linux and threads,
> etc... and to use the prebuilt binaries if you can...
>
> I've been usi
Anybody tried this? and hopefully got some good ideas of how to do it
properly?
I'm trying to create a perl script that just produces a MySQL compliant
SQL file based on the tables from Oracle, but I can't get everything work,
like indexes etc..
Someone?
// Johan Andersson
-
>read of a free hosting site a while ago if you are developing mysql sites.
>does anybody know about that? I can't find it anymore. Please I really need
>to host my test page as the server I had it one broke. Can anybody help me
>out
Use your favorite searchengine.
Bye,
B.
-
On Thu, Apr 26, 2001 at 09:54:56AM +0200, [EMAIL PROTECTED] wrote:
> we're just facing a "challenging" problem ... we have a MySQL lessons
> learned database. In two fields of the main table (LONGTEXT) we have the
> "description" and the "solution". You could think of two short abstracts,
> regar
Good Morning People,
we're just facing a "challenging" problem ... we have a MySQL lessons
learned database. In two fields of the main table (LONGTEXT) we have the
"description" and the "solution". You could think of two short abstracts,
regarding the lesson (some 100 words or more).
We need to
Hi all
I read of a free hosting site a while ago if you are developing mysql sites.
does anybody know about that? I can't find it anymore. Please I really need
to host my test page as the server I had it one broke. Can anybody help me
out
Thanks
peter
79 matches
Mail list logo
