I have a table of user info containing mixed case text. One user has
created a database named "brain" and another has created a database "Brain".
I was surprised to see that:
select * from users where dbname= "Brain" returns both "brain" and "Brain".
I read section 6.3.2.2 and select binary db
Hello George!
On Sat, 24 Nov 2001, georgem wrote:
> Hi all,
>
> mysql v 3.23.32. I've started using mysqldump to backup my databases but
> have run into a strange problem with decimal numbers. As I understand it,
> mysql treats decimals like strings so to insert a value into a decimal field
> y
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
hi,
when mysql starts up with Innodb for the first time, it cerates the
tablespace.
When I tried it on a test machine (remote), I didn't quite know what was
going on, as all the machine did was respond to pings, but nothing more,
till it created the
Hi,
Please, how do i correct wrong column name (field name, not one of values
stored under the column name) in a table in mysql?
I supposed to type password when i was creating the as field but end up
typed passwod.
Thanks.
kamal.
Hello Ravi,
Well, in the ./configure script, when I tried using just the
--with-mysql argument (without any argument like =/usr/local/mysql),
the configure script gave me this warning:
++
|*** WARNING ***
At 10:38 AM + 11/23/01, [EMAIL PROTECTED] wrote:
> >Description:
> Say we have column named id int NOT NULL AUTO_INCREMENT
> Say we have record, where id=0 (why not?)
Because AUTO_INCREMENT columns are for storing sequences of postive numbers.
Not negative numbers, and not zero.
Your prob
i'd like to connect to mysql sgdb but not by a specific database, only
the sgdb, using java to send the command "show database" and them afther
that select a database listed and connect to that database.
i tried "jdbc:mysql://localhost:3306"
i tried "jdbc:mysql://localhost:3306/"
but those have
> Hi,
>
> Please, how do i correct wrong column name (field name, not one of values
> stored under the column name) in a table in mysql?
>
> I supposed to type password when i was creating the as field but end up
> typed passwod.
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_26_0
/ Carsten
--
Car
System: FreeBSD 4.2
MySQL 3.23.44 binary dist.
PHP: 4.0.6 compiled from source using --with-mysql
Had a request for a game server. Put it up. Now someone said stats is a
useful feature too. Hmm had box with some spare cycles.
Stats program requires mySQL and PHP. I'm running mySQL on a BSD/OS
Hi!
I haven't understood the syntax of LOAD DATA fully. (Though i have read the manual:)
I do have a csv-file with
;
as field-seperator.
When saving my excel-table as csv excel includes field which contain ; as content in
"
for example:
blabla;blabla;"asdf;sdfg;34";blablabla
How to use the LO
Hi,
I am new to MySQL. I installed it on Win 98 and trying
to invoke the mysqld. First it gave me a strange error
that innodb_data_file_path is not found. I copied the
following from manual (I dont really want to create
such 2GB files though !).
--
it is a primary key..i did not assign either NULL or NOT NULL when i created
it. i tried all kinds of commands in the MYSQL books.. i am in Linux...
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Barbara Ferrell" <[EMAIL PROTECTED]>
Sent: Saturday, November 24, 2001 2:02 PM
Subject
On Sat, 24 Nov 2001, Vic wrote:
> #!/usr/bin/perl -w
> use CGI::Carp qw(fatalsToBrowser);
> use CGI;
> use DBI; # Version 1.20
> use DBD::mysql; # Version 2.09
$q = new CGI;
$first = $q->param('first');
$last = $q->param('last');
> print "Content-type: text/html\n\n ";
>
> $dbh = DBI-
Hi!
I haven't understood the syntax of LOAD DATA fully. (Though i have read the manual:)
I do have a csv-file with
;
as field-seperator.
When saving my excel-table as csv excel includes field which contain ; as content in
"
for example:
blabla;blabla;"asdf;sdfg;34";blablabla
How to use the LO
> For the questions...
> select tekst || tekst2 total from table;
> should return a virtual column called total with as value
> testtest
> it returns a virtual column called total alright on it's value is 0
> I also tried this with + instead of || in oracle this should give
> an error
> sinc
> Hi all,
>
> Is there anyway to delete the duplicate records in mysql
> without creating new tables. I am wondering what query
> will achieve this task where mysql doesnt supports like ROWID and
> sub queries.
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_8_0
/ Carsten
--
Carsten H. Pedersen
k
At 15:34 -0500 2001/11/24, Barbara Ferrell wrote:
>it is a primary key..i did not assign either NULL or NOT NULL when i created
>it. i tried all kinds of commands in the MYSQL books.. i am in Linux...
Try the most excellent documentation, either online at www.mysql.com or the one that
came with
Ok so I'm using Win98, and with this all I do to rename a database is go
into the MySQL folder then into Data folder and there you have all your
databases in their own folders, and then to change the database name just
change the folders name. It works for me. I have no idea how it's done in
MyS
we used to setup a linux system as a share internet connection server with
28 client. the configuration of server is :
PII-233
128MB Ram
3.2GB HDD
server is running RedHat Linux 7.1 with Squid as proxy ,MySQL, Java J2SDK
1.4, Jakarta-Tomcat for our web application.
Best Regard !
Trong Phuc
-
Hi Rick!
I see the msg about the configure adjustment in the next release but until
then I have a hack fix at the bottom of this message. Requires no
configure -switches, just add one line to configure.
On Sat, 24 Nov 2001, Rick Stones wrote:
> >Description:
> If you build the 4.0.0. syst
I recently downloaded both versions of mysql and would like to run both on
my computer at once for comparison purposes. My question is can I do this
using both winmysqladmin's. It seems that both products attempt to
overwrite the my.cnf file in C:\Windows, and I was wondering if there is
som
On Fri, 23 Nov 2001 23:46:40 -0600, Paul DuBois <[EMAIL PROTECTED]> wrote:
>>At 10:14 PM -0600 11/23/01, Mike(mickalo)Blezien wrote:
>>>Hello all,
>>>
>>>I'm a bit confused. Does the Mysql-Max only come with BDB/Innodb
>>>support or does
>>>both the Mysql and Mysql-Max binaries both support tr
Hi All,
Is there any way to modify the date format used by MyODBC when
returning dates? By example, I have a field in the database with the
value 2001-11-01 (this is Nov. 1st, 2001).
When I read it in my VB program I get the next date 11/1/2001; this
is because the computer date format
What is the semantics of passing a NULL mysql connection to
mysql_real_connect()? Does it create a new handler? This is the only
possible interpretation of the result value as documented. However it is
also (abundantly) documented that the handle must be created with
mysql_init(). So what stands?
MySQL has been updated:
Windows: http://fileforum.betanews.com/detail.php3?fid=967965401
Linux: http://fileforum.betanews.com/detail.php3?fid=974952174
FreeBSD: http://fileforum.betanews.com/detail.php3?fid=974952321
Thanks
Eddie Elmore
[EMAIL PROTECTED]
http://www.betanews.com
http://www.filef
At 10:14 PM -0600 11/23/01, Mike(mickalo)Blezien wrote:
>Hello all,
>
>I'm a bit confused. Does the Mysql-Max only come with BDB/Innodb
>support or does
>both the Mysql and Mysql-Max binaries both support transactions??
Max only.
>
>thx's
>
>Mike(mickalo)Blezien
>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
ALTER TABLE Customers RENAME Customer_Table;
-Original Message-
From: TOMASSONI Dominique [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 23, 2001 7:48 PM
To: 'MySQL_mailing_list'
Subject: Rename a database
Hello the list,
Is it possible to change the name of a database ? And if it i
Howdy,
I'm running MySQL 3.23.43 on Redhat 7.1 and an older version of MySQL
3.22.something on Redhat 6.2. Download and install from the RPM's and it
works like a charm. I have never had a problem.
One day when it is working a little harder, I shall look at recompiling to
optimise, but so far, i
cs: ~/personal >> mail [EMAIL PROTECTED]
Subject: automatic roll-back
I am using BDB tables as offered by MySQL version 3.23.43-max.
My question is related to aborting transactions.
I am implementing a global transaction manager and using
several MySQL engines. Suppose the GTM fails, what happen
I am a MySQL novice, so there may be a simple explanation for this. But I
have been unable to find one in the list archives, although several people
seem to have had similar problems.
I am running MySQL 3.23.36 from the package that comes with Mandrake linux
8.0. I am using linux software-RAID mi
Does any one know if mySQL has a way of accessing when a record was last
updated?
Jeff
Alta Host - Web Site Hosting Solutions-
http://www.altahost.com
760-726-4863
-
Before posting, please check:
http://www.mysql.com/manual
31 matches
Mail list logo
