I know i have to connect first to the server. I tried issuing
the command like this:
mysql mysql -h localhost -u root -p;
but it says error in syntax. if i take out the semi colon,
the shell would just add a '-' below.
You are already running mysql by typing that. You should have
read the
I've installed mysql-max-4.1.3-beta-apple-darwin7.4.0-powerpc to my PowerBook
and have executed the MySQLStartupItem.pkg. The /Library/StartupItems/MySQLCOM
exists and the /etc/hostconfig file includes the string MYSQLCOM=-YES-.
However, the only way I can get MySQL to start after boot up is to
Hi all,
How can I get the query plan output?
thanks alot
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
that will work..
or if you can guarantee that it always prefixed with '#' you can try
select id from mydata
order by if(left(id,1)='#',concat('z',id),id)
or if you didnt sure.. you can try the similiar way..
select id from mydata
order by if(left(id,1)'A',concat('z',id),id)
just make sure that
Hi
the usual syntax is mysql -u root -p
if that does not work look into
skip grant tables option
http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
HTH
Peter
-Original Message-
From: DBS [mailto:[EMAIL PROTECTED]
Sent: 23 August 2004 03:50
To: [EMAIL PROTECTED]
Hi,
we are experiencing a strange problem with a table of our MySQL-Server.
About every week this table gets corrupt and we have to repair it
manually. Besides a couple other tables and databases there is another
table who gets corrupted but not that often. Both tables are the
biggest on the
Eko Budiharto [EMAIL PROTECTED] wrote:
I am trying to find how to use command select count(*). I tried it in
mysql query console, it shows the number of my rows in my table. But
when I tried it in perl with $sth-do(select count(*) from mytable)
and run the perl script from DOS console, I
Jens Bierkandt [EMAIL PROTECTED] wrote:
we are experiencing a strange problem with a table of our MySQL-Server.
[]
System:
Software:
Installiertes OS: Fedora Core release 1 (Yarrow)
Installierter Kernel: 2.4.22-1.2188.nptlsmp
Filesystem:
°í ¿ìÁ¾ [EMAIL PROTECTED] wrote:
mysql select count(*) from pages;
ERROR 1016 (HY000): Can't open file: 'pages.MYI' (errno: 144)
mysql repair tables pages;
+---++--+-+
| Table | Op | Msg_type | Msg_text
Is there any way to issue a distibute query with mysql,
such as
SELECT * from mytab JOIN (SELECT * FROM
another_server_on_another_machine.MYTAB2)
?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DBS [EMAIL PROTECTED] wrote:
I have a problem, It's been months since I used MySQL and (I believe) I had
set it up with a root password. Now I can't log on to MySQL as root MySQL
user and create a new user or manage an existing user (I can log onto server
Familiar situation. :)
Do so:
Frank Perez [EMAIL PROTECTED] wrote:
I am trying to install MySQL 5.0.0 on a fresh install
of Fedora Core 1, however I am running into a little
trouble and I was hoping someone could give me a
little insight on what I might be doing wrong.
I am able to install the 'server', 'clients', and
Joseph E. Maxwell [EMAIL PROTECTED] wrote:
I am moving my database(s) from one server to another, did a full dump
of the data and have a large file with all the create instruction sets etc.
My question, what is the best way to recreate these db, tables etc. on
the new server. MySQL is
[EMAIL PROTECTED] wrote:
I use following code
use databasea
load data infileabcd.txt' into table databasea.tablename;
Data gets loaded in table, however at the end of each record I see a square
symbol, the symbol usually we see in compiled code.
This may be a linefeed or
Info [EMAIL PROTECTED] wrote:
After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to =
rob the piggy bank and build a new linux mysql server.
This seem to be a good fruit of your repentance. :)
I'm not rich, but what hardware and distro do you experts suggest? (My =
I am having more than 10 records in a table. I want to select only first top 10
records (depending on one field score) and then want to select 10th position record.
select * from table1 order by score desc LIMIT 10
This will give me 10 records but then how to get the last record ?
Thanks in
Cao Duy [EMAIL PROTECTED] wrote:
How can I get the query plan output?
See http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
SELECT
associates.shift,
concat(associates.firstname,',',associates.lastname) as Operator,
mrdaily.kronoshours,
mrdaily.pto
LEFT JOIN mrcategories USING
(
mrcategories.category='1',
mrcategories.category='2',
--On 22 August 2004 20:31 +0800 Manisha Sathe [EMAIL PROTECTED]
wrote:
I am having more than 10 records in a table. I want to select only first
top 10 records (depending on one field score) and then want to select
10th position record.
select * from table1 order by score desc LIMIT 10
This will
Feedback [EMAIL PROTECTED] wrote:
Well.. I had the same issue 2 weeks ago with another server from my
DC. I told them it was their hardware, they didnt believe it, so i had to
order a new
server, and ... The same problem occurs...
The axioma is: a user-land binary CANNOT hang the kernel. And
Hi Fredrik,
a LEFT JOIN could be faster (I'm not sure, try it). And you don't have a
fulltext index on msg_header.list.
What about this?
SELECTmsg_header.bodyid, msg_header.id, msg_header.subject,
msg_header.mfrom, msg_header.date, msg_header.list
FROM msg_header
LEFT JOIN
Mayuran Yogarajah [EMAIL PROTECTED] wrote:
Each |MyISAM| table is stored on disk in three files. The files have
names that
begin with the table name and have an extension to indicate the file type.
An `.frm' file stores the table definition. The data file has an `.MYD'
(MYData) extension.
I am having more than 10 records in a table. I want to select only first
top 10 records (depending on one field score) and then want to select 10th
position record.
select * from table1 order by score desc LIMIT 10
This will give me 10 records but then how to get the last record ?
Cycle them
Johan Jonkers [EMAIL PROTECTED] wrote:
and my table is marked crashed :-(
Please please upgrade to latest version (4.0.20) in binary format (download
from www.mysql.com) and check on it. Good chances are that everything will run
fine.
--
For technical support contracts, goto
Konstantin Yotov [EMAIL PROTECTED] wrote:
mysqlcheck -r is very slow when repair big tables
(over 4GB data - repair it 1h and 40m). Is there any
config option to fasten it.
Check your hard drives setup and throughput, it's not related to MySQL.
--
For technical support contracts, goto
íÉÈÁÉÌ íÏÎÁÛ£× [EMAIL PROTECTED] wrote:
Mihail, suda ne nado pisat' s russkim From :-)
How i can increase max allowed keys in myisam tables? I find this
sting in myisam.h:
#define MI_MAX_KEY 32 /* Max allowed keys */
Is it so simple? Or I must correct somthing more?
Demetrios Stavrinos [EMAIL PROTECTED] wrote:
Has any one heard or seen anything like it?
Sure. A hardware or kernel problem.
Get a stock kernel from ftp.kernel.org and compile a clean kernel for
your server if you know how to do it.
--
For technical support contracts, goto
Michael Stassen [EMAIL PROTECTED] wrote:
O
Well, clearly LD_LIBRARY_PATH isn't set at startup. That's one of the
reasons LD_LIBRARY_PATH isn't really the Solaris way, and is not
recommended. With a proper setup, you should never need LD_LIBRARY_PATH in
Solaris.
In any version of
From: root
To:
Subject: [second write process hangs if another one is writing already,!!but
in another database!!]
Description:
We have this mysql-server with two databases internet and
intranet.There are two data-collectors server1 and server2.Each writes
in one database. Server1 in
Well Actually the current Red Hat Release is Fedora Core 2 , which
works very well. You can find it here http://www.redhat.com/fedora/
Chris Hood
Investigator Verizon Global Security Operations Center
Email: [EMAIL PROTECTED]
Desk: 972.399.5900
Verizon Proprietary
NOTICE - This
I want to select first 10 records out of 100. And then get the 10th
position.
If i make use of
order by score asc limit 1
then I will get 100th record, How shall i pick up 10th position?
regards
Manisha
- Original Message -
From: Karl Pielorz [EMAIL PROTECTED]
To: Manisha Sathe
Emi Lu [EMAIL PROTECTED] wrote:
I have a questions about varchar columns change to CHAR columns
automatically.
See http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by
Mayuran Yogarajah [EMAIL PROTECTED] wrote:
Is there any command I can issue to release ALL locks held by any/all
transactions ? I know that restarting the server does this, but is there
a way to do this without restarting ?
No.
--
For technical support contracts, goto
yes, but is there any better way of doing it ?
regards
Manisha
- Original Message -
From: Karl Pielorz [EMAIL PROTECTED]
To: Manisha Sathe [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, August 23, 2004 8:34 PM
Subject: Re: How to get the last record from the slected record set
I have a questions about varchar columns change to CHAR columns
automatically.
See http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html
In addition to that - it doesn't really matter as the CHAR datatype
isn't properly implemented in MySQL and behaves the same as
the VARCHAR
* Manisha Sathe
I want to select first 10 records out of 100. And then get the 10th
position.
If i make use of
order by score asc limit 1
then I will get 100th record, How shall i pick up 10th position?
Try this:
order by score desc LIMIT 9,1
--
Roger
--
MySQL General Mailing
have MySQL 4.0.20 on my mac os x 10.3.x client machine. My question is, how do I go
about getting my MySQL databases that I created to another computer. I have been told
my databases are in /usr/local/mysql/data. When I try to get into the sub-directory
/data it says I do not have
Should mysql version 4.0.20 support the Insert data from a textfile into table which
is shown at the bottom of the page while in phpmyadmin with a database and table
selected? I am getting this error:
#1148 - The used command is not allowed with this MySQL version.
Thanks for any help,
Doug
Manisha Sathe wrote:
I want to select first 10 records out of 100. And then get the 10th
position.
If i make use of
order by score asc limit 1
then I will get 100th record, How shall i pick up 10th position?
regards
Manisha
order by score desc limit 9,1
--
MySQL General Mailing List
For list
How come when I am using the terminal on my mac os x 10.3.x and give the command show
databases I only see one database (the 'test' database that is included in the
install') as compared to viewing databases with my browser and phpmyadmin I can see 6
databases (that same 'test' database, a
--On 22 August 2004 21:05 +0800 Manisha Sathe [EMAIL PROTECTED]
wrote:
I want to select first 10 records out of 100. And then get the 10th
position.
If i make use of
order by score asc limit 1
then I will get 100th record, How shall i pick up 10th position?
I'm not quite sure I follow what
Ken Sorensen [EMAIL PROTECTED] wrote:
I am stumped. I have a very busy MySQL db that we've run for
about 3 years with no problems. A couple of months ago we upgraded
the system to RH-3AS with RedHat's distro mysql-server 3.23.58-1.9.
Recently I've started getting zombie processes ([mysql
Are you loggin into the terminal and PHPmyadmin as the same user?
-Original Message-
From: Hull, Douglas D
To: Note To MySQL List (E-mail)
Sent: 8/23/04 8:30 AM
Subject: showing dbs in terminal window opposed to phpmyadmin
How come when I am using the terminal on my mac os x 10.3.x and
Hello.
I'm looking for a schema designer / relations editor which
is GUI, supports MySQL and runs on *nix, either commercial
or freeware.
Can you suggest me something?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
Hi,
I don'e know if this will help as I am probably only one step ahead of you
here, but if it does great. If not you can just delete it.
How are you going to access the data? Via a program, PHP, using queries?
I am a newbie to this area myself, and use Delphi.
I know that using Delphi with
Hi,
you might want to try this:
DBDesigner from FabForce.
http://www.fabforce.net/dbdesigner4/
Regards,
Jens
Egor Egorov wrote:
Hello.
I'm looking for a schema designer / relations editor which
is GUI, supports MySQL and runs on *nix, either commercial
or freeware.
Can you suggest me something?
Hi,
I'm trying to use mysqlhotcopy to make a backup of some mysql
databases.
But when i try to run mysqlhotcopy I'm getting this error,
[EMAIL PROTECTED] Temp]# mysqlhotcopy -u root dbxpto /root/Temp
DBD::mysql::db do failed: You have an error in your SQL syntax near '`
READ,
Thanks to all of, I could get it
Thanks
Manisha
- Original Message -
From: Karl Pielorz [EMAIL PROTECTED]
To: Manisha Sathe [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, August 23, 2004 9:52 PM
Subject: Re: How to get the last record from the slected record set
--On 22
I'm trying to configure and install super-smack-1.2 and get a problem on configure.
it's looking for mysql_real_connect and can't find it...where would this be located?
I'm assuming it is in libmysqlclient.so, and I have that file in my /usr/lib/mysql
folder, among other places...but it
SELECT
foo
INTO OUTFILE
'\\l030k12\qcda\2004-08-03.html'
WHATEVER
foo;
Is that possible? I seem to be doing it wrong.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Scott,
At 11:58 AM 8/23/2004, you wrote:
SELECT
foo
INTO OUTFILE
'\\l030k12\qcda\2004-08-03.html'
WHATEVER
foo;
Is that possible? I seem to be doing it wrong.
select * into outfile 'p:\win2ktmp\mytest.txt' from mytable
where
order by
Make sure the output
If you wanted html output you could do this
mysql -uuser -p -H -equery_to_run webFile.html
...
The -H switch produces HTML output.
-Original Message-
From: mos
To: [EMAIL PROTECTED]
Sent: 8/23/04 12:11 PM
Subject: Re: into outfile
Scott,
At 11:58 AM 8/23/2004, you wrote:
SELECT
At 12:59 PM 8/23/2004, you wrote:
If you wanted html output you could do this
mysql -uuser -p -H -equery_to_run webFile.html
...
The -H switch produces HTML output.
It would be real nice if they added this feature to the Select statement. :-)
Mike
--
MySQL General Mailing List
For list archives:
Hello
I have a db with table usuarios I erased all data in this table but Id
is a autoinc and he have the value of the last value.
How I can Reset the field ID
thanks
---
Hola
Yo tengo una db con una tabla usuarios, yo borre todos los campos de la db
pero el campo
Try
alter table usuarios auto_increment = 1;
-Original Message-
From: Yusdaniel Rodriguez Espinosa
To: [EMAIL PROTECTED]
Sent: 8/23/04 9:15 AM
Subject: How to Reset a field
Hello
I have a db with table usuarios I erased all data in this table but
Id
is a autoinc and he have the value of
You could also have done this:
TRUNCATE TABLE usarios;
That will drop the table completely and then recreate it anew (and
empty). It will give you a fresh start.
--V
Victor Pendleton wrote:
Try
alter table usuarios auto_increment = 1;
-Original Message-
From: Yusdaniel Rodriguez
I have a database where, most of the time, I'm bulk-loading
data into new tables from an external source, several million
rows at a time. For this purpose, I create the tables without
indexes, and then add all my indexes after the load is done,
for efficiency purposes.
I'd now like to add the
I think that it is not a OS problem or mysql built.
I tested it in many version of mysql and I created the records from web by
crawling.
so whenever I test, the records are NEW. but the same error must occur to.
I think it is so curious that it makes no error in small scale tables.
I think
Why don't you disable the indexes before the load and enable the indexes
after the data load?
-Original Message-
From: Jesse Sheidlower
To: [EMAIL PROTECTED]
Sent: 8/23/04 3:33 PM
Subject: Testing for the existence of an index
I have a database where, most of the time, I'm bulk-loading
Why don't you download navicat or use php admin and then just open the table
up in design view? You can then see if it has an index or not and add one if
you need?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Donde estas tratando hacer eso, en el command line cierto? O estas
trabajando con mysql front o con algun otra programa? Perdon estoy muy nuevo
no entiendo donde hacer alter table usuarios auto_increment = 1, mil
gracias
--
MySQL General Mailing List
For list archives:
I have an app I'm using (I have source, but I'm not the programmer), that works pretty
good, but it seems to be speed-limited because of the time to connect to the mysql
server.
I run with IP's only, no DNS lookups and such, and things are better, but I think it
could
improve.
Is there a C
Hi,
Here's a table of mine
namedate changeDate
n1d1 cd1
n2d1 cd3
n2d2 cd1
n4d1 cd2
n1d2 cd5
n5d1 cd4
n6d2 cd2
I need to select every name for which the changeDate
corresponding
What's the purpose of the entry in the user table where it has
host='localhost' and user='' (blank) and all of the permissions set to N?
In other words, is this some sort of security safety net and it would be
dangerous to delete it? Or is it an example of setting up an anonymous
locahost
On Mon, Aug 23, 2004 at 03:45:28PM -0500, Victor Pendleton wrote:
Why don't you disable the indexes before the load and enable the indexes
after the data load?
If I'm bulk-loading a fresh install of data, then I'll be using
un-indexed tables and index them afterwards. Otherwise, I want
to keep
Hi Jens and Egor,
This is a very nice little product unfortunately it only appears to
compile on Linux not other *nixes. If anybody can get it to compile can
they please let me know? It works great on shudder Windows shudder.
However, it certainly connects with MySQL (is inbuilt) and is easy to
Also you can also use the crle command to build a permanent set of
library paths similar to ldconfig in Linux and other unices. There
should be a man page for it on your system. You can simply add
/usr/local/lib to there in the correct order and this resolves having to
use LD_LIBRARY_PATH.
Hello All,
I have a table that has a PartNumber and the Quantity of Items sold for
each partNumber, that is:
PartNumber
Qty
I need to get its sales raking given its PartNumber, that is. So if I
order the table by Qyt in descending order the first
record will be the partNumber that sold the
Thanks again for a wonderful detailed response. The
part that was still bothering me was the
multiple-same-category fields. I get locked into this
thinking and well, it's difficult to let go.
Then I tried something on a table that had
MemID, Doc1, Doc2, Doc3
I had put Doc1 in a few hours
Hit all, I have a question. I am working on a part inventory program for
work. I'm writing it in PHP4. I got the connection ok, the form ok and
all that. My problem came when I went to do the insert. I did INSERT
INTO table VALUES 'val1', 'val2' etc well when I ran the page, it gave
me a query
On Mon, 23 Aug 2004 15:25:21 +0200, Martijn Tonies [EMAIL PROTECTED] wrote:
I have a questions about varchar columns change to CHAR columns
automatically.
See http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html
In addition to that - it doesn't really matter as the CHAR
Hi Claire,
On Mon, 23 Aug 2004 14:52:29 -0700 (PDT), Claire Lee [EMAIL PROTECTED] wrote:
Hi,
Here's a table of mine
namedate changeDate
n1d1 cd1
n2d1 cd3
n2d2 cd1
n4d1 cd2
n1d2 cd5
n5d1
You can use LIMIT. For the 123rd position:
SELECT PartNumber, Qty
FROM your table
ORDER BY Qty DESC
LIMIT 122, 1;
With 2 arguments, LIMIT treats the first as the offset to the starting row
(0 = first row, so 122 = position 123) and the second as the number of
rows to show.
This is
If your insert really looks like what you have here, it's not complaining
about the quote character. You have a syntax error. If you are inserting a
value in every column, you need
INSERT INTO table VALUES ('val1', 'val2', ...);
You left out the parentheses. See the manual for correct
Hello everyone,
The master is moderately busy with load average of
2-3. This has worked very well for a long time
before I started replication (few months). When
replication is started, both master and slave
appear to work fine with no significant increase of
load on either side.
But, after a
Hi All,
Here's my table structure
Table 1: STM (Store Master)
STR_CODE
Desc
part_number
Table 2 : MRC(Master Received)
Ref_No
Rec_date
Table 3 : DRC (Detail Recived)
Ref_no
PO_No
STR_CODE
76 matches
Mail list logo