hi,
what is the function of nvarchar...is it can use in mysql7.
sql
thanks in advance
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
--
On Thursday, 11. April 2002 02:11, Fei Chen wrote:
> How do I write a UDF to handle a entire tuple, e.g. is it possible to have
> select my_udf(*) from myTable;
> ?
Parmeters in the UDF could also be fields from a table.
> Also, is there a way for a UDF to return a data structure, say, a multi
the command (run from my mysql basedir) "share/mysql/mysql.server start"
gives me this message
-
Starting mysqld daemon with databases from /usr/local/
mysql/var
020411 17:25:51 mysqld ended
Thats it. MySql wont start, I cant connect to MySQL. Any Help?
Thanks
Hi
Thank for the information...
I want to receive more detailed information...
In a context of increase of reliability of systems of e-commerce
on a basis MySQL+PHP+Apache.
The variant with organization a mirror - database is interesting.
But there is a question how to organize duly connection
Hi
Thank for the information...
I want to receive more detailed information...
In a context of increase of reliability of systems of e-commerce
on a basis MySQL+PHP+Apache.
The variant with organization a mirror - database is interesting.
But there is a question how to organize duly connectio
Hi,
I'm using the mysqlclient_r library to access the database.
I have written some code as an interface to access the MYSQL databse and
have written the following test code to test the library.
I'm using Linux 2.4.4-4 as the platform.
I'm putting locks around my entire test case so that two thre
>Description:
When attempting to modify a column from varchar(40) to char(40) the command
returns successfully, however the table is unaltered
>How-To-Repeat:
(prepare a table table_name with a column column_name varchar(40)
alter table table_name modify column_name char(4
I run libranet 1.9.1, and it had an option during install to change hostname,
and me not knowing anybetter customized it a little
/etc/hosts says:
127.0.0.1 blindjule localhost
can i just change the blindjule back to localhost? will that fix it? or will
i have to reinstall certain s
Ir. You got rid of localhost? :) D'oh!
What kind of system is this running on?
If it's a Unix type, what do you have in /etc/hosts?
--
sh
On Wed, 2002-04-10 at 19:19, Jule Slootbeek wrote:
> Hey,
> i just installed MySQL and i can't change anything since it's configured to
> search for local
Hey,
i just installed MySQL and i can't change anything since it's configured to
search for localhost, but my localhost name is something else, how do i
change this?
I know it was stupid of me to change the hostname in the first place, but i
didn;t know what i was doing, being a newbie and all.
I have a mySQL database with two tables that I am
trying to perform a Left Join upon. Table A has
approximately 38000 records and Table B has
approximately 43000 records. If I do a Inner join on
the tables on the ID field it takes less than 1 second
to perform the select statement. If I perform a
Hi
I did some digging on this going back. From memory, the ODBC drivers vary a
little from version to version of Sage. I think they are also read only,
which may not be a problem if data is only being imported into mysql.
I contacted a local Sage reseller who was very helpful, and knew Sage over
I don't believe you could do that with a single SQL statement. The best
way would be to build intelligence into an application that would look at
the search term, determine if it is a plural by looking up it some sort of
dictionary, and then use the singular in the form %singularsearchterm%.
At 15:18 10/4/2002 +0200, [EMAIL PROTECTED] wrote:
Hi!
>Thank you for your help, but I know that I must compile kernel (mysqld)
>with this char set. But, this I can do with Unix (or Linux, etc.). What
>can I do with kernel for Win32? Is any mysqld with char set win1250
>compiled in?
The 4.01 W
Ken,
On Wed, Apr 10, 2002 at 01:24:46PM -0400, Ken Menzel wrote:
> Hi Nick,
>I am seeing some rather strange problem here with mysqldump, after
> trying very hard to reproduce the problem on a test server, I gave
> up. Do the options make any difference when you run it? Can you send
Thanks
This is not clear from the manual. - Works fine now though.
Benjamin Pflugmann wrote:
>
>Hi.
>
>You have to use backticks (`) instead of single quotes (') as in
>
>CREATE TABLE TEST (`ID` INTEGER)
>
>When MySQL has been started with --ansi, double quotes (") will have
>the same meanin
Dear all,
I'm new to writing UDFs in MySQL so please bear with my couple of
questions.
How do I write a UDF to handle a entire tuple, e.g. is it possible to have
select my_udf(*) from myTable;
?
Also, is there a way for a UDF to return a data structure, say, a multi
dimensional array? Or do I n
Hi all,
I want to insert the string 'c:\Repository\Pack\' into a mysql table
using java and I did it as follows:
sql = "INSERT INTO files (filepath) VALUES ('c:\Repository\Pack\' )";
insertStmt.execute(sql);
I got an error and I know I should add an extra '\' to escape each of
the '\' in the ab
Two of my co-workers attended the MySQL training in San Francisco last
month. We have successfully installed 4.01 on a SUN Ultra 250 running
Solaris 2.8. Four myisam tables were created and populated. When we
tried
to install the same software on a SUN Sparc 20 running Solaris 2.6
errors
were
O.K. dumb question. A bigger string can't be contained in a smaller one.
But how can I make it so someone searching "dogs" can pull up an item that
contains dog?
Thanks,
SW
On Wednesday 10 April 2002 17:58, you wrote:
> In "MySQL" it says that adding the following to a where clause:
> like "%$s
> where can I find a simple php to generate a default html table
> from a MySql table ?
Try this (but specify your own username, password, database name, and query string
in the first three lines):
");
$numcols = mysql_num_fields($res);
// output field names for column headings:
for ($i=0;
You are searching for the word "dogs"...that word is not contained in
the word 'dog' or the phrase 'dog house.'
If you searched for '%dog%' you would get both of those results.
The wildcard character allows any other character in it's place...hence
'%dog%' finds 'mydog', 'mydogs', etc, etc...it
On Wed, Apr 10, 2002 at 11:18:14AM -0500, Henning, Brian wrote:
> Hello-
>
> I am a Sybase user with a mysql question. Does mysql do bulk copy
> (bcp)? Bulk copy allows a mass copy from a file a database and vice
> versa. I know there is mysqldump but, i am not sure if that is what
> i am looking
At 1:08 PM -0700 4/10/02, va ku wrote:
>
>We are developing a webbased serch application on MYSQL and PHP. I
>am sure most of you must have already implemented
>such application. Could you share with me the logic of such
>application. We were planning to keep a keyword search
>and my people fee
Does anyone know how Innobase would handle this query? If it would lock all
of the rows within the table, or attempt to find all of the rows within the
table instead of just finding the first X in my LIMIT and locking those and
updating those? I have a table with 1 million rows as my example WHE
In "MySQL" it says that adding the following to a where clause:
like "%$somestring%";
should select matches that contain $somestring in them anywhere.
However when I use it I find that if e.g. I have an entry "dog" in the
database, if I search for "dogs", it doesn't come up. Also if I search
Many thanks for any assistance:
I have data (classified ads) in a text file that I would like to load
into a table. The problem is that, as classifieds, they are broken down
by class and sub-class. For instance:
0031 - Announcements
- Notices
One ad
Two ad
- Tick
Hi
Change your WHERE statement
to
WHERE stns.stns_id=1
AND table.ent_nws_id <> "3" '
HTH
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-2
On 10 Apr 2002, at 17:23, Mike wrote:
> $result = mysql_query("SELECT
> ent_nws_id,img_path,substring_index(ent_body, \".\" ,1) AS ent_body FROM
> stns,images INNER JOIN ent_nws ON stns.stns_id=ent_nws.stns_id and
> images.img_id=ent_nws.img_id WHERE stns.stns_id=1",$db);
>
> I'd like to lea
Try building libmysqlclient_r with your local pthreads, the same ones
you're using in the application it self.
ie --with-pthraed=-pthread or --with-pthread=-lpthread
Shivam K Shah wrote:
>
> Hi,
>I have written the following test case in which I'm trying to access
> the database using d
Hi,
I've been trying to find some info on running a select statement that would
return a few rows and leave out one specific row.
Here is my select statement:
$result = mysql_query("SELECT
ent_nws_id,img_path,substring_index(ent_body, \".\" ,1) AS ent_body FROM
stns,images INNER JOIN ent_nws
Hi
We are in the process of developing Ultra High Availability ecommerce sites
based on php and MySql.
1. The software itself is well tested
2. The site is duplicated on two or more servers in separate data centres,
with live replication.
3. Nameservers for the domain are on the s
Hi,
I have written the following test case in which I'm trying to access
the database using differant threads each thread calls this function
test2(), access to which is protected by a pthread_mutex_lock() at the
beginning of the test and pthread_mutex_unlock() at the end of the test.
The same
I'm trying to compile my program using libmysqlclient_r
--enable-thread-safe-client.
Would using mysql.h suffice or is there any specific header file to be
included.
I'm asking this because mysql_thread_init() call is not being recognized
when I'm trying to compile the program
regards
Hello,
This is an announcement of a new product that will interest some of you.
I have completed work for the first Beta release of a native ADO.NET
provider to MySQL.
You can find the details at http://www.mattculbreth.com/eidmysql.
Thank you,
Matt Culbreth
---
Hi
Installation packages for the Raq range can be found at
http://pkgmaster.com/packages/raq/
>From the main control panel go to 'Control Panel' and 'Install Software'
MySql for Raq2 is not there, though it is for Raq3 and above, so perhaps
worth a try.
I installed it and it was almost 'hand
Sorry, new member didn't know whether I should hit reply or send as new message.
SELECT cscflash_mb.email FROM cscflash_mb LEFT JOIN csc_teammembers USING
(email)
WHERE csc_teammembers.tes_email IS NULL;
MySQL said: Unknown column 'csc_teammembers.email' in 'on clause'
What ON clause? Note: in
Folks, I've got a problem with a straight-forward master->slave replication
setup that has failed to replicate some data to the second server (or so it
appears). Below is a bunch of info including the last few lines of
mysqld.log from both servers, specs of the boxes, cron entries, etc... The
odd
` = back ticks next to the 1 and above the Tab, not ' = apostrophe next to
the ; and Enter, you should be able to copy directly from the e-mail
mysql> describe A-14c;
ERROR 1064: You have an error in your SQL syntax near '-14c' at line 1
mysql> describe 'A-14c';
ERROR 1064: You have an error in
mysql> describe 'A-14c';
ERROR 1064: You have an error in your SQL syntax near ''A-14c'' at line 1
It's not working...
- Original Message -
From: "nickg" <[EMAIL PROTECTED]>
To: "David Chen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 10, 2002 2:13 PM
Subject: RE: "-"
Have you tried delimiting the table name with some form of quotes?
> -Original Message-
> From: David Chen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 10, 2002 4:05 PM
> To: [EMAIL PROTECTED]
> Subject: "-" character in table name
>
>
> Hello,
>
> I probably installed a PHP s
Try enclosing it:
describe `A-14c`;
nickg
-Original Message-
From: David Chen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 2:05 PM
To: [EMAIL PROTECTED]
Subject: "-" character in table name
Hello,
I probably installed a PHP script that created a table with a - in its
Hi,
We are developing a webbased serch application on MYSQL and PHP. I am sure most of you
must have already implemented
such application. Could you share with me the logic of such application. We were
planning to keep a keyword search
and my people feel that that will require additional load
Hello,
I probably installed a PHP script that created a table with a - in its name.
I can't figure out how to even touch this table. If I try:
mysql> describe A-14c;
ERROR 1064: You have an error in your SQL syntax near '-14c' at line 1
This table exists for sure though:
| Tables_in_blesysdb
At 10:17 AM -0700 4/10/02, Juan M. Quiroz wrote:
>I'm trying to connect to mysql using lasso but no success.
>The message I get is that there are no databases found.
>
>Our environment is mysql 3.23.49 on osx server 10.1.3 and lasso 5
>
>What do I need to do to connect to mysql from lasso?
Hi Jua
Hi,
We want to use only MYSQL4.0 for our production database. Please let us know when the
Beta release is scheduled.
Regards
See Dave Matthews Band live or win a signed guitar
http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp
Hi,
If I have two mysql tables with two columns for email addresses respectively:
csc_teammembers.tes_email AND cscflash_mb.email
Now, what I want to do is only query those email addresses in cscflash_mb that
DO NOT have a match in the csc-teammembers dbtable.
Can I just do a select statement
Hi.
As I said, or at least, tried to say, a key over all used columns
should help. Adding the column from ORDER BY avoids the "using
filesort". Adding YIADDR (which I simply overlooked last time) should
add "using index", as I mentioned. This means, that the data file is
not touched at all, but o
Well, I haven't kept up on the Cobalt product line, but, I wasn't aware that
they had intel based offerings.
I thought they were all RISC chip based.
That probably explains why I86 binaries won;t install..
If they don't have a binary for Cobalt Cube/RaQ systems, it's compile
time...
Hi,
If I have two MYSQL tables with two columns for email addresses respectively:
csc_teammembers.tes_email AND cscflash_mb.email
Now, what I want to do is query only those email addresses in cscflash_mb that
DO NOT have a match in the csc-teammembers dbtable.
Can I just do a select statement
Hi,
I downloaded mysql Ver 3.23.49 binary to
a local directory. other than (/usr/local)
I changed ./bin/mysqlaccess for MySQL location, etc.
but for some reason it dies as sooon as starts.
I notice that some scripts and files in bin directory
Hi.
You have to use backticks (`) instead of single quotes (') as in
CREATE TABLE TEST (`ID` INTEGER)
When MySQL has been started with --ansi, double quotes (") will have
the same meaning. See http://www.mysql.com/doc/L/e/Legal_names.html
for more info.
Bye,
Benjamin.
On Wed, Apr 10
ben,
I did that about three minutes after I got Davids email. Things seem to be
working a lot faster now, and the "using filesort" is gone. i am assuming
there isn't much more i can do to make this thing faster, but anything else
i can do would be awesome!
heres is the explain:
mysql> expla
http://www.php.net/links.php
Mike
- Original Message -
From: "Luigi Stefano Sona" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 10, 2002 12:12 PM
Subject: a little help for a beginner
> Hello,
> where can I find a simple php to generate a default html table from a
Hi.
(I am replying to the wrong mail, because I already delete the one
from Steve...)
The slow part is probably the "using filesort". I am not sure, if it
will work, but try a key over all used column, i.e.
INDEX ( POOL, STATE, TIMESTAMP )
If it works (i.e. if MySQL correctly "sees" that it ca
ANSI92 states that quoted identifiers are delimited by double quotes "
-Original Message-
From: Nicholas A Read <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Date: Wed, 10 Apr 2002 19:39:52 +0100
Subject: Mysql and Quoted Identifiers
>
> Hi,
> I'm using MySQL version 3.23.37 which work
I guess
make install prefix=/home/turner/mysql/test
just isn't an option. How would I request this functionality be provided
in the make file?
Thanks, Dave Turner
On Tue, Apr 09, 2002 at 05:45:04PM -0700, David Turner wrote:
> Thanks, but what I need to do is have
>
> make install install
Hi.
Well, your are right, indexes are not used at all, so ignore
everything about key_buffer and indexes I said, regarding this issue
(but key_buffer=16MG seems small with 1GB anyhow ;-)
Depending on how often you need the query, and how much columns are
involved, you may want to consider to add
Hi,
I'm using MySQL version 3.23.37 which works fine. However I am
currently trying to convert a MS Access database to MySQL and some of
the column names have embedded spaces i.e. "First Name". Now according
to the manual MySQL supports quoting of identifiers (for the above
reason), I can
On Wed, Apr 10, 2002 at 10:06:47AM -0700, [EMAIL PROTECTED] wrote:
>
> Can anyone comment on the stability of the current 4.x MySQL
> release.
>
> I'd be using MyISAM tables and only features which are currently
> available in the 3.23.x series.
For my purposes, the 4.0.x builds I've used are j
On Wed, Apr 10, 2002 at 01:41:30PM -0400, Jeffrey Flowers wrote:
> I have started using MySQL because I want to learn about something new and
> to keep a database of my growing comic book collection, which would be handy
> should something should ever happen to them. In doing this, I have started
On 10 Apr 2002, at 12:16, Jeffrey Flowers wrote:
> Perhaps having a column in my
> database with a serialized, unique record number would be a way to prevent
> this in the future?
That would allow you to delete just one of the duplicates (which you
also do with LIMIT 1 on your DELETE query), bu
I have started using MySQL because I want to learn about something new and
to keep a database of my growing comic book collection, which would be handy
should something should ever happen to them. In doing this, I have started
to think of other ways to use MySQL, such as managing my CD collection
Hi Nick,
I am seeing some rather strange problem here with mysqldump, after
trying very hard to reproduce the problem on a test server, I gave
up. Do the options make any difference when you run it? Can you send
a trace of the actual dump? I was seeing mysqldump terminate in my
case, now
>Description:
I have downloaded a binary version of mysql, perform all installations steps
from the manual. As soon as I started to execute safe_mysqld --user=mysql &
I got a core dump and the program exited. Please help
>How-To-Repeat:
>Fix:
>Submitter
I'm trying to connect to mysql using lasso but no success.
The message I get is that there are no databases found.
Our environment is mysql 3.23.49 on osx server 10.1.3 and lasso 5
What do I need to do to connect to mysql from lasso?
Also, how do I start a deamon at boot?
Thanks
Juan M. Quiro
Katen
The manual has a section on optimization. If you have done
deletes on this table, the table may not be optimized.
Try: OPTIMIZE TABLE RADPOOL1
It does lock the table while doing it.
Other than that, I don't know what else to do.
David
-Original Message-
From: Steve Katen [ma
Can anyone comment on the stability of the current 4.x MySQL release.
I'd be using MyISAM tables and only features which are currently
available in the 3.23.x series.
--
do svidaniya,
~mitch
-
Before posting, please check
>You are 100% correct.
>
>Since MySQL does not support "cursors", I always
>put an auto_increment column in my tables for just
>this purpose.
>
>(This is what other DBMS' do, they just do it behind
>your back)
You're right. I use DBase IV at work and every record has an internal record
number.
>
Try
mysqld --remove
>From the MySQL\bin directory.
I assume you mean a service on NT
Alternatively you can just stop the service in MMC and set it to manual
so it never starts. But I'm guessing this isn't what you want
Let me know
-Original Message-
From: [EMAIL PROTECTED] [mailto:[
You are 100% correct.
Since MySQL does not support "cursors", I always put an auto_increment
column in my tables for just this purpose.
(This is what other DBMS' do, they just do it behind your back)
Unfortunately, the way MySQL really handles result sets doesn't lend itself
to simply adding
mysqld --remove
use
mysqld --help
for more info.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 3:41 PM
To: MySQL-Mailingliste
Subject: Mysqld as service
Hi
How can i deinstall the mysqld as a service?
Thx for help
mfg
El
>Description:
I'm using Mysql 4.0.1 with query caching:
set-variable = query_cache_limit=10M
set-variable = query_cache_size=10M
set-variable = query_cache_startup_type=1
The Command:
mysqldump -q -K -t --t
Hi,
I'm trying to use the old MS Visio Modeler with mysql. I have
downloaded and installed the myODBC driver and set up a DNS. But I keep
getting this connection error:
"Can't connect to MySQL server on 'www.jsicorp.com'(10060)"
I set the username and password the same as what works with phpMy
Hello-
I am a Sybase user with a mysql question. Does mysql do bulk copy (bcp)?
Bulk copy allows a mass copy from a file a database and vice versa. I know
there is mysqldump but, i am not sure if that is what i am looking for. Can
anyone explain?
thanks,
brian
---
I am new to MySQL and I have a test database that I am playing with. Through
an accident while playing around, I ended up with two identicle records in
the database. I did a filter to try and change just one of them but both
would come up, so I couldn't see how I was supposed to delete just one of
Hello,
where can I find a simple php to generate a default html table from a MySql table ?
thanks
Luigi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
»Chuck PUP Payne« sagte am 2002-04-10 um 10:27:19 -0400 :
> going 9, 8, 5, 10 on the dates. Here is the SQL statement I am using...
That's because your DATE which you've made with DATE_FORMAT is treated
as string. To fix it, I'd write:
> SELECT DATE_FORMAT(DATE, '%M %D, %Y') AS DATE, Title, Lin
>Description:
I'm using Mysql 4.0.1 with query caching:
set-variable = query_cache_limit=10M
set-variable = query_cache_size=10M
set-variable = query_cache_startup_type=1
The Command:
mysqldump -q -K -t --ta
i made the change, but it looks like it didn't speed the query up at all.
here are the results from the first explain:
mysql> explain select TIME_STAMP, YIADDR from RADPOOL where STATE=0 and
POOL='GLOBAL-POOL-SJC' ORDER BY TIME_STAMP limit 1;
+-+--+---+---
(one should not mess up strg and shift :-/)
> Hi again...
Hi,
> When I felt proud because last week I had asked about how to
> use NOW(), and
> get answer that got me working, but now I have a strange
> problem. It listing
> dates, but it not listing like it should, when the web page
> is c
Katen
Try using a compound index with STATE and POOL
INDEX ipoolstate( POOL, STATE )
Use EXPLAIN SELECT to see what mysql thinks.
David
PS anybody know if KEY is the same as INDEX?
-Original Message-
From: Steve Katen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 8
also, note that char is changed to varchar in some cases, such as when there
is a text field in the table.
-Original Message-
From: Jon Haworth [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 10:40 AM
To: 'Luke van Blerk'; [EMAIL PROTECTED]
Subject: RE: Char vs Varchar field ty
Your alias and column name are the same.
Which one do you think is being tested?
Also DATE is a reserved word.
Chuck \"PUP\" Payne wrote:
>Hi again...
>
>When I felt proud because last week I had asked about how to use NOW(), and
>get answer that got me working, but now I have a strange problem
> Hi again...
Hi,
> When I felt proud because last week I had asked about how to
> use NOW(), and
> get answer that got me working, but now I have a strange
> problem. It listing
> dates, but it not listing like it should, when the web page
> is create it
> going 9, 8, 5, 10 on the dates. He
It depends on who you talk to and what you want to do. varchar will use
less disk space, but char is faster to access (except for InnoDB tables,
where varchar has the advantage). The benefit is using char is that the
rows have a fixed length so MySQL knows exactly where each row starts and
can
i have been working on getting this query as fast as possible and figured
it was time to come to the mailing list.
the below table currently holds about 43 thousand records with potential to
grow to around 1,000,000 records.
CREATE TABLE `RADPOOL` (
`id` int(11) NOT NULL auto_increment,
Chris,
Wednesday, April 10, 2002, 2:01:05 PM, you wrote:
>> Egor,
>>
>> I'm running :
>>
>> Red Hat Linux release 7.0 (Guinness)
>>
>> on a Pentium III 450 with 128 meg of Ram.
>>
>> Are you thinking I may need to run an older version of Mysql?
Well, this looks very weird to me. The configuation
HITESH,
Wednesday, April 10, 2002, 2:29:23 PM, you wrote:
HP> i installed the client and server files (rpm)
HP> of MYSql for linux , but failed to get the gui working.
HP> could you please help me in this regards.
What exactly doesn't work?
Is it a failure to start MySQLGUI or to conne
Luke,
Wednesday, April 10, 2002, 4:18:48 PM, you wrote:
LvB> When is it appropriate to use Char instead of Varchar and vice versa?
CHAR column type has fixed length, VARCHAR is variable-length string.
CHAR column type appropriate to use when you have data with the same
length. Don't forget that
At 16:41 +0200 4/10/02, Elyasin Shaladi wrote:
>Hi
>
>How can i deinstall the mysqld as a service?
>Thx for help
Shut down the server, then issue this command:
mysqld --remove
>
>mfg
>
>Ely Van Kenobi
-
Before posting, please
Hi Luke,
> When is it appropriate to use Char instead of Varchar and vice versa?
Use CHAR for when you know in advance how many characters are going to be in
that field. A good example is for MD5 hashes: they are always 32 characters
long, so you can use CHAR(32).
Use VARCHAR for when you don't
[EMAIL PROTECTED] wrote:
>
> When is it appropriate to use Char instead of Varchar and vice versa?
Use char when you expect the length of the field to always be the same.
Use varchar when you're not sure.
Basically, when you're using varchar you're assigning a limit to the size
of the string th
Hi
How can i deinstall the mysqld as a service?
Thx for help
mfg
Ely Van Kenobi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To req
Hi everyone,
When is it appropriate to use Char instead of Varchar and vice versa?
Thanks
Luke
mysql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Hi again...
When I felt proud because last week I had asked about how to use NOW(), and
get answer that got me working, but now I have a strange problem. It listing
dates, but it not listing like it should, when the web page is create it
going 9, 8, 5, 10 on the dates. Here is the SQL statement I
Today I have used MM.MySQL-2.0.12 and noticed, that German umlauts are
represented as ?. In MM.MySQL-2.0.7 everything was all right there.
Volker
-
Before posting, please check:
http://www.mysql.com/manual.php (the manua
my boss figured out a nice solution to this
ORDER BY IF(ABS(Item) > 0,LPAD(Item,9,'0'),Item)
This will pad numbers ( ok it might not do so hot with DECIMAL, but it can
be fixed to work I supposed) with 0
So it should sort
1
2
00010
00022
00050
00230
instead o
At 07:55 10-04-02 -0500, Lee, Tom J wrote:
>When we tried
>to install the same software on a SUN Sparc 20 running Solaris 2.6 errors
>were encountered. Something about a missing file 'librt.so.1'. We thought
>the OS version was 2.7. Not correct! I downloaded the binary MySQL version
>3.22.32 f
Thank you for your help, but I know that I must compile kernel (mysqld) with this char
set. But, this I can do with Unix (or Linux, etc.). What can I do with kernel for
Win32? Is any mysqld with char set win1250 compiled in? Or must I download any other
version of MySQL? And which version (wher
1 - 100 of 131 matches
Mail list logo
