Does anyone know how I can go about troubleshooting what is wrong here? This
is mysql on a Linux system
I have no idea how to begin troubleshooting why the ACCOUNTING.MYD file
can't be opened, I need some hints.
Thanks,
Chris
Fatal Error
A serious problem was encountered:
Execute failed
I've got a question.
In the otherwise-excellent Paul DuBois book, on page 427 or so it talks
about how you can do this:
GRANT SELECT ON menagerie.* TO ro_user@% IDENTIFIED BY dirt;
So I tried something similar:
mysql GRANT SELECT ON *.* TO mysql@% IDENTIFIED BY dirt;
ERROR 1064: You have an
From: Johannes Pretorius [EMAIL PROTECTED]
Date: Wed, 06 Jun 2001 16:49:45 +0200
To: Chris L. Gray [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Importing spreadsheet data into MySQL
Hi there
Yes you can do this by going into Access and op[ening the XLS file from
010511 18:05:14 mysqld started
010511 18:05:14 /usr/local/libexec/mysqld: Table 'mysql.host' doesn't exist
010511 18:05:14 mysqld ended
These error messages above are in the log when I start mysql with:
/usr/local/bin/safe_mysqld --user=mysql
I can't figure out why, I ran mysql_install_db
Good Day All,
I seem to be stuck in a fog. I know the answer is probably easy
Let's say I have a query:
SELECT * FROM myTable;
and it's stored in a file:
getData
Then I can do something like this...
% mysql -A -uuserID -ppassword databaseName getData
and I'll see output. That's fine
Hello,
I have a site that I'm trying to implement a search engine on existing and
archived news stories on a medium text datatype in a database.
I read the documentation and got it running, but unless I missed something
it's not doing what I want it to do.
For example, if I put in the
http://www.mysql.com/doc/M/y/MySQL_full-text_search.html
On 4/3/01 11:07 AM, "Oson, Chris M." [EMAIL PROTECTED] wrote:
Hello,
I have a site that I'm trying to implement a search engine on existing and
archived news stories on a medium text datatype in a database.
I read the do
rekha,
mysql select date_format(dateEntered, "%m-%d-%Y %H:%I") as dateEntered,
- date_format(date_add(dateEntered, interval 2 hour), "%m-%d-%Y %H:%I")
as '2 Hours Later'
- from newsStories where storyID = 1122;
+--+--+
| dateEntered | 2 Hours Later
Mike,
Excuse me if I'm wrong, but isn't using persistent connections more
server resource intensive? I'm trying to optimize the database on
a heavy site, and I decided not to use persistent connections.
Chris
-Original Message-
From: Michael Betts [mailto:[EMAIL PROTECTED]]
Sent:
James,
Gotta say that this is a bad reason to choose one product vs.
another... because it lacks a GUI to build queries? Undertanding SQL
is all well and good, but I can tell you that I would give anything to
have a query builder that works like the one for MS SQL server. You may
enjoy
Cal,
satire 1
I would love to see this list split into 2 lists. MySQL-Newbies and
MySQL-non-newbies. Non-newbies would be either an invitation-only list or
you have to pass a test to get in. (The test would contain questions that
are all in the manual, we don't care if you know, we care if
For what it's worth, here's my $0.02...
-- Is there something that you can do with MS SQL and you can not do with
MySQL?
MSSQL - has support for triggers, stored procedures, views, XML, and
transactions. I would
mention subqueries, but subqueries are on the way with mySQL.
MySQL -
Peter,
try
SELECT * FROM table WHERE title IS NULL LIMIT 1;
HTH,
Christopher Oson
-Original Message-
From: Peter Szekszardi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 5:36 AM
To: [EMAIL PROTECTED]
Subject: selecting null values
Hi,
I have a database which has a
Hello,
On a related matter, do the various JOIN's (LEFT, INNER, and OUTER) use a
temp file
when processing?
Table pollResponses:
+-+---+--+-+-++
| Field | Type | Null | Key | Default | Extra |
Why can't you do something along the lines of:
select count(*) from pollResults where dayofyear(now()) =
dayofyear(dateEntered) and year(dateEntered) = 2001;
-Original Message-
From: Atle Veka [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 5:51 PM
To: Daren Cotter
Cc: Quentin
Paul,
I'm not sure if this is in the manual, but do you have some sort of general
timeframe when mySQL 4.0
will be available for the masses?
Christopher Oson
[Big Fan Of Your mySQL Book]
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 21, 2001
How about...
mysql select concat(50/1432, '%') as percentage;
++
| percentage |
++
| 0.03% |
++
1 row in set (0.00 sec)
mysql select concat(1324/4.14, '%') as percentage;
++
| percentage |
++
| 319.8068% |
++
1 row in
Try:
select whatever from whatever where field like '[0-9]%'
http://www.mysql.com/doc/P/a/Pattern_matching.html
-Original Message-
From: Ung, Seng [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 9:03 AM
To: [EMAIL PROTECTED]
Subject: Select a range from 0-9 or A-z
hi:
Why not try using ENUM?
http://www.mysql.com/doc/E/N/ENUM.html
You could setup your table like this:
CREATE TABLE logInfo2
(
logID INT NOT NULL UNIQUE,
ipAddress VARCHAR(20) NOT NULL DEFAULT 'None',
boolVarsENUM ('T', 'F') DEFAULT 'F'
)
SELECT ipAddress
Maybe, but you could define a constant..
CONST TRUE "T"
CONST FALSE "F"
INSERT INTO logInfo2 (logID, ipAddress, boolVars) VALUES (null,
'192.192.192.192', TRUE)
-Original Message-
From: Russ Davies [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 11:44
SQL is a language that is based on standards that are modified every so
often. So,
yes, in general there are SQL statements that you put together will work
with Access,
MSSQL, Informix, DB2, and Oracle, etc.
But *THE* key issue is that each DBMS application has it's own hooks that
are
assuming that each table only has one element, you could do a select * from
2 table.
If you don't and you need to combine everything, then you're trying to do a
UNION.
mySQL doesn't support UNION's yet.
one way to do a union is to create a temporary table then use two queries to
fill the
Good Day All,
This will work...
mysql SELECT storyID, title, summary, MATCH summary AGAINST (LCASE('news'))
AS probability
- FROM newsStories WHERE MATCH summary AGAINST (LCASE('news')) 0
LIMIT 0, 5;
But this will not...
mysql SELECT COUNT(*), MATCH summary AGAINST (LCASE('news')) AS
You need to flush privileges after you add a new user.
FYI... Paul DuBois' mySQL book covers this in great detail and should be
considered the Bible for mySQL
Check the manual for flushing priliges if you don't have available access to
this book...
-Original Message-
From: Carlos
Why not use ENUM?
create table test
bool ENUM('t', 'f') default 't' not null,
val1 char(15),
val2 int
...
...
It will "map" T to a 0 and F to 1. It's nearly identical to what
you're doing, but it may seem more intuitive to some.
Cheers,
Chris Oson
-Original
You can get around subqueries by using JOIN's. mySQL may not have all the
bells and whistles that some
other db applications may have, but more often than not, there is a way to
get around it.
Paul DuBois covers this in his mySQL book very well.
-Original Message-
From: Mark Marshall
26 matches
Mail list logo