Greetings,
I am upgrading my mysql from 3.22.23b to 3.23.35 on RedHat with kernel
2.4.0. I followed the instructions on the manual for the upgrade. Every
goes fine except I can't convert one table from ISAM to MYISAM.
I got quite a lot of tables and all can be converted successfully but
not this
Hi Mohammed,
- (MySQL is installed on both servers.)
- On the master GRANT FILE ON .* TO replicater@ IDENTIFIED BY 'replicater';
- Stop MySQL on both servers.
- Be sure you have two identical databases on each server. (Copy from one to the other
if needed. - check all the access rights stuff.)
-
>Description:
MySQL 3.23.36, built on a lunix-2.4.2 system using identical
configuration to the previous MySQL-3.23.35 build, dies immediately upon
launch with a SIGSEGV.
>How-To-Repeat:
All that's necessary on this system is to try to start MySQL.
>Fix:
Unknown.
>Sub
What process do you guys usually follow when upgrading your version of
MySQL? I have yet to perform an upgrade, but my first thought would be to
dump the databases, uninstall the old version (remove all the files),
install the new version, and import the dump file. Is this a good plan, or
is the
Hi
At 14:12 27/03/2001 -0800, Steve Quezadas wrote:
>Hey guys,
>
>Most of the accounts I have read about MySQL was that it was one of the
>fastest databases around. Now, for development purposes I created a
>FreeBSD system with JUST MySQL (no other major processes). Then I created
>a separate
I searched the archives but didn't come across anything like my problem
I have a table with 2 indices, the primary key that is an
auto_increment, and a datetime field. when I do a show index It
displays the primary key first and the story date index second.
When I run myismchk --sort-result=2
GNU gdb 5.0
Copyright 2000 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain
conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.
Just guessing here, but look two places:
1. The user you have set up on the MySQL server
2. The user in the MyODBC dsn on your Windows client [or appropiate
connection string in your ASP code if you are using a dsn-less connection]
I suspect you just need a user like 'webs' rather than:
'[EMAIL P
bye the bye,
I'm running RH6.2 on Intel
Chris Becker
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <
At 20:47 27/03/2001 +0300, Yusuf Incekara wrote:
Hi!
Actually the MySQL Win32 distribution doesn't provides yet,
the binaries and the source for BDB and Innobase stuffs.
However if you want to build yourself a MySQL server with the support of
BDB tables, below the instructions to build a server f
I'm having trouble installing the perl module DBD specifically. I found on
my CPAN cd the DBD module Msql-Mysql-modules-1.2208, tried to install it and
got errors, I discovered I needed DBI installed first. So I found DBI-1.13
and did the following:
perl Makefile.PL
make
make test
Made 100 co
> Has anyone seen any tool that would connect to
> a Progress DB and dump out a .sql (DB structure & data)
> so I can then load it into MySQL.
I know very little about Progress, but...
I have managed to get PHP http://www.php.net talking to both MySQL and Progress 8.3
using the openlink drivers
Herris Kocibelli wrote:
>
> Hi all,
>
> Has anyone seen any tool that would connect to
> a Progress DB and dump out a .sql (DB structure & data)
> so I can then load it into MySQL.
> Also, another thing I want to achive is to be able to run
> Progress 4GL code against MySQL DB.
> Has anyone hear
Java + mysql (windows 2000) :
When i use base64 to encode string , and then insert into database then show error
message
SQLException caught: Error during query: Unexpected Exception:
java.lang.IllegalArgumentException message given: Packet is larger than
max_allowed_packet from server c
Hi!
I've been searching the archives and found a lot of good stuff on setting
up Coldfusion with Mysql.. but for some reason I still the get the
following error:
"The connection to the data source failed. Check the following to resolve
this problem:
Are the data source settings configured prope
Greetings
Is anyone else having troubles running mysql-3.23.35 or mysql-3.23.36 on
FreeBSD 4.2-Stable or 4.3-X
Whether I install it via the port, or via a downloaded source-compile when I
try to run it it gives me a signal 11, segmentation fault..
Thanks
Nicole
[EMAIL PROTECT
Yes, your grant tables are not set up correctly.
For full information, see the manual.
For now try this:
Choose a userid and password just for your db connection. It can be
different from every other userid password you have.
With the mysql client issue the following to SQL statements
GRANT AL
Greetings
Is anyone else having troubles running mysql-3.23.35 or mysql-3.23.36 on
FreeBSD 4.2-Stable or 4.3-X
Whether I install it via the port, or via a downloaded source-compile when I
run it it gives me a signal 11, segmentation fault..
Thanks
Nicole
[EMAIL PROTECTED]
You can read a binlog with mysqldump?
Mat
Your mouse has moved. Windows must be restarted for the change to take
effect. Reboot now? [ OK ]
- Original Message -
From: "Scott Baker" <[EMAIL PROTECTED]>
To: "Mat Murdock" <[EMAIL PROTECTED]>; "MySQL"
<[EMAIL PROTECTED]>
Hello, I'm new here ...
I'm trying to use MySQL qith ASP, so I use ODBC .., but when I'm trying to
connect to the server, it always respons:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[TCX][MyODBC]Access denied for user:
'[EMAIL PROTECTED]@mbtpc20.bau-verm.uni-karlsruhe.de' (
On 3/27/01 4:54 PM, "WeAreUs" <[EMAIL PROTECTED]> wrote:
>
> Hi!
>
> I enter some .wav encoded (windows) data into a MySql table as follows:
>
> $data = addslashes(fread(fopen($form_data, "r"),
> filesize($form_data)));
>$result=MYSQL_QUERY("INSERT INTO
> b(audio,filename,filesize,file
How to reindex fulltext index? Thanks
==
xiewer
Emailto:[EMAIL PROTECTED]
CAD Garden -- http://xyzcad.yeah.net
==
-
Before posting, please check:
http://www.my
Okay,
This has already happened once and I had to restore it from backup. I
was using one of the pre-stable betas but i am not on the most current
stable release and it still crashes. The table is a little over 500MB. I
was doing a lot of inserts to the database both times this happened. T
Hi All,
Does anyone know where I can find such a beast?
Thanks.
Yours cheerfully,
Anderw Bush
http://www.bushpro.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
On Tue, Mar 27, 2001 at 04:57:12PM -0800, Oson, Chris M. wrote:
>
> Excuse me if I'm wrong, but isn't using persistent connections more
> server resource intensive? I'm trying to optimize the database on a
> heavy site, and I decided not to use persistent connections.
Persistaet connections rem
On the subject of RPMs, do they contain Innobase and BDB yet, or are those
still only in the source releases?
- Original Message -
From: Scott Baker <[EMAIL PROTECTED]>
To: Jack Lauman <[EMAIL PROTECTED]>; MySQL Mailing List
<[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 4:52 PM
Subjec
Mike,
Excuse me if I'm wrong, but isn't using persistent connections more
server resource intensive? I'm trying to optimize the database on
a heavy site, and I decided not to use persistent connections.
Chris
-Original Message-
From: Michael Betts [mailto:[EMAIL PROTECTED]]
Sent: Tue
Hi!
I enter some .wav encoded (windows) data into a MySql table as follows:
$data = addslashes(fread(fopen($form_data, "r"),
filesize($form_data)));
$result=MYSQL_QUERY("INSERT INTO
b(audio,filename,filesize,filetype,audio_description) ".
"VALUES
('$data','$form_data_name','$
I highly recommend installing from source. I've had many problems with the
RPMs.
At 04:42 PM 3/27/2001 -0800, Jack Lauman wrote:
>I'm getting the following error when I try to install the 3.23.36 RPM's
>on a P3-450 RedHat 7.0 box.
>
>I'd appreciate any suggestions.
>
>Starting mysql daemon with
I'm getting the following error when I try to install the 3.23.36 RPM's
on a P3-450 RedHat 7.0 box.
I'd appreciate any suggestions.
Starting mysql daemon with databases from /var/lib/mysql
/usr/bin/safe_mysqld: line 258: 8692 Segmentation fault (core dumped)
$NOHUP_NICENESS $ledir/$MYSQLD $defau
Hi all,
Has anyone seen any tool that would connect to
a Progress DB and dump out a .sql (DB structure & data)
so I can then load it into MySQL.
Also, another thing I want to achive is to be able to run
Progress 4GL code against MySQL DB.
Has anyone heard anything about this before?
Thanks
H
Look at "source downloads"
http://mysql.com/downloads/mysql-3.23.html
At 07:06 PM 3/27/2001 -0500, Mohammed Ali wrote:
>Hi there,
>I was looking for the master and client source code but I was unable to
>find, I found the rpm but not source in tar format.
>I ma tiring to configure 2 linux server
Hi,
>How may create a view in mysql, o make some seem to the queiries in
>access !!!
As discussed already many times over and over again and as it can be read
in the mySQL documentation (http://www.mysql.com) views are (not yet)
implemented in the current 3.23.36 version.
Regards
... Ralph ...
Need a lil bit more information from you.
Right now mysql doesn't support views, however it does support temporary
tables which can accomplish most things. What is it your trying to do here?
- Original Message -
From: "Marglobal - Pablo Salazar (Jefe de Sistemas)" <[EMAIL PROTECTED]>
To
Steve,
I also experienced the same results you did until I realized that
the MS-SQL connection was using pooled connections and my
use of MySQL wasn't. After I started using persistent connections
to MySQL, it was much faster than MS-SQL on identical hardware
and no tuning on either system.
Als
I am starting out to learn database scripting using PHP/mySQL/Apache on Win98:
Apache 1.3.14(Win32) with PHP 4.04pl1
MySQL 3.23.28-gamma, localhost via TCP/IP
As an exercise I wrote a php script which dumps the contents of a
form into a database, prints the contents of the table (most rec
Hi there,
I was looking for the master and client source code but I was unable to
find, I found the rpm but not source in tar format.
I ma tiring to configure 2 linux server one master and one slave, can you
tell me what's the best way to accomplish this and what settings I have to
change.
any he
Hi again Folks !!
How may create a view in mysql, o make some seem to the queiries in
access !!!
THanks
Pablo
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Just use mysqldump!
At 03:59 PM 3/27/2001 -0700, Mat Murdock wrote:
>I've looked through the manual and about 9000 posts from multiple
> mailing lists.. Is there a way to have mysqlbinlog take a log file and
> dump just the sql statements to a file? Am I using the wrong program to
> do th
In the last episode (Mar 27), Steve Quezadas said:
> Most of the accounts I have read about MySQL was that it was one of
> the fastest databases around. Now, for development purposes I created
> a FreeBSD system with JUST MySQL (no other major processes). Then I
> created a separate Windows 2000 A
Does anyone have some code or very specific pointers as to how I might take
an audio file stored in Blob format and write the file to disk?
Thanks!
-Warren
-
Before posting, please check:
http://www.mysql.com/manual.php (
on 27/03/01 21:42, Rick Emery at [EMAIL PROTECTED] wrote:
> I had the same problem.
> Ensure that /var, /var/lib, and /var/lib/mysql have their permissions set
> to: drwxr-xr-x
/var/lib/mysql hasn't these permissions but now, it's OK. But I still have
the same answer:
"starting mysqld daemon wi
I've looked through the manual and about 9000 posts from multiple mailing lists..
Is there a way to have mysqlbinlog take a log file and dump just the sql statements to
a file? Am I using the wrong program to do that? Any help would be most appreciated.
Mat
are there any hooks in ASP to access MySQL if it was running on the same box
as the ASP server, without using ODBC?
Php has the range of mssql_() functions, what are all the methods of getting
data from MySQL for ASP?
-
Befor
Did you put MS-SQL server on the ASP server machine? Or did you put windows
2000 on that formerly bsd box.
Where both setups communicating over ethernet?
Or was the second setup a single box? (would be much faster)
An ASP server communicating to MS-SQL, even via ODBC, is probably as close
to opt
In the last episode (Mar 27), Cal Evans said:
> Thanks for the clarification. I wasn't aware that MySQL (or any
> other SQL for that matter) stored records in a 'physical order'. I
> know in M$ SQL there is no such concept as records are constantly
> being reused as the contents are deleted. (a
Hi.
Well, there are too few information to say something concrete. Maybe,
for your enviromnet, MS-SQL is really faster, maybe MySQL wasn't well
tuned.
Anyhow, I wanted to point out, that there are two MySQL ODBC drivers
around, one with debugging enabled, the other one without debugging.
The one
Hi.
On Tue, Mar 27, 2001 at 08:22:39PM +0100, [EMAIL PROTECTED] wrote:
> > -Original Message-
> > From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
[...]
> > > Aha, I'll have to test more with the individual order of
> > combined indexes to
> > > see what I can get from it.
> >
> > We
On Tue, Mar 27, 2001 at 02:12:36PM -0800, Steve Quezadas wrote:
>
> Anyways, a period of time elapsed and we decided to move to MS-SQL
> server for feature reasons, and when we had the MS-SQL ODBC driver
> point to the newly created MS-SQL server (roughly same specs), it
> was like 50% faster! Wha
I have a problem getting the mysql started. I am running
slackware linux version 7.xx. Apparently mysql is installed.
I downloaded the linux binary package of mysql and installed it.
the mysql is installed in /usr/local/mysql. The problem is that
mysql ** immediately ends **. Here is one of the w
Hey guys,
Most of the accounts I have read about MySQL was that it was one of the fastest
databases around. Now, for development purposes I created a FreeBSD system with JUST
MySQL (no other major processes). Then I created a separate Windows 2000 ASP server to
server as our development server
You do not need telnet to access a mysql server - mysql has it's own
client-server protocol, accessible via the means described by Jean-Claude.
regards,
P
On Tue, 27
Mar 2001, Chad Nielsen wrote:
> Thanks Jean - Claude,
>
> NT Workstation comes with a built-in client. but from what I can te
On 3/27/01 12:12 PM, "Yann Larrivée" <[EMAIL PROTECTED]> wrote:
> Sorry i think this is my mistake the format that i gave did not get reoected
> by the mailing liste
>
> so my structure is
>
> provider books music
> video
> provider_idtitle
Thanks Jean - Claude,
NT Workstation comes with a built-in client. but from what I can tell, NT
Server does not come with a built-in Telnet Server. The NT book I have says
:
"The Telnet program requires TCP/IP on both the client and server, and
requires an account set up on the server being cont
On Tue, Mar 27, 2001 at 01:45:16PM -0600, Brady Orand wrote:
>
>
> Go back to version 3.22. It works very well. The most current
> vertion hasn't been ported yet.
I could build a Solaris Intel 2.6 binary if needed. It'll probably
work on Solaris 7.
Lemme know if there is interest...
Jeremy
Hi!
On Mar 27, Patric de waha wrote:
> Hi,
> I entered netstat and saw among other conections
> this one:
>
> tcp4 0 0 deepthroat.3179 web.mysql.com.auth TIME_WAIT
>
> Deepthroat is my bsd machine. it's a pure webserver.
> Why is my machine making a connectio
I can get the basic compiled version installed, but when I run
scrpits/mysql_install_db I get the following error.
ld.so.1: ./bin/mysql: fatal: libcrypt_i.so.1: open failed: No such file
or directory.
I'm a neebie when it come to Solaris sysadmin.. I've done a find and can
locate a file called
li
Esteban Cazarez wrote:
>
> Has anyone found the lastest mySQL for SUN SOLARIS 7 Intel version? I know there's a
>SPARC binary for 3.23 but what about an Intel binary?
>
I was able to compile it fine on Solaris x86 2.6.
-- Josh
_
Hi Rick,
You absolutely right, you are not required to specify field names in an
Insert. But it's a good idea to do so. 1) It makes you code more readable
for those following you. 2) If your table ever changes structure, your
Insert will still work. (Assuming you didn't remove one or more of t
Sorry i think this is my mistake the format that i gave did not get reoected
by the mailing liste
so my structure is
provider books music
video
provider_idtitle title
title
provider_name provider_id provider_id pr
Hi Chad
You do not need a Telnet client. Just install Myodbc and the mysql client.
To connect to your server, type "mysql -h yourhostname -u userID"
If you defined a password for the userID, add -p at the end of the line. The
system will prompt you for the password. See manual for more options.
I had the same problem.
Ensure that /var, /var/lib, and /var/lib/mysql have their permissions set
to: drwxr-xr-x
-Original Message-
From: Stephane Pinel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 12:58 PM
To: [EMAIL PROTECTED]
Subject: [NEWBIE] safe_mysqld
When I attempt
Hi All,
Does any one know where I can find one?
Thanks.
Yours cheerfully,
Andrew bush
http://www.bushpro.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
Go back to version 3.22. It works very well. The most current vertion
hasn't been ported yet.
Brady...
Original Message Follows
From: "Esteban Cazarez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: mySQL for Sun Intel
Date: Mon, 26 Mar 2001 18:16:00 -0800
Has anyone found t
But could i use something like a subselect ... I know they are not supported
by mysql but i see in my book that there is a substitute for it.
Also i am not to familiar with LEFT JOIN ... and all those ... can you give
me explanation ?
So really would it make what would be the real answer to my p
You DO NOT need to specify table field names when INSERTing records. For
instance, if the table were defined thus:
CREATE TABLE mytable (
valueA varchar(10) NOT NULL,
valueB varchar(25),
valueC varchar(30) );
This statement will insert one record:
INSERT INTO mytable VALUES("some text",
Hi,
I entered netstat and saw among other conections
this one:
tcp4 0 0 deepthroat.3179 web.mysql.com.auth TIME_WAIT
Deepthroat is my bsd machine. it's a pure webserver.
Why is my machine making a connection to mysql.com?(and why auth)
Mys
Is it the only way to get mysql to work on d: is to install on c: then move
to d: ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To r
> -Original Message-
> From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
> Sent: martes, 27 de marzo de 2001 10:00
> To: Nemholt, Jesper Frank
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: How to index this properly (to make it go faster) ?
>
[clip]
> > Why that, usertime & systemtime are da
> -Original Message-
> From: Rafael Martinez [mailto:[EMAIL PROTECTED]]
> Sent: martes, 27 de marzo de 2001 15:28
> To: [EMAIL PROTECTED]
> Subject: Mysql in a 4-way / 2 GByte server / raid 5
>
>
> Hello
>
> I am thinking to install our DB server in a 4-way machine with
> Intel Xeon pro
Doesn't MySQL on NT support networking? You should be able to install the
mysql client on the workstation and give it the IP address, port number and
database name on the server to connect. You don't have to install telnet.
I don't use NT, so if there really is some reason MySQL on NT won't work
When I attempt to launch mysql server with command safe_mysqld, the console
return this:
"starting mysqld daemon with databases from /var/lib/mysql"
"010327 19:33:37 mysqld ended"
I use RedHat 7.0 Linux on Intel
--
Stéphane Pinel
39, Rue du Docteur Heulin
75017
On 3/27/01 10:08 AM, "Cal Evans" <[EMAIL PROTECTED]> wrote:
> yep. That's the point of a tinyint, it only holds numbers 0-127. if you
> need more then try smallint, int or bigint. (and please read the manual
> regarding data types. It's clearly explained there.)
>
> Cal
> http://www.calevans.co
On 3/27/01 1:14 AM, "Filip Sergeys" <[EMAIL PROTECTED]> wrote:
> 3)For the last two bits(3C) I like to have the binary value
> HEX value = 3C
> Binary = 00
> Final SQL query: BIN(substring(HEX(intag), (length(HEX(intag))-1), 2))
Bin() takes an argument that is assumed to be deciaml. So bin i
3.23.35-log reports it correctly.
Cal
http://www.calevans.com
-Original Message-
From: Gordon Werner [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 12:01 PM
To: [EMAIL PROTECTED]
Subject: mySQL INSTR function problem
Hi there ...
I am running mySQL Ver. 9.33 Distrib. 3.22.
At 12:56 PM -0500 3/27/01, Marglobal - Pablo Salazar (Jefe de Sistemas) wrote:
>Hi Folks!!
>
>I have a question, How may set another location for my productions db,
>so, for instance if i want put my db in /mydb filesystem in my Linux
>Redhat???
>because when i create a db, this is in /var/lib/mys
In the last episode (Mar 27), Dacian Herbei said:
>
> I wonder if anyone had a problem like this one. I have created a
> table with one field autoincrement. The field is tinyint(4).
> whenever I try to introduce more then 127 records it refuses to
> introduce them. I tried with ti
I'm going to jump in here and give a little more information.
The password() function is in fact a one way encryption. For a two way
encryption use the encode() function. But beware, any data stored with the
encode() function is only as secure as the master password you assign it.
You can do so
At 7:49 PM +0200 3/27/01, Dacian Herbei wrote:
> Hi,
> I wonder if anyone had a problem like this one.
> I have created a table with one field autoincrement. The field is
>tinyint(4).
> whenever I try to introduce more then 127 records it refuses to
>introduce them.
> I tried w
OIC.
Thanks for the clarification. I wasn't aware that MySQL (or any other SQL
for that matter) stored records in a 'physical order'. I know in M$ SQL
there is no such concept as records are constantly being reused as the
contents are deleted. (and other optimization schemes are in place) These
Hi,
I am trying to write a query that will INSERT into a table a set of
values if they do not already exist.
It is a join table.
$colOneName = 'staff_id';
$colTwoName = 'subject_id';
$colOneValue = 2;
$colTwoValue = 3;
$sth = $dbh->prepare ("REPLACE into $sqlTable ($colOneName,
$colTwoNam
yep. That's the point of a tinyint, it only holds numbers 0-127. if you
need more then try smallint, int or bigint. (and please read the manual
regarding data types. It's clearly explained there.)
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PRO
I'll try to depict this here, though ascii form doesn't really help (this is where a
blackboard and some chalk do a better job)
Assume you have a table which is physically stored as:
ID TAG
-
1 lala
2 koko
3 haha
4 toto
If I create an index on ID, then t
Hi there ...
I am running mySQL Ver. 9.33 Distrib. 3.22.25 and I have run into the
following problem.
When I type:
mysql> select INSTR('foobarbar', 'bar');
it outputs
+---+
| INSTR('foobarbar', 'bar') |
+---+
| 7 |
+
You can use either ucase() or upper() functions.
ucase(str) or upper(str)
Seung-woo Nam
Zhu George-CZZ010 wrote:
> There's a function in SQL to convert strings to upper case (sounds like to_upper()?
>), I don't have the reference book at hand, does anyone know the syntax or that
>function?
>
Hi Folks!!
I have a question, How may set another location for my productions db,
so, for instance if i want put my db in /mydb filesystem in my Linux
Redhat???
because when i create a db, this is in /var/lib/mysql/data
Please , help me
Thanks !!
Pablo
-
On Tue, 27 Mar 2001 11:22:20 -0600, Zhu George-CZZ010
<[EMAIL PROTECTED]> wrote:
I believe it's upper(col_name)
>>There's a function in SQL to convert strings to upper case (sounds like to_upper()?
>), I don't have the reference book at hand, does anyone know the syntax or that
>function?
>
Hi,
I wonder if anyone had a problem like this one.
I have created a table with one field autoincrement. The field is
tinyint(4).
whenever I try to introduce more then 127 records it refuses to
introduce them.
I tried with tinyint(5) 6.. and so on. It works only with integer.
Tha instructions on mysql web pages ,
downloaded documents and
relelased product versions are not the same for Windows.
I still could not understand did 3.23.35a or 3.23.36
support bdb on windows and if
supports how can i implement this.
Regards.
http://www.mysql.com/doc/S/t/String_functions.html
UCASE(str)
UPPER(str)
Returns the string str with all characters changed to uppercase according to
the current character set mapping (the default is ISO-8859-1 Latin1):
mysql> select UCASE('Hej');
-> 'HEJ'
This function is multi-byte saf
Hello all.
I was wondering if anyone could help me out with a little project I have to do.
I have a win98 machine with a access database.
I would like to transfer everything into mysql on a red hat 7 linux box.
How would I do this?
Plus how would I be able to connect once it transfer to mysql th
There's a function in SQL to convert strings to upper case (sounds like to_upper()? ),
I don't have the reference book at hand, does anyone know the syntax or that function?
Thank you very much in advance.
-
Before posting, pl
How do you differentiate between primary and secondary indexes? I'm not
familiar with the distinction.
Cal
http://www.calevans.com
-Original Message-
From: Thalis A. Kalfigopoulos [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 10:55 AM
To: Cal Evans
Cc: Duke; [EMAIL PROTECTED
When we use grant as following:
GRANT select(col_name_1) on db_name_1.tbl_name_1 to peter identified by
"peter";
Then peter can only select the field of col_name_1 on the tbl_name_1 of
db_name_1.
However, when peter issue the query: DESC tbl_name_1; he can see all the
structure of that table. Th
Hi,
I'm trying to install mySQL on NT Server 4.0
I guess I need to install a Telnet Server so I can manage mySQL from a
workstation.
What's a good Cheap or Free Telnet Server for NT?
Also, any instructions on how to set this up would be great.
Thanks,
Chad
Chad M. Nielsen, GIS Programmer/Analy
On Tue, 27 Mar 2001, Cal Evans wrote:
> Key = Creates an index
> Index = Same as above? (Not sure, the section of the manual I just glanced
> at seems to indicate that they are the same thing)
> PRIMARY KEY = Creates a primary key for the table. Each table should have a
> primary key and it shou
Would you please read this too :)
- Original Message -
From: Yusuf Incekara <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 7:08 PM
Subject: Mysql Server Client & Myodbc Silent Install
> Is there any spesification for
> Installing Mysql Server Clients & Myodbc.
Hi!
This release should fix the final bugs we accidently got into 3.23.34
and a long security bug that has been in MySQL a long time!
The main fixed bugs are that UPDATE didn't always use keys when
updating on something not based on a primary key and that 'affected
rows' wasn't returned to the
Try
SELECT name, min(score) FROM grades
GROUP BY name;
--Greg Johnson
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 11:14 AM
To: [EMAIL PROTECTED
Use GROUP BY
SELECT names, score FROM grades GROUP BY names
regards,
-- Andrew
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 11:14 AM
Subject: Distinct Selects...
> Q: I have the following table "grades":
>
> +++
1 - 100 of 151 matches
Mail list logo