gopinath ([EMAIL PROTECTED]) writes:
> Please let us know about the correct link for download MySQL for WIn NT. =
> We want to know about the exact links for ODBC and the program also.
Try http://www.mysql.com/downloads/mysql-3.23.html
--
Ed Carp, N7EKG [EMAIL PROTECTED] 940/
Hi,
Please let us know about the correct link for download MySQL for WIn NT. We want to
know about the exact links for ODBC and the program also.
Regards
Gopinath
I write a cgi problem of c++, and I compile it and run it normally in mysql 3.22.25.
but when I change the mysql to 3.23.32, I recompile the program and run it,
It display a error msg like this:
shell>./test
./test.fgi: error in loading shared libraries: libmysqlclient.so.10: cannot
open s
Nusphere offers a full distribution of MySQL, Apache, Perl, and php for $79.
Included in the box are three O'Reilly quick guides and the MySQL manual in
a printed and bound format. The distribution provides a slick installation
on Windows, personally I've tried this and the Abriasoft distribution
I'm confused. You say you are in a time crunch to get mysql working on your
site but you have no mysql connection/code. You say you coded and tested on
another site and it works. If I'm right, that other site had the Windoze OS
as their web site which of course it work fine...
... unlesss ...
SELECT SUBSTRING(COL3,0,100) AS COL3 FROM TABLE
That will return the first 100 characters of your 10 pages of text...
If you want characters 200 through 299 do:
SELECT SUBSTRING(COL3,200,100) AS COL3 FROM TABLE
Untested, but I am 99.9% sure that will meet your needs.
Brian
>
> hmm...I don`
Hi,
I would like to find out if the Win2000 version of
mysql and myodbc support Win2000 clustering.
Thanks,
Sam
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
---
===
Diego Mauricio López G .
Docente Departamento de Conmutación
(Ingeniería Telemática)
Facultad de Ing. Electrónica - Universidad del Cauca. Popayán- Colombia
Tel: (+57-28) 233031 ext 192 Fax: (+57-28) 233031
website: http://www.ucauca.edu
Ming Hsu ([EMAIL PROTECTED]) writes:
> Hi, I've been working with mysql for a couple of months now for my
> website. Now I have to move to a different server, and would like to move
> the database as well. Problem is I have no idea what this entails and how
> to do it. Can someone help me? Tha
Don Read ([EMAIL PROTECTED]) writes:
> On 20-Feb-01 Denis L. Menezes wrote:
> > Hello friends.
> >
> > Can anyone please advise how I can obtain a printed copy of the MYSQL
> > manual?
> >
>
> $ cd /usr/local/share/doc/mysql
> $ lpr manual.txt
>
> -- or --
>
> http://www.mysql.com/documenta
Paradox ([EMAIL PROTECTED]) writes:
> I have a table with an integer auto increment primary key, INVNUM, and a
> CHAR(48) field NAME.
>
> Is there a way I can have my table presorted by the text field, so that a
> select call with "ORDER BY NAME" is just as fast as "ORDER BY INVNUM"? I
> have tr
=?iso-8859-1?Q?diego_L=F3pez?= ([EMAIL PROTECTED]) writes:
> I already did something like that .. the problem was i erase all the
> content of the mysql directory and i creaste a new mysql database, and when
> i try to restar the mysql daemon (/etc/rc.d/init.d/mysql start) i get a
> message l
Joe and Nancy ([EMAIL PROTECTED]) writes:
> I am in a time crunch to get mysql working on my site. I export inventory
> records out of my Peachtree software into Excel and planned to use that .xls
> table to show product pricing and availability on my web pages. Below is
> sample asp code that
I am in a time crunch to get mysql working on my site. I export inventory
records out of my Peachtree software into Excel and planned to use that .xls
table to show product pricing and availability on my web pages. Below is
sample asp code that works. My ISP had told me they support asp, but af
thanks in advice
I already did something like that .. the problem was i erase all the
content of the mysql directory and i creaste a new mysql database, and when
i try to restar the mysql daemon (/etc/rc.d/init.d/mysql start) i get a
message like:
[root@halley mysql]# Starting mysqld daemon
On Mon, 19 Feb 2001, [iso-8859-1] diego López wrote:
> Hi all,
> i installed successful Mysql ver 3.25.33-1
> after that i changer the root password and when i make a connection looks
> like i am connecting with the user @localhost instead the root user
>
> [root@halley bin]# mysql -u root mysq
I have a table with an integer auto increment primary key, INVNUM, and a
CHAR(48) field NAME.
Is there a way I can have my table presorted by the text field, so that a
select call with "ORDER BY NAME" is just as fast as "ORDER BY INVNUM"? I
have tried indexing the textfield, both a few leading ch
Rolf Hopkins ([EMAIL PROTECTED]) writes:
> The reason why I didn't answer this is because I think there is a bug
> somewhere. How was a dump file allowed to be created with reserved words?
> or better still, how where "illegal" column names allowed to be created in
> the first place?
% mysqldum
You mean 3.23.33???
Try: mysqladmin -u root password new-password
If that fails, start mysql server with skip grants and change the password
that way and then restart the server. Skip grants is in the manual. If you
still have problems, look at the permissions on the mysql directories/files.
hi, my system is OSF1 V4.0 878 alpha,
I tried to install mysql-3.23.30-gamma-dec-osf5.1-alphaev6. I think this is
binary distribution. the path in bin/mysqlaccess has been changed to
reflect my installation path.
when I run
scripts/mysql_install_db
it showed following error message, please indi
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:mysql account
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Rele
On 20-Feb-01 Denis L. Menezes wrote:
> Hello friends.
>
> Can anyone please advise how I can obtain a printed copy of the MYSQL
> manual?
>
$ cd /usr/local/share/doc/mysql
$ lpr manual.txt
-- or --
http://www.mysql.com/documentation/mysql/full/
(then click the PRINT thingy)
> thank you.
Hi all,
i installed successful Mysql ver 3.25.33-1
after that i changer the root password and when i make a connection looks
like i am connecting with the user @localhost instead the root user
[root@halley bin]# mysql -u root mysql
ERROR 1044: Access denied for user: '@localhost' to database 'my
Hello friends.
Can anyone please advise how I can obtain a printed copy of the MYSQL
manual?
thank you.
denis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
>"-lm" has been specified in the linker option line.
Before or after the -lmylsqlclient flag? It needs to be after.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PROTECTED] Rockville
The reason why I didn't answer this is because I think there is a bug
somewhere. How was a dump file allowed to be created with reserved words?
or better still, how where "illegal" column names allowed to be created in
the first place?
- Original Message -
From: "Gerald L. Clark" <[EMAI
I would leave it the way it is, if I were you except for one thing. Change
the table name Colours to CarColours. Will make it a little less confusing
in the future.
- Original Message -
From: "îÉËÏÌÉÎ óÅÒÇÅÊ" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 20, 2001
check out the "set" type instead of enum.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Column_types
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SET
-tcl.
On Tue, 20 Feb 2001, [KOI8-R] "îÉËÏÌÉÎ óÅÒÇÅÊ" wrote:
> Hello
>
> I have situatio
Best way I can think of is by doing a select on table2 to get the value you
want and then delete from table1.
You could try
> delete from table1 where table1.somecol=table2.somecol and
table2.somecol2=somevalue and table1.somecol4=someothervalue
but I doubt it as it is not in the manual. If it
Hello
I have situation where I can't decide whether to use ENUM type.
Here is a situation:
table contains records about CarID and its colour(s). Each CarID is allowed to have
more than one colour such as red, green, blue. CarID may have just one colour.
This is the code I would use to creat
Fred van Engen ([EMAIL PROTECTED]) writes:
> On Mon, Feb 19, 2001 at 06:44:50PM +0100, Abraham García wrote:
> > I have a weird (at least weird for me) problem trying to connect to mysql
> > server v 3.23...
> >
> > When I try to connect from some sites, I got an ERROR 1045: Access denied
> > fo
Sure, the remote clients have reverse and forward entries.
I'll recompile the server binary with debugging options turned on, and I'll
take a look at the error log...
Thanks.
Atentamente,
Abraham García Gutiérrez
AdverNet S.L. - OZÚ
Tel: 91 701 0186
-Mensaje original-
De: [EMAIL PRO
Rolf Hopkins ([EMAIL PROTECTED]) writes:
> I think you mean addslashes()
> > If you are using PHP there is the htmlspecialchars() function that will do
> just that for you.
> > > > > I have written a program which reads data from WWW forms and passes
> > > > it to
> > > > > MySQL queries. All w
> > I'm trying to set up a link to MySQL through Microsoft SQL.
> >
> > I set up a ODBC DSN using MyODBC and I told Microsoft SQL to link through
> an
> > ODBC Datasource. Everything seems to work except I can't query anything.
> >
> > This is a statement I try.
> >
> > SELECT * FROM [MySQL].mysql
I am getting this error when running a CGI script that inserts into a table.
The script works fine about 90% of the time but I get these occasionally.
Sometimes I will keep hitting the back button and re-submitting the form and
I sometimes get this as well. ie (the same logical path throgh the scr
I never tried but I would have thought you would type a normal table name in
your SELECT statement. It looks like your writing SQL statements meant for
MS SQL and not mysql.
- Original Message -
From: "Aaron Weiker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 20,
I think you mean addslashes()
- Original Message -
From: "Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 20, 2001 2:37
Subject: Re: special characters in MySQL query
> If you are using PHP there is the htmlspecialchars() function that will d
On Mon, Feb 19, 2001 at 11:06:21AM -0800, [EMAIL PROTECTED] wrote:
> I have a table with a date field, and would like to sort it
> on month and day. What I would like to do is:
>
>
> SELECT lastname,firstname,dob FROM table1 GROUP BY month(dob),day(dob)
>
> (where dob is a column of type 'da
Hi Doug,
Try to use
insert into player_table(playerid, player_name) values (auto,
'$player_name);
Cheers,
Minh Dam
On Mon, 19 Feb 2001, Doug Linley wrote:
> I have a table that I created that has a primary key field that should be
> auto_incremented. To fill in this value I am calling
>
>
Hi,
Your are using LAST_INSERT_ID wrong. You should just do:
insert into player_table(player_name) values ('$player_name');
And then use LAST_INSERT_ID to find out what player_id was assigned.
Although "LAST_INSERT_ID() + 1" will give you "your last value +1", another
client might already have
i guess the calculation returns a result (ie: whether it's successfull or
not), so '1-1' evaluates true; but 1-A evaluates false because A is not a
number so you can't calculate on it.
So in your case, this would be:
where user_num+"AL011-33"
if user_num='0':
where '0'="%any%"; /// returns True
Jim Bayers wrote:
>
> I have a non-profit site that uses mysql. I need to optimize two queries so
> they won't put such a load on the mysql server. If I don't lighten the
> load, they've treatened to kick us off.
Check the manual chaper about optimizations, especially about EXPLAIN
command. Th
On Mon, Feb 19, 2001 at 05:33:00PM -0500, Doug Linley wrote:
> I have a table that I created that has a primary key field that should be
> auto_incremented. To fill in this value I am calling
>
> insert into player_table(playerid, player_name) values (LAST_INSERT_ID() +
> 1, '$player_name');
>
If you have the field set as auto_increment the you don't need to do
anything else. Let nature take it's course. :)
try:
insert into player_table(player_name) values ('$player_name');
Cal
http://www.calevans.com
-Original Message-
From: Doug Linley [mailto:[EMAIL PROTECTED]]
Sent: Mon
If playerid is an auto_increment field, then either of these work --
INSERT INTO player_table(player_name) VALUES ('$player_name');
INSERT INTO player_table(playerid, player_name) VALUES
(NULL,'$player_name');
"Doug Linley" <[EMAIL PROTECTED]> wrote:
I have a table that I created that has a
On Mon, Feb 19, 2001 at 06:44:50PM +0100, Abraham García wrote:
> I have a weird (at least weird for me) problem trying to connect to mysql
> server v 3.23...
>
> When I try to connect from some sites, I got an ERROR 1045: Access denied
> for user: 'user@host' (Using password: YES)
> I'm sure the
Hi, i'm a newbe with MySql and the list.
I've made an application on my local host using ASP/Access and now i must transpose it
on a Cobalt system with Linux and ChiliAsp/Mysql. I'm looking for the connection
strings and principles to use but i can't find them.
Is there someone to help me ?
Th
Hello
In case this patch wasn't post here.
bye,
-christian-
Package: mysql
Version: 3.23.33-1
Severity: important
Tags: patch
Below is a patch against mysql 3.23.31 (but applies well to 3.23.33-1) for
things to work properly on Alpha. I've been applying this diff against
most of the mysq
I have a table that I created that has a primary key field that should be
auto_incremented. To fill in this value I am calling
insert into player_table(playerid, player_name) values (LAST_INSERT_ID() +
1, '$player_name');
My problem is that I'm getting duplicated key values because last_insert_
First time here, sorry if this is too much of a novice question to get
answered...
I just sent the command:
DELETE FROM users WHERE user_num+"AL011-33";
by accident (I meant to use an "=" not the "+"). It killed 81 rows. I
restored the data, but I couldn't find anything in the docs about what
On Mon, Feb 19, 2001 at 12:22:04PM -0800, John Jensen wrote:
> Okay, so I got it using the mysql root password as an option, but I
> find not evidence of a backup or sql file being created, unless I add
> a pipe and redirection instructions to the command. The mysqldump
> command is either putt
On Mon, Feb 19, 2001 at 09:26:34PM +0100, jaco wrote:
> I'm having problems with mysqldump too.
>
> I'm trying it on a Suse Linux 6.2 system, from the /usr/bin directory as root,
>typing ./mysqldump --all-databases > backup.sql
>
> as is explained on http://www.mysql.com/doc/m/y/mysqldump.html
>>I work for a web hosting company that has mysql 3.22.23 on one
>>of our servers. The server is Free BSD unix version 3.5. It seems every
>>few weeks it pops up with this
>>error.
>>
>>System Error: DBI->connect(WWWThreads:localhost) failed: Can't
>>create a new thread (errno 35). If you are no
Floats are inexact. If you want exact try the numeric data type. Its
stored as a character.
On Sat, 17 Feb 2001, Xi Jiang (ITSPORTSNET) wrote:
> Date: Sat, 17 Feb 2001 21:05:25 -0700
> From: Xi Jiang (ITSPORTSNET) <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: float value is changed
I'm trying to set up a link to MySQL through Microsoft SQL.
I set up a ODBC DSN using MyODBC and I told Microsoft SQL to link through an
ODBC Datasource. Everything seems to work except I can't query anything.
This is a statement I try.
SELECT * FROM [MySQL].mysql.db
This is the error message
I have a non-profit site that uses mysql. I need to optimize two queries so
they won't put such a load on the mysql server. If I don't lighten the
load, they've treatened to kick us off.
What columns are best to index?
SELECT messages.ID as ID, title, text, user_id,
username, email
FRO
> There are two timeouts in recent 3.23 client versions and several
> timeouts on the server.
>
> Check that you have set the right ones.
>
>
> Regards,
>
> Sinisa
Ok, thank you
-
Before posting, please check:
http:/
As far as my understanding at this point, mod_auth_mysql 2.20 is no longer
being developed by the original author. I have modified the source code
and configure options of mod_auth_mysql 2.20 to make it work with Apache
1.3.x (it was developed for 1.2.x) as well as am testing a version
optimized
Thank you Fred, that helps
On 19 Feb 2001, at 21:23, Fred van Engen wrote:
> On Mon, Feb 19, 2001 at 11:39:07AM -0800, John Jensen wrote:
> > I have an existing mysql database I am trying to back up before
> > upgrading to 3.23 from 3.22. Both the mysqldump and mysqladmin
> > commands tell me I
By "even as root", do you mean that you did something like this:
$ mysqldump -u root -p db_name > db_name.sql
? The "root" user *in* MySQL should have privileges to run
mysqldump. Describe the situation in a little more detail if
you're still having problems - like:
* what is the exact mysq
I'm having problems with mysqldump too.
I'm trying it on a Suse Linux 6.2 system, from the /usr/bin directory as root, typing
./mysqldump --all-databases > backup.sql
as is explained on http://www.mysql.com/doc/m/y/mysqldump.html
The response is : ./mysqldump: unrecognized option `--all-dat
On Mon, Feb 19, 2001 at 11:39:07AM -0800, John Jensen wrote:
> I have an existing mysql database I am trying to back up before
> upgrading to 3.23 from 3.22. Both the mysqldump and mysqladmin
> commands tell me I am accessing as the wrong user when I execute from
> the bash prompt, even as root
Okay, so I got it using the mysql root password as an option, but I
find not evidence of a backup or sql file being created, unless I add
a pipe and redirection instructions to the command. The mysqldump
command is either putting the dump in a location I don't know about
(and can't seem to fin
You can also use mysql and query "show databases" as in this sample script I
transcript:
DBS=`mysql -e "show databases"`
for db in $DBS ;
do
if [ "$db" != "Database" ] ; then # skip the title "Database"
included in the output of command DBS.
mysql -e "show tables from $db"
I have an existing mysql database I am trying to back up before
upgrading to 3.23 from 3.22. Both the mysqldump and mysqladmin
commands tell me I am accessing as the wrong user when I execute from
the bash prompt, even as root. From the mysql prompt, these commands
are not recognized at all. I
On Mon, Feb 19, 2001 at 04:34:05AM -0700, Ming Hsu wrote:
> Hi, I've been working with mysql for a couple of months now for my
> website. Now I have to move to a different server, and would like to move
> the database as well. Problem is I have no idea what this entails and how
> to do it. Can s
Anyone have any personal experiences with installing mysql on a ppc
machine running os x pb? if so, and you've got a bit to talk about
it, I've got some pretty pointed questions so far as my difficulties
getting it working...
much thanks.
John
-
Does anyone know the syntax for deleting records based on a join?
This is what i do in Sybase ASE:
delete table1 from table1,table2 where table1.somecol=table2.somecol and
table2.somecol2=somevalue and table1.somecol4=someothervalue
Anyone got a clue?
Thanks!
regards Oystein Selbekk, Visbook
In the first query, mysqld could get all the information it
needed from table a from the index file.
In the second query, it needed to read the data file to get all
the columns, and determined that using an index would not gain
any speed. From the 3 reow returned, I woul guess that you
don't hav
Hi,
For such small tables, does it matter.
MySQL will optimise queries the best way it thinks it can. In this case, in
the first query, only the index file for student_info3 will be used, so
that might have a bearing.
In the second query, where all columns from the student table are requested
w
Hello Heikki,
Monday, February 19, 2001, 5:24:10 PM, you wrote:
HT> Peter,
HT> I guess you mean the source tree at www.bitkeeper.com? The interface
HT> file ha_innobase.cc can be found there, but not yet the Innobase
HT> source, I think. Then it cannot yet be compiled from the source tree,
HT>
>>I work for a web hosting company that has mysql 3.22.23 on one
>>of our servers. The server is Free BSD unix version 3.5. It seems every
>>few weeks it pops up with this
>>error.
>>
>>System Error: DBI->connect(WWWThreads:localhost) failed: Can't
>>create a new thread (errno 35). If you are no
I have a table with a date field, and would like to sort it
on month and day. What I would like to do is:
SELECT lastname,firstname,dob FROM table1 GROUP BY month(dob),day(dob)
(where dob is a column of type 'date')
but that doesn't work. I'm using MySQL 3.22.32. I saw one post about
calc
Hi
Tru64 Compile errors.
Running V4.x Tru64 gcc 2.95.2 gnumake 3.x attempting build of
mysql 3.23.32 or 3.23.33
Getting error
sql_string.cc: In Method 'bool string::(double,unsigned int=2)' :
sql_string.cc:181 Implicit declaration of function 'in
Hi, I've been working with mysql for a couple of months now for my
website. Now I have to move to a different server, and would like to move
the database as well. Problem is I have no idea what this entails and how
to do it. Can someone help me? Thanks.
Ming Hsu
-
If you are using PHP there is the htmlspecialchars() function that will do just that
for you.
cheers,
thalis
> > - Original Message -
> > From: "Robert Heron" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Saturday, February 17, 2001 6:35 PM
> > Subject: special characters in
No Body answered my previous mail.
plz help me.
I have three tables.
i) student_info3
i) grade_ex3
i) test_info
and, There are those Index
In student_info3 table : index(student_no)
In grade_ex3 table : index(student_no, test_no)
In test_info table : index(test_no)
When I use t
>Date: Mon, 19 Feb 2001 10:57:35 -0800
>To: [EMAIL PROTECTED], [EMAIL PROTECTED]
>From: Max Harper <[EMAIL PROTECTED]>
>Subject: error 35
>Bcc: [EMAIL PROTECTED]
>
>I work for a web hosting company that has mysql 3.22.23 on one
>of our servers. The server is Free BSD unix version 3.5. It seems ev
Hello all,
I'm trying to use MysqlTool 0.90 and am getting the following error when I
pull up the web interface:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
Only thing is, /var/lib/mysql/mysql.sock does exist and I'm able to connec
to the database jus
Hello,
I'm trying to compile and link MySql with a CORBA (ORBacus) client and I
get the following error message:
Undefined first referenced
symbol in file
__muldi3
/opt/mysql-3.23.32-sol8/lib/mysql/libmysqlclient.so
__
What is the command you are using to change password?
- Original Message -
From: "Zen Woo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 22:16
Subject: mysqladmin
> Hi,
>
> mysqladmin: unable to change password; error: 'You are using MySQL as an
> anonymous
Hi everybody,
First excuse me about my bad English
I have a weird (at least weird for me) problem trying to connect to mysql
server v 3.23...
When I try to connect from some sites, I got an ERROR 1045: Access denied
for user: 'user@host' (Using password: YES)
I'm sure the privilege tables are ri
Hi,
Can anyone please explain the following?
I do two select count(*)'s from a big table, (21,000,000 + rows & 6.5 Gb).
All columns in the where are indexed. The first select is very quick, the
second very slow.
The ONLY difference is the value of one column variable (queue_id), which is
an IN
Hi. I'll be more precise: I'm trying to compile MySQL 3.23.32
it under Amiga, with EGCS 2.91.66 using some kind of UNIX emulation.
I've already ported other programs like Lynx, Yacas, MUD/IRC clients...
I've found that F_TO_EOF is defined as 0L in mysql/include/my_global.h,
but
Check the manual.
"Type" is a reserved word.
"Date" is a reserved word.
Martin wrote:
>
> The following CREATE TABLE came from a mysqldump. When I use the same create
> statement to create the table under mysql 3.23 I get an error:
>
> # MySQL dump 8.12
> #
> # Host: localhostDatabase: inst
Thanks, Pal,
I tried that and got an error, which led my down the road to using TO_DAYS()
etc...
Will try again, and post the error if it reoccurs.
Best,
Nick
Pal Wester wrote:
> Actually, there should be a function which does the oposite
> of the DATE_FORMAT function, ie. converting a string to
> Could you provide us with the error messages you are getting?!?!
My apologies. The problem appears to have been the copying of unexpected
characters into the SQL. I generated the SQL for the tables and put it into
a file. Apparently when I copy and paste the SQL, some hidden characters are
bein
You may also want to check CPAN for Spreadsheet::ParseExcel. I haven't dug
into it too deep yet, but it looks like it can parse native .xsl data.
Brian
-Original Message-
From: Ken Menzel [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 19, 2001 11:08 AM
To: Joe Ferrara; [EMAIL PROTECT
Actually, there should be a function which does the oposite
of the DATE_FORMAT function, ie. converting a string to date.
but as long as you use mysql notation on dates, you can write
...WHERE myDateField > '2001-02-14';
As I'm in norway and wriote norwegian applications I usually get dates
on t
Check out webfx.eae.net for a sample on how to do this.
It does require IE4+ or Mozilla.
Chris
On Mon, 19 Feb 2001, Tim Ward wrote:
> Date: Mon, 19 Feb 2001 13:47:00 -
> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>,
> [EMAIL PROTECTED], [EMAIL PROTECTED],
> [EMAIL PROTECTE
> We have a ton of data in MS Excel that I need to put into a Solaris
> based MySQL dB. The data needs input such that it correlates across
> several different tables (i.e. I can't just do table dumps). What
is
> the most efficient way to do this?
>
> Thanks,
>
> Valerie
Hi Valerie, My opinio
>How-To-Repeat:
On two or more client machines
Note this will not happen using 'virtual clients', i.e. one machine running
mucltiple threads
Open Connection
Turn AutoCommit off
> db.setAutoCommit(false);
loop through 10,000 queries, commiting aft
Hello everybody,
About two hours ago I had a system crash and one of my MySQL databases was
extensively used at the same time. When the system went back up, the table (the
table has 37000 rows) that was used at the time of the crash started to give me
the error
: Got error: 1030: Got error 127 fr
Hi again!
There were several questions on the mailing list, which I try
to answer:
- The MySQL manual says that you can convert between different table
types using ALTER TABLE, the same should hold for the Innobase table type,
though I must admit I have not yet tested it. ALTER TABLE is a high-l
Now I have a java application which connect to MS Access, I want to use MySQL
instead, how can I transfer all the tables and data into MySQL? should I use MyODBC
to replace JDBC-ODBC driver?
Thank you for any help!
Forest
-
B
Tim Ward schrieb:
>
> the complication in your case is that some of the js (building the arrays
> and the table) needs to be built by the php. I've never tried this but it
> should work if you just echo it as you would html.
yes - php can write out an external .js what is loaded by JavaScript
--
Gerald L. Clark writes:
> I also rebuilt 3.23.33 today for SCO Openserver 5.0.4 and RedHat Linux
> 6.2.
> Show Databases works just fine here.
>
Thanks !
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
I also rebuilt 3.23.33 today for SCO Openserver 5.0.4 and RedHat Linux
6.2.
Show Databases works just fine here.
Sinisa Milivojevic wrote:
>
> HI!
>
> In response to several mail messages on mailing list that were
> centered around some misbehaviour of SHOW DATABASES / TABLES, I have
> tested t
> "Atle" == Atle Veka <[EMAIL PROTECTED]> writes:
Atle> You say you go to runlevel 5 at boot? In that case, you need
Atle> to put the S99mysql into the rc5.d/ directory..
That worked.
Thanks,
John Hunter
-
Before
Hi! My name is Bruno and I'm speaking from Brazil.
I'm having ome problems with MyODBC and Crystal Reports.
I have a Mysql data base and can access this data base using PHP and
Microsoft Access (using myodbc for MS access).
But when i wanna access myodbc with crystal reports, the Crystal ask me
1 - 100 of 130 matches
Mail list logo
