Hallo
Is there a way to set the order in which data gets placed into the db?
I have a form with ten rows (input fields) they are labeled name[1],
name[2],name[3],name[4]
I then use a for statement incrementing $i up to 10 i.e name[$1] this
loop contains my query (INSERT INTO DB...) but if I
Is there a timeline/status for 4.x functionality available?
I would like to use MySQL 4.x, however, I'm looking for some of the
highly
requested functionality (ie; subselects, SP's, triggers and Views) and
would
like to know where/when in the sequence of things todo does everything
fall
HI
I am new to this forum. Can anybody tell me where can I find documentation of
mysql source code and the Architecure diagrams of mysql ?
Thanks to all for getting me in :)
-shrikant
Shrikant Gundapwar
--
A ship in harbour is
Hi.
On Fri, Feb 22, 2002 at 10:54:55AM +0200, [EMAIL PROTECTED] wrote:
Hallo
Is there a way to set the order in which data gets placed into the db?
No. With SQL you specify the order not on insertion but on seletion
time.
I have a form with ten rows (input fields) they are labeled
Its not open source, but I think theKompany.com has a good one.
Am Fre, 2002-02-22 um 04.55 schrieb Jeff Kilbride:
Are there any open source ERD programs for MySQL for doing basic data
modelling? I tried myERD at sourceforge and it couldn't parse the sql dump
from my database. It died with a
Hi,
we have 3.23.42 official binaries running on Linux 2.4.17. It seems
mysqld does not read in from /etc/my.cnf the value for net_buffer_length.
When having in the config file:
[mysqld]
set-variable= net_buffer_length=16M
set-variable= max_allowed_packet=16M
[...]
I get
|
Shrikant,
Friday, February 22, 2002, 11:06:09 AM, you wrote:
SG HI
SG I am new to this forum. Can anybody tell me where can I find documentation of
SG mysql source code and the Architecure diagrams of mysql ?
You can find info about installation of MySQL at:
We have a SCO Unix Open Server Ver. 5.0.5 with MySQL 3.23.43 x SCO 3.2
V5 (Intel) installed and we want set a connect timeout using the
following syntax:
timeout = 10; /* sec */
mysql_init(mysql);
mysql_options(mysql, MYSQL_OPT_CONNECT_TIMEOUT, (char*) timeout);
if (!mysql_real_connect(mysql,
Hi,
Has anyone got the following error on a BDB table :
read_const: Got error -30996 when reading table
We did some load testing on a particular BDB table and got this when we
tried to run 20 concurrent queries on the table. The query in question
works fine when the database
When the Next Edition of MySQL By Paul Dubois is coming?
-
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
It would be nice to see some thing for V4.
PS Paul...its only because we liked the first one so much.
-Original Message-
From: D Bamud [mailto:[EMAIL PROTECTED]]
Sent: 22 February 2002 10:47
To: [EMAIL PROTECTED]
Subject: Paul DuBois Book
When the Next Edition of MySQL By Paul Dubois
Hi list -
Is there a list off MySQL error-codes avalible?
Something like Oracle's oerr. program?
We are having trouble with one of our MySQL databases. The error is:
Got error 124 from table handler.
We get this error randomly on some of our MyISAM tables.
Optimize table seems to fix the
Hope somebody can help me on this one
At present I have two tables in my database. The data in question is built
around credit card transactions.
Tables Structure
Headers Table
ID (Primary Key used by the TRANSACTIONID field in the Transaction table)
HEADERDETAILS blah, blah
Transaction
On Fri, Feb 22, 2002 at 10:52:14AM +0100, Martin MOKREJ? wrote:
Hi,
we have 3.23.42 official binaries running on Linux 2.4.17. It seems
mysqld does not read in from /etc/my.cnf the value for net_buffer_length.
When having in the config file:
[mysqld]
set-variable=
Hi Alec,
On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote:
Is there a timeline/status for 4.x functionality available?
I would like to use MySQL 4.x, however, I'm looking for some of the
highly requested functionality (ie; subselects, SP's, triggers and Views)
and would like to know
Hi all,
i'm a newbie on this Mailing-list and i'm French.
So, sorry for my POOR english...
I try to execute an SQL Command but i have a syntax error :
SELECT Id_Game
FROM game
WHERE Id_Game NOT IN (
SELECT Id_Game
FROM member_game a
WHERE Id_Member = 4 )
I don't know waht happend..
Help
Edwards,
Friday, February 22, 2002, 12:58:23 PM, you wrote:
Eeoen Hope somebody can help me on this one
Eeoen At present I have two tables in my database. The data in question is built
Eeoen around credit card transactions.
Eeoen Tables Structure
Eeoen Headers Table
Eeoen ID (Primary
Hiya forum..
I have my site powered by MySQL server running on FreeBSD.
The site is facing problems when the traffic increases.Database connectivity
is through JDBC.My poolman is managing the
database connections with 30 connections set, and is growable.People have
started getting error when
Hi
Subselects doesn't work at time.
Am Fre, 2002-02-22 um 12.47 schrieb Guillaume BABIK:
Hi all,
i'm a newbie on this Mailing-list and i'm French.
So, sorry for my POOR english...
I try to execute an SQL Command but i have a syntax error :
SELECT Id_Game
FROM game
WHERE Id_Game NOT
Hello.
I have a problem with auto_increment and primary key.
I use MySQL 3.23.41-17 as backend and Access 2000 as frontend which is
connected with MyODBC 2.50.39.
I have created several tables like this:
create table tPruefBesch (fTimestamp timestamp(14), fPruefbeschNr int
auto_increment not
Hi,
I guess what you're trying to do is a kind of Sub-selectnot yet
supported by MySQL (see http://www.mysql.org/products for exact version : I
guess it is supposed to be done in 4.1, but not sure!)
However, for example, you can rewrite this query :
SELECT * FROM table1 WHERE id IN (SELECT
Guillaume,
Friday, February 22, 2002, 1:47:09 PM, you wrote:
GB Hi all,
GB i'm a newbie on this Mailing-list and i'm French.
GB So, sorry for my POOR english...
GB I try to execute an SQL Command but i have a syntax error :
GB SELECT Id_Game
GB FROM game
GB WHERE Id_Game NOT IN (
GB SELECT
On Friday 22 February 2002 02:15 am, Jeremy Zawodny wrote:
On Thu, Feb 21, 2002 at 08:07:39PM -0500, Anthony W. Marino wrote:
Is there a timeline/status for 4.x functionality available?
No. It'll be ready when it's ready. :-)
There are folks using 4.0.x in production and/or testing now.
On Friday 22 February 2002 05:48 am, Simon Green wrote:
It would be nice to see some thing for V4.
PS Paul...its only because we liked the first one so much.
-Original Message-
From: D Bamud [mailto:[EMAIL PROTECTED]]
Sent: 22 February 2002 10:47
To: [EMAIL PROTECTED]
Subject:
Hello
I would like to know how to use different languages in different tables (one
language/character set per table). The idea being users can view web page
data in their own language. Some of this content will need to be sortable.
For example:
- english
- french
- russian
- japanese
I am new
On Friday 22 February 2002 06:26 am, Arjen Lentz wrote:
Hi Alec,
On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote:
Is there a timeline/status for 4.x functionality available?
I would like to use MySQL 4.x, however, I'm looking for some of the
highly requested functionality (ie;
Can anyone point me to a comparison of +'s and -'s with each Transaction
enhanced formats (ie; InnoDb, SleepyCat and others) for MySQL.
Thanks,
Anthony
-
Before posting, please check:
http://www.mysql.com/manual.php (the
My vote is have the 'mySQL Cookbook' get out the door first, give Paul a
quick respite, and then put his nose to the grind stone for 'mySQL version
4'. 8-)
-Original Message-
From: Anthony W. Marino [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 7:30 AM
To: Simon Green;
query
Is it possible to set one SLAVE to handle two or multiple MASTERS???
For example if I want to replicate one table from one MASTER and
second table from another.
Thanx a lot
-
Before posting, please check:
Hi,
I've got this problem when i try to connect to a mysql server with a PHP
code
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (111)
hope you can help me
regards
theotherone
It can be done. The slave server needs to hold mutiple slave databases corresponding
to the masters. Each slave instance needs to be start separately. For example, each
database wil need it's own my.cnf file holding with port the master is connecting to.
I have seen this done with full
Chris,
Friday, February 22, 2002, 3:51:39 PM, you wrote:
CG Hello
CG I would like to know how to use different languages in different tables (one
CG language/character set per table). The idea being users can view web page
CG data in their own language. Some of this content will need to be
On Friday 22 February 2002 00:03, Colin Dewey wrote:
This is an example of a class of problem that crops up in a lot of
applications, like GIS systems all the time.
Unfortunately B-Tree type indexes, like RDBMS systems generally use are just
not well adapted to this type of query. I know
theOtherOne,
Saturday, February 23, 2002, 1:52:20 AM, you wrote:
t Hi,
t I've got this problem when i try to connect to a mysql server with a PHP
t code
t Warning: MySQL Connection Failed: Can't connect to local MySQL server
t through socket '/tmp/mysql.sock' (111)
It means that you are using
Hi,
Does anybody know how to copy an existing mySQL table schema with varchar datatype
my sql statement is:
CREATE TABLE new_table AS SELECT * FROM old_table where 1=0;
All the text columns in the old_table are in VARCHAR datatype, however,
after I copy to a new_table, all columns change to
Thank you for your very detailed reply. This was my understanding of it too.
I guess I was hoping that I had missed something!
Do you know when will this happen? (I hate to ask but since I know I will be
asked this, I feel I should ask you. My crystal ball is broken!)
Is it going to be in 4.x?
On Sat, 2002-02-23 at 01:52, theOtherOne wrote:
Hi,
I've got this problem when i try to connect to a mysql server with a PHP
code
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (111)
[mle@hal9000 data]$ perror 111
Error code 111:
At 04:38 PM 2/21/2002 , you wrote:
At 22:15 + 2/21/02, DL Neil wrote:
MySQL by Paul DuBoise
Paul monitors this mailing list, so if you have questions concerning what
you've read, he may answer.
You added an e to my name deliberately just to see if I'd reply,
didn't you! :-)
Not really,
* Mark Lo
Row 10ID00010need this value
Row 11ID00025have this value on hand
Row 12ID00063need this value
The questions is how do I find out the values in Row 10 and Row 12, if and
only if I only have one data that is ID00025 (select * from table where
field=ID00025)
thx
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, February 22, 2002 7:30 AM
Subject: mysql error
theOtherOne,
Saturday, February 23, 2002, 1:52:20 AM, you wrote:
t Hi,
t I've got this problem when i try to connect to a mysql server
Chad, this did not work. Though it did do something, the Position jumped
ahead
mysql show slave status\G
*** 1. row ***
Master_Host: 209.217.92.34
Master_User: repslave2
Master_Port: 3306
Connect_retry: 60
As show table status doesn't appear to be supported in this older version
I'm using, how did you who used this version get max table size information?
I haven't been to find anything from the list archives/manual about this.
Brian
sql,query
So it appears there is a maximum of 32 keys (indexes) that can be
created on a table. Is there any way to increase this? If so how?
-Tim
sql,query??
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Luc,
The problem is that in the replication somewhere an update was taken twice.
Adjust the skip to according to the position of the duplicate entry. I have had to
skip 100 before in order to get the slave started.
First check the binary log and see how many insert statements
Quoted from http://www.mysql.com/doc/T/a/Table_size.html is:
By default, MySQL tables have a maximum size of about 4G. You can check the
maximum table size for a table with the SHOW TABLE STATUS command or with
the myisamchk -dv table_name. See section 4.5.6 SHOW Syntax.
Gurhan
-Original
Hello all.
I'm using Debian 2.4.x
I was trying to upgrade mysql.3.22 to 23 by removing default packages and
after debianizeing rpm's with alien I installed them with dpkg.
After I did upgrade (as I assume ;-))) somewhere my.cnf file disappeared
Do someone know how to properly upgrade 22 to 23
I did see that reference, but found that myisamchk wasn't an option
either. I did find isamchk is available and have been seeing what
information it is able to provide. I'm wondering now whether summing
the table.ISD, table.ISM, and table.frm filesizes that I get from a
simple ls -l output will
On Fri, Feb 22, 2002 at 08:46:37AM -0800, Tim Allwine wrote:
So it appears there is a maximum of 32 keys (indexes) that can be
created on a table. Is there any way to increase this? If so how?
I seem to remember it being a simple soure code change. Check the
mail archives (if you haven't
That's pretty strange in this situation, we have three slaves being updated
from the master, the other two are moving along just fine.
This one however can't seem to get past these duplicate entries. I tried
skip_counter=2 and got a different duplicate entry, the possition moving
forward
again.
You, like me, are using 3.22 which does not have the myisam table type
(or others for that matter). ISAM I believe, has a lower limit. They do
support sizes less that 4GB (up to the OS file size limits). The three
file extentions total do constitute the total table size, but I believe
that
Fromt the mysql.com site: http://www.mysql.com/doc/I/S/ISAM.html
for all the limits.. Remember that your files sizes may be smaller
because of your OS.
On Fri, 22 Feb 2002, Brian Warn wrote:
Date: Fri, 22 Feb 2002 09:11:07 -0800
From: Brian Warn [EMAIL PROTECTED]
To: 'Gurhan Ozen' [EMAIL
Is it possible to run mysqld without binding to a TCP port?
As in run using only unix sockets?
- Jonathan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
* Roger Baklund
It is even possible to do this with one select statement and four
left joins to the same table, but it is a bit complicated:
select table.*,next.id as next,prev.id as prev
from table
left join table as prev on
prev.id table.id
left join table as prev2 on
Hello good people,
Okay I don't mean to offend anyone. I'm a newbie but I have managed to do
courier-imap-authmysql today.
I can add/remove/changepasswd for users comfortably. Command line is no problem.
However, this is a bit slow and I was wondering if anyone out there already invented
the
On Fri, 2002-02-22 at 11:09, havoc wrote:
Is it possible to run mysqld without binding to a TCP port?
As in run using only unix sockets?
Start with --skip-networking:
http://www.mysql.com/doc/C/o/Command-line_options.html
or put skip-networking into your my.cnf file.
--
Guy Davis
Just for my clarification, --skip-networking will disable TCP/IP, but
still allow mysqld to use a unix socket as specified by --socket=PATH,
correct?
On 22 Feb 2002, Guy Davis wrote:
Date: 22 Feb 2002 11:28:35 -0700
From: Guy Davis [EMAIL PROTECTED]
To: havoc [EMAIL PROTECTED]
Cc: [EMAIL
DoH!
I'm bein a moron here :)
Guy, thanx :)
On Fri, 22 Feb 2002, havoc wrote:
Date: Fri, 22 Feb 2002 12:32:10 -0600 (CST)
From: havoc [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Running Without TCP Port
Just for my clarification, --skip-networking will disable TCP/IP, but
I have this query that works just fine in msacess agains some linked mysql
tables, but if I run this statement in php or in mysqlfront it doesn't work.
I belive it's because there is two joins in it but i'm not sure. If that is
the problem then what is the work around? Here is the statement:
From: Mat Murdock [EMAIL PROTECTED]
... Like *java*
Try:
Like %java%
I would bet the the aseriscs are some non-SQL extention of MS Access.
---
Rodney Broom
Programmer: Desert.Net
-
Before posting, please check:
Each slave can only have one master. If you want to have one box be a
slave to multiple masters, you have to set up a mysqld for each master
on the slave box, each with a different port and socket.
Now, if this is on Linux, you also can't have the multiple servers share
data on this one box,
Ok, so I updated the statement like the past few posts have directed so the
statement looks like this:
SELECT FORUMCAT1.LASTPOST, USERS.USERNAME, FORUMCAT1.ID, FORUMCAT1.TOPIC,
FORUMCAT1.REPLIES, FORUMCAT1.ORIGINATOR, FORUMCAT1.STATUS
FROM USERS INNER JOIN (FORUMCAT1 INNER JOIN FORUMMSG1 ON
I have a table that has following fields
id (auto increment)
date
appleprice
orangeprice
pearprice
When I try to LOAD DATA INFILE with this file using comma as field delimiter
and newline as end of row
2000-01-04,281.08,5.27,430.05
2000-01-05,280.06,5.14,421.98
2000-01-06,279.99,5.13,408.59
http://www.mysql.com/doc/J/O/JOIN.html says that INNER JOIN and , (comma)
are semantically equivalent. Both do a full join between the tables used.
Normally, you specify how the tables should be linked in the WHERE
condition.
So you could use this instead:
SELECT FORUMCAT1.LASTPOST,
You need to specify the columns you're loading, if they aren't all the
columns in the table in the same order. So, you need to add
(date, appleprice, orangeprice,pearprice)
at the end of your LOAD DATA INFILE statement.
As for only loading one row, I'd guess your input file line endings
One thing that has always puzzled me is how poeple are
gaurding against duplication in columns where people's
names are stored.
For example this table has a persons's first and last name.
Stars:
starID
starFirstName
starLastName
1
Vanna
White
2
Bob
Marley
problems begin to
At 13:13 -0600 2/22/02, Craig Westerman wrote:
I have a table that has following fields
id (auto increment)
date
appleprice
orangeprice
pearprice
When I try to LOAD DATA INFILE with this file using comma as field delimiter
and newline as end of row
You need to add the column list:
... INTO
What does this quote from the manual mean:
If you do not have any GRANT statements done, MySQL will optimise the
permission checking somewhat. So if you have a very high volume it may be
worth the time to avoid grants. Otherwise more permission check results in a
larger overhead.
By not having
Is there a list off MySQL error-codes avalible?
Something like Oracle's oerr. program?
perror
We are having trouble with one of our MySQL databases. The error is:
Got error 124 from table handler.
chris@entropy:~$ perror 124
Error code 124: Wrong medium type
124 = Wrong index given
Hi,
Yes, just write :
perror 124
perror 124
Error code 124: Wrong medium type
124 = Wrong index given to function
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: Christian M. Stamgren [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, February 22, 2002 11:49 AM
Hi All,
Let's say I'm creating an affiliate program to track surfer clicks to sales.
I have a question on indexing that's always bothered me. I'm hoping an index
guru can help me out. Here's an example click-recording table:
CREATE TABLE clicks (
clickID int unsigned NOT NULL auto_increment,
Anyone seen this before?
Server configuration denies access to data source
I'm using the mm.mysql driver and attempting to connect from my java
classes with the ip of the server (from the server) as root.
The server itself only has two users, root mysql.
_
The trouble
Sorry to double post to the list. Is there anybody out there using SuSE7.3
with the downloadable 4.0.1 max version of mysql? I truly want to start
exploring mysql but I cannot get it to run (see below for first post).
Thanks in advance for any advice
G
Hi,
I am running SuSE 7.3 Professional
I posted a question but received a message stating the file was to large?
G
(mysql, query)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hi all,
I try to compile ezmlm with mysql see what I have got with the compilation
phase :
www:~/qmailnco# rpm --rebuild --clean --target i686
ezmlm-idx-mysql-0.53.324-4md
k.src.rpm
here it crashs
./load ezmlm-gate subdb.a getconf.o slurpclose.o slurp.o \
getopt.a getln.a auto_bin.o
All, there were many emails posted about this on the MyODBC list which,
of course, can be viewed via the archive on the mysql.com site. For the
most part I will neither quote nor repeat the information from those
emails here.
The conclusion is that MySQL + Merge Tables is perfectly capable of
I need to store large files in a MySQL database (in Windows). To do
this, I have created a table that has a BLOB column. How can I insert
the files into this table?
Thanks,
Ron
-
Before posting, please check:
Can I have different indexes on the tables in my master and slave? I
want to use the slave strictly for reporting and the master for inserts, so
I'd like to index the crap out of the slave and leave the master relatively
index free.
Will that work?
Thanks,
--jeff
P.S. -- how 'bout adding some
Dear All,
I am using PHP + MYSQL. I have a question that I need some expert
to help. That is:
How do I find out a next and preview row values by using PHP and MYSQL. For
examples,
Row 10ID00010need this value
Row 11ID00025have this value on hand
Row 12ID00063
Dear All,
I am using PHP + MYSQL. I have a question that I need some expert
to help. That is:
How do I find out a next and preview row values by using PHP and MYSQL. For
examples,
Row 10ID00010need this value
Row 11ID00025have this value on hand
Row 12ID00063
How do I find out a next and preview row values by using PHP and MYSQL. For
examples,
Take a look at the function
mysql_result();
Chris
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
The solution I have been using is to do three queries similar to the below
SELECT * FROM table WHERE field='ID00025'
SELECT * FROM table WHERE field'ID00025' ORDER BY field DESC LIMIT 0,1
SELECT * FROM table WHERE field'ID00025' ORDER BY field ASC LIMIT 0,1
If you whish more row returned
The solution I have been using is to do three queries similar to the below
SELECT * FROM table WHERE field='ID00025'
SELECT * FROM table WHERE field'ID00025' ORDER BY field DESC LIMIT 0,1
SELECT * FROM table WHERE field'ID00025' ORDER BY field ASC LIMIT 0,1
If you whish more row returned
Hi,
It seems worst to me because in your case mysql has to retrieve all the
rows.
If it's a table with 1 million records or more, this should hurt ;)
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: Chris Boget [EMAIL PROTECTED]
To: Raymond Gubala [EMAIL PROTECTED];
It seems worst to me because in your case mysql has to retrieve all the
rows. If it's a table with 1 million records or more, this should hurt ;)
As I said, it was pseudo code. Now, imagine that you were just
getting the records for a particular user? a particular application?
Where there
Yes, but how to get ONLY the 3 records you need ?
Because often in an application, you don't care about the other records.
In this case AFAIK, there is no other solution than issuing at least two
queries :
SELECT * FROM table WHERE field='ID00025' ORDER BY field DESC LIMIT 2
SELECT * FROM table
Yes, but how to get ONLY the 3 records you need ?
Because often in an application, you don't care about the other records.
In this case AFAIK, there is no other solution than issuing at least two
queries :
SELECT * FROM table WHERE field='ID00025' ORDER BY field DESC LIMIT 2
SELECT * FROM table
On Fri, Feb 22, 2002 at 11:21:23PM +0200, George Labuschagne wrote:
I posted a question but received a message stating the file was to large?
Look at the message. Some idiot's mailbox is over the limit. Anytime I
post to this list I get 2 return mails bounced from lusers.
With regards to
Hi Alastair,
Yip somebody pointed me towards the address from the returned mail ;-p. Now
for the answers to your questions:
1. I did create a user and a group for mysql by using:
shell chown -R root /usr/local/mysql
shell chown -R mysql /usr/local/mysql/data
shell chgrp -R
Hi, I installed the BD mysql and I am some problems.
# /usr/local/mysql/bin/safe_mysqld
It's ok.
Here:
# mysqladmin password my_password
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
And when I
I posted a problem I was having with this, but unfortunately nobody
responded. Regardless, here are the methods I've used:
1) using LOAD_FILE():
INSERT INTO table_name (column_name)
VALUES(LOAD_FILE('/absolute/path/to/file'));
In windows, of course, the path to the file should
did you follow the instructions in the link below?
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.htm
l#Post-installation
-Original Message-
From: Joedilson B. Azevedo [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 6:08 PM
To: [EMAIL PROTECTED]
Hello SqlFolk ;
I'm trying to install mysql the latest version of mysql (client,
server, devel, bench, shared)
on Red Hat Linux 7.0 (kernel = 2.2.16-22). After downloading the
RPMs, I get a signal
4 error on the server install and notice complaints concerning
threads. Perusing the
apologies for the sorry mail formatting...the whole link should be
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.htm
l#Post-installation
-Original Message-
From: Gregory Junker
Sent: Friday, February 22, 2002 6:22 PM
To: Joedilson B. Azevedo; [EMAIL
On Sat, Feb 23, 2002 at 12:39:43AM +0100, [EMAIL PROTECTED] wrote:
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:
sql,query
If you just reply to this
hello all,
anybody know where to find a quick reference guide for mysql commands/functions?
TIA,
luie
__
www.edsamail.com
-
Before posting, please check:
http://www.mysql.com/manual.php
Description:
The new POSIX standard is now official (IEEE Std 1003.1-2001),
and it has removed support for some obsolete utility options
that mysql uses in a few places. Basically, the new POSIX
has removed digit-string options (e.g., tail -1) and options
On Friday 22 February 2002 5:03 pm, Luie wrote:
hello all,
anybody know where to find a quick reference guide for mysql
commands/functions?
If you are looking for an SQL quick reference guide, check out SQL Instant
Reference (2nd Edition) by Martin Gruber, published by Sybex. Very good
Try www.mysql.com/doc
www.php.net/manual/en/ref.mysql.php
Warren Stringham
-Original Message-
From: Luie [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 5:04 PM
To: [EMAIL PROTECTED]
Subject: quick reference guide
hello all,
anybody know where to find a quick reference
Joedilson,
the syntax for specifying a password to mysqladmin is
--password=my_password, or -p if you want it to prompt. (Notice that it
says, Using password: NO .. thats because it doesn't realize you're
trying to use a password).
You also need to specify the password when you're using mysql
Actually, upgrading the kernel is /not/ hard. Simply follow the
instructions in the INSTALL file inside the tarball. Many people have a
fear of doing this, but if you read the instructions, and know your
machine, it's a simple matter.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
1 - 100 of 124 matches
Mail list logo