Hi, I have the following tables :
CREATE TABLE articoli (
codice varchar(16) PRIMARY KEY,
descrizione varchar(255),
marca varchar(255) NOT NULL,
misure varchar(32),
peso
What GUIs exist for MySql and which is the best to use?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_1_0
lists most of them...
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
Hi Madhuri,
Subquery is in the immediate todo list of Mysql. It should be soon
available. The alternative is to use temporary tables. You can read about
temporary table in the Mysql manual. Section 3.5.4. would be helpful.
Anvar.
At 10:58 PM 30/10/2001 -0800, you wrote:
hi,
I have
I'm newly acquinted with MySQL today, and made a very first attempt to
create a table with MySQLGUI. However, the Commands-Tables-Create Tables
menu option doesn't seemed implemented -- nothing happens. Is this something
that hasn't been implemented, or am I not using the tool correctly? I'm
Powerful MySQL Manager for Win32.
http://www.mysqlmanager.com
Regards,
Vadim
- Original Message -
From: Joe Fan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 31, 2001 9:44 AM
Subject: GUI for MySql
What GUIs exist for MySql and which is the best to use?
Shankar Unni writes:
Please treat this as a fairly urgent problem. It's simple to fix, but the
effects of the bug are a severe loss of functionality under Win32.
Several options in the mysql client (--batch, --silent, etc.) have no
corresponding options to reverse that behavior (e.g.
Hello,
is there an easy way of rearranging id's in a table after deleting one or
more entry/entries (other than creating a new tbl and dropping the old one).
I appreciate any hint. Thank you.
---
Ali Reza Sajedi
hello,
I got problem when I tried to have CURRENTDATE as DEFAULT date.
For this I gave sql statement as
CREATE TABLE XX(..,fldDate DATETIME DEFAULT NOW() NOT NULL, ..);
NOW() CURDATE() both will give Current date. But I am getting syntax
error.
If i give some Date like 10/31/2001 it is
Nathan A. Saint Clair writes:
I'm looking for instructions on installing the mysql GUI interface on a unix system.
Is that possible? Thank you,
Nathan
Of course it is possible.
What Unix system. There are binaries for Linux and some other Unix
systems ready so that you can download the
Can someone pls advise me on how to make a website running in an apache
webserver on a Linux box connect to a remote mySQL database on a separate
Sun box?
Thank you.
- (on foxtrot)
Privileged/Confidential Information may be contained in this message.
Moomps is a monitoring daemon which works using configuration
(dashboard) files created by the moodss (Modular Object Oriented Dynamic
SpreadSheet) graphical application. The configuration files contain the
definition of thresholds, which when crossed, trigger the sending of
email alert
Ali writes:
Hello,
is there an easy way of rearranging id's in a table after deleting one or
more entry/entries (other than creating a new tbl and dropping the old one).
I appreciate any hint. Thank you.
Drop the column and recreate it. It really is an incredibly
dumb thing to do, but if
Hi,
MySQL V. 3.23.33 with binary log and replication turned on:
this is what i do on the master (in a perl script):
===
create temporary table TEMP_HITS ( ... ) TYPE=HEAP;
Insert several things into TEMP_HITS;
Select from TEMP_HITS and
How can i migrate a database from mssql7 to Mysql?
- Moreno Riccardi
-
Before posting, please check:
Scott Seong writes:
Hi,
I'm newly acquinted with MySQL today, and made a very first attempt to
create a table with MySQLGUI. However, the Commands-Tables-Create Tables
menu option doesn't seemed implemented -- nothing happens. Is this something
that hasn't been implemented, or am I not
HI everybody.
I saw, when i delete all records from the table where id
is primary key and auto_increment, the first number for id is'nt 1 but next
in a row (the last was 5 the next will be 6).
Can i change this behavior ? Mybe in file my.ini ?
The goal is, that when i delete all records from
[EMAIL PROTECTED] writes:
MySQL is working perfectly on my Linux box. I downloaded MySQLGUI, and ran it.
It connects fine, I can view a table, etc.. But, when I click on the
GRANT/REVOKE menu, it hangs on the Windows side. When I go to the Linux side and
issue SHOW PROCESSLIST, there are as
=
45219
011031 2:17:41 Slave: connected to master
'[EMAIL PROTECTED]:3306', replication started in log
'3306_bin_log.001' at position 71445219
ERROR: 1051 Unknown table 't'
011031 3:09:04 Slave: error running query 'drop table MY_SHOP.t'
011031 3:09:04 Error
Hi!
I'm new to linux, PHP and MySQL.
I'm having a problem using LIMIT and ORDER BY in the same query.
When I use this:
SELECT uid,name,uname,email,local,tel FROM users order by name LIMIT 10 , 19
And mysql is returning 14 results.
I'm testing, so I replaced the names for numbers to
Jari Mäkelä writes:
It is easier to have consequential data before starting to make the
relations if you are forced to work on fixing up the follies/ages old
tables of other people
True, true.
What I can't understand is why so many people insist on
wanting to renumber things continously.
I suggest writing a PERL script/filter which accepts the text file and sends
a comma-delimited file to standard-out. This file could then be sucked in
by mysql
-Original Message-
From: Michael Benbow [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 7:48 PM
To: [EMAIL
Hello guru,
It is not appropriate to me to use standard replication mechanism of
MySQL. because the interactions between master server and slave server
will be too busy.
Is any possibility
1. to replicate data over certain period of time ( I need period
24hours)
2. some how to replicate
Does mysql support the utf-8 (Unicode) character set? If so, where can I
find it.
Thanks,
Neil
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
I did a dump of a table from another database table and wanted to run
the .sql file in another database. I used PHPadmin to do this and used
phpadmin to run the .sql file against the other database
I have this is the error from mysql:
SQL-query :
CREATE TABLE tblmembers (
ID int(11)
This question was asked back in 1999 and wasn't answered, so hopefully
someone will answer it now.
I am using JBoss and they provide a JDBC to mySQL type mapping that maps
java.util.Dates to a jdbc-type of DATE and mySQL type of DATETIME. Well,
only the date portion (10-31-2001) is being
On Wed, Oct 31, 2001 at 09:35:49AM -0500, [EMAIL PROTECTED] wrote:
: This question was asked back in 1999 and wasn't answered, so hopefully
: someone will answer it now.
:
: I am using JBoss and they provide a JDBC to mySQL type mapping that maps
: java.util.Dates to a jdbc-type of DATE and
By is not a legal data type
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 9:17 AM
To: [EMAIL PROTECTED]
Subject: Running Query
I did a dump of a table from another database table and wanted to run
the .sql file in another
A relatively straightforward way round this - and a number of other problems
with FULLTEXT - is to combine a full text search with a LIKE criterion to
narrow the results. Example (assuming that you are searching a table called
Documents on a TEXT field called Term):
SELECT * FROM Documents WHERE
That is the problem. I changed the mapping for java.util.Date to a JDBC
type of TIMESTAMP, which is mapped to a mySQL type of DATETIME. I am now
getting the desired results.
Thanks,
Michael
-Original Message-
From: Philip Molter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31,
No,
The column name should have been Modified By data type should have
been text
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 9:20 AM
To: 'Todd Williamsen';
By is not a legal data type.
Did you mean By text, without the word Modified?
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 9:17 AM
To: [EMAIL PROTECTED]
Subject: Running Query
I did a dump of a table from another database table
At 12:18 PM 10/30/2001 -0600, Dan Nelson wrote:
In the last episode (Oct 30), Bennett Haselton said:
I created one table with the command:
CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species
VARCHAR(20), sex CHAR(1), birth DATE, death DATE, id INT UNSIGNED NOT
NULL);
and
Hi
I'm working on importing csv datafile returns Warnings, after carefully
checking data I noticed that there are double quotes () inside the
records.
mysql LOAD DATA INFILE '/home/sql/data.csv' INTO TABLE csvdata
FIELDS TERMINATED BY ',' ENCLOSED BY '\' LINES TERMINATED BY '\n';
Query OK,
Hi!
nsabbi == nsabbi [EMAIL PROTECTED] writes:
nsabbi Hi, I have the following tables :
cut
nsabbi explain SELECT DISTINCT a.* FROM articoli a, keywords k WHERE a.codice =
nsabbi k.codice AND keyword IN ('tubo') GROUP BY a.codice HAVING
nsabbi count(k.keyword)=1 limit 1, 26;
nsabbi
I've been trying to add the following table to my database, and I keep
getting the error below.
CREATE TABLE mod_userpage_data (
id INT(5) NOT NULL default '0',
title VARCHAR(200) NULL,
data LONGTEXT NULL,
PRIMARY KEY (id)
);
ERROR 1064 at line 1: You have an error in your SQL
At 02:32 PM 10/30/2001 -0700, Steve Meyers wrote:
What would be ideal would be to use auto-incremented numeric fields as
primary key fields, and then have a special field in each table
designated
as the user-friendly field. That way, when you want to view the
contents
of a table, the
I think you are mistaken, you do not connect the Apache you connect your
script ie php, perl, python to talk to your remote database, by specifying
the dns database and password in your config file which should be on your
apache server.
You must ensure you have the specific odbc modules
It would be nice if mysql had a function that would return a list of words
that it's going to ignore when I do a full-text search.
Its hard for me to explain to users of my site the difference between your
words didn't match anything, and the database ignored your query because
the words were
Hi there,
After reading some debate under way in kernel lists, i'm curious
regarding performance of MySQL under the two diferent VM currently in
the kernels (Linus and Alan Cox kernels).
Has anyone any info regarding this?
Cheers,
Luis Ferro
is data a reseverd word in mysql?
On Wed, 31 Oct 2001, Richard W. Wood wrote:
I've been trying to add the following table to my database, and I keep
getting the error below.
CREATE TABLE mod_userpage_data (
id INT(5) NOT NULL default '0',
title VARCHAR(200) NULL,
data
Use optionally:
mysql LOAD DATA INFILE '/home/sql/data.csv' INTO TABLE csvdata
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' LINES TERMINATED BY
'\n';
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 9:33 AM
To: [EMAIL
There may be a space before the word data as in mod_userpage_ data
-Original Message-
From: Richard W. Wood [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 9:44 AM
To: [EMAIL PROTECTED]
Subject: Problem adding table
I've been trying to add the following table to my
And the problem is?
João Rosa - Dimensão Global wrote:
Hi!
I'm new to linux, PHP and MySQL.
I'm having a problem using LIMIT and ORDER BY in the same query.
When I use this:
SELECT uid,name,uname,email,local,tel FROM users order by name LIMIT 10 , 19
And mysql is returning 14
You can use a pretty cool software from http://www.datanamic.com/
First one being ImporterScript
http://www.datanamic.com/importerscripts/index.html then dump your
datastructure from your m$sql7 into Dezign
http://www.datanamic.com/dezign/index.html then use this to change the
database to MySQL.
From: rc [EMAIL PROTECTED]
is data a reseverd word in mysql?
No.
On Wed, 31 Oct 2001, Richard W. Wood wrote:
I've been trying to add the following table to my database, and I keep
getting the error below.
I copy-pasted your SQL and it worked. I'm using 3.23.38.
---
Rodney Broom
No it is not. Reserved word list: http://www.mysql.com/doc/R/e/Reserved_words.html
I think Richard's problem is the NULL. You could do default NULL, but I think NULL by
itself doesn't
mean anything to mysql (in a create table, anyway).
- Original Message -
From: rc [EMAIL PROTECTED]
Hi
Can MySQLGUI start and stop the daemon?
/Henrik
-
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
On Wed, Oct 31, 2001 at 04:28:27PM +0200, Vyacheslav I. Raytsin wrote:
Hello guru,
It is not appropriate to me to use standard replication mechanism of
MySQL. because the interactions between master server and slave
server will be too busy.
Is any possibility
1. to replicate data over
I am having some problems with using join.
here's the tables:
t1 t2
MachineId MachineNameMachID Service_Name
111mach1 111DHCP
112SNMP
t4
Service_cat Service_name
Network DHCP
EmailExchange
Network SNMP
Has anyone played with extracting data from sage version 6 on Windows to
MySQL? What is the easyest way of extracting data from sage? Their
support will not help sing my contract with them expired and I have
decided to use a different product.
Regards
Ajdin
thanks, I finnally figured out how to set it on the command line and
modified safe_mysql script to do it. Thanks
On Wed, 31 Oct 2001, Wouter de Jong wrote:
Date: Wed, 31 Oct 2001 09:19:14 +0100
From: Wouter de Jong [EMAIL PROTECTED]
To: William R. Mussatto [EMAIL PROTECTED]
Cc: [EMAIL
I've been lurking here for a while and have been itching to ask this...
Does anyone use mysqlfront to manage and work with MySQL on Windows? I love
it and can not live without it now. My other favorite is Advanced Query Tool
and the combination is fantastic!
Any thoughts?? (and it does not beep
I am having some problems with using join.
here's the tables:
t1 t2
MachineId MachineNameMachID Service_Name
111mach1 111DHCP
112SNMP
t4
Service_cat Service_name
Network DHCP
EmailExchange
Network SNMP
Since this is the first mention of the datanamic tools I have seen, I have a
question.
In using DeZign to layout the structure and then generate scripts to build
the tables, what happens when you just want to make a few changes to the
tables? Do you have to re-generate the whole thing? Do you
Hello Everyone,
I need to run MySQL using JSP.
I am a JSP newbie, actually a Java newbie too. I am more of a PHP/MySQL
guy.
I have successfully installed Allaire JRun 3.0 on Win98 using PWS.
JRun has an application management console and I cannot seem to run
MySQL.
I am totally
I had a view on sqlserver which i am trying to convert to work with mysql.
It uses a union which i believe does not work with mysql. What is another
alternative for union.
Sql with union:
select a.asset_id,a.material_id,b.material_id as parent_material_id from
lib_asset_tbl a inner join
Any thoughts, besides switching to Linux?
Linux beeps also, as evidenced by this intentionally incorrect query (had to
get query in there so the message wouldn't bounce!):
mysql select * from junk;
ERROR 1146: Table 'SBS4_run_db_25_10_2001__16hr8min36sec.junk' doesn't exist
(and a beep)
Hello,
I've been working on this for a long time now and I
cannot figure this out.
Can someone help me get this sql statement without
erroring or why it doens't work.
Here is the SQL statement...
SELECT DISTINCT ItemMaster.ParentNum,
ItemMaster.Desc1, ItemMaster.Price
FROM BillOfMat AS
I had a view on sqlserver which i am trying to convert to work with mysql.
It uses a union which i believe does not work with mysql. What is another
alternative for union.
Sql with union:
select a.asset_id,a.material_id,b.material_id as parent_material_id from
lib_asset_tbl a inner join
On Wednesday 31 October 2001 10:44 am, Richard W. Wood wrote:
I've been trying to add the following table to my database, and I keep
getting the error below.
CREATE TABLE mod_userpage_data (
id INT(5) NOT NULL default '0',
title VARCHAR(200) NULL,
data LONGTEXT NULL,
PRIMARY
Hi,
I am looking for experienced writers who would like to write a complete and
authoritative reference on MySQL. If you are interested in writing such a
book, please contact me at [EMAIL PROTECTED] To learn more
about the books we publish, please visit our Web site at www.osborne.com.
Hello everyone,
We'll probably be using MySQL with our software. But in order to do that it has to be
aproved by FDA( Food and Drug Administration). Are there any off the shelf products
that will have all the MySQL capabilities bundled up in it? I think that way our
software will be
On Wednesday 31 October 2001 12:00 pm, Schmidt, Allen J. wrote:
I've been lurking here for a while and have been itching to ask this...
Does anyone use mysqlfront to manage and work with MySQL on Windows? I love
it and can not live without it now. My other favorite is Advanced Query
Tool and
Advanced Query Tool - uses the MySQL odbc connection to get to the remote
MySQL server.
http://www.querytool.com
The group that produces it is really great and has added several things I
have suggested. Great support. Easy to use.
Hope you like it too.
We are switching out Zope installation
The problem was in fact an illegal column name in one of the tables that a
Content Management program tried to create. (phpWebSite) The program seems
to be well done, but somehow they missed a beat on one of the modules that
it creates (or doesn't because of the illegal name) I tracked it down
Is there anyway in SELECt statement to tell, if service name is DHCP
look into service table , if service name is exchange look into software
table. Can i use something like this service.DHCP , soft.Exchange.
You could use a UNION and then specify both queries if you're using mysql
4.0
ie
Anything you could want to know, and more, can be found here:
http://www.mysql.com/downloads/gui-mysqlgui.html
Mike
[EMAIL PROTECTED] wrote:
Hello,
I have the Mysql 3.23.27-beta version installed on my Windows NT PC and I am able to
create the database and query from the command line and
I am a newbie.
When I create a table, one colum contains a space, how can I caeate it
correctly?
like:
CREATE TABLE mytable(
name CHAR(60) NOT NULL,
Email VARCHAR(50) NOT NULL,
Thrid colum CHAR(60), ///Here there is a
space?
PRIMARY KEY (Email)
);
My mind is not working with me this morning...
According to the manual about join syntax:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#JOIN
One should be able to do a LEFT JOIN without a
join_condition, eg. an ON or a USING:
table_reference LEFT [OUTER] JOIN
You can't use brackets on left joins like that. If you want to do two left
joins, you use:
LEFT JOIN table1 ON conds LEFT JOIN table2 ON conds
That's why you're getting the error that mysql displayed, it doesn't expect
a bracket.
Chris
SELECT DISTINCT ItemMaster.ParentNum, ItemMaster.Desc1,
Harpreet wrote:
I had a view on sqlserver which i am trying to convert to work with mysql.
It uses a union which i believe does not work with mysql. What is another
alternative for union.
Sql with union:
select a.asset_id,a.material_id,b.material_id as parent_material_id from
You use the ` char as a quote. (the backwards quote, right below the ESC
key on your keyboard with ~)
Chris
When I create a table, one colum contains a space, how can I caeate it
correctly?
-
Before posting, please check:
Name: MySQL
Display Name: MySQL
Driver: org.gjt.mm.mysql.Driver
URL:
jdbc:mysql://192.168.0.2:80/studiosusa?user=rootpassword=axnolnms
I would assume that here is your problem, most likely mysql is not running
on port 80 on your machine and you should change it to 3306, so
Some other useful information on this problem:
I have tried the operation in two other ways, both based on a version of
the program with only one connection using the API and emiting the UPDATE
statments on standard output:
1. output piped onto mysql -- failure :-(
2. output saved on a
for windows environment: http://sourceforge.net/projects/phptriad/
for linux: I've had complete success with Red Hat 7.1
-Original Message-
From: Demirchyan Oganes-AOD098 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 11:43 AM
To: '[EMAIL PROTECTED]'
Subject: Off the
Subject: MySQL Authors Needed
Hi,
I am looking for experienced writers who would like to write a
complete and
authoritative reference on MySQL.
Thanks,
Chris Johnson
Paul DuBois has already done a bang-up job. His book, MySQL (New Riders),
is the bible as far as I'm concerned, and
I am using version 3.23 and dont think will be moving up to 4.0. Can i
somehow create a temporary table and add all the rows i need and do a select
query from that temp table. Neone done this before.
Thanks for ur responses and time,
Regards,
Harpreet Kaur
Software Developer
Crispin
Heikki,
thanks for the reply. Regarding the trace output, My test has been
bombarding the db server with 15 simultaneous clients, each
generating up to 1000 transaction sets.
I still do not get any output from Innodb Monitor.
I created table innodb_monitor in the database that I'm accessing.
Change:
LEFT JOIN (BillOfMat LEFT JOIN ItemMaster ON BillOfMat.CompNum
=ItemMaster.ParentNum)
ON BillOfMat_1.CompNum = BillOfMat.ParentNum
to:
LEFT JOIN BillOfMat ON BillOfMat_1.CompNum = BillOfMat.ParentNum LEFT JOIN
ItemMaster ON BillOfMat.CompNum =ItemMaster.ParentNum
You cannot do
What do you mean there's a space? You mean after the comma in CHAR(60),
?
And you you provided is not what you entered into mysql, because Thrid
colum CHAR(60), won't work; colum is not a legal data type
-Original Message-
From: I. TS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October
Try going with simply:
SELECT T1.*, T2.* FROM tbl1 T1, tbl2 T2
WHERET1.a=1AND T1.b=2 AND T2.a=2 AND T2.b=T1.b;
-Original Message-
From: Bill Adams [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 12:21 PM
To: Mysql List
Subject: Left join w/o on or using join_condition
Gisella,
Heikki,
thanks for the reply. Regarding the trace output, My test has been
bombarding the db server with 15 simultaneous clients, each
generating up to 1000 transaction sets.
this is strange. When you start the server from
the command promp, does it then print something
to the
Hi,
We have just launched a non-profit open source jobsite. Check it out at
http://www.freeusall.com/ It's built on MySQL 4.0 (Alpha), Perl and
Apache. We'd appreciate any feedback you might have.
kind regards,
Mark Maunder.
Hi!
Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:
Sinisa TAKAHASHI, Tomohiro writes:
Hi, All
I Fixed two bugs.
1. If LoginUser has empty password, Driver can not connect to MySQL.
2. Connection Pool does not work correctly. ;-)
Check this URL out for new Driver. :-)
Rick Emery wrote:
Try going with simply:
SELECT T1.*, T2.* FROM tbl1 T1, tbl2 T2
WHERET1.a=1AND T1.b=2 AND T2.a=2 AND T2.b=T1.b;
Well, if I resort to that then the documentation is wrong.
Here is what I am really trying to do. Say you have a table and data:
DROP TABLE IF EXISTS tbl2;
Can i somehow create a temporary table and add all the rows i need and do
a select query from that temp table.
Yeah, that's the easiest way to do it.
Create temporary table A.
insert into A select
insert into A select
select * from A
If you want to mimic 'insersect' features
Hi
I didn't see any difference between using optionally or not.
Any solutions to make the two that fails work? (see test case below)
Using 3.23.41.
Thanks
test.csv:
Record 1,some data,Works
Record 2,some data,Works
Record 3,some 'data',Works
Record 4,some data,Works
Record 5,somedata,Fails
Description:
Configuring MySQL 4.0.0 with --with-ssl causes the server to
act as though interactive_timeout and/or wait_timeout were
set to approximately 6 seconds, although the variables seem
to have normal values.
How-To-Repeat:
When I create a table, one colum contains a space, how can I caeate it
correctly?
like:
CREATE TABLE mytable(
name CHAR(60) NOT NULL,
Email VARCHAR(50) NOT NULL,
Thrid colum CHAR(60), ///Here there is a
space?
PRIMARY KEY (Email)
);
Heikki,
I looked at the mysql error log and all the stuff was there.
I was expecting it on the standard output as the documentation said.
Thanks again. I'll have to restart the server again since the
innodb monitor output on the error log says that I'm not running a debugable
version, so there
Hi, your test.csv file has some flaws in records 5 and 7 because the
OPTIONALLY ENCLOSED BY char= isn't matched for each column. Changing those
offending CSV lines to be instead something like:
Record 5,\some\data\,Fails
Record 7,some data\,Fails
and then modifying your LOAD to be something
I didn't see any difference between using optionally or not. Any
solutions to make the two that fails work? (see test case below) Using
3.23.41.
That's a problem with your input data. You can't have the character that
you're using to surround the fields within the field,
At 10:48 31/10/2001 -0800, Gisella Saavedra wrote:
Hi!
Take a look at /mysql/data/mysql.err for to see the output
for innodb_monitor.
I guess that you need to stop the server, for open this file.
Regards,
Miguel
Heikki,
thanks for the reply. Regarding the trace output, My test has been
Gisella,
Heikki,
I looked at the mysql error log and all the stuff was there.
I was expecting it on the standard output as the documentation said.
it should come to the standard output. I am sending a copy
of this email to Miguel of MySQL AB. He should check why
mysqld started as --standalone
Since I sent this, I've noticed two things:
1. Somewhere in the process of reporting and working around problems in
the build process, I lost a few recommended CXXFLAGS. I started over from
scratch, so mysqlbug now reports
Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include'
At 2:47 PM -0500 10/31/01, [EMAIL PROTECTED] wrote:
Hi
I didn't see any difference between using optionally or not.
Any solutions to make the two that fails work? (see test case below)
Using 3.23.41.
Thanks
The problem is that your CSV file isn't legal CSV. You'll need to
tell your
At 10:32 AM -0500 10/31/01, [EMAIL PROTECTED] wrote:
Hi
I'm working on importing csv datafile returns Warnings, after carefully
checking data I noticed that there are double quotes () inside the
records.
mysql LOAD DATA INFILE '/home/sql/data.csv' INTO TABLE csvdata
FIELDS TERMINATED BY ','
sdsd
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
sdsd
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Hi all,
Is there any good reason for ``mysql_install_db'' to use the -s option to
hostname instead of using FQDN? Every time I install mysql 3.23 out of
ports, it fails running that script and I have to edit it manually and
remove the -s option.
# grep /bin/hostname
1 - 100 of 160 matches
Mail list logo