Hi,
Why MySQL does not support PL/SQL, Views, Functions, Procedures,
Sub queries. Will that be added in forthcoming MySQL version.
If it above mentioned features are added will the database becomes
slow.
Pls. give me some information on this issue.
Thanks in Advance.
HEMANTH
--
MySQL G
Hi there,
Can any body tell me the various reasons why the MySQL replication
stops?
Thanks in Advance.
Regards,
HEMANTH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>Description:
I have upgraded from 3.23.5x versions to 4.0.12 on Linux Redhat
operating system. On 3 machines I only upgraded the RPMs and
everything worked. On only Linux Redhat 7.3 server RPM upgrade
also worked fine. The problem is that mysql server report no
Hi All,
Say I have a table with an auto_increment field that is being used at the primary key.
When I insert a new record, is there any way to easily grab the primary key value for
that new record? I had another unique field that I was originally going to use to do
a select statement; but n
I know its possible to use multiple fields for the primary key in a table
i.e. "primary key(foo,bar)"
Is it possible to do this with "unique" identifiers as well? Like "unique
key(foo,bar)" ??
I already have a primary key on a table, but I'd also like to force two fields to form
a unique comb
Quick rundown.
Table:
Assignments
CaseID auto_increment
FileNumber char(18)
FirstName char(20)
LastName char(20)
and on and on and on
Indexes on
CaseID (Primary)
FileNumber
Name (LastName, FirstName)
What I would like to do is something alo
# [EMAIL PROTECTED] / 2003-03-31 07:38:44 -0500:
> Uttam wrote:
>
> >u can use highly customizabe MySQL DATE_FORMAT() function for retrieving
> >date in desired format.
> >
> Thanks for the detailed information.
>
> >For manipulating date in php, u can use the MySQL UNIX_TIMESTAMP(date)
> >funct
Thanks to C. Reeve and Michael Shulman for their answers. However, if
the things that are documented worked, then I might not be complaining.
I tried some of the stuff you suggested, and eventually managed to
solidly lock myself out of mysql, with no further access to anything!
Arghh!
Note that m
Has anyone had any luck with the ODBC 2.5 drivers?
-Original Message-
From: Venu [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 11:45 AM
To: Wynne Crisman
Cc: MySQL-List
Subject: RE: Crystal Reports and MySQL
On Mon, 2003-03-31 at 07:57, Wynne Crisman wrote:
Hi !!
> I too have
> No but those in need of help does. And those ppl who are capable of
helping
> them are usually busy. Do they keep a browser open and refresh the forum
> frequently? I'll answer that question: no.
Many forums packages have the ability to distribute the discussion as a
mailing list as well (Yahoo!
3306 or you can specify it in my.cnf which should be located in /etc
(*NIX OSs)
or @ the command line
-Original Message-
From: daniel [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 3:25 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: What port to forward ?
i'd also lik
Miguel Here are the contents of my localhost.err:
InnoDB: Error: log file .\ib_logfile1 is of different size 0 0 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
030331 18:16:45 Can't init databases
030331 18:16:45 Aborting
030331 18:16:45 InnoDB: Warning: shutting down a not pro
At 18:18 31/03/2003 -0700, Martin Gainty wrote:
Miguel Here are the contents of my localhost.err:
InnoDB: Error: log file .\ib_logfile1 is of different size 0 0 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
030331 18:16:45 Can't init databases
030331 18:16:45 Aborting
030331 18:
What would also help is English. Would you translate the messages for
us?
-Original Message-
From: trashMan [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 3:19 PM
To: 'Scott Helms'; [EMAIL PROTECTED]
Subject: R: R: Replication don't work.
Sigh.
Master.err
030401 1:14:42
At 16:49 31/03/2003 -0700, Martin Gainty wrote:
Sorry to hike the thread but I have a specific question
What causes "System Error 1067" when starting mysql in Windows
Does anyone know?
The MySQL server has aborted for some reason that should be
find on \mysql\data\hostname.err or mysql.err.
also yo
>Description:
I configured mysql to check for the subject and issuer of a clients
cert. It seems that mysql can check the issuer of a cert but does not
verify if the cert was really signed by a CA that is known to the
server. I could generate a second client cert fr
Hello,
from the InnoDB documentation
"To be able to recover your InnoDB database to the present from the
binary backup described above, you have to run your MySQL database with
the general logging and log archiving of MySQL switched on. Here by the
general logging we mean the logging mechanism
i'd also like to know this as i've tried to access the local db which is the
the lan server aswell , i have a firewall iptable script running on it and i
cant seem to connect using mysqlcc
>= Original Message From <[EMAIL PROTECTED]> =
>Well,
>I have a firewall on my LAN, but need to have
On Mon, Mar 31, 2003 at 11:37:47AM -0800, Seth Brundle wrote:
> First people, please dont get all angry about my suggestion...please hear me
> out...
>
> > I really hate on-line forums. They're difficult to track because I
> > must remember visit them daily.
>
> OK this is the first issue - 95%
The binlog and the pos are the same in master and slave !
Webserver-bin.008 pos 73
Ehmm...i don't know how to save on file the output of show master/slave
status
-Messaggio originale-
Da: Jennifer Goodie [mailto:[EMAIL PROTECTED]
Inviato: martedì 1 aprile 2003 0.11
A: trashMan; [EMAIL
If they are at the same position everything should be fine. What makes you
think replication is not working? How are you determining that there has
been no change in data? How are you determining that something was done on
the master that the slave should have replicated?
-Original Message-
Just my two cents
> -Original Message-
> From: Seth Brundle [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2003 3:29 PM
> To: David Brodbeck; [EMAIL PROTECTED]
> Subject: Re: Could we make this a web discussion forum?
>
>
> > > I really hate on-line forums. They're difficult to track
Sorry that this is not a MySQL question per se, but
I've tried the "SQL" forums and haven't received a
reply. Hopefully someone on this list can see what
I'm trying to do and provide an answer, taking maybe a
minute of their time. It would mean a lot to me.
Question:
How can I get two child tab
Sigh.
Master.err
030401 1:14:42 MySql: Forzata la chiusura del thread 13 utente:
'titti'
030401 1:14:42 MySql: Forzata la chiusura del thread 12 utente: 'ODBC'
030401 1:14:42 MySql: Forzata la chiusura del thread 11 utente:
'geofor'
030401 1:14:42 MySql: Forzata la chiusura del threa
OK. Everything was up and running thanks to what Lenz suggested
earlier. I was even able to connect to the server using JDBC from the
local machine.
But then the Java connection, for no apparent reason, stopped working.
Java apps would just stall without ever connecting, but I could still
conn
> Most ppl don't like forums.
I disagee with that, but then again I probably dont have any more idea then
you do.
> Do you know even one serious project which uses
> a forum? I know Slackware did and it really was a PAIN.
All of the projects on SourceForge.net?
Also, by forum I also mean usenet
Situation: I have an app created in Forte. Its does some DB IO and dumps
the results to a web page. Works great in the IDE. I export it to .war
file and put it in my tomcat install. Now I get the following errormsg
when I try to run it:
java.sql.SQLException: Can not issue data manipulation statem
Massi,
You will get much better results if you provide the following:
Copies of:
my.cnf file from both master and slave
(look in $MYSQL/data or /etc)
$HOSTNAME.err logs from master and slave
master.info file from slave
(look in $MYSQL/data directory)
and check that one does not exist o
Sorry to hike the thread but I have a specific question
What causes "System Error 1067" when starting mysql in Windows
Does anyone know?
Martin
- Original Message -
From: "Seth Brundle" <[EMAIL PROTECTED]>
To: "David Brodbeck" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March 31
forward Port 3306 to mysqlserver daemon
the ports are illustrated in the my.conf file
-Martin
- Original Message -
From: "Darryl Hoar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 3:49 PM
Subject: What port to forward ?
> Well,
> I have a firewall on my LAN,
The show master status is saying
I'm On the bin log file 8 at position 73 (right after the header of the
bin log)
Some helpful checks
Make sure in your data dir (for this example /var/lib/mysql)
Hostname.index contains all the binlogs especially the one that the
slave is pointing to. Execute sho
> It's much more convenient than a web forum, and much
> faster too, because I don't have to wait for some remote, overloaded
server
> to respond.
This makes no sense as message I post to a Yahoo! Group get emailed to
opt-in members and appears on the group within seconds, while I may not
receive
> > I really hate on-line forums. They're difficult to track because I
> > must remember visit them daily.
>
> Agreed. I don't need yet another web page to keep track of. I prefer to
> let my mail reader thread up the messages on this list, then I browse
> through every now and then and delete e
This is probably a topic that has been beaten to
death, but I need help in finding a resource for
getting postfix to support mysql on RedHat 8.0. I'm
not a serious RedHat admin, so I'm looking more for an
rpm of a prebuilt mysql-ready postfix for RedHat, but
if I can find a set of (fairly explicit
At 11:57 -0800 3/31/03, Michael Shulman wrote:
The first time I run winmysqladmin, it creates a my.ini file for me in the
windows directory. It prompts for a username and password, recommended for
first time users, it says.
What does the "user=" and "password=" fields in the my.ini file do? They
Well,
I have a firewall on my LAN, but need to have access to the database
server from the wild internet. What ports do I need to forward ?
thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
What position and in what binlog does your slave show it is at? It might be
helpful if you post the entire output of show slave status (minus user and
host if you are concerned about that for some reason).
-Original Message-
From: trashMan [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31
On Mon, Mar 31, 2003 at 06:00:12PM +0100, Ben Edwards wrote:
> Anyone know why the two ISPs I use (www.pair.com, www.oneandone.co.uk) are
> still using V3 and don't have any timescales for upgrading?
I should point out that if you're looking for an ISP that can support
MySQL 4.0.xx, let me know o
The error.log on the master dont' report anything...
MySql: ready for connections
Other info
>Show master status;
***
Headeranswer note
***
File webserver-bin.008
Position 73
The first time I run winmysqladmin, it creates a my.ini file for me in the
windows directory. It prompts for a username and password, recommended for
first time users, it says.
What does the "user=" and "password=" fields in the my.ini file do? They
don't seem related to the "mysql" command lin
> I really hate on-line forums. They're difficult to track because I
> must remember visit them daily.
OK this is the first issue - 95% of people who need MySQL info do not need
it daily. Mailing lists are a poor tool for them.
No but those in need of help does. And those ppl who are capable of h
MySQL List,
MySQL was working fine until today. I hadn't used it for a
month or so but now, I try to restart the MySQL Daemon and I get this
error:
030331 12:32:27 mysqld started
/usr/local/mysql/mysql-3.23.55-max/bin/mysqld: Too many parameters
/usr/local/mysql/mysql-3.23.55-max/bin/mys
Massi,
How about looking in the data directory, on the master. There will be
a file called hostname.err the contents will probably lead you to the
answer or least give some more data for the list to look at ;p
Scott Helms
On Mon, 2003-03-31 at 16:29, trashMan wrote:
> There are two wee
It the master actually writting to the binlog? What does the master say
when you run SHOW MASTER STATUS? Is the size of the binlog growing?
-Original Message-
From: trashMan [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 1:29 PM
To: [EMAIL PROTECTED]
Subject: Replication don't wo
There are two weeks i try it...but...the replication don't start!!
I've follow the istruction
http://www.mysql.com/doc/en/Replication_HOWTO.html without success.
In the slave i have:
>Show slave status;
***
Headeranswer note
**
On 31-Mar-2003 Mike William wrote:
> Hi Don,
>
> Thanks for the suggestions. Here's what happened.
>
> > Your pconnects are probably sleeping too long.
>> in /etc/my.cnf:
>>
>>[mysqld]
>> set-variable = wait_timeout=10
>
> I tried this, and it was a mixed bag. On the one hand, the "Can't
In the last episode (Mar 31), Seth Brundle said:
> First people, please dont get all angry about my suggestion...please
> hear me out...
>
> > I really hate on-line forums. They're difficult to track because I
> > must remember visit them daily.
>
> OK this is the first issue - 95% of people who
Sorry everybody. I assumed that as it had been out for a long time (2
years?) it was stable. I should of chequed.
Ben
At 14:32 31/03/2003 -0500, Scott Helms wrote:
Ben,
I certainly can't speak for those organizations, but from our
point of
view MySQL v 4.x has just been declared stab
Yes, if someone has something to complain about, make a website and
point the others to it. This topic of dicussion - improving the state of
things - has been recurrent in every mailing lists for ages, and it
stops only when somebody DOES something about it ;-)
Very nice argumentation by Seth Brun
Jeremy Zawodny wrote:
On Mon, Mar 31, 2003 at 06:00:12PM +0100, Ben Edwards wrote:
Anyone know why the two ISPs I use (www.pair.com, www.oneandone.co.uk) are
still using V3 and don't have any timescales for upgrading?
No idea. Ask them, maybe?
This is probably a "don't fix what's not
Hi,
I would like to add my 2 cents worth.
First, I like having a mailing list. I do not post very frequently but I do like to
scan the posts of others. It is a great way to learn little tricks and tips about
MySQL.
Second, I don't see why you can't have both a mailing list and an on-line forum
> -Original Message-
> From: Seth Brundle [mailto:[EMAIL PROTECTED]
> H...seems like some Yahoo! employee has never used
> Yahoo! Groups ;)
I know a lot of people who refuse to use Yahoo Groups because of Yahoo's
very open and ever-changing privacy policy.
Most of the other comb
On 31 Mar 2003 at 16:39, Dyego Souza do Carmo wrote:
> this is a bug... because i modify the database escribaupdate from
> database mysql and this is not logged...
Yes, it is a bug, but you can work around it by using replicate-wild-
do-table. See the documentation for the replicate-do-db option
You may consider it a bug, but it is the documented behavior.
Dyego Souza do Carmo wrote:
I'm using MySQL/InnoDB 4.0.12
I set replication to replicate only database escribaupdate...
The bug is:
I connect in database escribaupdate and run:
delete from escriba_autorizacao;
go to shell and execut
Ben, this is really a question you have to pose to them.
Many "professional" ISPs won't just automatically upgrade to the newest
version of X before taking the time to create a full test environment to run
through any and all circumstances that they think they might come across.
Also, a new versi
I'm using MySQL/InnoDB 4.0.12
I set replication to replicate only database escribaupdate...
The bug is:
I connect in database escribaupdate and run:
delete from escriba_autorizacao;
go to shell and execute:
scribthree:/database/log-bin# /usr/local/mysql4/bin/mysqlbinlog logbin.001
# at 4
#03
First people, please dont get all angry about my suggestion...please hear me
out...
> I really hate on-line forums. They're difficult to track because I
> must remember visit them daily.
OK this is the first issue - 95% of people who need MySQL info do not need
it daily. Mailing lists are a poor
Do you happen to know how to change the charset?
I have read thru the manual, but I have no clue where to start.
Thanks in advance
-Dan
- Original Message -
From: "Keith C. Ivey" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Cc: "Dan Tran" <[EMAIL PROTECTED]>; "Matt Gostick"
Ben,
I certainly can't speak for those organizations, but from our
point of
view MySQL v 4.x has just been declared stable. This means that its now
time for us to run it internally for a few weeks and see if its going to
cause any new problems over the existing 3.2.x series AND test the
u
On Mon, Mar 31, 2003 at 06:00:12PM +0100, Ben Edwards wrote:
> Anyone know why the two ISPs I use (www.pair.com, www.oneandone.co.uk) are
> still using V3 and don't have any timescales for upgrading?
No idea. Ask them, maybe?
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine,
Charles Hauser wrote:
All,
I am having difficulty loading data into a DB using a perl script.Linux
RH8 box.
DB creation:
mysql -uroot -p -e 'create database yeast'
mysql -uroot -p -e 'grant all privileges on yeast.* to [EMAIL PROTECTED]'
mysql -uroot -p -e 'grant all privileges on yeast
On 31 Mar 2003 at 9:49, Dan Tran wrote:
> I wont work for me, I dont have access to SQL layer.
You can declare your columns as VARCHAR BINARY rather than VARCHAR in
your table creation. Another possibility might be to set your
character set for the database to latin1csas rather than the defaul
All,
I am having difficulty loading data into a DB using a perl script.Linux
RH8 box.
DB creation:
mysql -uroot -p -e 'create database yeast'
mysql -uroot -p -e 'grant all privileges on yeast.* to [EMAIL PROTECTED]'
mysql -uroot -p -e 'grant all privileges on yeast.* to [EMAIL PROTECTED]'
Apparently V4 douse, its been out for over a year but for some reason ISP
don't use it.
ben
At 10:29 31/03/2003 -0800, Adam Randall wrote:
Well, as far as I know, your SOL =) MySQL does not support settings for
full text indexing as of yet, so the only way that I know how to do it is
to modif
I have successfully used Erwin 4.1 to connect to and model MySQl databases. Read
the Erwin tutorial. You need to create an ODBC connection first.
David
sql, query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL P
Anyone know why the two ISPs I use (www.pair.com, www.oneandone.co.uk) are
still using V3 and don't have any timescales for upgrading?
Ben
* Ben Edwards +44 (0)117 968 2602 *
* Critical Site Builder
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
> I really hate on-line forums. They're difficult to track because I
> must remember visit them daily.
Agreed. I don't need yet another web page to keep track of. I prefer to
let my mail reader thread up the messag
If you added a timestamp column when you created the table then it's
easy... the timestamp column is updated automagically when an update or
insert is done.
create table tablename (id int, timestamp timestamp);
select timestamp from tablename where id = 123;
If you didn't use a timestamp column,
Hi,
Is there a way in mysql to get the
record's last updated date?
Thanks,
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Don,
Thanks for the suggestions. Here's what happened.
> Your pconnects are probably sleeping too long.
in /etc/my.cnf:
[mysqld]
set-variable = wait_timeout=10
I tried this, and it was a mixed bag. On the one hand, the "Can't create
thread..." error did indeed go away, and max_used_conn
Thanks, Gerald. I appreciate the assist.
As for the docs: I know it's not a docs problem, really - yet if you
compare, say, the PHP docs with the MySQL docs, the PHP docs are much easier
to read and the examples are clearer than in the MySQL docs - IMHO. I think
it's unrealistic to expect anyone t
Hello Michael-
Would you know of any links to working examples for Windows?
Thanks!
Martin
- Original Message -
From: "Michael Shulman" <[EMAIL PROTECTED]>
To: "Martin Gainty" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 10:02 AM
Subject: Re: Pa
I'm not sure if you can do it globally... but here is what I do:
select passwd
from blerg
where login = "Matt"
and binary login = "Matt";
I do it twice b/c the binary operation is quite slow and doing the
normal equate first speeds it up significantly.
Doesn't exactly answer your questio
On Mon, 2003-03-31 at 07:57, Wynne Crisman wrote:
Hi !!
> I too have had problems with Crystal Reports and MySQL using the ODBC
> drivers provided by MySQL. The problem is not that you can't make
> Crystal Reports work with MySQL, but that when you connect to the
> database Crystal Reports is un
We are using it on Windows 2000 and Windows XP. But it doesn't seem to be
tied in to the Windows security system, so it should work the same on WinME.
-ms
- Original Message -
From: "Martin Gainty" <[EMAIL PROTECTED]>
To: "Michael Shulman" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL
I wont work for me, I dont have access to SQL layer.
I use JDO
In Micorosft SQL Server I can specify the Collate during database creation
to make my string case-sensitive. Is there an equivalent configuration for
MySQL?
Thanks ahead for all suggestions
-Dan
- Original Message -
From: "M
This is not really a MySQL docs problem.
The manual gives the mysql syntax, but you are expected to already know SQL.
You need to get a book on SQL.
SELECT data.id, data.title
FROM data,archive
WHERE data.favorite=archive.favorite AND data.favorite='Y';
Bob Sawyer wrote:
First, a little rant: I d
I delete the old binlogs after doing my nightly mysqlhotcopy.
Tiele Declercq wrote:
Hey, thanks fopr the tip. Indeed the line was in there. Can i now erase
those bin files that have been written before ?
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Tiele Declercq" <[
Michael et al-
I am trying to locate ONE working MySQL example for windows. Is this a myth
or is there WORKING source example out there somewhere?
Thanks,
Martin
- Original Message -
From: "Michael Shulman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, March
Great!
any links to working examples would be greatly appreciated!
Thanks!
Martin
- Original Message -
From: "Michael Shulman" <[EMAIL PROTECTED]>
To: "Martin Gainty" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 10:02 AM
Subject: Re: Passwords d
Hey, thanks fopr the tip. Indeed the line was in there. Can i now erase
those bin files that have been written before ?
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Tiele Declercq" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 6:39 PM
Subjec
First, a little rant: I don't know what it is about
the MySQL docs that make them so difficult for me to
read, but try as I may, I have the most difficult time
making heads or tails of anything in the official
MySQL documentation.
That being said, here's my question, the answer to
which I was NOT
[EMAIL PROTECTED] wrote:
I did use date as a column name but I'll change that.
Also, I'm trying to select the contents of each column for each recors
and do this date calculation but apparently I cannot do both at the same
time?
I can do SELECT * from table;
but can't do SELECT id, agent, ad
Hello,
This actually brings up a question I've been meaning to ask.
from the InnoDB documentations
"To be able to recover your InnoDB database to the present from the
binary backup described above, you have to run your MySQL database with
the general logging and log archiving of MySQL switched
Those are binary log files used in replication.
If you are not running replication, remove the line
bin-log
from the config file.
Tiele Declercq wrote:
Hey guys,
Ii could not find an answer on the innodb website, i'm using InnoDB now for some months and i'm very happy since the constant corruptio
I did use date as a column name but I'll change that.
Also, I'm trying to select the contents of each column for each recors
and do this date calculation but apparently I cannot do both at the same
time?
I can do SELECT * from table;
but can't do SELECT id, agent, ad_type, date_add('submit',
Start reading here:
http://www.mysql.com/doc/en/Privileges.html
and read to 4.2.10.
Two tips I found useful:
1. The current_user() function tells you what MySQL user name it thinks that
you are. This can be used to verify if you are an authenticated user.
mysql> SELECT current_user();
2. Remove
At 09:17 AM 3/31/2003, you wrote:
Dear MySQL users developers and programmers,
ERWin 4.1 not applicable for MySQL
I'd like to model some logical databases in Entity Relationships
diagrams
From here I found interesting software
What design tool do you use under Windows or Linux for modeling a
log
Hi, how do I configure mysql to be Case-Sensitive globally?
(ie where, like, clauses work with case-sensitive strings
Help is greatly appreciated.
-Dan
[EMAIL PROTECTED] wrote:
I'm trying go get a future date from a query that contains a datetime
column. I figured I would be able to use an alias in the query to
calculate the future date as follows:
select expires as date_add('date' + interval 180 days) from table;
'date' is a string.
Did you m
Hey guys,
Ii could not find an answer on the innodb website, i'm using InnoDB now for some
months and i'm very happy since the constant corruptions i had in MyISAM are gone now.
Although i have been warned that InnoDB would take up more diskspace i did not suspect
gigabytes.
When first install
On Monday 31 March 2003 10:34, Shylendra H V wrote:
> I am Shylendra from HP, working on the ServiceGuard (Clustering product
> of HP).
>
>
> Problem 1
> -
>
>
> While Starting and Stopping MySQL Server frequently, sometimes it hangs
> up and the output of ps -ef is as below.
>
> -
On Monday 31 March 2003 17:35, wrote:
> Can someone provide a link to the use of these in queries in the
> online MySQL manual? I did find them a few weeks ago but I've been lurking
> around the manual now for an hour or so and can't find them at all.
Use search in the online manual ;)
On Monday 31 March 2003 18:27, wrote:
> I'm trying go get a future date from a query that contains a datetime
> column. I figured I would be able to use an alias in the query to
> calculate the future date as follows:
>
> select expires as date_add('date' + interval 180 days) from table;
>
> 'dat
hello,
i'am working on REDHAT,and trying to connect to a mysql DB. i tested this code which
works correctly on Windows.
import java.sql.*;
//
public class TestMM
{
public static void main(String args[])
{
// Chargement du driver JDBC
Hi,
Does anybody know of any MySQL vs. PostgreSQL recent article?
I mean, that it covers MySQL 4.x and PostgreSQL 7.3.x
Thanks in advance,
Juan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I too have had problems with Crystal Reports and MySQL using the ODBC
drivers provided by MySQL. The problem is not that you can't make
Crystal Reports work with MySQL, but that when you connect to the
database Crystal Reports is unable to display the tables that are in the
database.
This makes
I'm trying to set up my own web server . . . the typical
Linux/apache/perl/php/mysql combination. I've got all these components
working *except* that I am unable to connect to a MySQL database from
perl or php.
PHP & Perl are working fine with Apache and I can run MySQL commands
from the shell
>I am looking for any type of documentation on using Crystal Reports
with
>MySQL. I have connected to mysqld from CR but when it shows the
>selected database, there are no tables listed. Is there something I
>have to configure in the MyODBC driver? Please help me out with any
>advice you may ha
I recently updated from MySQL 3.23-55 to 4.0.12 now my mysql log keeps
showing lots of restarts. I've searched around but have not found anything.
I upgraded the 3.x rpm's using rpm -Uvh MySQL* and did the following rpm's.
I also followed the upgtrade doc on the MySQL page and ran the
mysql_fix_p
1 - 100 of 133 matches
Mail list logo
