At 11:01 PM -0600 1/20/01, Andrei Zmievski wrote:
>At 06:34 PM 1/20/01 -0800, Jeremy D. Zawodny wrote:
>>MySQL does trailing whitespace removal on all VARCHAR data as
>>described in the manual.
>
>Hmm, well that presents a problem in my application that counts on
>exact comparisons - I guess a wa
when i connect to a mysql server and use the odbc driver, i get #deleted no
matter what i do. I can connect & authenticate ok. does nayone have a
suggestion ??
thanks in advance
Gabriel
-
Before posting, please check:
h
At 06:34 PM 1/20/01 -0800, Jeremy D. Zawodny wrote:
>MySQL does trailing whitespace removal on all VARCHAR data as
>described in the manual.
Hmm, well that presents a problem in my application that counts on exact
comparisons - I guess a way to do it is to use 'like' instead of '='?
-Andrei
In the last episode (Jan 21), Muhammad Farhan Ghazi said:
> How much space is taken by the datetime field?
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Storage_requirements
> Is there any way that we can only store date or time in it?
http://www.mysql.com/documenta
How one can implement foreign key in MySQL? I've looked at the doc but
didn't get the method.
Please comment,
Ghazi, Muhammad Farhan
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
---
How much space is taken by the datetime field?
Is there any way that we can only store date or time in it?
How we can seperate date and time from this field?
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hot
How much space is taken by the datetime field?
Is there any way that we can only store date or time in it?
How we can seperate date and time from this field?
Regaards,
Ghazi, Muhammad Farhan
_
Get Your Private, Free E-ma
On Sat, Jan 20, 2001 at 02:46:49PM -0600, Andrei Zmievski wrote:
> I recently ran into a problem when doing comparison against varchar
> field. Basically, comparing 'foo' and 'foo ' (note extra space)
> against the records produced the same results - almost as if MySQL
> trims the whitespace from
I had some trouble using insert delayed - I wonder if anyone can shed some
light on the problem.
I have a table for logs that records are inserted into regularly - once
every 10 seconds or so. I tried to update record in the table, but the
update just waited forever, it seemed to be waiting unti
Just a quick question, maybe I'm missing the point of using merged tables, but why do
I have to use like '%string' to find a match from a merged table instead of = 'string'?
Example.
mysql> select PARTNO,SUP,SUP_PARTNO,STOCK,PRICE,DESCR from combined_search where
PARTNO = 'DSB-C300' order by PR
Thanks all. The problem is solved.
Lots of talk about TMPDIR and such so I gave all my attention to software
problems and missed the obvious.
For some reason the OS didn't recognize all the RAM and started reporting
only 128M instead of the installed 384M This led to over use of swapfile.
I lo
On Sat, Jan 20, 2001 at 02:53:22PM -0500, Hlady, Brian wrote:
> I'm using the code found on page 245 - 247 of Paul Dubois' book, MySQL. When
> I attempt to make it
> under Code Crusader, I get the error found below.
>
> gcc -g -Wall -Werror -I- -I. -I/usr/local/include/mysql -c common.c -o
> co
is this the proper comparison:
MySQL and Cold Fusion Server (not CF Studio)?
i just started a database class (relational/ODBC) -they will of
course, eventually, use CF and Access... only a little -it's a
general class.
i, of course:), wish to resist those!
i run OS X pb.
one kindly friend was
Hi,
I recently ran into a problem when doing comparison against varchar
field. Basically, comparing 'foo' and 'foo ' (note extra space) against
the records produced the same results - almost as if MySQL trims the
whitespace from the search parameter before running the search. Can
anyone shed ligh
Upon closer examination, I realized the things are not as bad as I thought -
if the client aborts connection, the coredump happens only if mysqld was
compiled with debugging - otherwise the trouble code is not executed. We
will, however, make 3.23.32 release shortly, because of other bad bugs (
Hi
I'm maintaining the MySQL packages for the Debian distribution. As introducing
new major versions into already released distribution trees is generally
not a good thing, I want to patch the version 3.22.32 which is in the last
release regarding the new security bug fixed in 3.23.31.
Can anybo
Hello,
I am trying to figure out how to allow a MySQL user
to change his own password. So far, the absolute
minimum access I have been able to grant the user is
to change anyone's password (using the columns_priv
table). I want the user to be able to change his own
password, but only his own pass
I'm using the code found on page 245 - 247 of Paul Dubois' book, MySQL. When
I attempt to make it
under Code Crusader, I get the error found below.
gcc -g -Wall -Werror -I- -I. -I/usr/local/include/mysql -c common.c -o
common.o
gcc -g -Wall -Werror -I- -I. -I/usr/local/include/mysql -c clien
Hello,
I recently changed moved my system to a new location where it now has all new
network connection settings. When I went ot start MySQL up for the first time
after the change I got this error:
# ./safe_mysqld &
1416
# Starting mysqld daemon with databases from /usr/local/mysql/var
Killed
my
I installed mysql on a Redhat client on the LAN. Used ./configure
--without-server option.
Now when I make test Msql-Mysql-modules I get the following:
[root@lowlyfollower Msql-Mysql-modules-1.2214]# make test
make[1]: Entering directory
`/usr/rushclient/src/Mysql_Mod/Msql-Mysql-modules-1.
2214
On Saturday 20 January 2001 09:32, fongming wrote:
>Hi:
>
>Happy New Year!!
>
>Today I downloaded the Mysql-3.23.31 and installed
>
>on win98.
>
>When I executed a little test query string on
>the localhost web (win98 )just like :
>-
>mysql_pconnect ("
I have UD4 pages working on my NT4 with Mysql.
There are two ways to connect to database:
1. Via myodbc, in this case you can connect using DSN name.
2. Through the connection string:
YourRS.ActiveConnection =
"Driver=MySQL};Server=localhost;DATABASE=YourDBname;UID=Username;pwd=yourpas
swd;";
Mak
Hi:
Happy New Year!!
Today I downloaded the Mysql-3.23.31 and installed
on win98.
When I executed a little test query string on
the localhost web (win98 )just like :
-
--
I thought it to be a simple te
Derek Sivers wrote:
>
> > > Any measures I could take (like SSH) to encrypt the transaction?
> >Use CIPE tunnel. You can find it:
> >http://sites.inka.de/sites/bigred/devel/cipe.html
>
> Is this anything like ipsec?
> http://www.openbsd.org/faq/faq13.html
> (I'm using OpenBSD.)
>
> Or, rather,
"Murph" <[EMAIL PROTECTED]> writes:
> I'm test-driving Dreamweaver UltraDev 4 and can't get it to connect to =
> my remotely hosted MySQL database despite the last six hours' worth of =
> effort. Macromedia's online docs aren't helping much.
Can you do it via any other front end?
--
Dave Hodg
My replication crashed just once again...
my my.cnf on the slave contains:
master-host = 123.123.123.123
master-user = rep
master-password = hidden
replicate-do-db = db1
server-id = 6
replicate-ignore-table=db1.specials
I created a new DB on the master called "specials".
create
-Original Message-
From: JeffWang
Sent: Wednesday, January 17, 2001 7:18 PM
Subject: ¯º¸Ü
¦³¤@¦¸ºÖº¸¼¯´µ»PµØ¥Í¤@°_¥hÅSÀç,
¦b±bÁO»\¦n¤§«á,¥L̤GÓ´NÆp¶i¥hºÎıı
¨ì¤F¥b©]..ºÖº¸¼¯´µ¬ðµM§âµØ¥Í·n¿ô
¨Ã¥B«üµÛº¡¤Ñ¬P¬P¹ïµØ¥Í»¡
"µØ¥Í,§A¬ÝµÛº¡¤Ñ¬P¬P¦³¦ó·P·Q£«"
µØ¥Í¬Ý¤F¬P¬P¤@²´¤§«á´N»¡
Crystal Reports with MyODBC and MS Windows.
Pat...
- Original Message -
From: "Laurie Savage" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 9:03 PM
Subject: A report generator MySQL
> I am writing a database to store student academic records at my local
> h
Michael Griffith writes:
> Cacheing before writing sounds like exactly the type of thing that would
> explain the problem. However, I'm on FreeBSD (Sorry, didn't give too many
> details). Anybody know if there is something similar in to bdflush BSD?
>
> I did run iostat to monitor the the a
Michael Griffith writes:
> My TMPDIR is actually not separate from the data. There is plently of disk
> space. In fact, thinking it was some sort of RAM problem I reduced the size
> of the database by almost 30% with no change in performace.
>
> You say this should not happen, yet as I've be
Juergen Leeb writes:
> How can I get a row[i] in a char* or a qstring variable?
>
> thank for helping!
> juergen leeb
>
HI!
You can use either get_string() or dat() methods to get std::string
out of row[i].
Why should you use char *, when you are using C++ and STL already.
If you do re
First of all MySQL rocks!!!
--
Now for my problem...
Unfortunately, before I knew how autoincrement worked, I have setup a database with a
signed autoincrement column.
When I insert columns, I usually pass NULL as the column value for the INSERT
statement to correctly in
Dear Rasmus,
I checked the php.ini file and the entry "extension=mysql.so"
already exists under the "dynamic extensions" section. But the
problem still exists. Please help me.
regards,
Willy
> --
> From: Rasmus Lerdorf[SMTP:[EMAIL PROTECTE
Cacheing before writing sounds like exactly the type of thing that would
explain the problem. However, I'm on FreeBSD (Sorry, didn't give too many
details). Anybody know if there is something similar in to bdflush BSD?
I did run iostat to monitor the the activity during the freeze. It appears
th
Hi Jason,
You did not supply any platforms, so if IIS with ASP/VBScript support:
http://www.scibit.com/MySQLX check out the Sample website.
> -Original Message-
> From: Jason Frisvold [mailto:[EMAIL PROTECTED]]
> Sent: 18 January 2001 23:24
> To: '[EMAIL PROTECTED]'
> Subject: Front End
In your php.ini file:
extension=mysql.so
-Rasmus
On Sat, 20 Jan 2001 [EMAIL PROTECTED] wrote:
> Thanks Matt.
> MySQL is finally working.
> But the problem now is that PHP is not recognizing its MySQL
> functions. The error I am getting is:
>
> Fatal error: Call to undefined function: mysql_pco
Thanks Matt.
MySQL is finally working.
But the problem now is that PHP is not recognizing its MySQL
functions. The error I am getting is:
Fatal error: Call to undefined function: mysql_pconnect() in
/var/www/html/Willy/MySQL/test1.php on line 28
Well, the php_mysql RPM has been installed along w
Hi Laurie,
You can also try:
http://www.scibit.com/Mascon
Full Reporting support, with images, graphs, pivottables, etc, etc.
> -Original Message-
> From: Laurie Savage [mailto:[EMAIL PROTECTED]]
> Sent: 20 January 2001 04:03
> To: [EMAIL PROTECTED]
> Subject: A report generator MySQL
>
>Earlier I posted a message about SHOW PROCESSLIST reporting queries "locked"
>whenever another thread is "Copying to tmp table"
>
>After many more hours of diagnosis, the actual problem is somewhat different:
>
>MySQL does report other processes as locked. But they do not wait until the
>temp t
OS is Linux latest version
web server apache
servlets apache jserv
databse server MySql
problem :
when machine starts and all server starts
any databse having more than 6 tables
creates problem
problem is
column cln1, cln2 not found in aa.frm table
when i shut down and start mysql se
Hi!
> "Goodman," == Goodman, Michael <[EMAIL PROTECTED]> writes:
Goodman,> I'm not sure exactly what happened, but mysql was freezing everytime I tried
Goodman,> to access a particular table...everytime I tried to select anything from it,
Goodman,> alter it, drop it, whateverjust nothin
Hi !
Ok. I've made correctly replication with two servers in a two-way replication. Both
servers are master/slave. But I would like to know if is it possible to make three
servers to replicate and receive the updates from each others like this:
a sends updates to b and c
a receives updates fro
Hi!
I'm test-driving Dreamweaver UltraDev 4 and can't get it to connect to my remotely
hosted MySQL database despite the last six hours' worth of effort. Macromedia's online
docs aren't helping much.
I don't think this should be impossible but you never know. Are there some docs or
hints some
43 matches
Mail list logo