From my experience, if you want to import data into a date field, you have to make
sure that the date format in your csv file conforms to a date format required by
MySQL. This part is covered in MySQL documentation. So, your 20.12.1999 date
should become 2001-12-20 and so on.
P.S. Don't
What I want to do is not overly complicated (and it works the way I did
it) but I want to find out if it can be done easily using MySQL only.
Table_a: col1, col2, col3
Table_b: col1, col2, col3
Currently, to replace values in col1 in Table_a with values of col2 in
Table_b, I do the following:
Where can I get MySQL authentication module for Apache?
Thanks.
--
Bolek,
URL: http://www.bolek.com
URL: http://slash.bolek.com
e-mail: [EMAIL PROTECTED]
ICQ: 4086197, Address: 402905326
-
Before posting, please check:
It seems to me that you have misunderstood the manual. As you have pointed
out yourself, you are running MysQL on Windows platform. The syntax you are
referring below is for UNIX/Linux systems... (shell means current shell in
use your system and the rest are commands available on UNIX systems).
You should definitely read up the manual. If you don't do this, will not do
you homework and simply expect an answer handed down to you, you might get
disappointed. Question you have asked is like MySQL 101. To get you started
this time, however, here it is:
select * from table bands order by
-
From: --==[bMan]==-- [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 7:40 PM
To: MySQL List
Subject: Is this a normal behaviour?
O.K. I use MySQL version 3.23 (RedHat 7.0 release) and have a question
about
this query:
1.) [...] LIKE '%pattern'
2.) [...] LIKE 'pattern%'
The first
This is a question for PERL group but anyhow, read again the chapter in MySQL
on printing results from MySQL using PERL. It prints continentA because
that's what you have asked for.
On Sunday 11 February 2001 15:36, Andreas Antes wrote:
=I have created 2 columns:
=col1 varchar(20)
=col2
"Only" 272235??? I enter on average about 75,000 to 80,000 records a day
(and some times, I break 100,000 records a day. I do monthly rotations so
it's easy to calculate how big my table gets). Granted, I don't know what
your table structure is but mine is very simple. All I do is run
If RPM used:
rpm -ql mysql (or if unsure about the package: rpm -qa | grep -i mysql)
Location:
/var/lib/mysql
There you will find your databases where one directory under mysql
corresponds to one database. Documentation on line and searchable on-line
manual come also handy. Just read
I just want to ask a quick question which is probably only indirectly related
to this group. Where can I find some useful info on how to integrate MySQL
into Apache authentication scheme? Basically, I want to use MySQL database
to store users' ids and passwords rather than .htpasswd file
Why gamma??? Go to www.mysql.com and download a stable version of
mysql-3.23.31. It's official now!
On Saturday 27 January 2001 16:11, CheongMeng wrote:
= Hi,
= I failed to install mysql-3.23.30-gamma on bsdi4.2.
= this is the err mesg I got:
= Making all in myisam
= make: don't know how to
11 matches
Mail list logo