Hi,
I finally after 2 weeks battle with asp.net - mysql - myodbc got a
connection.
my only problem now is that I got the connection because I downloaded
microsofts ODBC.NET component and I'm using the Microsoft.Data.Odbc
namespace.
but I can't find any
Yes and no
If you are taking info from a live database you would have it in a steady
state to copy it. This means locking the tables.
But once you have a copy of the table all you would need to do is update the
changes from the logs.
Using replication for this I is the most simple way but
Hi Allon,
Only one query can be sent to server at a time. But your particular case
can be handled with the single query
Insert Into orders (Number) select Max(Number) FROM Orders;
Anvar.
At 04:45 PM 19/03/2002 -0800, you wrote:
Hi All-
We are using the mm driver for MySQL and multiple
Hi,
I my mysql server database directory (that is the directory that holds the
.err and .pid files) so strange files have apeared. They look line
machine-name-bin.001
machine-name-bin.002
etc
machine-name-bin.index
Some of them are huge! They seem like binary files, but are full
Have a look for binary log files in the manual these are binary log files,
needed for replication setup eg.
Lars
mysql mailing list user wrote:
Hi,
I my mysql server database directory (that is the directory that holds the
.err and .pid files) so strange files have apeared. They look line
Hi,
Is there a way to speed up inserts on a table with three fulltext
indexes? I'm using the multiple value insert format like:
insert into blah (field1, field2) values ('val1', 'val2'), ('val2',
'val3'), etc..
Perhaps this is a bug in the current mysql4 bk snapshot, but inserts and
selects on
i believe you've the replication option turned on.
see http://www.mysql.com/doc/R/e/Replication_Options.html for more
details.
mysql mailing list user wrote:
Hi,
I my mysql server database directory (that is the directory that holds the
.err and .pid files) so strange files have apeared.
sql,Mysql
Hi Allon,
Sorry. It wont work. I didn't notice that you were inserting to the
same table as the select.
Anvar.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Am Mittwoch, 20. März 2002 11:24 schrieben Sie:
I just installed mysql fresh out of the box on a fresh SuSE linux 7.1.
mysql does not let me enter german umlauts, though. I tried to start it
with mysql --default-character-set=latin_de, but it complained about
the character sets not being
Hello,
s possible to create table with default value returned by built-in
function ??
like:
create table x (a int not null default UNIX_TIMESTAMP());
When inserting new column in table field a will contains timestamp?
sql,query
Regards,
Michal Dvoracek [EMAIL
I just took a look at all of that, especially the jar file.
It contains another jar file! (with the mm.mysql driver classes)
maybe it appears that some runtimes don't get this working !?!
it worked fine on my system :
browsers netscape 6 (winnt4 and linux) and opera 5 (winnt4).
Andreas
*
Hi,
I have a text file , with several MySQL instructions (CREATE TABLE, INSERT,
SET @var, etc.).
I want to execute all these instructions from a C program , using the API.
It is possible to use the function mysql_query(), to execute all the
instructions contained in the file in a single call
Hi,
Lonnie Wormley wrote:
Is this the correct file to have in your class path?
addpath /home/launi/JBuilder6/lib/mm.mysql-2.0.11/mm.mysql-2.0.11-bin.jar
Yes, please add it into jdk.config. :)
--
TAKAHASHI,"KEN",Tomohiro
Borland -- Enabling a new digital world where our customers have
I run mysql on a SuSe 7.3 and a FreeBSD 4.5 server.
The FreeBSD mysql version is 3.23.49.
The linux mysql version is 3.23.33.
I just copied a large table using mysqldump | mysql from the linux server to
the FreeBSD server.
An explain statement on a select on this table shows different row
Jeremy
You can set it up so that the slave only gets updates to certain
databases. Have you looked at the replication docs in the manual yet?
Yes I did, but what put me off slightly was the concept of a master
and slave. My requirement is per sql database not per sql server.
Am I being stoopid
Hi All,
I am getting following error msg when I try to install
MySQL using rpm -i My*
error: MySQL-3.23.49a-1.i386.rpm cannot be installed
error: failed dependencies:
data-showtable is needed by
Msql-Mysql-DBI-perl-bin-1.1823-1
DBI-perl-bin is needed by
How would I list all users via the command line?
sql,query
--
Mike Yrabedra
President
323 Enterprises
Home of The MacDock and The MacSurfshop
[http://macdock.com] : [http://macsurfshop.com]
VOICE: 770.382.1195
___
in all
Young Sul wrote:
Hi,
I've got a website that uses a mysql backend database. Due to the way in
which
the database and development has been architected, I'm unable to
load-balance
the database between multiple DB servers, taking advantage of replication
inherent
in mysql. (this is due
Hi,
reading the table-dump with MyISAM takes about 30 seconds.
With InnoDB it ran 3 hours before I killed it.
I removed the Unique-key definitions and it took 22 seconds with InnoDB.
Now I'm creating one unique key and it's running more than 20 hours already.
Perhaps someone with a
Hi Rob
Read the manual, you can do exactly what you need to and it is explained in
the manual. I am doing it myself.
Regards
Warren
You can set it up so that the slave only gets updates to certain
databases. Have you looked at the replication docs in the manual yet?
Yes I did, but what
Sounds as though you haven't got Perl installed, or more particularly the
DBI modules for MySql. If you on Linux, almost certainly to be found on your
Linux CDs.
HM
Suresh R. Soni writes:
Hi All,
I am getting following error msg when I try to install
MySQL using rpm -i My*
Try:
mysql -e SELECT user FROM mysql.user
You may need to add the following as well
mysql -h hostname -uyouruserid -pyourpassword -e SELECT user FROM
mysql.user
-Original Message-
From: Mike Yrabedra [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 6:55 AM
To: [EMAIL
On Tue, 19 Mar 2002, Young Sul wrote:
Hi,
I've got a website that uses a mysql backend database. Due to the way in
which
the database and development has been architected, I'm unable to
load-balance
the database between multiple DB servers, taking advantage of replication
inherent
in
mysql mailing list user wrote:
Hi,
I my mysql server database directory (that is the directory that holds
the
.err and .pid files) so strange files have apeared. They look line
machine-name-bin.001
machine-name-bin.002
etc
machine-name-bin.index
Some of them are huge! They seem
Hi, I am using Redhat 6.2 kernel 2.2.20 and am getting
this error below. I know that these paths are
incorrect , should be /jive/usr/biosym/235 instead
of /usr/biosym... where do I change this? Which file?
Sorry if this is obvious, but I am new to mysql.
Thanks,
Amrita
unknown user id:
Thi Cao writes:
All,
I can't seem to perform an update on my database with MySQL++. The
execution of the query always throws an exception. Here's a snippet of what
I did.
Query query(conn);
query update employee set children = 3 where id = 9;
query.execute();
The above code
Michal Dvoracek wrote:
Hello,
s possible to create table with default value returned by built-in
function ??
like:
No.
create table x (a int not null default UNIX_TIMESTAMP());
What is wrong with the timestamp field type?
When inserting new column in table field a will contains
Joel,
I have read the manual related to windows several times. But the problem
that I was not having is not mentioned in the manual.
I am not too sure if I am the one who needs root canal like someone earlier
claimed. Or the manual needs one. I dont think the manual is helpful for
beginners.
From: Michal Dvoracek [EMAIL PROTECTED]
s possible to create table with default value returned by built-in
function ??
like:
create table x (a int not null default UNIX_TIMESTAMP());
When inserting new column in table field a will contains timestamp?
In general, this cannot be done.
See section 4.3.1 Grant and Revoke syntax and 4.3.8 Using
secure connections. There is a very good version of the docs in
frame format at http://www.bitbybit.dk/mysqlfaq . I highly
recommend it.
-Original Message-
From: Chris Hanes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19,
multiple commands Not as far as I know, you need to open your file, read
the commands and process them one at a time.
The C API is not magic and has no more capability than you do setting down
and typing in the commands yourself.
What you can do is build one HUGE insert command from lots of
At 11:35 + 3/20/02, Javier wrote:
Hi,
I have a text file , with several MySQL instructions (CREATE TABLE, INSERT,
SET @var, etc.).
I want to execute all these instructions from a C program , using the API.
It is possible to use the function mysql_query(), to execute all the
instructions
Regarding your issue with accents, I understand more now about your
problem, you are using shell tools in free BSD and you have not set
the LANG shell environment variable. Add the folling line to your
shell environments (usually .profile).
LANG=en_US.ISO_8859-1; export LANG
or for german
Hi Again Sasha,
You will find that explain is not always accurate. It makes
guesses about the date based on statistics stored with the table
files. It does not actually run the query, however if you dumped the
table and reimported the table table on Linux you would probably get
the same
Hi Guys,
I would like to request an additional feature with EXPLAIN.
EXPLAIN does not run the query guesses on how the query would be run.
This is not always accurate. The slow-log however logs the actual
information the query was run with (like explain only the truth!).
Could we have an
Hello,
I hope someone here can help me out with this. I can't find anything in the
documentation that does help. Everything points to the port being in use,
however it isn't. I know it for a fact (netstat/telnet), no the mysqld also
is not running, I know that for a fact (process list).
I
On 19 Mar 2002, at 18:14, Michael Halcrow wrote:
Any suggestions as to where to start?
There's a Perl module called SQL::Statement that does SQL parsing:
http://search.cpan.org/search?dist=SQL-Statement
--
Keith C. Ivey [EMAIL PROTECTED]
Washington, DC
Hi,
Application uses Jboss server with mysql backend.
IMDB tables (Heap tables) are created by the app. Things work on fine.
Suddenly we miss Heap tables. We are not able to reproduce this at any
particular event.
It happens randomly. We could not make out the reason for this.
We set
I've tried everything thats in this email and nothing seems to work for me.
I think my situation is a little different because I had access to my
database originally but now I cant connect I can sign on as kreyes but I
cant sign on as root. I can even sign in as ODBC. I dont know what to do. I
Can someone look at this at see what I am doing wrong:
The following SQL returns to records:
50
333
select SC_USER_ID as parmSecurename from CP_USER_COMMENT where SC_ID =
107793;
If I include it in the following loop the result is
50
333
333
CREATE OR REPLACE Procedure SP_USER_COMMENT_2
as
Hi Liyju,
Before answering your note, I need to explain about the using the syntax for
mysql -u user -p.
If I use the format above for mysql -u root -p,
I can press ENTER after typing mysql -u root -p
and wait for the password inquiry. I dont need to enter the password (I dont
have one,
thank you very much
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 8:25 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: URGENT: Update Error with MySQL++
Thi Cao writes:
All,
I can't seem to perform an update on my
- Original Message -
From: Chuck Roberts [EMAIL PROTECTED]
To: alan4100 [EMAIL PROTECTED]
Sent: Wednesday, March 20, 2002 9:36 AM
Subject: RE: mysql -u root DENIED
-Original Message-
From: alan4100 [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 11:50 AM
To:
Hi.. my name is Marco Leiva and i have just downloaded your software...
i want to connect Mysql to Visual Basic, I downloaded the ODBC drivers but
the following error message keeps on popping:
An error Occurred while copying c:\windows\system\mfc30.dll restart windows
and try installing again
I'm setting up some tracking stats for (opt-in) e-mail campaigns, and
one of the things I'm tracking is click-thrus. I'm going to re-direct
traffic thru a script that will just count the number of clicks, and
store that number in a mysql table.
It needs to be fast and efficient, and I'm
Anis,
My problem has been solved without configurating my.cnf.
It looks like I dont need it at all because WINADMINSQL has created its own
my.ini file.
You may find my email to others about the fix. I still dont know what the
problem is. But it appears to be fixed ; fine and okay now. After
At 01:17 AM 3/20/2002, you wrote:
An Oracle DB programmer reviewed a query that I wrote and told me that
putting constants at the beginning of the query would make it slower. I
thought I'd go to the experts on MySQL and be told the truth one way of
the other.
Example query:
SELECT
Ken Menzel writes:
Hi Guys,
I would like to request an additional feature with EXPLAIN.
EXPLAIN does not run the query guesses on how the query would be run.
This is not always accurate. The slow-log however logs the actual
information the query was run with (like explain only the
Hi,
I'd like to setup two database servers in a dual master/slave config. So
both machines will be each others master and slave.
Only one server will be queried (selects, inserts/updates and deletes). In
case of failure of one master a network switch will handle failover. The
failed machine
Odd, I think it does a very good job of helping troubleshoot:
http://www.mysql.com/doc/A/c/Access_denied.html
On Wed, 20 Mar 2002 09:30:48 -0500, alan4100 wrote:
And does not explain at all when mysql -u root -p does not work.
Can a file be inserted to a mysql table from a unix(linux) command prompt?
Also, can I query the same table and output the data to a filename.ext in a
specified directory?
Not sure if this is an appropriate question for the list, but all
clues/examples would be greatly appreciated.
I have:
mysql Ver 11.12 Distrib 3.23.32, for redhat-linux-gnu (i386)
and wonder about the log file /var/log/mysqld.log
shouldn't that include failed connections??
mvh: Pål Wester
høgskoleingenør/programmerer
never.no as, stortingsgt 30, 0161 Oslo
direkte: 22 01 66 34, 906 900 62
tlf: 22 01 66
Kathy,
Sounds like mine, but it is fixed. I still dont know what the fix was. May
I ask you how you signed in as Kreyes? Did you add username and password
yourself?
Since you are denied access to mysql (default) database, it surely sounded
like mine. Before I may give you some help, may
I
Hello all
I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at that
computer now, so that could be wrong slighly) install pkg
I have installed it, and I can get it to run with the --skip-grant-tables
option.
When I try to run safe_mysqld without the skip option I get the
Let us know your results ...
Adib.
Keith C. Ivey wrote:
On 19 Mar 2002, at 18:14, Michael Halcrow wrote:
Any suggestions as to where to start?
There's a Perl module called SQL::Statement that does SQL parsing:
http://search.cpan.org/search?dist=SQL-Statement
Thanks Anvar-
But I guess you didn't really follow this thread. We started with the
statement you are suggesting because we are porting from another datasource.
As it turns out, you cannot do a Insert ... Select from the same table in
MySQL.
It's supported in other databases, so I was
I've tried everything thats in this email and nothing seems to work for me.
I think my situation is a little different because I had access to my
database originally but now I cant connect I can sign on as kreyes but I
cant sign on as root. I can even sign in as ODBC. I dont know what to do. I
Hi All
Could someone explain to me why an index in a select I am doing is only
sometimes used.
The select I do is a complex one with multiple tables, and when it uses the
index it takes 1.5 seconds, but when it dosnt it takes 1 min and 25-50
seconds.
I have simplified it down and founed the
Hi,
I am loading table A from values in table B with an insert . . . select
statement.
I also need to populate a x-ref table with the new insert ids from the
insert . . . select.
I know in Oracle I would put a trigger in to do the x-ref insert after
each row of the insert. . .select is
At 10:15 -0500 3/20/02, Ramaraju.R.V wrote:
Hi,
Application uses Jboss server with mysql backend.
IMDB tables (Heap tables) are created by the app. Things work on fine.
Suddenly we miss Heap tables. We are not able to reproduce this at any
particular event.
Is someone restarting the server?
Hello,
Does anybody know how MySQL works with MS Access especially when it comes
to preventing concurrent updates from more than two users? I use InnoDB
tables and link them through ODBC driver to MS Access for viewing and
updates. Will there be any issues if two or more people have this type of
Andreas,
I gained some experience putting 15'000 documents into TEXT columns and
indexing them. It's not quite 15gigs, but your amount of data will be
reduced when you go from *.doc to pure ASCII. My table size is:
-rw-rw1 mysqldaemon 187621564 Jan 8 20:02 plaintext.MYD
Kathy,
This is 2nd copy because I forgot to cc to [EMAIL PROTECTED] myself.
Try to cc to [EMAIL PROTECTED] . There are others who want to read it.
But you said earlier about emails that did not do much of help. I was lucky.
Perhaps you have to wait for your turn.
First, I feel I am not ready to
I have a table with over 60,000 records, I have a text field that is a
full text index. I need to change it to medium text. My question is can
it do it without taking the site offline. will the table still be able
to serve select queries while the alter is running or will they be locked until
Hi,
In my mysql .err file I get a lot of the following error...
Aborted connection 121031 to db: ..connection details... (Got an error
reading communication packets)
What does this mean, and is it bad, and what do I do about it?
Any help appreciated.
Howard
Hi,
You can just do an UPDATE:
UPDATE $table set total_clicked = total_clicked+1
Regards
rory oconnor wrote :
I'm setting up some tracking stats for (opt-in) e-mail campaigns, and
one of the things I'm tracking is click-thrus. I'm going to re-direct
traffic thru a script that will just
From: rory oconnor [EMAIL PROTECTED]
I'm setting up some tracking stats for (opt-in) e-mail campaigns, and
one of the things I'm tracking is click-thrus. I'm going to re-direct
traffic thru a script that will just count the number of clicks, and
store that number in a mysql table.
It
I have had very much success with passing sql commands via ado over the
myodbc layer. I wouldn't trust addnew and update batch methods nor have I
tested how or if they work, it's better to keep your connections to the
database stateless for performance purposes. Meaning to execute dml
At 10:48 -0500 3/20/02, Stembridge, Michael wrote:
Can a file be inserted to a mysql table from a unix(linux) command prompt?
mysqlimport?
Also, can I query the same table and output the data to a filename.ext in a
specified directory?
SELECT ... INTO OUTFILE
Not sure if this is an
I need to do a search where I am looking at the table that has dates and I
need to look only things that are 30 days or younger.
Can so one show me a some SQL statements where you use , ? And the key
for equal to or less?
Chuck Payne
Magi Design
I thought I was sending my email to the [EMAIL PROTECTED] but I guess I
wasnt.
Thank you so much for your help Alan,
I cant figure out how I have lost access to 'mysql' (default) database. When
I attempt to use mysql on my Linux machine I get the error message ERROR
1045: Access denied for
Does anyone know of any good PL SQL Oracle Lists?
thank you in advance
Lance
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Hi, can any one suggest where I can get latest MySQL rpms for redhat 6.2
with glibc 2.1x... the new rpms .49+ are all for glibc 2.2+
_
Send and receive Hotmail on your mobile device: http://mobile.msn.com
$dbh =
DBI-connect(DBI:mysql:database=$database;host=$host,$user,$mysqlpassword,{'RaiseError'=1});
$update_number = UPDATE $table set total_clicked = total_clicked + 1;
$sth = $dbh-prepare($update_number);
if (!$sth) { die Error: . $dbh-errstr . \n; }
if (!$sth-execute) { die Error: .
On Tuesday 19 March 2002 11:35, you wrote:
Hi all,
I too new to php and mysql, trying to get things works. I installed Redhat
7.2, Apache, mysql and php. I copied a sample php script from the internet
and save it as phptest.php in my cgi-bin. When calling it from my browser,
I got Format
Hi,
I am trying to get the following to work but it returns invalid values.
SQLINTEGER size;
SQLExecDirect (hstmt, Select 8, SQL_NTS);
SQLBindCol(hstmt,1, SQL_C_ULONG, size,0,NULL);
I tried various datatypes for size but I always get some invalid value. Is
the above correct or do I need to
At 16:31 + 3/20/02, Steve Gardner wrote:
Hi All
Could someone explain to me why an index in a select I am doing is only
sometimes used.
The select I do is a complex one with multiple tables, and when it uses the
index it takes 1.5 seconds, but when it dosnt it takes 1 min and 25-50
seconds.
You can avoid the step of extracting the row data by doing:
UPDATE mytable SET numclicks = numclicks + 1
-Kevin
-Original Message-
From: rory oconnor [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 8:44 AM
To: [EMAIL PROTECTED]
Subject: fast,efficient query for counting
I'm
Does mysql own the mysql database directory, and all its files?
You should have run it as
mysql_install_db --user=mysql
Rance Hall wrote:
Hello all
I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at
that computer now, so that could be wrong slighly) install pkg
I have
On Wed, 20 Mar 2002, Steve Gardner wrote:
Hi All
Could someone explain to me why an index in a select I am doing is only
sometimes used.
mysql explain select * from mailstat where domain_id in(2);
+--+--+---+--+-+--+-+---
-+
|
If more than a third of the rows would be selected, it is faster not to
use the index.
Over 2 million records match the '2'.
How many are there total?
Steve Gardner wrote:
Hi All
Could someone explain to me why an index in a select I am doing is only
sometimes used.
The select I do is a
Yeah,
I've abandoned the nice neat insert . . . select.
Instead I am selecting the table B dataset, inserting each row into
table A, capturing the insert id, populating the x-ref, and going on to
the next row. Twice as much code, but it works.
Andrew Hazen
-Original Message-
From: Paul
MySQL Error: 1049 (Unknown database 'databasename')
I having a very weird unpredictable problem. I have a webserver which
makes database connections via Perl and DBI. For the most part it works
pretty much all the time but sometimes (2 or 4 times per month) it gives
an error: Unknown database
Thank you very much for the hint. The problem occurs on SuSE linux, though,
not on FreeBSD, and lang=de_DE.
Following your hint, I set
LANG=de_DE.ISO_8859-1
The problem still remains. Then I set
LANG=de
since there is a directory
/usr/share/locale/de
on the system, but
Ibrahim,
Wednesday, March 20, 2002, 9:52:25 AM, you wrote:
IKC I want to knowledge about blob.
IKC how can write or read blob to/from MYSQL database by using Visual C++.
IKC Can any body help me.
You can look at example in MySQL++ (C++ API for MySQL) documentation:
Ron,
Wednesday, March 20, 2002, 2:30:56 AM, you wrote:
RS I'm installing MySQLto a Corel /Debian platform, following
RS directions in the book Beginning PHP4. Successfully
RS did ./configure, make, make install, and mysql_install_db
RS as described on page 387. The book says I'll now need to
colin,
Tuesday, March 19, 2002, 11:04:31 PM, you wrote:
co When i try to access the database which is on my Linux
co machine i get the following error:
co ERROR 2002; Can't connect to local MySQL server
co through socket '/tmp/mysql.sock' (111)
co There is nothing in this file, although i dont
Shon,
Tuesday, March 19, 2002, 7:48:30 PM, you wrote:
SS i am running mysql version 3.22.32. yes i am planning an upgrade. in the
SS meantime, i need to check (and possibly) repair my tables without bringing
SS down the mysql daemon.
For version 3.22.32 you can use only isamchk/myisamchk for
Mike,
Wednesday, March 20, 2002, 2:55:18 PM, you wrote:
MY How would I list all users via the command line?
If you mean users in mysql privilege tables you can use the following command:
mysql -e 'SELECT user FROM mysql.user'
If you mean active user that use database you can get list of active
Steve,
Wednesday, March 20, 2002, 6:31:09 PM, you wrote:
SG Could someone explain to me why an index in a select I am doing is only
SG sometimes used.
SG The select I do is a complex one with multiple tables, and when it uses the
SG index it takes 1.5 seconds, but when it dosnt it takes 1 min
Does anyone know of any good PL SQL Oracle Lists?
thank you in advance
Lance
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
On Wed, Mar 20, 2002 at 04:48:11PM +0100, Danny Kruitbosch wrote:
Hi,
I'd like to setup two database servers in a dual master/slave
config. So both machines will be each others master and slave. Only
one server will be queried (selects, inserts/updates and
deletes). In case of failure of
Hi, I'm trying to sort out an inconsistency where adding an index changes
the results of a query. Seems like this is incorrect.
I'm running 3.23.36-debug, under NT. I have yet to try this on other
versions...
The following may be a bug, but it's at least inconsistent.
I wonder if this is
I do this from the command line sometimes:
mysql -h HOST -pPASSWORD DATABASE statements.sql
The statements.sql file should contain full sql statements. This will
read in the file and execute the sql 1 line at a time.
The opposite would be to use mysqldump like so:
mysqldump -h HOST
Oracle-L has a number of PL/SQL gurus on it. Good list.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Lance Prais [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 12:42 PM
To: [EMAIL PROTECTED]
Subject: Important question
Does anyone know of any good PL SQL
On Wednesday, 20. March 2002 18:31, Chuck PUP Payne wrote:
Hi!
I need to do a search where I am looking at the table that has dates and I
need to look only things that are 30 days or younger.
Can so one show me a some SQL statements where you use , ? And the key
for equal to or less?
I'm trying to make a connection from a java app to a MySQL database I've
created on my local PC. How can I tell the app where to look for the
existing database?
Code I'm working with:
Class.forName(sun.jdbc.odbc.JdbcOdbcDriver).newInstance();
Connection con =
Hi,
The problem was due to permissions in the end, i used
the following commands to get into the database:
shell chown -R root .
shell chown -R root ./bin
shell bin/safe_mysqld --user=root
bin/mysqladmin version
.
.
bin/mysql
I can now use the database, but it still doesn't
explain why i
select * from accounts where duedate=convert(float,getdate())
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 20, 2002 12:31 PM
Subject: Date and SQL statement
I need to do a search where I am looking at the table that has
On Tue, Mar 19, 2002 at 02:08:17PM +0530, Charitha wrote:
Hello all,
Can i use rsync instead of replicating two servers for mysql(
particular database db). If yes Then just clear off my doubt
whether it will lead to any data loss as while doing rsync.
If the data on the master is in a
1 - 100 of 154 matches
Mail list logo