Yes, read up on LOAD DATA statement in manual.
--
Richard Ellerbrock
[EMAIL PROTECTED]
>>> Clement <[EMAIL PROTECTED]> 2001/01/25 09:33:46 >>>
Hi,
Can you suggest a way to import a CSV file into a MySQL table? Your
help is greatly appreciated.
Regards,
Clement
--
Hi,
Can you suggest a way to import a CSV file into a MySQL table? Your
help is greatly appreciated.
Regards,
Clement
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
I don't know why I keep forgetting the URL every time I do this.
Here it is,
http://dbd.aktieprat.nu/
...
Anders Hedström wrote:
> Hi
> I have been building an online dbdesigner for MySQL, to be able to
> design a database with some of my non-programming friends.
> The result has become
Good morning,
we want to create a bibliographical database with ca. 500.000 entries and a
very simple structure (3 tables) to publish it on the internet (with PHP
and Apache). A second aim is to make a CD for those, who cannot always be
online. It should be usable like the CD-ROMs you normally
Hi
I have been building an online dbdesigner for MySQL, to be able to
design a database with some of my non-programming friends.
The result has become more than a toy, so I thought I'd show it to
y'all, dear MySQL community.
Features
* Create/change/delete databases / tables / fields / keys
* Ea
Hi
The culprit is OutLook Express. Unfortunately OutLook Express is broken. I
use Eudora Pro and I don't get any problems
At 23:58 24/01/2001 +, Texscene_Support wrote:
>Hi,
>
>I keep getting hundreds of mysql postings.
>
>
>I was away between 16th jan, and 23rd. Since I came back I started
Hi
Use Objectvity, POET or Versant OODBMS
MySQL is not an OODBMS. I have used both Objectivity and POET and for me
POET the easiest to use, especially if you are proficient in C++
Both OODBMS are very expensive
At 21:14 24/01/2001 +, Ez zougari Elmostafa wrote:
>hello there;
>i want to know
Hi,
I`m setting up a field in my DB called Description and basically want it to
have a max character length of 1000, my MySQL manual tells me varchar is
limited to 255 so thats out of the window then it goes on to say text has a
max of 64 kb of text and defines all the others in this way. I di
Can anyone help me with this query???
I have a very big table (70.000 rows) which has several rows like this:
idproductdescription
1P1desc1
2P1desc2
and I want to transform it into:
idproductdescription
1
Can anyone help me with this query???
I have a very big table (70.000 rows) which has several rows like this:
idproductdescription
1P1desc1
2P1desc2
and I want to transform it into:
idproductdescription
1
Sir,
I have downloaded mysql from the net. I want to
install it on the linux machine . I followed all the
instructions given for installation in the binary
distribution form. But there is an error saying that
'unable to connect to socket /tmp/mysql.sock 'while
trying to check whether the serve
Hi Greg,
Thanks for that, perhaps I should drink more coffee help my brain to be a bit
more active at 5.30 in the morning.
Cheers
Ade
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
Try turning your thinking the other way around and you will make life a
little easier for yourself.
Have a tblProject table with projectId as the primary key. You can have as
many other fields for whatever data you want to store.
Then have a tblBids table, having it's own primary key bidId. It
oh, true..thanks!
actually its now saying:
isnt odbc_connect() a predefined function?
Fatal error: Call to unsupported or undefined function odbc_connect()
-hmmm...
mac
- Original Message -
From: Thiemo Nagel <[EMAIL PROTECTED]>
To: Mac Martine <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
S
Hi,
I am creating a web site which allows users to post projects and then others
to place bids. I am setting up two tables in MySQL 'Projects' & 'Bids' my
problem is how best to cross reference. What I was thinking of doing is
creating a number of fields in the Projects table...
Bid1
Bid2
oh, true..thanks!
actually its now saying:
isnt odbc_connect() a predefined function?
Fatal error: Call to unsupported or undefined function odbc_connect()
-hmmm...
mac
- Original Message -
From: Thiemo Nagel <[EMAIL PROTECTED]>
To: Mac Martine <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
S
Hi there,
One of my users wants to copy a large table. He normally does this through
PHPMyAdmin, but the table seems too large for the web browser to handle,
and it times out.
I'm using mysql version 3.22.32-log on a RedHat Linux 6.2 (Intel) box. The
file system is on a hardware RAID array.
>On RedHat there's no need to add "-lz" to the linker options, on Debian it
>is (when using the statically libmyslclient.a). Is this a bug somewhere
>in the makefile or anyways, should compress be in the .a lib or is it ought
>to be added manually with -lz?
Use -lz
Read on:
-
THE PROBL
On Wed, Jan 24, 2001 at 10:45:53PM -0500, Scott Vanderweyst wrote:
>
> I have a couple of questions regarding replication in MySQL:
>
> 1) does it work well/handle loss of connections due to network
> outages/delays; we have a geographically diverse environment, and were
> hoping to be able to re
At 09:58 PM 1/23/01 , Manuel Leos wrote:
>Hi everybody, I'm trying to install the RPM on a RH
>7.0 everything looks normal but the server dies
>sending this message
>mysqld: Can't find file: 'host.ISM' (errno: 2)
It's part of the first database/table that MySQL sets up for you.
I get this error
>Just a question of curiousity. Can you install PHP using tars files?
>I was looking at purchasing a few servers last fall and when I looked at the
>RAQ3/4 they (colbalt) told me that you could only install their stuff and
>they didn't have new versions of MySQL and only PHP3.
Yep!
The Cobalts
I have a couple of questions regarding replication in MySQL:
1) does it work well/handle loss of connections due to network
outages/delays; we have a geographically diverse environment, and were
hoping to be able to replicate the data across the connections (which
may have outages from time to ti
Hi,
as far as I can see that, you forgot the $ sign in front of the odbc_db
variable at the line, that causes the error.
bye,
Thiemo
Mac Martine schrieb:
>
> hello-
> I'm getting a parse error here...any ideas why? This is my first try at databases,
>php, mysql and odbc, so.
> the d
hello-
I'm getting a parse error here...any ideas why? This is my first try at databases,
php, mysql and odbc, so.
the database is one which i made in MSaccess...
thanks-
if(!(odbc_db = odbc_connect($odbc_dsn, $odbc_userid, $odbc_password)))
<---PARSE ERROR ON LINE ABOVE-
Thanks for looking at my problem and giving me a hint.
> Do a myisamchk on your table. It sounds like you're having
> trouble with a corrupted index.
>
First run of myisamchk indicated "1 clients is using or hasn't closed the
table properly"
I ran myisamchk -r on the shop.MYI and got the messag
Today I had an unsuccessful intallation of mysql 3.22.32 (RPM) server on a
Cobalt Raq 3 Server. I am not quite sure why the file didn't install but the
2202 can't find var/lib/mysql mysql.sock error continues to be an error when
starting safe_mysqld server. How can I solve this problem? I went
I have used both on the same machine(FreeBSD 4.1) and never have had a
problem.
- Original Message -
From: "Khuon Tech" <[EMAIL PROTECTED]>
To: "MySQL forum" <[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 7:56 PM
Subject: MySQL + PHP ?
>
> Hi all,
>
> I'm actually using RH kernel
Hi all,
I'm actually using RH kernel 2.2.16 with Apache(1.3.9 + mod_ssl)/Perl5/
MySQL(3.22.30). Managing databases in MySQL with Apache/DBI.
My question is:
Is it possible to use both DBI(Perl) and PHP on the same machine in order to
manage databases in MySQL with Apache? Any conflict?
I gon
Did you ever get an answer?
I played with some queries and came up with this:
SELECT ID, NAME, RATING FROM SINGLEMALTS ORDER BY RATING DESC LIMIT 0,1;
If you want more than one record, you can change the 1 at the end to how
many you want. If you want to list them all in that order, you can take
o
Hi,
you need to install the perl DBI package!
> What is DBI, sounds like data base interface or something like that. Do I
> need a latter perl or a different configure for my perl???
"The DBI is a database interface module for Perl. It defines a set of
methods, variables and conventions that pr
DBI is the database interface for Perl, I assume this bench mark uses perl
so you will need to install the DBI.
- Original Message -
From: "MacDonell, Dennis" <[EMAIL PROTECTED]>
To: "'MySQL List'" <[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 5:51 PM
Subject: Running mysql tests
Hi,
>Row = mysql_fetch_row(result); < Here is the problem
That syntax seems correct. Make sure you have defined Row as:
MYSQL_ROW Row;
and that result is defined as
MYSQL_RES *result;
printf("\n\t%u %4s",j,Row); <---YOUR problem seems to be here! change
Row to Row[0] and see if
Dear mail overload,
Here are some things you can do:
1.) Make sure that you set your mail client to delete messages off the
server when deleted.
2.) Download the messages and Delete all the messages you don't want.
3.) Make sure to remove yourself from the list before you go away next time.
4.)
Hi,
There must be a simple answer to this but I'm not quite across it.
I build mysql-3.23.32 yesterday, and seeing if everything worked. Going
through the steps of INSTALL-SOURCE, everything seemed to be working until I
got to the bit where you run all the tests. From the command line in
/usr/l
First of all, before I forget it...
My MySQL is:
mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)
I have a problem with mysql_fetch_row...
When I use it the system goes to 100% CPU usage and nothing else, I get
not
rows...
The code is:
.
.
.
When I run this query on a 20,000 record table with 18 fields. The table
has some identical entries and I am trying to get a count of those entries
descending.
SELECT
email,
fname,
lname,
count(email) as emailcount
FROM
referralSpace
GROUP BY
email
ORDER BY
emailcount ASC
LI
Muhd Zamri MS wrote:
>
> Hi...
>
> I need to somebody clarify what is the problem with this..:
>
> MYSQL mysql;
> MYSQL_RES *result;
> MYSQL_ROW rows;
> int i,n;
>
> .
> .
> .
>
> result = mysql_store_result(&mysql);
>
> n = mysql_num_rows(result);
>
> for(i=0;i<=n;i++)
> {
>
>
> On Wed, Jan 24, 2001 at 05:09:59PM -0600, Kevin Day wrote:
> >
> > I don't know why configure doesn't think I have snprintf, but I
> > guess I'm glad it doesn't, because shouldn't that cause bad things
> > if I did? shouldn't the line be:
> >
> > snprintf(to,val_buffer->length(),"%.*f",
>
> On Wed, Jan 24, 2001 at 03:15:48PM -0600, Kevin Day wrote:
>
> Does this only occur when more than one client is accessing the table
> in question? If so, it's a thread-related problem that has been with
> us since FreeBSD 3.x. :-(
>
> It looks like what I've seen before.
>
> I have a re-p
Hi,
I keep getting hundreds of mysql postings.
I was away between 16th jan, and 23rd. Since I came back I started to receive all the
mysql mails since 16th of January whenever I press the "Send/Receive" button on the
OUTLOOK EXPRESS.
First time round there were about 800 messages. I patient
Hi,
I keep getting hundreds of mysql postings.
I was away between 16th jan, and 23rd. Since I came back I started to receive all the
mysql mails since 16th of January whenever I press the "Send/Receive" button on the
OUTLOOK EXPRESS.
First time round there were about 800 messages. I patient
On Wed, Jan 24, 2001 at 05:20:30PM -0500, Kent Hoover wrote:
>
> Can I add, activate, and use a new UDF function to an already
> existing udf_.so library without restarting MySQL server?
Yes.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (
On Wed, Jan 24, 2001 at 05:09:59PM -0600, Kevin Day wrote:
>
> I don't know why configure doesn't think I have snprintf, but I
> guess I'm glad it doesn't, because shouldn't that cause bad things
> if I did? shouldn't the line be:
>
> snprintf(to,val_buffer->length(),"%.*f",dec,nr);
>
> In
On Wed, Jan 24, 2001 at 03:15:48PM -0600, Kevin Day wrote:
Does this only occur when more than one client is accessing the table
in question? If so, it's a thread-related problem that has been with
us since FreeBSD 3.x. :-(
It looks like what I've seen before.
I have a re-produceable case that
Okay, thanks guys! I'll lob this ball atcha, then:
My main data table is 'trcdatabase2'. I currently use perl programs to get
our in-house exported flat-file database into web-ready shape, but these
can go *really* *slowly*, so I wanted to harness the speed of SQL. I've
created a couple of
did you try substr?
http://www.php.net/manual/en/function.strstr.php
-Original Message-
From: Lucas Rockwell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 1:14 PM
To: PHPDB
Subject: [PHP-DB] substring equiv in PHP
Hello,
I am wondering what PHP's equilivent of the SQL s
>
> >Description:
>
> I'm getting a pretty consistant crash in mysqld:
>
> /usr/ports/databases/mysql323-server/work/mysql-3.23.32/sql/mysqld: ready for
>connections
>
> Program received signal SIGSEGV, Segmentation fault.
> 0x282ae35c in bcopy () from /usr/lib/libc_r.so.4
> (gdb) bt
> #0
I am attempting to benchmark mysql on a single-proc machine vs a quad-proc
machine.
Every time I run mysql-super-smack against the test2.smack file provided, I
get the error:
mysql-super-smack:client 'smacker2' referenced on line 61 is not
defined
mysql-super-smack:line 54: set_nu
Can I add, activate, and use a new UDF function to an already existing
udf_.so library without restarting MySQL server?
Thanks,
Kent Hoover
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi,
If my calculations are correct, your table will grow quite a lot
if you change from the MyISAM format to HEAP. The space to hold
the data will be roughly 1.3GB (a double of what it's with MyISAM!)
and the index will be another 1.3GB. Pretty huge, isn't it?
I think the dynamic row format is
hello there;
i want to know if it's possible to implemente an oriented object databases,
and what should i do to release this implementation.
thank's.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manu
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/m
ysql.sock' (111)
I have a Cobalt Raq3 trying to get mysql installed but I can't get passed
this. Any suggestions.
-
Before posting, please check
I haven't participated, but the site at
www.sqlteam.com
looks useful and does have a number of forums there.
HTH,
G.
> -Original Message-
> From: Jason Witherspoon [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 25 January 2001 8:14
> To: [EMAIL PROTECTED]
> Subject: rank newbie looking
OK,here goes more information about my problem:
I have a table with the next structure:
flag char(1)
nextval bigint(20) unsigned autoincrement
The query i execute with no problems in mysql 3.22 is:
select * from table;
REPLACE INTO table values (\'\',nextval+1)
Hi Jason,
You have found the right place.
No one here minds you asking simple questions, so long as you have checked
the manual and the list archive before asking. In particular, Red Hat
installs are a frequent topic.
This list is supposed to be MySQL specific, but sometimes we get a little
sid
Hi
I have not used MySQL for a while and just noticed in the manual a feature
called SQL_BUFFER_RESULT. I was wondering whether this is useful if I am
writing an application in PHP (web based)?
For example, if I did a select that returned 1000 rows, would PHP store the
dataset in its memory and
start with:
http://www.sqlcourse.com/
At 01:44 PM 1/24/2001 -0800, Jason Witherspoon wrote:
>Hi--
>
>As stated above, I'm a raw beginner looking for some (probably fairly
>simple) SQL conceptual help. Having lurked for a while, I can see that
>since this isn't MySQL-specific, there's probabl
Hi--
As stated above, I'm a raw beginner looking for some (probably fairly
simple) SQL conceptual help. Having lurked for a while, I can see that
since this isn't MySQL-specific, there's probably a better forum in which I
can attempt to iron out my confusion.
Can anyone point me to a mailing
Sounds good. You should probably have a cleaner process of some kind just in
case one of your threads dies before it can release the lock. I think with
get_lock you have a timeout that protects you from that. I'm curious about
the internals of get_lock - perhaps it's more efficient to use a soft l
>Description:
I'm getting a pretty consistant crash in mysqld:
/usr/ports/databases/mysql323-server/work/mysql-3.23.32/sql/mysqld: ready for
connections
Program received signal SIGSEGV, Segmentation fault.
0x282ae35c in bcopy () from /usr/lib/libc_r.so.4
(gdb) bt
#0 0x282ae35c in bcopy () fro
Randy,
My recommendation (and there are probably many people who will disagree with
me) is to use a "soft-lock" schema.
In your account table, add a field named lockedBy. I usually add a field
named lockedAt also as a timestamp.
the basic flow is this:
1: Check to see if the record has somethi
Sounds like you want a mutex and you can use get_lock and release_lock in
mysql for that.
http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
GET_LOCK(str,timeout)
Tries to obtain a lock with a name given by the string str, with a timeout
of timeout seconds. Returns 1 if the lock was obta
Benjamin, beautifully put. Thank you both so much.
--Dylan Shea
Benjamin Pflugmann wrote:
> Hi.
>
> It's simply that you can look at (a_id,b_id) as a PRIMARY KEY. You
> don't need an additional, aritificial sequence number ab_id.
>
> CREATE TABLE table_ab (
> a_id INT NOT NULL,
> b_id INT
Hello monty,
I'm using mysql 3.23.32 on linux and it looks like there is a
problem with check/auto-recovery left:
On many of my servers I find the above in a log file:
24.Jan 23:45:07 : pid:1412 counter:32256 AllInOne MySqlEr
Query - #1034 [tor.local] - Incorrect key file for table: 'g09
Hello,
I am creating a mock site that has a money balance that people can login
and pretend to pay money for stuff online via my site.
I am using php with mysql to implement this.
How do I make sure that a balance for a particular account is (locked) so
only 1 spend for that account can happen
Richard
Thanks for the info! I have just one more question. To get the structure of
the table I did a myisamchk and did a desc on the table. The output is shown
below. From this is it possible to determine the amount of RAM I would need
for a HEAP table?
Thanks!
MichaelT
MyISAM file: d
On 24-Jan-01 Jesús Gómez Pastor wrote:
> I have a problem in 3.23.32,
> The query
>
> select * from table
> repalce table values('','nextval+1)
^^ ^
these might be a problem, in addition to your select/replace/(update)
confusion.
>
> returns me always nextval=1.
n
It's one of MySQL's permission files which is usually in
/var/lib/mysql/mysql
If the file is there it may be permissioned incorrectly. It usually needs to
be owned by the mysql user and group so
cd /var/lib/mysql
chown mysql.mysql mysql -R
if this seems to be the problem.
The permission files in
That feature is only available in 3.23, while you're running
3.22. Upgrade your server and you'll get it.
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From: lrado [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 2
On Wednesday 24 January 2001 09:47, Josef Chladek wrote:
>> I am currently investigating this. In the mean time, see if the following
>> workaround will solve the problem:
>>
>> CHANGE MASTER TO
>> MASTER_HOST='your-master',MASTER_USER='user',MASTER_PASSWORD='mast
>> er-pass',
>> MASTER_LOG_POS
hi everybody !!!
i need to resolve the following query ( a silly one ) in a mysql server
3.22.30
and i get the following error:
mysql> select count(distinct ip_dst) from iphdr;
ERROR 1064: You have an error in your SQL syntax near 'distinct ip_dst)
from iphdr' at line 1
mysql>
Hi everybody, I'm trying to install MySQL-3.22.32
on a RH 7.0 everything looks normal but the server
dies sending this message
mysqld: Can't find file: 'host.ISM' (errno: 2)
How do I fix this?, Where can I get this file? or How
can I build it?
Thanks
_
Hi!
On Jan 23, Alex Krohn wrote:
> Hi,
>
> Has anyone used the fulltext indexes in 3.23 and can share their
> experiences? I've only done limited testing, but was quite disapointed
> with performance.
>
> We have an import of DMoz data into a table with Title, URL and
> Description fields as a
Hey Chuck,
We replicate data on a regular basis from Oracle to MySQL and back using
perl cron scripts. Here's a basic one for ya:
#!/usr/bin/perl
use strict;
use DBI;
my $dbh1=DBI->connect("DBI:mysql:dbname:host.mark.com:6969", 'root'
,'password');
my $dbh2=DBI->connect("DBI:mysql:dbname2:host
Hi,
I do what to know this literal question. But what about if you are doing
this across two servers?
You certainly don't want to copy they whole table to the second database to
update the second with the first.
And I know someone will say use replication, but I am more interesting in a
general
I have a problem in 3.23.32,
The query
select * from table
repalce table values('','nextval+1)
returns me always nextval=1.
table has 1 row and the query runs fine in mysql 3.22.x
Any idea?
Thanks.
You might be able to build it from tarball as a regular user but access
to the RPM database (e.g. installing via RPM) requires root level
permissions.
On Wed, 24 Jan 2001, lkeeton spewed into the bitstream:
l>Why am I getting this error. Is the rpm program not working. I am running as
l>user ad
hey all,
i'm having some problems with 3.20.32a not accepting any default values.
on the following test create i get
ERROR: Invalid default value for 'testid'
create table tbltest (
testid mediumint(11) unsigned DEFAULT '0' NOT NULL auto_increment,
test char(12) NOT NULL,
PRIMARY KEY (testid))
After noticing all my PHP scripts using MySQL had stopped working, I
noticed that any attempt to look through databases mith mysql brought
up;
Can't read dir of '.' (Errcode: 9)
Can't read dir of './mysql' (Errcode: 9)
Database changed
I can no longer get any information from MySQL, and I'm hopin
I used to get this all the time, myself, when I was trying to update
a mysql database with Access 2000 through myodbc. Funny, at the time,
nobody else seemed to understand what I was talking about. Once I got
phpMyAdmin working, the problem became academic, but it never did get
solved.
I'm s
if you've compiled php without apache support (separately from your normal
php with apache support) but with mySQL then you can write php scripts that
run from the command line. I usually keep a second php.ini for command line
scripts because they can run long. This all could be put in a CRON jo
Hi.
It's simply that you can look at (a_id,b_id) as a PRIMARY KEY. You
don't need an additional, aritificial sequence number ab_id.
CREATE TABLE table_ab (
a_id INT NOT NULL,
b_id INT NOT NULL,
PRIMARY KEY (a_id,b_id),
UNIQUE (b_id,a_id)
)
Replace INT by whatever type seems appropriate
Chuck Barnett wrote:
>
> Thanks for replying.
> I know the SQL commands, I want to know how to automate the whole sequence.
>
> I've always written php pages that do the calls. I want to write a script
> to do it on the server as a cron job or something.
Ahhh, pardon my confusion, since this
Thanks for replying.
I know the SQL commands, I want to know how to automate the whole sequence.
I've always written php pages that do the calls. I want to write a script
to do it on the server as a cron job or something.
thanks
Chuck
- Original Message -
From: "Steve Ruby" <[EMAIL PROT
Why am I getting this error. Is the rpm program not working. I am running as
user admin not root. I was told that I can still install mysql without using
the root user. The only thing i know is that when I went to that directory
below I don't have permission to write to that directory. I am not
Chuck Barnett wrote:
>
> How do I copy the data from one table to another table with a time stamp
> every night?
>
> example: table A contains x,y,z.
>
> at midnight, I want to copy table A's contents to table B (B has same
> fields, just adds a date field) and reset x,y,z to zero.
>
what d
I'm doing NIDS work as a small part of my job and have setup MySQL 3.22.32 for
logging of alerts. My problem is that when a user accesses the db it gets
locked and the NIDS hangs if the read takes too long, forcing a reboot of the
NIDS box. I'm trying to determine if I replicate the db and do th
Dear,
I am Tomcat 3.2 user and it is running on Windows 2000 Professional.
I used MS Access and Tomcat crashed everytime.
So I downloaded MySql (mm.mysql-2.0.1-bin.jar for JDBC , MySQL3.23,
MyODBC ) and still Tomcat is crashing.
I think the problem would be memory leaking caused by JDBC-ODBC bri
How do I copy the data from one table to another table with a time stamp
every night?
example: table A contains x,y,z.
at midnight, I want to copy table A's contents to table B (B has same
fields, just adds a date field) and reset x,y,z to zero.
my setup is a cobalt raq4i MySQL 3.22.32
Thank
Hi-
I know I'm probably gonna regret this (bandwith issues), but I have just
put up an online SQL reference at http://comclub.dyndns.org:8081/sqlref/
Feel free to use it. If you see any problems, just tell me or hit the
webmaster link at the bottom.
--Quentin
--
Hi there folks,
I upgraded to 3.23.32 yesterday from 3.22.32.
Now I'm seeing a whole host of problems.
(I just joined the list, so while I saw tc lewis' similar problem #1,
I didn't see the resolution.)
1) I've got the aborted connection problem appearing in my logs
frequently:
010124 11:17:5
It's not annoying if that's the format you require...
Try the DATE_FORMAT() function like so:
select DATE_FORMAT(datecolumn,"%d/%m/%y") from tbl_name;
Please see the manual:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
On Wed, 24 Jan 2001, Sam wrote:
> Hi all,
>
> I was wonde
Hi all,
I was wondering how I can display a date in this format 'DD/MM/YY'
As when I do a select statement and display the date I get it in this format
'DD-MM-YYY 00:00:00'
Which is kind of annoying.
I am using mySQL and also PHP.
Thanks in advance.
Sam Rose
Try writing a PERL wrapper, that dumps the table to the screen and then
pipe it to more
% MyPerlwrapper -table | more
>Is there a user friendly utility that would allow one to display the
>structure of a table or view the contents of one? Of course, this can
>be done from within "mysql -p" bu
Hi
There appears to be a problem with the .wpi files of 3-23-28 OS/2 port.
The main file sends my swap file to over 300 Meg and with the inf and pdf files I get
a message that they are corrupted.
Could the person who ported it please re-issue them.
Thanks
Robert Gehrig
Webmaster at www.gdbar
Rajesh Prakasan
I use this free and lighweight SSH client for win32 to access my remote
mysql servers on linux
check it out at
http://www.chiark.greenend.org.uk/~sgtatham/putty/
-Sherwin
Yesmynet Internet
#mysql - undernet irc
- Original Message -
From: "Rajesh Prakasan" <[EMAIL
I have not read in the documentation if we can do this or not.
I would like to have a script running that would have a server socket
listening for connections. Once a connection is made, it would receive,
say, 5000 lines of info into some temp buffer. We have some efficient
SWIG'd C code that can
mysql etoys < test.txt | more
where test.txt contains something like:
desc addresses;
desc members;
Or try
mysqldump dbname addresses members orders -d | more
That'll give you the data definition language without any data for each
table. (addresses, members and orders in the above example)
If
Here are attached files:
<> <> <>
---
Dear MySQL supporter,
I tried to install MySQL version 3.23.32 on our AIX machine but got
errors.
Source compilation also failed. Here are the situation I worked and
attached are error log files.
Binary Insta
Dear MySQL supporter,
I tried to install MySQL version 3.23.32 on our AIX machine but got
errors.
Source compilation also failed. Here are the situation I worked and
attached are error log files.
Binary Installation
released file : mysql-3.23.32-ibm-aix4.3.3.0-rs6000.tar.gz
error log fro
1 - 100 of 152 matches
Mail list logo
