The db in question is a shopping cart and I was looking for products I added
that might have been duplicated in another category. My first attempt that
worked.
select prodid,count(groupid) as cnt from products
where (groupid=65 or groupid=66)
group by imgsml order by cnt;
The thing wrong
Hi.
I wonder if optimize table results are equal to dump such table and insert it back ?
Regards.
--
Grzegorz Paszka
sql,mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
Thankyou for your quick response.
When I start getting this error, the mysql crashes, any application which I
try to start which uses mysql backend, says mysql.sock error could not
connect .
-
DBI connect('database=search;host=localhost','web',...) failed: Can't
connect to
Hi again,
Second: specify what you mean with all relations. Can you
share some sample data and sample output (that is: what
do you expect the query to return).
Ok my table noms is like
| id | int(11) | | PRI | [NULL] | auto_increment
| reference| varchar(255) |
|
Hi
I've got a master and a slave both at 3.23.49. I've been running
replication for the last 3 months and all of a sudden I've got queries
failing on the slave with duplicate entries (error 1062). From the
documentation all I can figure out is that there's a possibility I might be
using
On Tue, Jan 13, 2004 at 02:03:26AM -0500, [EMAIL PROTECTED] wrote:
select prodid,count(groupid) as cnt from products
where (groupid=65 or groupid=66)
group by imgsml having cnt1;
I.e. replacing order by with a having clause. After trying many variations; are
'order by' and 'having'
Hi MySQLians!
I have clearly mentioned my objective and the portion of work i have finished in my
last mail.
unfortunatly I don't find any reply for the past weekdays. Tii I have a trust, some
one would take
time to read this and sent me the suggestion to this list.
My current issue is from
Hello.
Table 1:
Items
id, Name
Table 2:
Properties
id, Item, Name, Value
I want select Items _and_ all thier props only if Item have specified
property.
Example:
Table Item:
1, Mouse
2, Monitor
3, Keyboard
Table Properties:
1, 1, Color, Red
2, 2, Color, Gray
3, 1, Interface,
Hi,
When trying to create a fulltext index on my large table, I get the
following error:
ERROR 1034 (HY000): 121 when fixing table
I'm using version 4.1.1-alpha of the MySQL database, a source-compiled
version with the --with-raid option. I'm trying to build a newpaper
article search engine.
Hi All,
Is there any AS3AP benchmark suite readily available for MySQL?
Thanks in advance,
Ram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'd like to move some bookmarks in one database to another. The format
of the Active PHP Bookmarks 'apb_bookmarks' table is (minorly trucated):
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
Hi Ya
I believe the Dos Mysql Client has limited table name completion, but
do any of the GUI Clients have this feature??
zzapper (vim cygwin zsh)
--
vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?
http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips
--
MySQL
Hello,
Many thanks for your reply!
I am currently syncronizing two MySQL servers (version 3.23.49) on a
very high traffic website.
There are, at peak times upwards of 600 updates a second (and many many
more selects)
During these times the slave database will fall out of sync, sometimes
by
Hi,
I've been inserting a csv file of about 150Mb into a mysql database. The
problem is that there is no enough free space on the hard disk, and the
process have been collapsed.
Now I've been trying to access to the database to drop the table and change
the directory where mysql stores the
I have tried two ways of dumping data but it doesn't seem to be working.
One using the admin window with mysqldump dbname dumptest.sql but I
don't know if it has done anything because all it did was return to a
new blank line. I can't find anywhere a file named dumptest.sql
The other way was
Hi!
On Jan 13, Kurt Haegeman wrote:
Hi,
When trying to create a fulltext index on my large table, I get the
following error:
ERROR 1034 (HY000): 121 when fixing table
I'm using version 4.1.1-alpha of the MySQL database, a source-compiled
version with the --with-raid option. I'm
On Sat, 2004-01-10 at 12:04, Bernard Clement wrote:
Hello Aman,
For instructions on taking the exam in India goto the URL:
http://www.vue.com/mysql/ and click on test center of To register for exams
in India, please contact the test center directly. This will bring you a
window
Sergei Golubchik wrote:
Hi!
On Jan 13, Kurt Haegeman wrote:
Hi,
When trying to create a fulltext index on my large table, I get the
following error:
ERROR 1034 (HY000): 121 when fixing table
I'm using version 4.1.1-alpha of the MySQL database, a source-compiled
version with the
hi - ive been playing with the OGC support for WKT but cant find data type size
constraints for GEOMETRY types. does anybody know what they are? Ive a polygon with
140,000 bytes as WKT but inserts all produce a NULL geometry...
any ideas?
regards
Programming today is a race between
adburne [EMAIL PROTECTED] wrote:
I'll be trying to work with sp on win32/5.0.0-alpha-max-debug; I take the
mysql's page example to test but makes an error:
mysql delimeter |
You made a typo. You should write 'delimiter'.
- create function hello (s char(20)) returns
I've been asking around for awhile without a solution to this problem and thought I'd
post it here perhaps some one will know of a script that will help.
I need to have emails sunmitted to a database field but more to the point I need to
have the attachment stripped and added to MySQL. People
Andrew DeFaria [EMAIL PROTECTED] wrote:
I created the following .sql file to demonstrate a problem I'm having.
According to the manual:
If |ON DELETE CASCADE| is specified, and a row in the parent table
is deleted, then InnoDB automatically deletes also all those rows in
the
On Tue, Jan 13, 2004 at 09:41:57AM -0400, Vernon Webb wrote:
I've been asking around for awhile without a solution to this
problem and thought I'd post it here perhaps some one will know of a
script that will help.
I need to have emails sunmitted to a database field but more to the
point I
I am really struggling with a mysqldump. I am trying to create a dump
of a complete database called csi_db01 and I am trying to save the dump
file to My Documents on the C drive.
I am sure I am doing right, but could somebody email me the full syntax
to use which comes after the mysql
If I
I am really struggling with a mysqldump. I am trying to create a dump
of a complete database called csi_db01 and I am trying to save the dump
file to My Documents on the C drive.
I am sure I am doing right, but could somebody email me the full syntax
to use which comes after the mysql
if
Victoria, sorry for waste your time with this =(
Just is a EMS MySQL Manager 2.0.1.4's error, from command line (mysql) works fine; the typo was writing the mail.
Alejandro.
---Mensaje original---
De: Victoria Reznichenko
Fecha: 01/13/04 11:04:50
Para: [EMAIL PROTECTED]
Asunto:
On Tue, 13 Jan 2004 14:07:38 +, Matthew Stuart
[EMAIL PROTECTED] wrote:
I am really struggling with a mysqldump. I am trying to create a dump
of a complete database called csi_db01 and I am trying to save the dump
file to My Documents on the C drive.
I am sure I am doing right, but could
Scenario:
Client gets a connection from MySQL. The client process is killed i.e.
client does not close the connection to MySQL.
Observation:
When I use Show ProcessList command to look at all the open connections,
the connection with the client (terminated abnormally) doesn't show up in
the
Xavier Fernández i Marín wrote:
Hi,
I've been inserting a csv file of about 150Mb into a mysql database. The
problem is that there is no enough free space on the hard disk, and the
process have been collapsed.
Now I've been trying to access to the database to drop the table and change
Matthew Stuart wrote:
I am really struggling with a mysqldump. I am trying to create a dump of
a complete database called csi_db01 and I am trying to save the dump
file to My Documents on the C drive.
I am sure I am doing right, but could somebody email me the full syntax
to use which comes
At 03:52 AM 1/13/2004, Harald Fuchs wrote:
SELECT *
FROM tbl
WHERE user = 'jones'
AND '/data1/index.php' LIKE concat(path, '%');
Thanks for the tip.
Bob
==
Bob Ramsey Applications Development
Birju,
What messages do you get in the mysql log file? The message you're
getting from perl just says that the database is not available. Before
you try to restart mysql, have you checked to see if there are still
mysql processes running (ps -eax |grep -i mysql). Have you run myisamchk
on the
Viktor [EMAIL PROTECTED] wrote:
subj.
It's inconvenient, because one should get source distribution and
compile this tool.
You can use comp-err.exe from older packages.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
mysqldump is run at the system command-line, not within the mysql
client environment.
This is most likely to be my problem then. I assumed that what is
called the system command line to be the mysql client environment. The
tutorial book that I have been going through instructs me to issue this
blush ouch /blush
To Jimmy and Chris and the list in general. This list is particualiarly kind to
question of this nature. I for one appricate it. In this case it is amazing how
many wrong things I came up with.
On Tue, 13 Jan 2004, Chris Elsworth wrote:
On Tue, Jan 13, 2004 at 02:03:26AM
I am attempting to construct a select statement in which I can find values
between two fields: start, and end. I have tried using BETWEEN and
comparing with = and =, but neither meet success. Can someone please set
me straight? This is meant to be in a PHP page, but I'm assuming the syntax
is
Kurt Haegeman [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Sergei Golubchik wrote:
Hi!
On Jan 13, Kurt Haegeman wrote:
Hi,
When trying to create a fulltext index on my large table, I get the
following error:
ERROR 1034 (HY000): 121 when fixing table
Hi Sergei,
We have a table with floating point measurement values stored in VARCHAR's.
How can I get MIN in SELECT to evaluate these as numbers instead of strings
so negative value sort correctly? Right now I've kludged it as
MIN(SIGN(Value) * ABS(Value)). Is there a more straight forward way?
--
MySQL
Hello All,
In MySQL it is possible to check if an element is existing in a group, like:
... WHERE 'a' IN ('a','b','c','d') ...
but that checks one element only.
I want to check if any element from a group exists in another group, like:
... WHERE ('a','f','g') IN ('a','b','c','d') ...
'a' in
Could you CAST them first, then apply MIN?
-Original Message-
From: Eldon Ziegler [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 9:56 AM
To: [EMAIL PROTECTED]
Subject: MIN with negative numbers in VARCHAR
We have a table with floating point measurement values stored
Hi everyone,
Excuse me for asking this question but I would like to know if I
can install and use other DBMSes like: PostgreSQL, Oracle, and Sybase.
I'm using Mac OS X v10.3.2, and MySQL v4.0.14
I like MySQL and haven't found a need for other DBMSes except that most
Job listings I come across
Couldn't it be something like:
WHERE ('a' IN ('a','b','c','d')
OR 'f' IN ('a','b','c','d')
OR 'g' IN ('a','b','c','d')
)
On Tue, 2004-01-13 at 15:34, Eli Hen wrote:
Hello All,
In MySQL it is possible to check if an element is existing in a group, like:
... WHERE 'a' IN
From: Michael B Allen [mailto:[EMAIL PROTECTED]
I'd like to move some bookmarks in one database to another. The format
of the Active PHP Bookmarks 'apb_bookmarks' table is (minorly
trucated):
+--+--+--+-+-+
---+
| Field|
From: Eve Atley [mailto:[EMAIL PROTECTED]
I am attempting to construct a select statement in which I
can find values between two fields: start, and end. I have
tried using BETWEEN and comparing with = and =, but
neither meet success. Can someone please set me straight?
This is meant to
DOUBLE doesn't seem to be an option with CAST
At 10:31 am 1/13/2004, you wrote:
Could you CAST them first, then apply MIN?
-Original Message-
From: Eldon Ziegler [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 9:56 AM
To: [EMAIL PROTECTED]
Subject: MIN with negative
From: Ruslan U. Zakirov [mailto:[EMAIL PROTECTED]
Hello.
Table 1:
Items
id, Name
Table 2:
Properties
id, Item, Name, Value
I want select Items _and_ all thier props only if Item have specified
property.
Example:
Table Item:
1, Mouse
2, Monitor
3, Keyboard
ok... you might have two options:
1- (don't know if this will work)
do a min(cast(Value * 100 as signed integer) / 100
2- or min(Value + 0.0)
and see what happens.
-Original Message-
From: Eldon Ziegler [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 11:24 AM
To:
In the last episode (Jan 13), [EMAIL PROTECTED] said:
This may have been mentioned.. I have not been recieving message for 12+
hours now.. And it appears:
Jan 13 01:23:49 cyclone tcplog: smtp connection attempt from 213.136.52.31
Jan 13 01:23:50 cyclone sendmail[10674]:
To all the InnoDB gurus out there:
I have a similar problem to this person's predicament, except my situation
is that I have all the innodb data and log files, but have absolutely
no .FRM files.
Are there any general tools for data recovery from InnoDB databases? Any
companies that can do this
On Tue, 13 Jan 2004 14:07:38 +, Matthew Stuart
[EMAIL PROTECTED] wrote:
Similarly.
SELECT intDEVID,txtDEVPOSTCODE INTO OUTFILE c:/aaa/dump.sql from
ytbl_development;
(dump.sql file must NOT already exist)
zzapper (vim cygwin zsh)
--
vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/
I'm attempting to install version 4.0.16
When I try to install the software I get an error that reads:
An error occurred during the data move process: 103
Can anyone give me any guidance on how to resolve this.
Thanks,
Ken
This e-mail and any files transmitted with it may contain
Sorry, here are the EXPLAINS of a similar case, where what I did was switch
the first two tables in the join, and make it LEFT not INNER (note: the query
may look a little odd, as I took out some of the fields I was selecting,
etc...to make it shorter ;p)
mysql EXPLAIN SELECT t.profile_alias
I am trying to allow someone to access our mysql server that is behind our
firewall. If I open the firewall ports 3306-65000/tcp the person can get
through. If I just try to open up the port 3306/tcp, they can not get
through. Is there another port that I need to open also? I have tried
min(Value + 0) works. It's not the most direct way I've run into but it
does the job. I wonder why they didn't do something more common like the
C cast syntax (double) Value?
At 11:35 am 1/13/2004, you wrote:
ok... you might have two options:
1- (don't know if this will work)
do a
I tried a lot of things. Knowing now:
MySql is listening at... INET, TCP, Port 3306.
Direct connection is possible! The server answered with its version.
But what is with broadcast? Because I don't known were the servers!
That is what I like to find out!
Do any buddy know how to call a MySQL
I am using 4.0.17 rpm on Red Hat 7.3 (fully updated). I have a server
colocated at my local ISP, and my workstation is on ADSL behind a Netsys
router (the ADSL ISP uses PPPoE, don't know if that's relevant or not).
The server has RAID 1, and has always been 100% reliable (up since
2000). I have
Our server works with remote access just with 3306/tcp. Maybe it's
something to do with what you are using to access mysql.
At 12:53 pm 1/13/2004, you wrote:
I am trying to allow someone to access our mysql server that is behind our
firewall. If I open the firewall ports 3306-65000/tcp the
At 11:53 -0600 1/13/04, Steve Buehler wrote:
I am trying to allow someone to access our mysql server that is
behind our firewall. If I open the firewall ports 3306-65000/tcp
the person can get through. If I just try to open up the port
3306/tcp, they can not get through. Is there another
OK I got the database created and stuff; When in the MySQLAdmin screen
under databases it doesn't show under databases. That is the first problem.
And for some reason the MYSQLadmin screen list the local user name as
Administrator and will not let me change it. But I can get into the mysql
On 13 Jan 2004, at 09:19, Victor Reus wrote:
Hi again,
Second: specify what you mean with all relations. Can you
share some sample data and sample output (that is: what
do you expect the query to return).
Ok my table noms is like
| id | int(11) | | PRI | [NULL] |
Steve Folly said:
However, I suspect this isn't the full story. Do you also want to
see what components make up C003 and D003 in the same query? I
think you're after a feature not yet implemented in MySQL - the
'CONNECT BY PRIOR' SELECT statement, just the ticket for
hierarchical queries.
On Mon, 12 Jan 2004, Viktor wrote:
Hello mysql,
Table-level privileges do not work at all... (on Windows)
Works fine for me:
4.1.1a-alpha-max-nt:tmp GRANT SELECT ON tmp.tmp TO [EMAIL PROTECTED]
IDENTIFIED BY 'aaa';
Query OK, 0 rows affected (0.18 sec)
4.1.1a-alpha-max-nt:tmp \q
Bye
Ok I was able to use mysqlcc and as long as I keep the host name localhost
it will let me in. But the name of the host should be Napmarilu or the IP
number right? When you change it to either one of those it will not let you
in. So how would I fix this problem. However on the other hand
Matthew,
http://www.innodb.com/ibman.php#InnoDB_Monitor
Starting from 3.23.44, there is innodb_table_monitor with which you can
print the contents of the internal data dictionary of InnoDB.
The output format is not beautiful, and you have to manually reconstruct the
MySQL CREATE TABLE
Victoria Reznichenko wrote:
Andrew DeFaria [EMAIL PROTECTED] wrote:
I created the following .sql file to demonstrate a problem I'm
having. According to the manual:
If |ON DELETE CASCADE| is specified, and a row in the parent table
is deleted, then InnoDB automatically deletes also all
Keith Bussey wrote:
...
Also, I'm running MySQL 4.0.13-standard, STRAIGHT JOIN doesnt seem to exist
for me ;p
I think it is actually STRAIGHT_JOIN...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi!
On Jan 12, Holm Tiffe wrote:
Description:
mysqld 4.0.17 crash on FreeBSD 5.1-current-alpha
How-To-Repeat:
Any acces over IP (not domain socket) crashes mysqld:
#/usr/local/bin/mysqladmin: connect to server at 'install' failed
error: 'Lost connection to MySQL server during query'
mysql select Notice_ID from Notices where match (Text) against
('+pollution +control' in boolean mode);
Empty set (0.00 sec)
mysql select Notice_ID from Notices where match (Text) against
('pollution control' in boolean mode);
Empty set (0.02 sec)
mysql select Notice_ID from Notices
Birju,
Here's a little Linux/Unix info for you.
The /tmp/mysql.sock in question is used for ipc (Inter Process
Communication). This allows other applications to communicate with the mysql
server without using a TCP/IP connection. This eliminates the need to pass
everything through the
I want to have all the items into a recorset with only one query like
Select id, reference, component from NOMS where reference = '4'
but i want not only the primary relations, i want all relations.
Could somebody help a newbie like me?
It can also help to change the way you look at the
Not a bug.
In the manual, section Upgrading from Version 3.23 to 4.0, there is
* To use `MATCH ... AGAINST (... IN BOOLEAN MODE)' with your tables,
you need to rebuild them with `REPAIR TABLE table_name USE_FRM'.
Based on a guess, or did you analyze the data file I sent?
And if
Hi,
I am trying to do some performance analysis by trying different indexing
schemes and testing how long it takes. To get consistent results, I would
like to use something like SQL_NO_CACHE. However, the mysqld version that I
have installed does not seem to support it..its 4.0.16
Could
I have been using adjacency lists to solve problems with hierarchical data.
The algorithm is described in a relatively database independent way here:
http://www.intelligententerprise.com/001020/celko1_1.shtml
And by the same author here: http://www.dbmsmag.com/9603d06.html
Includes a tiny bit
I have somehow managed to create the datatype in COBOL matching
to C datatype and passed as argument to mysql_init and
mysql_real_connect.
My COBOL coding seems to working fine, but it could not able to
connect to MySQL and retrive Data. Instead it produce an error as;
Unknown MySQL
On Tue, 13 Jan 2004, Priyanka Gupta wrote:
Hi,
I am trying to do some performance analysis by trying different indexing
schemes and testing how long it takes. To get consistent results, I would
like to use something like SQL_NO_CACHE. However, the mysqld version that I
have installed does
Birju Shah wrote:
Hello,
Thankyou for your quick response.
When I start getting this error, the mysql crashes, any application which I
try to start which uses mysql backend, says mysql.sock error could not
connect .
-
DBI connect('database=search;host=localhost','web',...)
I have a shell script that is supposed to connect to a remote server running
MySql 3.23.53. It comes up with an error ERROR 1045: Access denied for
user: '[EMAIL PROTECTED]' (Using password: YES)
The script looks like this:
/usr/local/mysql/bin/mysql --user=$username --password=$password
Hi!
On Jan 13, Joe Rhett wrote:
Not a bug.
In the manual, section Upgrading from Version 3.23 to 4.0, there is
* To use `MATCH ... AGAINST (... IN BOOLEAN MODE)' with your tables,
you need to rebuild them with `REPAIR TABLE table_name USE_FRM'.
Based on a guess, or did you
Based on a guess, or did you analyze the data file I sent?
Based on your data.
.. ..
And of course I tried this myself before writing to you :)
Cool. Thanks for the analysis.
And if so, may I suggest that the upgrade documentation REALLY needs to
be broken into
On 13 Jan 2004, at 19:49, Chris L. White wrote:
Ok I was able to use mysqlcc and as long as I keep the host name
localhost
it will let me in. But the name of the host should be Napmarilu or
the IP
number right? When you change it to either one of those it will not
let you
in. So how would I
Hiya all!
I'm curious about if there's a simple way to manage user quotas in a MySQL
database? F.x. user one can have 10MB data in the database and user two can
have a maximum of 5MB?
Anders Norrbring
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
On 13 Jan 2004, at 19:11, Jochem van Dieten wrote:
I most certainly hope this Oracle idiosyncracy will never make it into
MySQL.
The SQL standard defines a different syntax for doing recursive
queries, using WITH RECURSIVE. I see no reason for MySQL to implement
a non-standard way for doing
Steve,
This is on Server 2003 Enterprise Edition. TCP/IP is installed, so I have
not a clue. I know it should be using the IP address of the machine or the
Machine name instead. Well At least I need it to function that way
eventually, cause this is for a client.
Chris L. White
Network
I get the following access denied error:
Warning: mysql_pconnect(): Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES) in
C:\Apache\Apache2\html\C2R\catalog\includes\functions\database.php on
line 17
Unable to connect to database server!
Why Is this happening and how can I fix
Even though Napmarilu and localhost are resolving to the same machine, they are
different host names. MySQL security uses a combination of username and hostname in
the form of: [EMAIL PROTECTED]
That means that [EMAIL PROTECTED] is a different user than [EMAIL PROTECTED] Since you
have the
Hi there,
I have recently installed mysql and php on my mechine
and both work fine. But when i wrote an HTML/Php to
access my databse I got the following error message:
Fatal error: Call to undefined function:
mysql_pconnect() in /var/www/html/employee.php on line
48
I tried also with
From: Aron Bereket [mailto:[EMAIL PROTECTED]
Hi there,
I have recently installed mysql and php on my mechine
and both work fine. But when i wrote an HTML/Php to
access my databse I got the following error message:
Fatal error: Call to undefined function:
mysql_pconnect() in
Thanx for the quick reply peter.
That of one of the things I did when I had the
problem. It was not enabled. But when I enable it it
gave me mysql.so doesn't exits. I checked it on the
path there is not mysql.so.
cheers,
Bereket
--- Peter Lovatt [EMAIL PROTECTED] wrote:
check your php.ini to
Dear Mike,
Thanx for the quick reply. I did what you specified on
your rely.
There is --with-mysql argument but is not set it is
just '--with-mysql'
does it mean I have to recompile it again?
cheers,
Bereket
--- Mike Johnson [EMAIL PROTECTED] wrote:
From: Aron Bereket [mailto:[EMAIL
Are you logged on as Administrator?
Is there enough disk space free?
Does it generate the same error if you try re-installing?
Is there an existing installation with the server still running?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi, I've got a csv archive with a date field 15/02/03, how can I load it to a
date field with the mysql date format (ISO ? ) 2003-02-15 ?
thank you
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
These are completely different programs so you shouldn't have any problems. I've never
run into mention of any conflicts listed in the MySQL docs. You might check the docs
of the other applications. I know the MSSQL and MySQL can co-exist.
--
MySQL General Mailing List
For list archives:
Hi, I've got a csv archive with a date field 15/02/03, how can I load
it to a date field with the mysql date format (ISO ? ) 2003-02-15 ?
thank you
I wouldn't mind knowing this too, my work around is doing it in php using
fgetcsv to extract the csv data, finding the right rows and columns
Antonio De Luna wrote:
Hi, I've got a csv archive with a date field 15/02/03, how can I load it to a
date field with the mysql date format (ISO ? ) 2003-02-15 ?
Well, if you're a Unix type, then you could pipe the input through a
small Perl script:
#!/usr/bin/perl -w
while ()
{
Matthew Stuart wrote:
mysqldump is run at the system command-line, not within the mysql
client environment.
This is most likely to be my problem then. I assumed that what is called
the system command line to be the mysql client environment. The tutorial
book that I have been going through
Right having just got to grips with the mysqldump command, I would like
to be able to know how to import the database back in to MySQL should
anything happen to my PC.
Does mysqlimport have to be done in the command line window like
mysqldump, and if so, how? It's just that I tried to import
Mike Tuller wrote:
I have a shell script that is supposed to connect to a remote server running
MySql 3.23.53. It comes up with an error ERROR 1045: Access denied for
user: '[EMAIL PROTECTED]' (Using password: YES)
The script looks like this:
/usr/local/mysql/bin/mysql --user=$username
I've a second look to de csv file and the format of the date is 09/14/1988,
so I think it's easier to load it to the mysql date format, could it be done
using mysqlimport, or LOAD DATA INFILE ??
Thanks
On Tuesday 13 January 2004 18:24, Antonio De Luna wrote:
Hi, I've got a csv archive with
Several years ago, I used a cgi based tool that allowed me to upload a csv file to a
server and load the data into either a new table or an existing table.
Anyone happen to know of one like it now. I can't seem to find it in my archives
anymore.
I know I can do it with load data infile, but I
On Tue, 2004-01-13 at 01:58, Prasad Budim Ram wrote:
Hi All,
Is there any AS3AP benchmark suite readily available for MySQL?
Ram,
Yes but you're asking it in the wrong place :)
It is still not published to the public (we plan to publicly open our
Benchmark BitKeeper tree later this month)
1 - 100 of 109 matches
Mail list logo