Hoskins'
Cc: '[EMAIL PROTECTED]'
Subject: RE: select help
No problem. Use mod(m,n). To get the records where the 8 bit is set, use
and mod(os.os_id,8) = 0;
mysql use test
Database changed
mysql create table t (i integer);
Query OK, 0 rows affected (0.18 sec)
mysql insert into t values (1
: Michael Shulman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 11:38 AM
To: 'John Hoskins'
Cc: '[EMAIL PROTECTED]'
Subject: RE: select help
No problem. Use mod(m,n). To get the records where the 8 bit is set, use
and mod(os.os_id,8) = 0;
mysql use test
Database changed
mysql
-Original Message-
From: Michael Shulman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 11:38 AM
To: 'John Hoskins'
Cc: '[EMAIL PROTECTED]'
Subject: RE: select help
No problem. Use mod(m,n). To get the records where the 8 bit is set, use
and mod(os.os_id,8) = 0
Jeff Shapiro wrote:
If you want to be a bit more generic you could do something like this:
# store the desired OS ID into a variable
SELECT @desired_id := os_id FROM os_table WHERE os_name = win nt;
# now find the solutions that match with the os_id
SELECT o.os_id, o.os_name, s.os_code,
On Friday 28 March 2003 13:59, Ing.Peter Misovic wrote:
i have deleted mysql database,
can i restore it with start defaults ?
mysql_install_db is your solution. :)
Thailon, Slovakia
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by
On Fri, Mar 28, 2003 at 06:10:55PM +0100, Vidar wrote:
Hi
I know that you may set max binlog size with the max_binlog_size
variable. However, is it possible to control the size of the
relay-bin logs on the slave servers as well?
I don't believe it's documented (yet?) but I seem to remember
Try reading your return codes.
You got a duplicate key error that you were ignoring.
C. Reeve wrote:
I got it - stupid me has a unique field that I wasn't using in the test
script I was using - so every I tried to add an entry this field was a
duplicate and as such did not add the record. Is
On 27-Mar-2003 C. Reeve wrote:
I got it - stupid me has a unique field that I wasn't using in the test
script I was using - so every I tried to add an entry this field was a
duplicate and as such did not add the record. Is there a way to put
something in so mysql would tell me this - 2 hours
: MySQL List [EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 9:32 AM
Subject: Re: Fw: Help, Insert not working.
Try reading your return codes.
You got a duplicate key error that you were ignoring.
C. Reeve wrote:
I got it - stupid me has a unique field that I wasn't using in the test
script I
Charles Kline wrote:
I am fairly new to SQL and this is a really complex query for me.
Possibly more complex than necessary. Must you have a separate column
for each of the areas? If you don't mind having them all in a single
column, the query becomes simple and efficient:
SELECT p.fname,
--- Andrew [EMAIL PROTECTED] wrote:
Hi All MySQL guru's
I have a query that I need some help with. I have put into operation a setup
that needs to be chnaged and could do with a little help before the Db get
any
bigger. It's only a small MySQL DB at the moment but will grow so I need to
* [EMAIL PROTECTED]
Two tables
1. Clients
ClientID (Primary Key, Unsigned int , Auto_Increment)
Vehicle typeChar(200)
Vehicle Color CHAR(200)
2. Service
ServiceID (Primary Key, Unsigned int , Auto_Increment)
ClientID
On Friday 07 March 2003 00:43, Chris Montgomery wrote:
I have been using MS Access for 5+ years and am new to MySQL. I
understand the theory behind setting relationships between tables, but
am trying to get up to speed in how to do it in MySQL.
My environment: Win2k and MySQL 3.23.54
Howdy Egor,
Friday, March 7, 2003, 7:36:00 AM, Egor Egorov wrote:
Both columns Node are indexed, so just add foreign key constraint. You can
find examples in the InnoDB manual:
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
I've looked at the examples, but one thing it doesn't
Disregard my previous msg. It looks like I have it figured out.
Friday, March 7, 2003, 5:31:38 PM, Chris Montgomery wrote:
I've looked at the examples, but one thing it doesn't mention is whether
both indexes need to be unique. In the primary table they are, but does
the index in the table
This should do what you want:
UPDATE Table2, Table1 SET
Table2.DataDestination=Table1.DataSource WHERE
Table1.col1=Table2.col1 AND Table1.col2=Table2.col2
AND Table1.col3=Table2.col3;
--- PandaCoop-Krasimir_Slaveykov [EMAIL PROTECTED]
wrote: Hello mysql,
I have 2 tables :
Table1:
On 26-Feb-2003 John Hoskins wrote:
Probably a simple query but, I need to find select a field with data that
exists in one table but does not exist in a field in another table.
example:
table1.name table2.name
---
bob
On Friday 21 February 2003 19:38, you wrote:
You asked:
Does replication user have REPLICATION SLAVE privilege?
Yes it does.
Connect to the master as replication user and see if SHOW SLAVE HOSTS gives
any error messages.
--
For technical support contracts, goto
On Thursday 20 February 2003 02:17 pm, Ajay Patel wrote:
I have a host table where I save the platform model. The platform model
can be saved in various ways. For example,
Sun Enterprise 250 (2 x UltraSPARC 164MHz)
Sun Enterprise 250 (2 x UltraSPARC-II 400MHz)
Sun Enterprise 250 (2 x
On Thursday 20 February 2003 09:28, saravanan saravanan wrote:
I am using mysql for my project.I am finding
problems of using FOREIGN KEY and STORED procedures in
version 4.0.please help me and send the details as
earlier as possible
Stored Procedures are not supported in MySQL yet.
Veysel Harun Sahin wrote:
select vanNumber, sum(grossPay) from usertableDaily group by vanNumber;
The above is the correct query, to save yourself some time. As for your
problem:
But when I execute I get this:
Resource id#3
Resource id#4
This means you're using a resource
select vanNumber, sum(grossPay) from usertableDaily group by vanNumber;
[EMAIL PROTECTED] wrote:
hello,
I've performed searches on this site and php.net to try and figure out
why this is occuring. I can't find any instance in my searches that
helped me. So, I'm posting my very first question
Hi
Interesting problem, normally to get a total by type, you would have a query
like,
select van, sum(pay) from ($usertableDaily) group by van;
However you are individually quering each total, your approach is correct, but
slower.
The problem you have though is the return of
Resource
Are you referencing the result set correctly in php ?
How are you dealing with what MySQL returns ?
Looks like the info is there, you just not getting it out of the result
set.
-
Jerry @
MetalCat.Net
-
- Original Message -
From: Guru Geek
I think you can't
If you want this why is this table structure? Details shold be as columns
nos as records in separate table - just to lose time ?
On Tue, 11 Feb 2003 13:13:31 +, Jeff Snoxell [EMAIL PROTECTED]
wrote:
Hi,
How can I write a MySQL query to grab single lines of the form:
You have one column detail - What do you mean by detail1, detail2 and so?
=
On Tue, 11 Feb 2003 13:13:31 +, Jeff Snoxell [EMAIL PROTECTED]
wrote:
Hi,
How can I write a MySQL query to grab single lines of the form:
Lars,
if I understand you correctly:
create table table1
(
hotel_number int
);
create table table2
(
hotel_number int,
free_day datetime
);
insert into table1 values(1);
insert into table1 values(2);
insert into table1 values(3);
insert into table2 values(1,Jan 1 2003);
At 9:24 -0600 2/5/03, Jaime Teng wrote:
I have a MySQL table:
++--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-++
| id
DISTINCT?
-Original Message-
From: Tab Alleman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 12:31 PM
To: Jaime Teng; [EMAIL PROTECTED]
Subject: RE: need help with GROUP BY
SELECT id,account FROM tablename WHERE detail LIKE '%pattern%' GROUP BY
Account;
-Original
SELECT id,account FROM tablename WHERE detail LIKE '%pattern%' GROUP BY
Account;
-Original Message-
From: Jaime Teng [mailto:[EMAIL PROTECTED]]
I have a MySQL table:
...
It should only return *one* result per account.
Jaime,
You should be using the DISTINCT function.
SELECT DISTINCT account, id, FROM etc.
This should give you one instant of 'account' in your SELECT output.
At 09:24 AM 2/5/03 +, Jaime Teng wrote:
I have a MySQL table:
Jaime,
You should be using the DISTINCT function.
SELECT DISTINCT account, id, FROM etc.
This should give you one instant of 'account' in your SELECT output.
At 09:24 AM 2/5/03 +, Jaime Teng wrote:
I have a MySQL table:
* [EMAIL PROTECTED]
I've been a member of this mailing list for quite a long time and very
thankful that most of my difficulty in creating queries are being answered
by just reading responses to questions. Right now I have a problem in
creating a query (in fact I'm not sure if this is
On Wednesday 22 January 2003 12:10, Haydar KOCAK wrote:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
[1]+ Exit 1 ./bin/mysqld_safe --user=mysql
Check with
ps ax | grep mysqld
that MySQL server is running.
--
For
What does mysqld.log say?
Manuel Velasco wrote:
I'm getting the following messages after running
safe_mysqld (as root):
leo:/usr/bin # ./safe_mysqld
[1] 4798
leo:/usr/bin # Starting mysqld daemon with databases
from /var/lib/mysql
030121 19:38:15 mysqld ended
[1]+ Done
What version of MySQL are you using? UNION is implemented in MySQL 4.0.0.
Check out http://www.mysql.com/doc/en/UNION.html
for more information.
Victor Pendleton
-Original Message-
From: Garry Rothert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 8:11 AM
To: [EMAIL
Garry,
You are using mysql version 4? Unions are only supported in version 4.
If so, the only difference I can see from your example to the manual is that
each select is in brackets in the manual. Try the query:
(select cnumber from spouse where fd_status = A)
union
(select cnumber from
Natale,
please address these general questions to [EMAIL PROTECTED]
InnoDB requires that the indexes are created explicitly. It would require a
change to MySQL to automate the creation of them.
Without indexes foreign key checks would be very slow because then every
check would have to do a
Hello Dolly,
Kindly state and share with us the error encountered if there were any.
Your source code would also be of help :-)
Fred.
dolly wrote:
Hi,
I installed MySQL 4.0 on Red Hat 8.0 server and able to connect from
mysqlgui application. I couldn't connect from ODBC ver 2.50 nor 3.51.
On Sunday 05 January 2003 09:08, Anton Zavrin wrote:
Well, I read, played around and updated it (I guess)
Now, when I try to start mysql with this command (same as before), it
gives me that:
# /usr/local/bin/safe_mysqld --user=mysql
[1] 71491
# Starting mysqld daemon with databases from
, iConnect (Berlin)' [EMAIL PROTECTED]; 'Thomas
Spahni' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, January 05, 2003 8:08 AM
Subject: RE: MySQL Help Needed Please
Well, I read, played around and updated it (I guess)
Now, when I try to start mysql with this command (same as before), it
gives me
:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 7:01 AM
To: Anton Zavrin
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL Help Needed Please
Anton,
check the hostname.err and hostname.log files in your data
directory.
Then check permissions. My sock file looks like:
srwxrwxrwx1 mysqldaemon
7970948-3
- Original Message -
From: Anton Zavrin [EMAIL PROTECTED]
To: 'Thomas Spahni' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, January 04, 2003 9:01 AM
Subject: RE: MySQL Help Needed Please
I have this file:
srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock
I
) [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 04, 2003 8:01 AM
To: Anton Zavrin; 'Thomas Spahni'
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL Help Needed Please
Anton,
first thing, try:
ps [whatever options] | grep mysqld
The daemon (database server) is called mysqld, not mysql.
Regards
04, 2003 9:59 PM
Subject: RE: MySQL Help Needed Please
Did:
ps -ef | grep mysqld
got nothing
Though I can do:
# mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
#
Anything else I should try :( ?
Best Regards, Anton
, January 04, 2003 2:14 PM
To: Anton Zavrin; 'Thomas Spahni'
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL Help Needed Please
Anton,
ps -ef | grep mysqld
got nothing
Because the MySQL SERVER isn't running!
Though I can do:
# mysql -u root -p
With this command, you start the MySQL Monitor (that's
Anton,
check the hostname.err and hostname.log files in your data directory.
Then check permissions. My sock file looks like:
srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock
and finally check for your
socket= /tmp/mysql.sock
entries in /etc/my.cnf and
David,
I am unsure if I followed your example completely, but maybe this might
help. Not knowing your complete database structure, I am unsure if my
comments will be entirely valid but here goes.
I think you could achieve your goal if you think of your groups as
containing one or many clients.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Frank, et al --
...and then Frank Peavy said...
%
% David,
% I am unsure if I followed your example completely, but maybe this might
% help. Not knowing your complete database structure, I am unsure if my
% comments will be entirely valid but here
David,
Just some thoughts..
See my comments below...
A scheduling, or a booking, eventually has to have a class type (private
or one of many groups -- so I suppose I could simply make a group class
type 'private' and that type has only one slot), an instructor, a place,
a time slot, and the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Frank --
...and then Frank Peavy said...
%
% David,
% Just some thoughts..
% See my comments below...
Thanks!
%
% A scheduling, or a booking, eventually has to have a class type (private
% or one of many groups -- so I suppose I could simply
Even so, that still doesn't answer the question of how to have data of
different magnitude in the same table. If I have one class with one
person and another with two people, how would I have a single record for
each which lists the client(s)?
Easy,
Your scheduling query results, as I said:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Frank --
...and then Frank Peavy said...
%
% Even so, that still doesn't answer the question of how to have data of
% different magnitude in the same table. If I have one class with one
% person and another with two people, how would I have a
Hi. I noticed a couple of weird things with your script:
- The error DBI-connect(myd) failed: Couldn't connect to... is
happening I think because 'DBI:mysqlPP:myd' is in single quotes when you
call DBI-connect, and the syntax seems off. Maybe you'll have better
success if you follow the syntax
You want to look at 'group by acctSrv.accountID' rather than a compound
select.
On Mon, 23 Dec 2002, Adam Nowalsky wrote:
Date: Mon, 23 Dec 2002 09:04:32 -0500
From: Adam Nowalsky [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: sql help
hi, wonder if the sql gurus can help with this
I Installed succefully MySQL, but i want to have a graphical interface to
create a new databases and manage my existing database.
i readed in a asp-php.net (french web site)
http://www.asp-php.net/tutorial/asp-php/iis_et_mysql.php?page=1
the steps for installing phpmyadmin, you cas see the web
I guess your question is more about configuring IIS (or PWS) than about
MySQL.
Anyway, you have to create a web site in IIS pointing to your phpMyAdmin
directory and define in it the default document (index.html. default.php
or whatever)
Adolfo
-Original Message-
From: Rachid
On Friday 13 December 2002 22:19, Benjamin Fisher wrote:
I'm fairly new to MySQL, and RDBMS's in general, but not to system
administration nor linux. I'm running Gentoo, and I can't seem to get
mySQL to work.
[skip]
My guess, it can't find the pid to stop it with.
And the file
You need to do a join ...
SELECT T.*
FROM transport AS T, acl AS A
WHERE T.id=A.id AND
A.adminId='1'
--Joe
--
Joe Stump [EMAIL PROTECTED]
http://www.joestump.net
-Original Message-
From: news [mailto:[EMAIL PROTECTED]]On Behalf Of Max Clark
Sent: Wednesday, December 11, 2002
Is there a good tutorial somewhere on the join command. No matter what
I do
it just doesn't work. Obviously I'm doing something wrong, but the
MySQL
manual just doesn't help at all.
Try this link.
http://www.devshed.com/Server_Side/MySQL/Join/page1.html
One of the best books for understanding
At 15:18 -0800 11/28/02, [EMAIL PROTECTED] wrote:
Have MySQL db with hundreds of thousands of event records from
geographically dispersed logging devices. The logs are batched and
auto loaded/parsed into MySQL on a daily/weekly basis depending on
external factors. As an example, during a 7
theapparatus,
Thursday, November 21, 2002, 5:35:04 AM, you wrote:
tandn I just have a quick question. I've been setting up a
tandn website using a MySQL database loaded with a large
tandn number of articles but I'm having a problem.
tandn Some of the articles did not load correctly into the
I took a look at the command but I don't see where you tell
mysql which specific field to use within a specific column. The
rest of the column is fine and I understand the id=# points at the
column that I want.
Thanks for the response btw,
Mike Wendell
At 01:07 PM 11/21/2002 +0200, you wrote:
Hi,
Perror 13 means :
perror 13
Error code 13: Permission denied
So it seems you don't have the permission to create the temporary table is
this directory.
Regards,
Jocelyn
- Original Message -
From: Stefan Hinz [EMAIL PROTECTED]
To: MySQL Main List [EMAIL PROTECTED]
Sent: Monday,
: +49 30 7970948-3
- Original Message -
From: Jocelyn Fournier [EMAIL PROTECTED]
To: Stefan Hinz [EMAIL PROTECTED]; MySQL Main List
[EMAIL PROTECTED]
Sent: Monday, November 18, 2002 8:32 PM
Subject: Re: Please help with strange Win2K error
Hi,
Perror 13 means :
perror 13
Error code
You might want to try actually running the query.
mysql_query ($query);
or
mysql_query ($query,$db);
depending on your preference.
-Original Message-
From: Beauford [mailto:beauford.2003;rogers.com]
Sent: Thursday, November 14, 2002 1:53 PM
To: [EMAIL PROTECTED]
Subject: Update help
Hi,
' (Using password: NO)'
Ugh. :)
-Original Message-
From: Paul DuBois [mailto:paul;snake.net]
Sent: Tuesday, November 12, 2002 7:21 PM
To: Black, Kelly W [PCS]; 'Phil Iovino'; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help
At 11:45 -0600 11/12/02, Black, Kelly W [PCS
Right.
My mistake.
I think you get the general idea.
~K Black
-Original Message-
From: Paul DuBois [mailto:paul;snake.net]
Sent: Tuesday, November 12, 2002 4:21 PM
To: Black, Kelly W [PCS]; 'Phil Iovino'; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help
At 11:45
localhost
~Kelly W. Black
-Original Message-
From: Phil Iovino [mailto:phil;nxtek.net]
Sent: Wednesday, November 13, 2002 10:36 AM
To: 'Paul DuBois'; Black, Kelly W [PCS]; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help
I wasn't sure if I was supposed to use 'root
] [mailto:kblack05;sprintspectrum.com]
Sent: Wednesday, November 13, 2002 1:39 PM
To: 'Phil Iovino'; 'Paul DuBois'; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help
Sorry I made a mistake as Paul pointed out.
I meant
GRANT ALL ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'somepassword
Scott Pippin
[EMAIL PROTECTED]
Phil Iovino [EMAIL PROTECTED] 11/12/02 08:13AM
I'm trying to install MySQL under RedHat 8. I installed the MySQL
3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs.
Per the instructions at
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.htm
, 2002 10:43 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Installation Help
Scott Pippin
[EMAIL PROTECTED]
Phil Iovino [EMAIL PROTECTED] 11/12/02 08:13AM
I'm trying to install MySQL under RedHat 8. I installed the MySQL
3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs.
Per
.
Since I installed with the RPM didn't it give root permission?
-Original Message-
From: Scott Pippin [mailto:spippin;mtctrains.com]
Sent: Tuesday, November 12, 2002 10:43 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Installation Help
Scott Pippin
[EMAIL PROTECTED
. Black
-Original Message-
From: Phil Iovino [mailto:phil;nxtek.net]
Sent: Tuesday, November 12, 2002 8:14 AM
To: 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help
I believe root has all permissions. I'm using Webmin to verify it.
I started it with -u root but still got
At 11:45 -0600 11/12/02, Black, Kelly W [PCS] wrote:
Make sure you issued the correct GRANT statements
at the sql, query.
mysqluse mysql;
Database Changed
mysql GRANT * ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'somepassword';
That's not quite right.
- GRANT * is not legal, I suspect you
john,
Saturday, November 09, 2002, 9:45:15 PM, you wrote:
j Ok.. I got the /etc/my.cnf under control, but now when I do this:
j root@rock:/etc# mysqladmin -u root -h rock password *
j mysqladmin: connect to server at 'rock' failed
j error: 'Host 'rock.biohazard.org' is not allowed to connect
I dont have a my.cnf file, so I touched /etc/my.conf still doesnt
work. Where do
I find a .cnf file to copy over?
and
root@rock:/var/run/mysql# ls
mysql.sock= it exists.
What could my problem be..? I even upgraded. I am using Slackware 8.1
with 2.4.19 kernel. Maybe that will help.
Thanks so
On Sat, 2002-11-09 at 14:45, john wrote:
Ok.. I got the /etc/my.cnf under control, but now when I do this:
root@rock:/etc# mysqladmin -u root -h rock password *
mysqladmin: connect to server at 'rock' failed
error: 'Host 'rock.biohazard.org' is not allowed to connect to this
MySQL
Make sure you use the complete line of syntax
mysqladmin -u username -p -h hostname create databasename
password: (enter the password to that userid here)
Oh yeah sql query .
~Kelly W. Black
-Original Message-
From: john [mailto:john;cllug.org]
Sent: Monday, November 04, 2002 3:53
On Mon, 2002-11-04 at 18:52, john wrote:
When I start safe_mysqld , I get a command prompt back again and ps aux
shows this:
mysql30269 0.0 0.1 10580 1024 pts/1S17:38 0:00
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
Jeff,
Try a JOIN:
http://www.mysql.com/doc/en/JOIN.html
or for some good articles:
http://www.onlamp.com/pub/ct/19
HTH!
Cory
On Fri, 2002-11-01 at 10:01, jeff wrote:
Hello
I am having some trouble writing a query that will pull the information I
need from the database. I hope it's
I have been successful (after days of trying) with Apache 2.0.43 ,
PHP 4.2.3 on Redhat 7.3
I compiled php with ./configure --with-mysql --with-apxs2=/apth/to/apxs
(apxs is under /path/to/apache2/bin)
After 'make' and 'make install' you will find libphp4.so in
/path/to/apache2/modules
Then I
Akash,
Sunday, October 27, 2002, 10:49:55 AM, you wrote:
A I came across a strange problem in MySQL. Some of the tables are getting
A corrupted. The most common error messages which I encountered are : Can't
A open file: 'tablename.MYD'. (errno: 145) and Got error 127 from table
A handler.
A
corrupted. The most common error messages which I encountered are : Can't
open file: 'tablename.MYD'. (errno: 145) and Got error 127 from table
handler.
I rectified it by shutting down the MySQL Server and using myisamchk
with the options -r and sometimes -o.
145 = Table was marked as
Try again.
-Original Message-
From: [EMAIL PROTECTED] [mailto:mysql;lists.mysql.com]
Sent: Sunday, October 27, 2002 9:17 PM
To: John Meyer
Subject: Re: RE: plz help...tables getting corrupted...
Your message cannot be posted because it appears to be either spam or
simply off topic
Does no one know how to compile a program with the myisam
library?
I will gladly put together a simple document on it for others
if someone can just point me in the proper direction, i.e. which
header files are required (I get a bunch of warnings if I just
include myisam.h), and what the
Heh... it seems like a perfect solution to me... I am loading
a few million records a day into tables... building a new table
and swapping out the old... I have to process the data a little,
so to speed it up I've been forking children and passing 1
record files to load into LOAD DATA INFILE
Hi all... I am attempting to play with the myisam
api to try to make loading hordes of data a little
simpler/faster, and so am trying out the myisam interface...
specifically, eventually to try an wrap it in a perl
module. Herein lies my problem...
I know enough C to get by, but am having
Kolari,
Sunday, October 20, 2002, 9:26:45 PM, you wrote:
KSB I am totally new to MySQL. I have read the documentation and an OReilly
KSB book on MySQL; all discuss installation and configuration from source
KSB and binary but not RPM. I have installed MySQL 4.0.4 RPM package in a
KSB PC
On Mon, 2002-10-21 at 13:07, Chip Rose wrote:
I can't get PHP-4.2.3 compiled to work with MySQL and Apache, despite months
of trying. Apache compiled ok, and so did MySQL -both work, on my Debian
Linux box.
I've tried various combos of installing the Deb packages, compiling from
source,
It looks like you have a dynamic IP your end and the mysql server is looking
for a fixed IP.
Try name based DNS form your PC.
Simon
-Original Message-
From: [EMAIL PROTECTED] [mailto:manuvi;eth.net]
Sent: 18 October 2002 09:38
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Urgent
It looks like you have a dynamic IP your end and the mysql
server is looking
for a fixed IP.
Nope, you read it wrong, both of you. MySQL is printing out YOUR IP
address, not the address of the server. It's complaining that you don't
have permission to access the data you want.
sql, query.
Hello jantos,
Tuesday, October 15, 2002, 2:03:50 PM, you wrote:
jamdd when I'm connecting to mysql-server via tcp/ip then the mysql-server
jamdd cuts the connection and it restarts the mysql-server.
jamdd when I don't make connections from other hosts than it's running
Hi there!
After include /usr/local/bin on the library path as was suggested
by ED appears to work because isn't complaining about any more but
It broke again on something different.
Please any Idea?
Thanks
Jose Albert
Here the output
\...
I'm still trying to build mysql-3.23.51
Ed thanks for your replay
But the libraries are there on the path
PATH=/usr/local/lib:/usr/lib:/usr/local/:/usr/local/bin:/usr/bin:/u
sr/ccs/bin/:/usr/ucb:/etc:.
bash-2.05$ ls /usr/local/lib/libstdc++.so.5
/usr/local/lib/libstdc++.so.5
- Jose
g++ -O3 -DDBUG_OFF -fno-implicit-templates
Hi
Two thoughts
try \r\n instead of \n
or
if you are getting warnings it may be that there is a problem with the
data - illegal characters or something?
if neither works email me offlist and I will take a look, if that helps.
HTH
Peter
---
On Thursday, Oct 10, 2002, at 02:26 America/Phoenix, Nasir Aziz Gill
wrote:
Hi fellows,
I got one text file of 9816 records (9816 lines) seprated by commas and
enclosed by the inverted quotes and seprated by the end of lines. But
when I
import the file, it only gets half of records in
I did the following to resolve the problem.
1. Your create command didnt work for me and I changed the add(128) on line
6 to addrs varchar(128). I suppose this was a typo since you already had a
working table.
2. Your main problem comes from the format of your input. Use /N for
ommited column
Maybe I'm way out here, but this happens to me (or similar) quite often.
My solution; SELECT DISTINCT
And a single row will be returned for each.
Niclas
On Tuesday 08 October 2002 21:48, Michael Knauf/Niles wrote:
Here's a query for ya:
SELECT products.product_name, products.fg_number,
* Dragos Madalin Popa
I am trying to run this update statement, but I got an error syntax...near
offsetCould You please point out what is wrong?
Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where
ABBREVIATION is null;
Use the CONCAT function:
URL:
901 - 1000 of 1409 matches
Mail list logo