Johnny Withers schrieb:
Group is a keyword in mysql:
You need to put backticks around it in your statement:
| LOAD DATA INFILE 'test.csv' INTO TABLE table
| FIELDS TERMINATED BY ','
| LINES STARTING BY '' TERMINATED BY '\n'
| (Page, Device, `GROUP` , ItemID, Item, Value);
Ooookay. Thank
lease help me!
MySQL version = 5.0.32-Debian_7etch8-log
TIA,
Ralph
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
m.
We just want to start a standalone mysql server with the data on the
snapshot to make some mysqldumps for archiving.
Regards,
Ralph
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
/ibdata1
Nov 23 13:36:30 aliao mysqld[16073]: InnoDB: File operation call: 'open'.
Nov 23 13:36:30 aliao mysqld[16073]: InnoDB: Cannot continue operation.
Why does InnoDB open this file read/write, is there an option avaliable
for opening this file read-only?
Regards,
Ralph
--
MySQL Gene
/var/run/mysql is empty. I tried creating the mysqld.pid
file (with mysql as owner and group) but still get the same problem.
>Submitter-Id:
>Originator:Ralph J. Jackson 407.381.7797x568
>Organization:
JHT, Inc.
>MySQL support: none
>Synopsis: mysqld refuses to
t the password for both mysql and mysqladmin after installation. What
should I do?
Thanks for your help.
Ralph
On Wednesday, January 7, 2004, at 01:24 PM, Michael Stassen wrote:
Ralph McCarthy wrote:
Hi:
I've just installed MySQL on Mac OS X 10.2.8. I'm unable to create a
databas
host' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
Please help. Thanks in advance.
Ralph
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SELECT * FROM table_name WHERE EndDate < now();
Is this what you need?
-Original Message-
From: Rob Sirota [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 4:12 AM
To: [EMAIL PROTECTED]
Subject: Help with SELECT statement for date range
Hello,
I am having a problem when doing a
Maybe the weed has got me high right now, but here is something some of
you on this list may find funny, others may find this useful. This is
not spam, this is actually a good manual you should all read:
http://catb.org/~esr/faqs/smart-questions.html
Good Reading.
--
MySQL General Mailing Li
Here are two other books that I would recommend, specially the first
one:
* SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in
SQL
by Michael J. Hernandez, John L. Viescas
Joe Celko's SQL for Smarties: Advanced SQL Programming
by Joe Celko
-Original Message-
From: Fa
I have to do a catalog search through multiple tables and columns for
product model number, description, and name. I realize that doing
pattern matching with multiple LIKE statements is slow so I found that
FULLTEXT searches is a better alternative.
I have added a FULLTEXT index to the tables I'm
Users.
MySQL Cookbook
By Paul DuBois
Ralph
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
TASK:
I have to generate a report with all categories, subcategories and
products in database.
PROBLEM:
I want to write one query that will return:
1. category
2. subcategory: determined by parent_id
3. products in each category or subcategory.
I have four tables with the following structure:
-
LOAD DATA INFILE "data.txt" INTO TABLE table_name FIELDS TERMINATED BY
'|' ENCLOSED BY '"' LINES TERMINATED BY '\n';
You can find more on this at:
http://www.mysql.com/doc/en/LOAD_DATA.html
-Original Message-
From: Rudolf Bekker [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 2:
LOAD DATA INFILE "data.txt" INTO TABLE table_name FIELDS TERMINATED BY
'|' ENCLOSED BY '"' LINES TERMINATED BY '\n';
You can find more on this at:
http://www.mysql.com/doc/en/LOAD_DATA.html
-Original Message-
From: Rudolf Bekker [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 5:13
Joe Celko's SQL for Smarties: Advanced SQL Programming
By Joe Celko
-Original Message-
From: David Thompson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 4:21 AM
To: 'MySQL Mailing List'
Subject: Good Database Philosophy Book?
Looking for a book to help me develop a philosophy
I am getting a list of all countries from database, and then I am
sorting by country name. However since most orders will be from US I
want the US to appear first over the rest of the countries. How can I go
about doing this?
Currently, this is my query:
SELECT countries_id, countries_name FROM T
ng_status` int(5) NOT NULL default '0',
`payment_date` datetime NOT NULL default '-00-00 00:00:00',
`commission_percent` decimal(4,2) NOT NULL default '0.00',
PRIMARY KEY (`affiliate_orders_id`)
) TYPE=MyISAM;
-Original Message-
From: Mike Hillyer [mailto:[EMAI
I've been stuck on this one all morning. Can't seem to figure it out.
I have 2 tables, one with affiliate sales and another with affiliate
clickthroughs. I have to query both tables, so that I can get
clickthrough dates, hits, and then query affiliate sales table to get
number of orders for each d
too hopeful for an HA solution, is there a better/different way to
accomplish the same thing, or what?
Thanks!!
- Ralph Forsythe
Aspiring ISP Ninja
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
"1" at line 1
How can I get this done??
Ralph
-
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 &l
e the problem is... Is InnoDB not 64bit clean? Anyone else
saw this problem?
Greetings,
++ralph
P.S.: The same happens when using 3.23.50!
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmai
hi,
if i try to download the latest odbc driver i get a file with 43k. what
is wrong ? the original file on
http://www.mysql.com/downloads/api-myodbc-3.51.html is over 602K...
what have i to do?
-
Before posting, please check
maybe does the trick with mySQL, too. UNION ALL is
supported with mySQL >= 4.x.
Best regards
... Ralph ...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
p.changed DESC,
d.dam ASC
Any idea how I can get this sorted by changed, but correctly DISTINCTed?
Regards
... Ralph ...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://l
>Does anyone know how to write a query to get out the sum of a whole
>table column?
SELECT sum() FROM {WHERE };
Also see the manual.
:wq!
Ralph
-
Before posting, please check:
http://www.mysql.com/manual.php
can I download the latest version?
Best regards
... Ralph ...
-
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 &l
inutes ago.
Hi Jeremy,
thanks alot for your hint. I will check the list again, but seems like that
mail hasn't reached me yet. Glad to hear it's not an issue only affecting
my system. Thanks again for your great assistance.
the UPDATE process in two separate UPDATE statements?
The version I use is 3.32.41, linux, 2.2.19 kernel, gcc 2.95.2. If needed,
I can provide a mysqlbugreport.
With my best regards
... Ralph ...
-
Before posting, please check
ld1=1 AND
field2 > 0 ORDER BY sortvar1 LIMIT 1;
Maybe this can be optimized further to improve the query speed, but that's
another issue.
Regards
... Ralph ...
-
Before posting, please check:
http://www.mysql.com/
Documentation.
Regards
... Ralph ...
-
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 PROTECT
Hi,
>How may create a view in mysql, o make some seem to the queiries in
>access !!!
As discussed already many times over and over again and as it can be read
in the mySQL documentation (http://www.mysql.com) views are (not yet)
implemented in the current 3.23.36 version.
Regards
...
.../lib/mysql". This did the trick and Mysql compiled
fully.
>Submitter-Id:
>Originator:Adam Ralph
>Organization: Institute of Virolgy, Glasgow UK
>
>MySQL support: [none ]
>Synopsis: Did not compile under Tru64.
>Severity: non-critical
>Priority:
g. After
several operations running locally on the new master's version, the same
error occured. It immediately disappeared after I upgraded the slave to
3.23.34 too. Never saw it again.
Maybe only coincidence, but...
giving all four possible combinations
(p=Y/d=Y, p=N/d=N, p=N/d=Y and p=Y/d=N), alas this should not affect the
querys execution plan in any way, if I see it right.
With my best regards
... Ralph ...
EXPLAIN
SELECT DISTINCT
p.dam_id,
p.lastchanged
FROM
products p
LEFT JOIN
35 matches
Mail list logo
