Bonjour,
mysql Ver 11.15 Distrib 3.23.47, for sun-solaris2.8 (sparc)
It crashed after more than a month with no problem and here are the logs :
020225 11:04:48 mysqld started
020225 11:04:50 InnoDB: Started
/usr/local/mysql/libexec/mysqld: ready for connections
020226 12:01:05 failed
Hello Wout,
Appareantly it's impossible to insert a string, consisting entirely
out of
spaces, in a textual field (I've tried varchar(19) and char(2) types,
they
both don't work). MySQL doesn't complain about it, but it trims the
strings
down to the empty string. If I try a select searching
Hello Sherwin,
Thanks for ur prompt reply.
Yes, I have gone thru the mySQL manual chapter that
you have mentioned..
But what I think the problem is somewhere else..
when I try to execute the command 'mysql' (when I log
in as user 'babul') on command line, I get the
following error:
ERROR
Hi,
How to take part in a mail list for Redhat and FreeBSD such as this one.
Thanks, Dominic
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi everybody!
I have found following 'bug' in type TIMESTAMP:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1279 to server version: 3.23.48-Max-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql
Create a table with
Hello, list!
I'm not quite sure that this is the right place to ask, but
I'm having problems getting MySQL and ColdFusion Server 5 to
work together.
I have a ColdFusion server that connects to MySQL via ODBC.
I've configured the Merant MySQL ODBC driver via the ColdFusion
administrator, and
* Ceferino Ortega
mysql UPDATE prueba SET fecha2= '20020313101000' WHERE id=1;
mysql select * from prueba;
++++
| id | fecha1 | fecha2 |
++++
| 1 | 20020313101501 | 20020313101000 |
Hi!
rafe == rafe [EMAIL PROTECTED] writes:
Description:
rafe I am not subscribe to this list so please cc me in your reply.
rafe I created a ~5GB table full of large (TINY|BIG)TEXT fields in it. This is a
fresh build and there has been no activity except for the following:
rafe 1)
* Douglas Nusbaum
Referencing your tutorial I created a text file to use with
LOAD DATA LOCAL INFILE ../data/pet.txt INTO TABLE pet;
I have tried every possible combination that I could think of of , \t
\\t \, \T etc
as delimiters in the data strings such as
I want to use the MySQL default binaries (i used to build them
in my own machine, but i have followed this list and you're
always saying to use the default ones).
My question is: is there a way of using the default binaries
and have Table type=RAID support ?
Thanks in advance.
--
dsoares
On Wed, 2002-03-13 at 01:48, Abi wrote:
Hi,
I have this following error when back up table :
mysql lock tables mytable read;
Query OK, 0 rows affected (0.02 sec)
mysql select * into outfile
'/home/myhome/dump/mytable.txt' from mytable;
ERROR 1: Can't create/write to file
In article [EMAIL PROTECTED],
Simon Green wrote:
I am just installing a new MySQL server at the moment.
We are using PHPMyAdmin witch is ok as we can limit what each user can do,
but
some tables do not work with it.
We have 2.1.0 at the moment.
Do I
1. Just go for the latest
On Wed, 2002-03-13 at 08:08, b g wrote:
when I m in root or mysql USER login.. then I can
login to mySQL server.. its fine..
but other than 'root' and 'mysql', i can not connect
to the database server..
With which user are you trying to connect ?
Did you grant permissions to that user ?
Be
Dear all,
Will MySQL supports composite primary key constraint? If so what
is the actual syntax? How foreign key relationship can be
established in MySQL? Please help me.
Prasad.
-
Before posting, please check:
Hi.
I've installed mysql-3.23.49a rpm packages from www.mysql.com on a Pentium
RedHat 7.2 machine.
When I try to install MySQL-bench-3.23.49a-1.i386.rpm package it depends in
MySQL-DBI-perl-bin package.
I failed to find MySQL-DBI-perl-bin package in www.mysql.com, where is it?
and what version
Two things to check:
1. Ensure the mysql server is running. mysql.sock is automatically created when the
server is started.
2. If you still get the error, it may be in another subdirectory, usually
var/lib/mysql. Once you locate mysql.sock,
modify the my.cnf file to point to the correct
Does anybody know the evolution of MySQL. I understand it evolved from
mSQL, but the company is unwilling to discuss this history.
I write a computer encyclopedia and am trying to trace back the product.
Can anyone help?
Is there some major secret going on here some CIA mission. Or has
Hi,
I have an application I have
developed in java using tomcat
as a webserver and mySQL as a DB.
Is it possible to distribute
this package on a CD?
To do this I need to put tomcat,
my application, JRE and mySQL on
the CD.
Anybody tryed this before to use
mySQL without installing it first
or
shaj,
Tuesday, March 12, 2002, 3:12:18 PM, you wrote:
s Can any one tell me what is the text limitation for mySQL??
What do you mean text limitation?
You can read about blob and text column types at:
http://www.mysql.com/doc/B/L/BLOB.html
Read also about storage requirements at:
Hi,
I'd like to know how I can do the following:
I want to query a single table like this:
select field1, field2, field3 from table1 where field1='something' and
field2=0;
This query will result in more then one match. It's not possible for me to
use a more specific query.
From the result
I've read in the read-me that dbf2mysql doesn't handle memo files. Does this
mean that it won't work for any tables that include memo fields?
Neil
-
Before posting, please check:
http://www.mysql.com/manual.php (the
On Tue, 12 Mar 2002, shaj wrote:
Can any one tell me what is the text limitation for mySQL??
TEXT datatype is limited to a maximum length of 65535 (2^16 - 1)
characters.
LONGTEXT allows up to 4'294'967'295 (2^32 - 1) characters, which is enuf
for most applications. The real limitation is
nagendra,
Wednesday, March 13, 2002, 8:04:58 AM, you wrote:
np hi ,i got this error 3 -4 times ,then i reinstalled
np mysql the it used to work properly.
np Once i come baack to office the next day run the page
np again,it gives the same error again.
np the error is
np
Tomasz,
InnoDB in 3.23 and 4.0 is the same codebase. InnoDB versions are best
counted from the 3.23 series, because they appear more frequently. I am
sorry that this is confusing.
MySQL/InnoDB-3.23.50 has not been released yet. It will probably be out at
the end of March.
From section 16 of
Hi!
You should add a new data file as explained in section 5 of
http://www.innodb.com/ibman.html.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
Speed up adding of features to MySQL/InnoDB through support contracts
See
sql,query
I cant get the server to starts more than one thread. I have installed
the server from the port collections and im running freebsd 4.5 stable
Regards leo de geer
-
Before posting, please check:
Specialized SQL structs do not yet work with VC++.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/
Ken Menzel writes:
Hi everyone,
If you have increased your MAXDSIZ variable in FreeBSD to above
2048 the mysqld will crash on FreeBSD 4.5. Please set it to 2047 or
lower:
options MAXDSIZ=(2047*1024*1024)
to quote a very intelligent source (Thanks Sinisa!)
It happens with
Hi!
On Mar 13, Thomas Spahni wrote:
On Tue, 12 Mar 2002, shaj wrote:
Can any one tell me what is the text limitation for mySQL??
TEXT datatype is limited to a maximum length of 65535 (2^16 - 1)
characters.
LONGTEXT allows up to 4'294'967'295 (2^32 - 1) characters, which is enuf
DIVIDE ET EMPERA
Hi,
OK you wish to discuss about CONCEPTUAL point of view.
You said: Partitioning data and Parallelism.
We begin to talk about this principle, but i feel, something is missing
here.Ohhh...yeaaa... is calling DISTRIBUTION DATA.And if we talk about how
or what
I think I read somewhere about this issue. I think it had to do with
multiple mySQL servers running concurrently.
See if there is multiple servers running using the ps command. If so,
then kill one of them. Also, when adding a user, do you select a
database first before adding a user?
Is it possible to support both single and double-byte characters in the same
database?
We have offices all over the world -- and want to share information, but in
some cases, there will be japanese and possibly hebrew text in the
database - in addition to English, Dutch,
french, and Spanish.
Is
Aman,
Wednesday, March 13, 2002, 2:32:29 AM, you wrote:
AR I re-installed MySql from RH Linux 7.2 cd and now I am getting the following
AR [root@coolnis-ar mysql]# Starting mysqld daemon with databases from
AR /var/lib/mysql
AR 020312 18:29:52 mysqld ended
AR [1]+ Done
David,
Friday, March 08, 2002, 11:03:30 PM, you wrote:
DMP I just tried something and would a second opinion:
DMP I re-configured my MySQL server on my RH Linux machine using the following :
DMP CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS ./configure
DMP and ran the following SQL:
DMP CREATE TABLE
Hi,
I have two tables:
languages:
id tinyint(3) unsigned not null,
language varchar(30) not null
language_pairs:
from tinyint(3) unsigned not null,
to tinyint(3) unsigned not null
language_pairs.from and language_pairs.to are linked with
Hi,
I would like to use transactional sql tables that support columns with NULL
values. I think that only BDB and InnoDB tables types support transactions,
but I have read that:
Only the MyISAM table type supports indexes on columns that can have NULL
values. In other cases you must
SELECT f.language as From, t.language as To
FROM language f, language t, language_pairs lp
WHERE f.id = lp.from
AND t.id = lp.to;
--Greg Johnson
-Original Message-
From: Andreas Frøsting [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 10:13 AM
To: [EMAIL PROTECTED]
Subject:
Is that what you want?
SELECT languages.language, languages.fieldN, .., language_pairs.fieldX
FROM language_pairs INNER JOIN
Languages ON languages.id=language_pairs.id WHERE /* conditions */
-Original Message-
From: Andreas Frøsting [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March
Hi Greg,
SELECT f.language as From, t.language as To
FROM language f, language t, language_pairs lp
WHERE f.id = lp.from
AND t.id = lp.to;
I really need to get some sleep I think.
So simple, and yet my buggy mind didn't come up with that solution.
Thanks,
//andreas
(sql, query - just to
Hi,
I've been migrating an MS Access database from Access to use a MySQL
linked-table backend. Most problems have been fixed by the advice on the
MyODBC FAQ and other resources but I am having trouble with a sub form
to which I cannot find an answer...
The database is a customers/stock/orders
Hi all,
I'm sorry my English.
I 'm install mysql 3.23-49 en Linux and I have the next problem during to
instalation:
I execute : make
creating libmysqlclient.la
(cd .libs rm -f libmysqlclient.la ln -s ../libmysqlclient.la
libmysqlclient.la)
make[2]: Leaving directory
Hi,
We are having a serious problem with a simple replication setup using
MySQL. One small database with 12 tables is being replicated one way -
one master, one slave. Write transaction load is small, about 1 record
per second, usually on only one of the tables. Read load is also light.
The
David,
a Solaris version of InnoDB Hot Backup is planned, as well as a FreeBSD
version.
Currently I am working with beta testers trying to get the Large file
support on Linux to work :).
Regards,
Heikki Tuuri
Innobase Oy
-Original Message-
From: David Felio [EMAIL PROTECTED]
Hi!
Where did you read that? That text should be updated!
At least InnoDB supports indexes on columns which can have a NULL value.
Regards,
Heikki Tuuri
Innobase Oy
-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Date: Wednesday, March
You could probably save yourself some trouble by installing binaries.
But what version of Linux? And what version of gcc? There are many
problems associated with using gcc 3.x that I won't get into here. But
it helps to pass along these details.
On Wed, 2002-03-13 at 11:04, Roberto C. Salazar
Description:
shr.o not found in libz.a when running mysql-install_db
How-To-Repeat:
Output from mysql_install_db:
root@cedar:/work/work/mysql/mysql-max-3.23.46-ibm-aix4.3.3.0-rs6000
scripts/mysql_install_db
exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of
I work with Linux Cobalt (like to RedHat)
My gcc version is gcc-2.7.2
RCS
- Original Message -
From: Jim Philips
To: Roberto C. Salazar M.
Cc: [EMAIL PROTECTED]
Sent: Wednesday, March 13, 2002 11:18 AM
Subject: Re: Problem in instalation
You could probably save yourself some trouble
I am not at all familiar with Cobalt. But your gcc version is pretty
old. Everything compiles without error on my RedHat 7.2 system with gcc
2.96. Or, you might want to consider the binary...since upgrading gcc
might not solve the problem.
On Wed, 2002-03-13 at 11:20, Roberto C. Salazar M.
I believe I needed to upgrade at least to version 3.23.42. There was a
bug fix where certain record lengths killed the REPAIR (See D.2.9). So I
tried an upgrade problem is gone... whether or not my diagnosis was
correct.
I want to thank all that replied for your dead-on help. Also I have to
say
On Wed, Mar 13, 2002 at 07:05:40AM -0500, Alan Freedman wrote:
Does anybody know the evolution of MySQL. I understand it evolved
from mSQL, but the company is unwilling to discuss this history.
It did not evolve from mSQL. It copied the mSQL API, but the code
itself evolved from Unireg.
Can anyone give me an example of how to run mysqlhotcopy from the command
line? What can I expect as the output and where is the file created/ stored?
Thanks
Mark
-Original Message-
From: Michael Grassman [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tuesday, March 12,
[EMAIL PROTECTED] writes:
Description:
shr.o not found in libz.a when running mysql-install_db
How-To-Repeat:
Output from mysql_install_db:
root@cedar:/work/work/mysql/mysql-max-3.23.46-ibm-aix4.3.3.0-rs6000
scripts/mysql_install_db
exec(): 0509-036 Cannot load program
From: Al Johnson [EMAIL PROTECTED]
We are having a serious problem with a simple replication setup using
MySQL. One small database with 12 tables is being replicated one way -
one master, one slave. Write transaction load is small, about 1 record
per second, usually on only one of the
Hi,
Try to start mySQL daemon like service in init 3.
Good luck,
Gelu
- Original Message -
From: Aman Raheja [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 13, 2002 12:00 AM
Subject: Re: installation problem
This is what's going on
[root@coolnis-ar mysql]#
Hi,
I need your opinion about optimizing this query...
I would really appreciate your help on this:
The following table saves data about views to certain object identified
by (cod-campanha,cod_tema,cod_canal,tipocanal,localizacao,seccao) from
users. Each tuple
Hi all,
I'm trying to delete records with this query on php program:
delete from Bands where ID_ALBUM IN (select ID_ALBUM from Albums where
ID_GROUP = '$group')
I use it on MSSQL and work fine but on mysql don't work, there's some other
query that make the same result on mysql
Thank's all
MySQL does not currently support sub-selects.
The manual says:
DELETE [LOW_PRIORITY | QUICK] FROM table_name
[WHERE where_definition]
[ORDER BY ...]
[LIMIT rows]
Did you review the manual first?
-Original Message-
From: Riccardi Moreno [mailto:[EMAIL PROTECTED]]
Sent:
Yes i review manual many times without success
-Messaggio originale-
Da: Rick Emery [mailto:[EMAIL PROTECTED]]
Inviato: mercoledì 13 marzo 2002 16.52
A: 'Riccardi Moreno'; Php List; Mysql List
Oggetto: RE: [PHP-DB] Delete problem
MySQL does not currently support sub-selects.
The
Hi all,
Posted this yesterday and got no response. Trying again today.
I'm having a small problem with a biggish query.
The query:
$Itemlistquery= select [a whole load of fields from 3 tables] ending with
;
$Itemlistquery.= transactions.Pdownload ;
$Itemlistquery.= from
Hi,
If you expect only 1 result you can try:
select (@myvar:=ID_ALBUM) from Bands where ID_GROUP='$group';
delete from Bands where ID_ALBUM=@myvar;
Good luck,
Gelu
- Original Message -
From: Riccardi Moreno [EMAIL PROTECTED]
To: Php List [EMAIL PROTECTED]; Mysql List [EMAIL PROTECTED]
Hello all.
I downloaded the mysql v4.0.1 source and openssl 0.9.6c source.
I built openssl OK
I built mysql as follows:
./configure --with-vio --with-openssl
make
make install
The build went well all the way.
The mysql server seem to start ok. When I try to connect with mysql
client after a few
i'm moving MySQL over to unix and i can't for the life of me get anything to
work.
i just want to use MySQL from my directory. no root users or anything like
that. i just want to noodle around with the db as a 'local' user.
so i installed the binaries, created my symbolic link, configured the
Try the following:
mysqlhotcopy -u root -p password dbname /path/to/copy/the/data/to
so, if you want to copy the db foobar, you do the following:
mysqlhotcopy -u root -p password foobar /backup/data
and a new dir will be created called /backup/data/foobar
with all the tables there
-dan
On
Try the following:
mysqlhotcopy -u root -p password dbname /path/to/copy/the/data/to
so, if you want to copy the db foobar, you do the following:
mysqlhotcopy -u root -p password foobar /backup/data
and a new dir will be created called /backup/data/foobar
with all the tables there
-dan
On
I'm very much interested to know how do you manage multiple language support with
mySQL.
I haven't found how i can define different character sets for different tables or
even for separate databases.
Do i have to run several mySQL servers, one per each charset?
Maybe, it is the solution for
I want to create a database test_db1, if test_db1 does not exist in the
server using sql script. Is it possible?
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Hello friends,
I am having a problem using the MySQL JDBC driver from an applet. In my
local machine's browser and on very few remote machine's browsers the
applet works correctly, however in most remote machine's browsers it
cannot find a suitable driver.
What is wrong with my Java code? Or my
At 01:02 AM 3/13/2002, you wrote:
Greetings!!!
I would just like to know if the following is normal:
I created a file TRANSACTION_LOG.sql to create an InnoDB table with MULTIPLE
KEYs with one AUTO COLUMN.
The file consists of the following SQL commands:
drop table TRANSACTION_LOG;
create
Hi !!
-Original Message-
From: Markus Lervik [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 1:22 AM
To: [EMAIL PROTECTED]
Subject: A bit OT: ColdFusion can't connect to MySQL via ODBC (newbie)
Hello, list!
I'm not quite sure that this is the right place to
Victoria,
Monday, March 11, 2002, 11:24:00 AM, you wrote:
RT I am just wondering if the latest stable build of MySQL has support
RT for Unicode character set so I can use it to store english, chinese and
RT korean characters. If so please let me know. And also if there is going
RT to be any
nagendra,
Wednesday, March 13, 2002, 1:06:18 PM, you wrote:
np Dear all,
np Will MySQL supports composite primary key constraint? If so what
np is the actual syntax?
Yes, MySQL supports composite primary key.
CREATE TABLE table1(
id1 int NOT NULL,
id2 int NOT NULL,
PRIMARY KEY(id1, id2));
You
Riccardi,
Wednesday, March 13, 2002, 5:48:28 PM, you wrote:
RM Hi all,
RM I'm trying to delete records with this query on php program:
RM delete from Bands where ID_ALBUM IN (select ID_ALBUM from Albums where
RM ID_GROUP = '$group')
RM I use it on MSSQL and work fine but on mysql don't work,
Alex,
Wednesday, March 13, 2002, 7:16:02 PM, you wrote:
AK I'm very much interested to know how do you manage multiple language support with
AK mySQL.
AK I haven't found how i can define different character sets for different tables or
AK even for separate databases.
AK Do i have to run
Alan,
Wednesday, March 13, 2002, 2:05:40 PM, you wrote:
AF Does anybody know the evolution of MySQL. I understand it evolved from
AF mSQL, but the company is unwilling to discuss this history.
AF I write a computer encyclopedia and am trying to trace back the product.
AF Can anyone help?
You
If I understand your question, you just need to join with the languages
table twice, using aliases:
select LF.language, LT.language
from language_pairs P, languages LF, languages LT
where LF.id = P.from and LT.id = P.to;
From: =?iso-8859-1?Q?Andreas_Fr=F8sting?= [EMAIL PROTECTED]
To:
On Wed, Mar 13, 2002 at 09:40:44AM -0800, Radhakrishna Mohan Tadepalli wrote:
I want to create a database test_db1, if test_db1 does not exist in the
server using sql script. Is it possible?
From http://mysql.com/doc/C/R/CREATE_DATABASE.html
6.5.1 CREATE DATABASE Syntax
CREATE DATABASE
Haven't done a great deal of this but it does work pretty well. Obviously
connection speed is a bit of an issue especially where you are dealing with
INSERTS into several linked tables from a form.
I couldn't find an equivalent field in MySQL for the Yes/No type in Access
so it you create an a
ensure that /tmp has correct read-write-execute permissions
-Original Message-
From: Hresko, Christian A. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 10:57 AM
To: '[EMAIL PROTECTED]'
Subject: starting mysql
i'm moving MySQL over to unix and i can't for the life of me get
Hi all -- I just need a quick sanity check on a query.
I have two tables:
CREATE TABLE users (
userID VARCHAR(10) NOT NULL PRIMARY KEY,
[many other fields]
)
CREATE TABLE subscriptions (
userID VARCHAR(10) NOT NULL,
listID INT NOT NULL
)
In these tables, users.userID ==
I tried to run mysql.server start on mysql that I just installed.
OS I use is SCO Open Server Rel 5.00
The error I received is
[EMAIL PROTECTED] [/usr/local/mysql]:mysql.server start
./support-files/mysql.server: @HOSTNAME@: not found
[EMAIL PROTECTED] [/usr/local/mysql]:Starting mysqld
Hello,
I am attempting to add the ROOT user as a MYSQL administrator using the
following syntax:
mysqladmin -u root password 12345
and I recieve the following error:
mysqladmin: connect to server at 'localhost' failed error: 'Access denied
for user: 'root@localhost' (Using password: YES)'
Heya,
I've managed to repeatably crash mysqlgui by running a query that
returns a column of type year. Though it dumps core, gdb does not
provide a useful stack trace. Though this is not a serious bug, it is a
bit of an annoyance.
- Alex Vandiver
--
Networking -- only one letter away from
Thanks Dan -
Quick question -
I have a db named content with user admin and pass mypass Do I still
use -u root p maypass ? or would I use
mysqlhotcopy -u admin -p mypass content /path/to/copy/the/data/to
Thanks again for your help.
Mark
-Original Message-
From: Dan Patnaude [EMAIL
Is it possible to issue 1 select that gathers data from databases on 2
separate servers?
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
sql, query
-
Before posting, please check:
Sorry, please excuse this post. I found the problem. A single space in front of
the account number.
Thanks
Richard D. Williams
[EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
At 13:26 2002-03-13, Victoria Reznichenko wrote:
Alex,
Wednesday, March 13, 2002, 7:16:02 PM, you wrote:
AK I'm very much interested to know how do you manage multiple language
support with
AK mySQL.
AK I haven't found how i can define different character sets for
different tables or
AK even
On Wed, 13 Mar 2002, Mohamad Waluyo wrote:
I tried to run mysql.server start on mysql that I just installed.
OS I use is SCO Open Server Rel 5.00
The error I received is
[EMAIL PROTECTED] [/usr/local/mysql]:mysql.server start
./support-files/mysql.server: @HOSTNAME@: not found
[EMAIL
At 08:13 2002-03-13, Heikki Tuuri wrote:
Tomasz,
InnoDB in 3.23 and 4.0 is the same codebase. InnoDB versions are best
counted from the 3.23 series, because they appear more frequently. I am
sorry that this is confusing.
MySQL/InnoDB-3.23.50 has not been released yet. It will probably be out at
Nope; two databases on the same server OK, but not different
servers.
Ken
- Original Message -
From: Cal Evans [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 13, 2002 4:00 PM
Subject: Selecting across servers
Is it possible to issue 1 select that gathers data from
Does anyone know if the MyODBC binary for Solaris 2.7 will work ok on 2.8,
or will I need to
compile from source?
For anyone who's interested, we're in the process now of migrating from
Access/ColdFusion/NT
to MySQL/ColdFusion/Solaris in our web development environment.
As far as software to
Tomasz writes:
From section 16 of http://www.innodb.com/ibman.html you find detailed
information about every InnoDB version. For example, 4.0.1 == 3.23.47.
Foreign keys should work in 4.0.1.
Hmmm... That's what I read, too. And after several unsuccesful
attempts
to create my own tables,
Hi,
I am a beginner developer trying to use mySQL ODBC with ADO. I am using ADO
library version 2.5, and Visual Basic 5.0/6.0 (doesn't really matter).
Here is my configuration:
- mySQL ODBC Version 02.50.38
- mySQL server Version 02.50.38
- Windows NT 4.0 with SP6
It seems like, mySQL does
Get your VB Manuals out, or test your programme against an Access Data Base.
Once you have issed an Update statement, you need to either retrieve the record
for further update or set all the fields then issue the Update statement!
This is very 'Off Topic
Clive Smart
Kelvin Lam wrote:
Hi,
I
I'm trying time a export process but I cant figure out what the right sql
statement.
I tried using getdate() but it gives me an error.
Any Ideas???
Kathy Reyes
Live Technology International
2975 Westchester Avenue
Suite 103
Purchase, NY 10577
Tel: (914) 490-7096
[EMAIL PROTECTED]
From your point of view it's off-topic (and it is), but from his the
problem could be anything, including MySQL. You did, however, produce
the proper answer, since this is an ADO issue, and I further provide a
link to the relevant Knowledge Base article:
* Kathy Reyes
I'm trying time a export process but I cant figure out what the right sql
statement.
I tried using getdate() but it gives me an error.
getdate() is not a valid mysql function, try NOW() or CURTIME().
URL: http://www.mysql.com/doc/D/a/Date_and_time_functions.html
--
Roger
Hi Kathy,
Are you trying to get current time in mysql ?? If yes, you can do it by
issuing:
SELECT NOW();
statement...
Gurhan
-Original Message-
From: Kathy Reyes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 5:17 PM
To: [EMAIL PROTECTED]
Subject: How do I get the time?
Hi everyone,
I've got a really annoying problem with mysql, and I was hoping someone
could help.
I've got 2 tables in Mysql:
Table 1 - Topics
| topic_id | name | subject | comment |
-
| 1 | john | weather| the
Description:
SELECT fullTextMatches.realname, fullTextMatches.address,
fullTextMatches.address2, fullTextMatches.city,
fullTextMatches.state,
fullTextMatches.zip, fullTextMatches.country,
fullTextMatches.email,
fullTextMatches.homephone, fullTextMatches.workphone,
How do you do it from different databases on the same server?
David Buerer
Senior Designer
PLA Designs, Inc.
-Original Message-
From: Ken Menzel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 1:21 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Selecting across
1 - 100 of 132 matches
Mail list logo