Have you checked the manual to be sure that the 65000 varchar is
available to the version of MySQL you are using? Prior to 5.0.3, it was
255 only.
- Original Message -
> *From:* "Krishna Chandra Prajapati" <[EMAIL PROTECTED]>
> *To:* mysql
> *Date:* Tue, 9 Sep 2008 17:54:46 +0530
>
>
Suggest you read the online manual...
- Original Message -
> *From:* "Krishna Chandra Prajapati" <[EMAIL PROTECTED]>
> *To:* mysql
> *Date:* Tue, 9 Sep 2008 17:54:46 +0530
>
> Hi,
>
> I would like to know the difference between char, varchar and text.
>
> char limit 255 character
Look up the LIMIT clause of SELECT statement, also ASCENDING/DESCENDING
- depending on how you want it. Remember LIMIT can take a number and an
offset.
Terry
- Original Message -
> *From:* Renito 73 <[EMAIL PROTECTED]>
> *To:* mysql@lists.mysql.com
> *Date:* Sun, 9 Sep 2007 10:05:52 -0
Learn something every day.
TFT
- Original Message -
> *From:* "Andrew Braithwaite" <[EMAIL PROTECTED]>
> *To:* "coolcoder" <[EMAIL PROTECTED]>,
> *Date:* Thu, 23 Aug 2007 14:19:25 +0100
>
> mysql> select format(300,0);
> +---+
> | format(300,0) |
> +
Not really a MySQL problem, this is a presentation problem. MySQL will
store the number as digits only (unless you are storing in a character
field - but why would you?). If using PHP, for instance, the output of
the field would be
number_format($fieldvalue)
or if you want the answer to two d
- Original Message -
> *From:* Ryan Stille <[EMAIL PROTECTED]>
> *To:* mysql@lists.mysql.com
> *Date:* Sat, 24 Feb 2007 15:28:25 -0600
>
> Ryan Stille wrote:
> > Paul DuBois wrote:
> >> At 4:40 PM -0600 2/20/07, Ryan Stille wrote:
> >>> Is there an easy way to test to see if MySQL already
- Original Message -
> hi,
>
> can new mysql work on Microsoft® Windows Server 2003
>
> regards
>
> prao
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAI
- Original Message -
> I have an InnoDB table in a MySQL 4.1.14 database. Can anyone suggest
> why MySQL Adminstrator says the table has 497 rows, while doing a query
> or a count on the same table shows that it only has 434?
>
IIRC, InnoDB only gives an estimated row count in admin
!
Terry
>See:
> http://dev.mysql.com/doc/mysql/en/slave-logs.html
> http://dev.mysql.com/doc/mysql/en/Binary_log.html
> http://dev.mysql.com/doc/mysql/en/mysqlbinlog.html
>
>
>
> Terry Riley <[EMAIL PROTECTED]> wrote:
> > We are running 4.1.13
We are running 4.1.13 standard on Linux as a master, and 4.1.14 on NT4
as a slave.
Replication seems to work extremely well, except in the following
circumstance.
On the master server, running a query similar to:
insert into zmast.leagueinfo
(countieslist, defaultleaguecode, leaguename ...
- Original Message -
> Terry Riley wrote:
> > I'm running 4.1.13 on Linux as master, with 4.1.12 on XP as slave (in
> > house test setup).
> >
> > This vaguely duplicates what is set up on the live servers, except
> > that the slave is 4.1.3 on N
e
taken before flushing, or you won't ever see that logged data again.
Is this the way it is meant to be? I don't want to institute any log
rotation policy on the slave of the live setup if this happens.
Regards
Terry Riley
--
MySQL General Mailing List
For list archives: http:/
's not being destroyed by the 'rpm -e'.
Does anyone out there happen to know what that is? I've looked at the
archives for the MySQL-GUI and find no reference to this...
Cheers
Terry Riley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
David,
According to the documentation, OPTIMIZE will also work on InnoDB tables.
Will that produce the same result as your ALTER TABLE ?
Cheers
Terry
- Original Message -
> Hi Chris,
>
> For MyISAM/BDB tables use OPTIMIZE TABLE ;
> For InnoDB tables try ALTER TABLE TYPE=InnoDB;
>
>
Luke
- Original Message -
> This error message seems a bit different than others I have gotten. it
> is from a ColdFusion server that uses an ODBC driver...
> ODBC Error Code = S1000 (General error)
Which version of CF are you using?
If it is MX6.1, surely you can use a native MySQL
Thanks, Joshua - just the sort of info I needed.
Off to find a more recent distro
Cheers
Terry
- Original Message -
> On Friday 11 February 2005 09:15, Terry Riley said something like:
> > Having inherited an elderly PIII/500MHz box with an 8Gb SCSI disk,
> > that ha
the msi installer.
>
> Now the question: If I'm only using this as a database (no development)
> on RH7.3, which is the preferred download? I am confused by the
> plethora of options available for Linux. Just need something that is
> relatively simple to install (either 4.1.9 or 5
load? I am confused by the plethora of
options available for Linux. Just need something that is relatively simple
to install (either 4.1.9 or 5.0.x).
Suggestions, please?
Cheers
Terry Riley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
Something like:
select
fh1109.state,
fh1109.cd,
fh1109.party,
fh1109.representative,
ssa1202.total,
((total-children*percentunder18)/vapall)*100,
ssa1202.retired_workers,
ssa1202.disabled_workers,
ssa1202.widow,
ssa1202.wives_and_husbands,
ssa1202.children
from ssa1202, fh1109, vapall
y-write, so I assume therefore
that there is no harm in changing flush_time to zero.
Any ideas on the second part of my question (which tables are counted)?
Cheers
Terry
>
>
> Terry Riley <[EMAIL PROTECTED]> wrote:
> > We're running mostly with InnoDB tables, about 5%
> &
is 130.
What other tables are counted in the opened_tables calculation; does this
include tables that may be opened twice under different aliases? Does this
include temporary tables (created by MySQL)?
Cheers
Terry Riley
--
MySQL General Mailing List
For list archives: http://lists.mys
Heikki,
- Original Message -
> Terry,
>
> - Original Message -
> From: "Terry Riley" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.myodbc
> Sent: Monday, December 06, 2004 8:15 PM
> Subject: Locking Issue?
>
>
> > Can so
- Original Message -
Thanks for those hints, Dathan (see below):
>
> -Original Message-
> From: Terry Riley [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 06, 2004 10:12 AM
> To: [EMAIL PROTECTED]
> Subject: Locking Issue?
>
> Can someone help,
et=16M
set-variable=key_buffer=8M
log-bin=
log_slow_queries=
[mysql]
local-infile=1
Any pointers as to what I may be doing wrong? Please?
Yes, I know we should upgrade to 4.1.7, and we will - soon.
Cheers
Terry Riley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Replying to my own message:
- Original Message -
> We are shortly to go live with a new set of databases (InnoDB).
>
> The data in each database is identical in fields and types, the only
> difference being in the relevance of the data - they are soccer
> leagues, and each database re
We are shortly to go live with a new set of databases (InnoDB).
The data in each database is identical in fields and types, the only
difference being in the relevance of the data - they are soccer leagues,
and each database represents information on the leagues/teams for a
single season. There
You can't - auto_increment cannot have a default value, AFAIAA.
Terry
- Original Message -
> mysql> create table list_admin (
> -> admin_id int(11) default '0' not null auto_increment
> -> );
> ERROR 1067 (42000): Invalid default value for 'admin_id'
>
> How can I set default va
the Server and the Administrator, but am
unable to until we have some downtime.
Can I assume that, as the server is still running (apparently without
problems) that the reported fault is only to do with Admin trying to read
the log files, and nothing more serious?
TIA
Terry Riley
--
MySQL Gener
All sorted now, Ian.
- Original Message -
> Hope this helps
>
> If not try this (joking):
>
> http://foldoc.doc.ic.ac.uk/foldoc/foldoc.cgi?RTFM
>
> Ian
> --
That's what was missing. LOL
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
rator (v 1.0.12)
> and at the command line opening of mysql.
>
> Have I done something stupid, or are others seeing this, too?
>
> Terry Riley
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
directory have creation
> dates on or about 27 August, the documentation is for 4.1.4gamma, so it
> does look as though the upgrade went through, as far as copying files is
>
> concerned.
>
> Just restarted again with no change (just in case). Any other clues?
>
> Terry
&g
about 27 August, the documentation is for 4.1.4gamma, so it
> does look as though the upgrade went through, as far as copying files is
>
> concerned.
>
> Just restarted again with no change (just in case). Any other clues?
>
> Terry
>
> - Original Message ---
s for 4.1.4gamma, so it
does look as though the upgrade went through, as far as copying files is
concerned.
Just restarted again with no change (just in case). Any other clues?
Terry
- Original Message -
> Terry Riley <[EMAIL PROTECTED]> wrote:
> > I have tried several instals
mysql.
Have I done something stupid, or are others seeing this, too?
Terry Riley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I think you'll find that 'create procedure' and 'create function' don't
appear until version 5.0 of MySQL.
Which is why you get a syntax (are you sure you have the right version?)
error.
Regards
Terry
- Original Message -
> Hi!
> Anybody knows how to use CREATE PROCEDURE and CREATE FU
Stuart, why not change your select statement (assuming it is correct and
actually works, in and of itself) to give the date-formatted field an
alias:
SELECT
LFWJobBank.JobReferenceCode,DATE_FORMAT(LFWJobBank.Entered,'%m/%d/%Y') AS
date_entered,
LFWJobBank.DazeLeft, LFWJobBank.JobTitle
FROM LFWJ
Stuart,
If the field is the only (or first) timestamp-type field in the table
columns, then the record will automatically have the current date/time
inserted when it is added. The only (or first) timestamp field will *also*
be updated every time you update the record.
View the timestamp field
Stuart
Could this be something as simple as the fact that you have a field with a
space in its name ('Contact Email'), which is sometimes called as 'Contact
Email' and sometimes as 'Contact_Email'?
I'm not even sure if a blank space is actually allowed in
I'd go along with that recommendation.
Terry
- Original Message -
> Welling & Thomson is terrific.
> - Original Message -
> From: Kerry Frater
> To: "MySQL List"
> Sent: Thursday, August 12, 2004 8:09 AM
> Subject: recommended books for web app.
>
>
> I am looking t
CONCAT() is what you need!
SELECT CONCAT(Firstname,' ',Lastname) AS Name FROM Users;
Terry
- Original Message -
> Hi,
>
> Is it possible to join two fields in a query so that they are displayed
> as one column? For exmaple:
>
> SELECT Firstname + ' ' + Lastname AS 'Name' FROM Users;
I think the error is self-explanatory - you can't use auto_increment in a
heap table (but you can have an index)
Terry
- Original Message -
> I couldn't get temporary table to load into memory using type=heap,
> here's
> the sample error as following:
>
>
>
> mysql> create table tbl
Thanks to all who replied.
Regards
Terry Riley
- Original Message -
> We have the query cache turned on, and it appears to be working well.
>
> However, there appears to be no indication in the manual as to the time
> that a cached query remains in memory. In the abs
if the cached query is
called before the timeout.
Regards
Terry Riley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ed by the documentation), but
I'm still miffed by this set of entries.
Any hints would be gratefully accepted.
Cheers
Terry Riley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
passwords. Killing these off, restarting
with --old-passwords and redoing them as 16-char passwords allowed CF to
register the DSNs.
Hope this might help someone else who's going prematurely bald.
Cheers
Terry Riley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
No problem, Heikki.
It's just a bit disconcerting to see '1' when '0' is expected. As for
larger numbers, I realise that the rowcount is only an estimate for
InnoDB.
Cheers
Terry
- Original Message -
> Terry,
>
> thank you for reporting this. Since the cardinality reported by SHOW
>
alpha.
SELECT COUNT(*) retrieves the correct number, however.
This is not the case for the MyISAM tables, which show the correct numbers
at all times.
Is this supposed to happen?
Terry Riley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
MX)? Can't see why the DISTINCT clause should change a
string to a ByteArray
Any help would be appreciated.
Terry Riley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Pieter,
I think FTS minimum WORD size is 4 characters - you may to be searching
with 3 on 'May May'.
Not having ever used FTS; I believe you can adjust it to count 3-character
words by changing the configuration, but I'm not sure where - and it would
then need re-indexing, if I'm not mistaken.
Just a suggestion, Kevin, but how about changing from INT to BIGINT?
Terry
--Original Message-
> We have a table with a primary index which is INT NOT NULL
> AUTO_INCREMENT.
>
> After inserting ~87,000,000 entries, we started seeing error 1062,
> ER_DUP_ENTRY.
>
> We can ge
gt; --
> Chris W
If I understood the question correctly, what you need is something like:
SELECT @totaldates:=COUNT(DISTINCT date) FROM Table;
SELECT COUNT(*)/@totaldates AS Average
FROM Table;
Regards
Terry Riley
--
MySQL General Mailing List
For list archives: http://lists.mysql.
Probable cause: 'order' is a reserved word in MySQL (as used in 'order
by').
Terry
--Original Message-
> I have a field named "order" i think im missing something obvious, but i
> cant find it.
> When i insert something on the field order via PHP, no data on all of my
> field
Also interested in answer to this one.
Terry Riley
--Original Message-
> Hi List,
>
> When can we expect limits in sub-queries? I am currently on 4.1.0.
>
> 1235 - This version of MySQL doesn't yet support 'LIMIT &
> IN/ALL/ANY/SOME
>
Occasionally, when looking at the processlist using MySQLAdmin, I see
entries
'unauthenticated user' 'reading from net'
Would some kind person tell me what this means, and if I'm in danger of
having data compromised?
Thanks
Terry Riley
--
MySQL General Mailing Lis
Take a look at LIMIT in the Manual
Cheers
Terry
--Original Message-
> eg. say a table is created using:
>
> create table fred (f1 char(10), f2 int)
>
> Then it has neither keys nor an AUTO_INCREMENT field.
>
> Let's say 1000,000 records are then inserted into table fred
Subselects are only available from 4.1 - that's why you have an error.
Terry
--Original Message-
> Hi all
> I have Mysql 3.23.45 on linux.
>
> while trying this command :
> SELECT outbox_id
> FROM outbox
> WHERE send_time=(SELECT MAX(send_time) FROM outbox WHERE
> subs_id=
> Hello Terry,
>
> Tuesday, March 9, 2004, 6:25:00 PM, you wrote:
>
> TR> Good point, Richard. I was perhaps in a little bit too much of a
> > hurry
> TR> putting that together, and didn't even consider that!
>
> No worries. One other thought that occurred to me that might help with
> the o
See below:
--Original Message-
> Hello Terry,
>
> Tuesday, March 9, 2004, 5:11:00 PM, you wrote:
>
> I know you have some solutions to the original problem already, but I
> just wanted to make one small observation:
>
> TR> The fields are to be CounterCode (Varchar 10), Count
an be fairly certain that the record exists (or can code around it if
it doesn't), so I'll probably stick with what I've got.
Thanks anyway!
Terry
>
> - Original Message -
> From: "Terry Riley" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
Thanks, Jeremy
What I actually needed was:
UPDATE Table
SET CounterValue = CounterValue+1,
CounterStartDateTime =
IF(CounterStartDateTime IS NULL, Now(), CounterStartDateTime)
This prevents it going back to NULL if the value is already not NULL.
Thanks again.
Terry
--Original Messa
-line manual, and cannot find any reference to
such conditional updates. Perhaps I missed it.
Any clues, please?
Cheers
Terry Riley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Think that is for your script to work on, i.e.
INSERT INTO table
(field1, field2)
VALUES (UCASE('form.field1'), form.field2)
depending on the syntax of your programming language (and which MySQL
version you are using). The above works on 4.1.1.
Terry
--Original Messag
Try ABS()
Terry
--Original Message-
> Hi all,
>
> I m looking for any function or a work around to fetch numerical data
> without its sign (-10 --10, 10 --> 10). Any ideas?
>
> Thanx
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
I think it should be:
SELECT * FROM articles
WHERE sectionID=1
ORDER BY Entrydate Desc
LIMIT 1,10
Terry
--Original Message-
> Any idea what is wrong with the following:
>
>
> SELECT * From articles ORDER BY EntryDate DESC
> LIMIT 1,10
> WHERE SectionID=1
>
> I want to retur
x27;t
> >find this file in the temporary folder.
> >Can you help me on this regard
> >
> >Thanks and Regards
> >Saurabh Sharma
> >
> >Fidelity Brokerage Technology
> >
> >--
> >MySQL General Mailing List
> >For list archives: http://lists.
.
How can I upgrade from 4.0.17, please? Or even start again from scratch
with 4.1.1?
Regards
Terry Riley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks, Bruce, Roger
Terry Riley
--Original Message-
> Currently running 4.0.17 InnoDB on XP/Apache 2.0.47; client wants to
> investigate using capability for stored procs in v5, but doesn't have
> another machine on which to experiment. Can these two be run
Currently running 4.0.17 InnoDB on XP/Apache 2.0.47; client wants to
investigate using capability for stored procs in v5, but doesn't have
another machine on which to experiment. Can these two be run on the same
machine (though not at the same time)?
Regards
Terry Riley
--
MySQL Ge
Michael
--Original Message-
> I am trying to select the firstname and surname fields from a table.
>
> select firstname + surname fullname from people;
>
> This does work in other databases but does not seem to work here.
>
> Am I doing something wrong or is there a diff
Gary
Does your php code use persistent connections?
mysql_pconnect() rather than mysql_connect() ?
If so, that would ramp up the CPU usage fairly quickly, AFAIAA.
Just a thought
Terry
--Original Message-
> Hi all
>
> Is there anybody out there who has managed to successful
Dan
What you may be looking for (and I had to hunt around to find it myself!)
is
myisamchk -eis table_name
Hope that helps - just because you don't get an answer doesn't mean we
don't care - it probably means we don't know.
Terry
--Original Message-
> Ok, if this is th
As far as I'm aware, in php you can only do one statement per call.
Terry
--Original Message-
> Hi there,
>
> When i try to do the following in PHP I get errors. Is this not
> permitted or is this due to a setting somewhere? Can i do only one SQL
> statement per call to mysq
--Original Message-
>
> CREATE TABLE nuke_contactbook(
> workphone varchar( 255 ) ,
> homepage varchar( 255 ) ,
> IM varchar( 255 ) ,
> events text,
> reminders int( 11 ) ,
> notes text,
> PRIMARY KEY ( contactid ) ,
> KEY contactid( contactid ) ,
> KEY uid( uid )
You seem
Hi, I've been struggling for a couple of days trying to get phpMyAdmin to
accept csv files for data uploads onto my hosted MySQL, and was having no
success using v2.5, despite 'local file being switched On at both ends.
My ISP just installed v2.5.1 and whooppe! it works.
I wouldn't normally
Vielen Dank, Mark
Cheers
Terry
--Original Message-
> Use "source " from the mysql command line
> Start mysql in the bin directory, switch to the db in use via "use
> "
> and run the command "source "
>
> Or read the manual section "3.6 Using mysql in Batch Mode"
>
> Cheers
Yes
--Original Message-
> Hi,
>
> I have written a program that creates statments for me, and sometimes I
> end
> with
> SELECT..WHERE number IN(1)
> instead of
> SELECT... WHERE number IN(1,2,3,4)
> would number IN(1) works,
> for the moment i have no mean to test it, it
try, in my ignorance, ends with
a 'SQL query error' or similar.
Help, please, I'm not used to this command-line stuff!
Terry Riley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This may be a PHP rather than MySQL issue
I'm using 4.0.13 on Windows XP and Apache 1.3.
My phpinfo() shows (among others) QUERY_STRING and REQUEST_URI in the
Apache environment and _SERVER["QUERY_STRING"] with _SERVER["REQUEST_URI"]
under the PHP variables.
On my ISP, who is running W2K/I
Great!Didn't know you could do that.
Cheers
Terry
--Original Message-
> I think I found another answer to my own question. FYI a good way to
> return
> results in a random order
> SELECT user FROM table ORDER BY RAND()
>
--
MySQL General Mailing List
For list archives:
Scott
--Original Message-
> What would be the most efficient query to determine the number of rows?
>
Probably something like
SELECT COUNT(*) AS rectotal FROM table ?
Cheers
Terry
PS - better to reply direct to list rather than individual, as you seem to
have done on this
Scott
--Original Message-
> I have a database table with say 100 rows. What I would like is to
> preform
> a query starting at a random place within the table, that will wrap
> around
> if I want it to. That is if the query starts returning results at the
> 98th
> row, then
81 matches
Mail list logo