DESC is a reserved word in MySQL: it is short for DESCENDING and is used
to reverse the sort order in SELECTs. You an create a field with that name
by enclosing it in backticks: `desc` whenever you need it. However, this
would be regarded by many as very bad practice. It would be better to
chan
The battle has been fought before - and the list administrator has given
his reasons why he has not made the requested change. The way the list
currently behaves is not an accident or omission, but a deliberate
decision. I do not recall the grounds for that decision - maybe RFCs or
the behaviou
news <[EMAIL PROTECTED]> wrote on 06/04/2006 14:39:33:
> IF I have a table like this:
> id int not null,
> field2 int not null,
> ..,
> primary key (id),
> key (field2)
> ) ENGINE=MyISAM;
>
> The primary key is id only or (id, field2)?
> If this is the case which constraint are aplied on fiel
[EMAIL PROTECTED] (saf) wrote on 23/03/2006 16:10:04:
> On Thu, Mar 23, 2006 at 11:04:55AM -0500, [EMAIL PROTECTED] wrote:
> > [EMAIL PROTECTED] (saf) wrote on 03/23/2006 10:50:10 AM:
> >
> > The short answer is "no". The Record #2 already existed. It's current
> > status is "deleted". If you h
"Rhino" <[EMAIL PROTECTED]> wrote on 21/03/2006 13:41:49:
>
> - Original Message -
> From: "Zsolt" <[EMAIL PROTECTED]>
> To: "MySql Mailing List"
> Sent: Tuesday, March 21, 2006 2:58 AM
> Subject: How to shutdown mysql from Java
>
>
> > Hi,
> >
> > my application starts mysqld (via Ru
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 16/03/2006 11:32:45:
> From: <[EMAIL PROTECTED]>
> > "Martijn Tonies" <[EMAIL PROTECTED]> wrote on 16/03/2006 11:02:32:
> >
> > > Well, the question still is if you should store "unknown" at all ;)
> > >
> > > Not according to Date: you should store wh
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 16/03/2006 11:02:32:
> Well, the question still is if you should store "unknown" at all ;)
>
> Not according to Date: you should store what is known. See the remarks
> about the "true propositions", from which relational databases are
derived
> (but
nigel wood <[EMAIL PROTECTED]> wrote on 14/03/2006 13:09:08:
> [EMAIL PROTECTED] wrote:
>
> >"Paul Halliday" <[EMAIL PROTECTED]> wrote on 14/03/2006 12:09:10:
> >
> >
> >
> >
> >>As an example:
> >>
> >>There was a table called event.
> >>
> >>This table is now broken up like this:
> >>
> >>even
"Paul Halliday" <[EMAIL PROTECTED]> wrote on 14/03/2006 12:09:10:
> As an example:
>
> There was a table called event.
>
> This table is now broken up like this:
>
> event __.
>
> So for every sensor, and every day, there is now a new table. So if I
> have 20 sensors, every day I will have 20
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 14/03/2006 11:32:10:
> Hello Paul,
>
> I suggest you reply to the mailinglist :-) ...
>
> > The developer insists that for scalability issues, this was the
> > answer. It is likely, for example in my deployment, that these tables
> > would see upward
Ronan <[EMAIL PROTECTED]> wrote on 16/02/2006 11:56:18:
> Im trying to set up a primary key of server(text), date (date), hour
> (small int) but when i try to include the server field in the key it
> replies with
>
> ALTER TABLE `exim` DROP PRIMARY KEY ,
> ADD PRIMARY KEY ( `date` , `hour` , `s
Al Sparks <[EMAIL PROTECTED]> wrote on 13/02/2006 16:11:49:
> Basically, I'm new to mysql (or to any database for that matter).
>
> I have an old version installed on my linux machine. I thought, as a
> learning exercise I'd take 2 files (tab separated tables) load them
> into mysql and then mer
Patrick Duda <[EMAIL PROTECTED]> wrote on 10/02/2006 16:28:56:
> I guess I don't understand this locking stuff. I have a InnoDB table
that
> has one thing in it, a counter. All I want to do is have multiple
> instances of the code read this counter and increment it. I want to
make
> sure t
"David T. Ashley" <[EMAIL PROTECTED]> wrote on 07/02/2006 14:03:04:
> Hi,
>
> I have several tables linked in various ways so that an inner join is
> possible. However, at the same time and in the same SQL query, I'd also
> like to query by some field values in one of the tables.
>
> Two quick
To reply to this, I think we have to understand why you have chosen to
split the tables at all. It seems to me that this, by introducing a
two-level lookup, is certain to be slower than any possible single table
lookup. Generally, Log A + log B is bound to be larger than log (A*B).
It appears
AmirBehzad Eslami <[EMAIL PROTECTED]> wrote on 24/11/2005 18:36:25:
> On 24/11/2005, Alec worte:
>
> > I think this is your problem: MySQL does not properly support
Unicode
> > until version 4.1. I am successfully using FullText with MySQL
> 4.1 to sort
> > UTF-8 encoded Japanese text.
AmirBehzad Eslami <[EMAIL PROTECTED]> wrote on 24/11/2005 17:48:29:
> Dear list,
>
> I'm considering programming a simple "Search Engine" for a website,
> to find Arabic/Persian data within a MySQL database.
> This database contains a huge amount of data, encoded with
Unicode(UTF-8).
>
>
Brian Dunning <[EMAIL PROTECTED]> wrote on 02/11/2005 16:22:29:
> I'm trying to find a list of customers including a count of all their
> invoices, but it's not including customers who have no invoices - and
> it should. What's broken?
>
> SELECT customers.company, count(invoices.id) as invcoun
"Xiaobo Chen" <[EMAIL PROTECTED]> wrote on 01/11/2005 20:28:38:
> Hi, all
>
> I have a question like this:
>
> There's a field in table_A, date_time, if I say this in Mysql:
>
> select min(date_time), max(date_time) from table_A;
>
> it returned something like this:
>
> +-
Andreas Steichardt <[EMAIL PROTECTED]> wrote on 24/10/2005 10:34:08:
> Hi!
>
> I just hit something really strange which is either a bug in MySQL or a
> dumbness bug of me.
>
> I am trying to insert a string ending with a simple space and i really
want
> this space at the end of my string ;).
[EMAIL PROTECTED] wrote on 21/10/2005 12:28:18:
> Hi,
>
> I had installed a free version of mysql database software in one of the
> servers that are available to me. I had installed the mysql in the c:/
> folder, is it possible for me to change the data storage location from
> C:\mysql\data\
news <[EMAIL PROTECTED]> wrote on 17/10/2005 15:45:15:
> I need it some info to help a client defend against a legal challenge.
> Is there a MySQL function that will allow me to ascertain the date and
> time that a particular field's value was last updated. I can't find
> anything in the MySQL
"Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> wrote on 14/10/2005
03:28:15:
> Hi Listers,
>
> Does anybody know if the MyISAM engine (apart from InnoDB) allows the
> use of raw disk space rather than having cooked files? If not, is this
> feature likely to be included in a future release?
Hugh Sasse <[EMAIL PROTECTED]> wrote on 13/10/2005 16:27:44:
> I'm fairly new to MySQL and am getting an error messages like:
>
> ERROR 1064 (42000) at line 5: You have an error in your SQL syntax;
> check the manual that corresponds to your MySQL server version for
> the right syntax to use near
gt;
>> I like to hear from you.
>
> I think you are wrong in your presumption that there are individual
> indexes. Consider a telephone directory: this may be regarded as indexed
> on FamilyName, GivenName. There is only one index even though it is over
> two fields (th
is only one index even though it is over
two fields (the order in the telephone directory). You would only need
another index if you wanted to search over GivenName,FamilyName. This
would then require an extra index, which would have to be put in the back.
Alec Cawley
--
M
Yannick Warnier <[EMAIL PROTECTED]> wrote on 03/10/2005 11:18:05:
> Hi all,
>
> Using PhpMyAdmin, I seldom get the warning message:
> PRIMARY and INDEX keys should not both be set for column `ID`
>
> I understand its meaning, but I was wondering to what extent having a
> field indexed AND being
Vinayak Mahadevan <[EMAIL PROTECTED]> wrote on 27/09/2005 11:28:51:
> [EMAIL PROTECTED] wrote:
>
> >Vinayak Mahadevan <[EMAIL PROTECTED]> wrote on 27/09/2005 04:55:13:
> >
> >
> >
> >>I am creating an application in Visual Basic 6.0 which will require a
> >>centralised database server. All this
Vinayak Mahadevan <[EMAIL PROTECTED]> wrote on 27/09/2005 04:55:13:
> I am creating an application in Visual Basic 6.0 which will require a
> centralised database server. All this while I had been planning to use
> MS-Access. But then I found out that MS-Access is ok to be a desktop
> rdbms but
Sid Lane <[EMAIL PROTECTED]> wrote on 19/09/2005 15:02:58:
> stupid ?:
>
> what keeps them from getting caught in a write loop? turning off
> log_slave_updates?
>
> I had never thought of this but is has intriging possibilities...
Each update is marked with the unique server id of the server w
Scott Haneda <[EMAIL PROTECTED]> wrote on 15/09/2005 10:31:48:
> I have moved my data from mysql 3 to 4, across various updates, over the
> past few years. I use phpmyadmin generally, and it defaults to making
tables
> myisam.
>
> I can not seem to find a really clear answer as to why I want to
"'Yemi Obembe" <[EMAIL PROTECTED]> wrote on 08/09/2005 10:33:25:
> Talking limit (in select query), does it "limit" the search result
> after ordering according to relevancy and the likes, or before?
> thanks
LIMIT operates after ORDER BY.
Alec
--
MySQL General Mailing List
For l
that platform is marketed by a company who many of us
find totally repulsive. If you let yourself be hyped into dropping MySQL,
you will be harming a company that is, in my opinion, a model of how to
provide full commercial quality software (or better) with an Open Source
licence, while not
insensitive throughout, so do as you will.
Alec Cawley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
m i l e s <[EMAIL PROTECTED]> wrote on 30/08/2005 15:28:31:
> Hi,
>
> Ive noticed that my ALL my databases and tables have
> "latin1_swedish_ci" as the collation...h that wouldn't be so bad
> except that I didn't set it that way by default, and I don't speak
> swedish. Not that swedish is
Hal Vaughan <[EMAIL PROTECTED]> wrote on 24/08/2005 17:41:36:
#>
> Okay, so INSERT IGNORE only works if I am avoiding duplicate keys. Is
there
> any way to use INSERT the way I thought INSERT IGNORE worked -- in other
> words is there any keyword for the INSERT command to keep it from
dupli
Yui Hiroaki <[EMAIL PROTECTED]> wrote on 24/08/2005 10:57:20:
> I created table for fulltext. I publish SQL:
>
> sql>create table (test title longtext)TYPE=MyISAM;
> sql>alter table test add fulltext title (4);
>
>
> But title is so small to insert text.
> what biggest text I can insert tit
The insert will only be bounced where you specify the columns as unique.
Thus you need either separate UNIQUE indexes on Name and Value, if you
want them to be individually unique, or a single joint UNIQUE index if you
want them to be jointly unique but separately duplicable. The INSERT
command
"Blue Wave Software" <[EMAIL PROTECTED]> wrote on 18/08/2005
15:57:34:
> I'm having one of those slow brain days.
>
>
>
> I want a partial filter egg. All records where field1 begins with "ABC"
any
> body know the where clause to do this.
>
> In Access it's where field1 = 'ABC*' but I can'
Sorry - I think you need a LEFT JOIN or it won't count shipments which are
not returned.
Alec
[EMAIL PROTECTED]
12/08/2005 16:38
To
[EMAIL PROTECTED]
cc
mysql@lists.mysql.com
Subject
Re: Complex query. (It's killing me)
Just in the spirit of refining my own skills, here is how I w
Just in the spirit of refining my own skills, here is how I would tackle
the problem. It parses, but I haven't populated the tables so I don't know
if it works:
SELECT s.dateshipped, COUNT(r.type="undelivered"), COUNT(r.type =
"customer"), COUNT(r.status="open")
FROM shipments s JOIN returns r
Bob Rea <[EMAIL PROTECTED]> wrote on 28/07/2005 18:19:34:
> I am learning MySQL from an older book, and some of the examples it give
do
> not work in MySQL, so I am going to ask for help on those.
>
> select cust_contact from Customers where cust_contact like '[JM]%';
> returns Empty set (0.0
Nico Grubert <[EMAIL PROTECTED]> wrote on 22/07/2005 09:06:25:
>
> Hi there,
>
> I have a MySQL 4.1 DB running including a database whose character set
> is set to utf8.
> In the database I have a table "tblmembers" with some records containing
> german umlauts.
> How do I sort results with germ
The system cannot used the index on field2 because it is the second half
of the index in both cases, and it can only use indexes in order. It
cannot use the separate indexes on field 1 and field 2 because the are
ORred together.
If you rephrase your query
SELECT * from table
WHERE field2 LI
Andrea Gangini <[EMAIL PROTECTED]> wrote on 22/07/2005 10:17:34:
> I have a column in one of my table, which:
> - must be unique
> - must be indexed because almost all queries are "SELECT .. WHERE
> COLUMN LIKE "
>
> I created two indexes this column, one of type UNIQUE and a normal one
"Haisam K. Ido" <[EMAIL PROTECTED]> wrote on 01/07/2005 15:04:01:
>
> I've created the following table (server 4.1 in win2k)
>
> CREATE TABLE `os` (
>`id` tinyint(10) NOT NULL auto_increment,
>`name` varchar(255) NOT NULL default '',
>`description` varchar(255) default NULL,
>PRI
news <[EMAIL PROTECTED]> wrote on 30/06/2005 16:47:43:
> I'm designing a simple family tree db which is at present just a flat
table
> In which each record everyone has a father & mother, a variable
> number of wives,and variable number
> of children.
> The links to other family tree members is
David Kagiri <[EMAIL PROTECTED]> wrote on 30/06/2005 09:44:11:
> Hi
> I our database there is one table that will grow into tetrabytes
> within a short time.
>
> I would like to know how i can reduce full table scans.
>
> I have used separate tables as per region for now but the problem is
> if
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 28/06/2005 14:36:37:
> Hello,
> I am reading the docs, but I am slightly confused.
>
> I have a table with a varchar(50) column (not a primary column)
> where I do not want duplicates. It is a properties column, and I am
> getting duplicates inserted
[EMAIL PROTECTED] wrote on 27/06/2005 16:33:44:
> Are you actually saying that you have a database with more than 1.8e+19
> records in it? I don't think you do.
If you were to add records at the rate of a million a second, which is, I
think, beyond the capabilities of any foreseeable future h
Zachary Kessin <[EMAIL PROTECTED]> wrote on 22/06/2005 09:12:22:
> Martijn van den Burg wrote:
> > Stephane,
> >
> >
> >>I've was wondering if anyone is using MySql as their main ERP
> >>production database, if so how stable and reliable is it?
> >
> >
> > SAP and MySQL have teamed up to cert
"'Yemi Obembe" <[EMAIL PROTECTED]> wrote on 17/06/2005 09:40:39:
> Hi all,
> just want to know if there is a specific number of concorent users
> dat can query from a mysql databasee at d same time.
MySQL has a configurable limit to the number of simultaneous connections
that it can support. Se
[EMAIL PROTECTED] wrote on 16/06/2005 16:29:46:
>
>
> [EMAIL PROTECTED] wrote on 06/16/2005 11:30:10 AM:
>
> > Cory Robin <[EMAIL PROTECTED]> wrote on 16/06/2005 08:09:22:
>
> > > I need to speed up a search, big time.
> > >
> > > I have an application that searches for records on a date field
Cory Robin <[EMAIL PROTECTED]> wrote on 16/06/2005 08:09:22:
> I need to speed up a search, big time.
>
> I have an application that searches for records on a date field. If it
> doesn't find an exact date match, it keeps searching adjacent days until
it
> finds a certain amount of records.
>
Angelo Zanetti <[EMAIL PROTECTED]> wrote on 08/06/2005 17:06:51:
> Hi guys.
>
> I'm having a problem deciding whether a left join is suitable for what i
> want to do.
>
> I have two tables
>
> A Users
> -userID
> -isactive
>
> B BuddyList
> -userID
> -buddyID
>
> what i want to do is to get a
Digvijoy Chatterjee <[EMAIL PROTECTED]> wrote on 01/06/2005
17:13:25:
> Hello all,
> My question is if unix Epoch time started on January 1st 1970 ,and
> mysql uses
> the same implementation of time , what is the logic mysql developers
have
> used to offset it by 30 odd years that is the max
Dan Salzer <[EMAIL PROTECTED]> wrote on 16/05/2005 14:36:41:
> I have the following table:
>
> > CREATE TABLE `Article_Search` (
> > `ArticleID` int(11) NOT NULL default '0',
> > `Content` text NOT NULL,
> > PRIMARY KEY (`ArticleID`),
> > FULLTEXT KEY `Content` (`Content`)
> > ) ENGINE=MyISAM DE
"Scott M. Grim" <[EMAIL PROTECTED]> wrote on 12/05/2005 16:42:00:
> I've fairly extensively (although not necessarily scientifically) tested
> SATA 150 vs. SCSI U320 and find that if you're doing a lot of random
reads
> and writes (such as with a database server), SCSI provides nearly 5x the
news <[EMAIL PROTECTED]> wrote on 10/05/2005 15:13:49:
> In article <[EMAIL PROTECTED]>,
> [EMAIL PROTECTED] writes:
>
> > Hi,
> > Have you forgotten what's a primary key ?
>
> > Using order by will sort data, and if it's already sorted, it willbe
sorted
> > again. Time, memory and maybe disk i
MY first guess is that you simply need an ORDER BY field in yout (later,
ad you put it) SELECT.
However, the whole point of using a database such as MySQL is that you do
not worry about how exactly your data is stored. there are many different
tricks that a database can use to optimise both sto
"jatwood" <[EMAIL PROTECTED]> wrote on 28/04/2005 22:35:45:
> I am new to MySQL. Please excuse my ignorance if this question has been
> previously discussed. I was not able to
>
> find an answer to my question by searching the archives.
>
>
>
> I have MySQL installed on a dedicated AMD-64 c
"Ron McKeever" <[EMAIL PROTECTED]> wrote on 29/04/2005 14:09:38:
> I have a TEXT field in my db (4.0) that has lists of IP numbers; can a
> full-text search be done for IP numbers?
Unfortunately not, because Fulltext regards the dots as terminators. The
IP address 192.168.32.2 will therefore be
[EMAIL PROTECTED] wrote on 26/04/2005 14:46:37:
> Hello,
>
> I have a big problem, I only want to check if it's the minute 45
> currently.
>
> I want to make a virtual SELECT without tables:
>
> mysql> SELECT MINUTE(CURRENT_TIMESTAMP()) WHERE
> MINUTE(CURRENT_TIMESTAMP()) = 45;
> ERROR 1064 (
Micha Berdichevsky <[EMAIL PROTECTED]> wrote on 14/04/2005 12:53:31:
> Hi group.
> I have a table with a varchar(250) column in it (let's call it c)
> I want to select values that contain a number of given words in them
> (three or more), in any words order
> I currently use
> SELECT * FROM table
The command you need is
source ;
Alternatively, if you are outside the mysql clined
mysql <
Alec
"Joppe A" <[EMAIL PROTECTED]>
04/04/2005 09:59
To
mysql@lists.mysql.com
cc
Subject
how to run a file in MySQL
Hello all,
This is probably really basic for all of you but I have
"Christopher Vaughan" <[EMAIL PROTECTED]> wrote on 30/03/2005 16:48:47:
> I have data in a table listed as
> 44:22:22
> 333:33:33
> It stands for hhh:mm:ss
> I want to break each part of the data into different parts based on
> the ':' to separate them. Then I want to take that data and sum it.
Du?an Pavlica <[EMAIL PROTECTED]> wrote on 30/03/2005 16:35:40:
> Hello,
>
> maybe this is a silly question but how useful it is to create
> indexes on columns containing only values 0 and 1 (true and false)?
Since I believe that MySQL ignores indexes if it expects to get more than
30% hits, i
select l.b, r.a = l.b from tab l join tab r on l.a = r.b where l.a = 1 ;
seems to produce the result you want
"Gabriel B." <[EMAIL PROTECTED]>
29/03/2005 09:30
Please respond to
"Gabriel B." <[EMAIL PROTECTED]>
To
mysql@lists.mysql.com
cc
Subject
help with a mutuality check (good query e
I am not quite sure I understand your question, then: you would have to
make your table structure a little clearer. Generally, however, puristic
database design would say that you do not have the same "class" of data in
different tables. Instead, you have one "master" table with all the
"simila
"mel list_php" <[EMAIL PROTECTED]> wrote on 23/03/2005 10:14:07:
> Hi list,
>
> I would like to search for something into one or several tables.
> My first idea was to retrieve the tables' names, then for each of them
> retrieve the columns' name and have a look in each of this column.
> Is ther
Eko Budiharto <[EMAIL PROTECTED]> wrote on 18/03/2005 16:54:09:
>
> Hi,
> I am trying to to update one field with multiple value.
> I tried with regulare "update" command syntax does not work. How to
> update a field with multiple value.
>
> regular update syntax is this, UPDATE variableInfo S
"Andy Hall" <[EMAIL PROTECTED]> wrote on 18/03/2005 12:06:30:
> Hi,
>
> I have tried the following process in order to try and replicate a
database
> with InnoDB files:
>
> 1. created a new database in PHPMyAdmin
> 2. via command line, copied all the .frm files from the old database
> directory
Ted Toporkov <[EMAIL PROTECTED]> wrote on 15/03/2005 11:04:09:
> List,
>
> I'm trying to create tables that will store data temporarily, if a php
> page generates data to fill the table, then any number of queries could
> be run on the table, and then be automatically be deleted if it's not
>
cords,
the commands suggested by David will certainly free space and probably
improve performance.
Alec Cawley
"Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> wrote on 08/03/2005
22:58:12:
> Hi Chris,
>
> For MyISAM/BDB tables use OPTIMIZE TABLE ;
> For In
"Kevin A. Burton" <[EMAIL PROTECTED]> wrote on 28/02/2005 17:41:07:
> Right now one of the only reasons we can't put our entire config for our
> slaves in CVSup is that the config *requires* the ability to set a
> server-id for each machine.
>
> Seems like it would be pretty trivial to support
"Jesper Andersson" <[EMAIL PROTECTED]> wrote on 15/02/2005 13:15:43:
> Hello,
>
> I relly new with databases and writing sql-questions.
>
> But in my db want I to check what have new rows have come the last hour.
>
> the db have I as follow:
>
> ID email created upd
"mel list_php" <[EMAIL PROTECTED]> wrote on 15/02/2005 10:18:55:
> Hi!
>
> I have a database where several users can connect and input data.
>
> I managed to have my insert queries as atomic, but I was wondering about
one
> special case: I make one insert, and retrieve the last id inserted by
"mel list_php" <[EMAIL PROTECTED]> wrote on 14/02/2005 13:54:35:
> additional test,
> it is always bugging at the key 127...
> I put a backup online, with until 106.
> Added few test records, from key 127 it just doesn't want to increment
the
> auto-increment field anymore.
> I'm completly lost
e (on the Updates side at least) Raid 0 does not
help you, because there are no overlapping reads to get from alternate
disks.
Alec Cawley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
"Denis Gerasimov" <[EMAIL PROTECTED]> wrote on 10/02/2005 10:59:11:
>
> Hello,
>
> One simple question... AFAIK I can specify value for an autoincrement
> primary key (int) when inserting a record like this:
>
> INSERT INTO `tablename` (`id`, `name`) VALUES (1, 'test')
>
> But it doesn't work
used on. In simple
performance tests, it appears that named pipe access is between 30%-50%
faster than the standard TCP/IP access."
Alec Cawley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
al variable ft_min_word_len to 3 to achieve what
you want. As shipped, it is set to 4, which means that words of three or
less letters are ignored. After changing the variable, you need to rebuild
the index.
Alec Cawley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
quot;obvious" syntax - or the alternative syntax (SELECT 5 XOR
1;) ;
Alec Cawley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
n?
The WHERE keyword is followed by an "expression". There appears to be no
no formal definition of "expression", but it could be informally defined
as the a combination of Operatiors applied to column names and constants.
See manual chapter 12: Operators. The WHERE clause restr
t; for MySQL, doesn't it?
Since no-one replied to your first post, apparently not. I have never seen
such a thing.
Alec Cawley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jacob Friis Larsen <[EMAIL PROTECTED]> wrote on 28/01/2005 11:23:46:
> We have a table that grow by 200MB each day.
>
> Should we put data in different tables or is one big table just as fast?
> We will for new data do select, update and insert and for old data
> only select.
It is not possible
My product has at is centre a Windows PC whose sole purpose is to run
MySQL plus my middleware layer. However, it installed on a site with a
large amount of heterogeneous IT department and an active IT department
managing the whole corporate IT structure. This IT department insists
that, if it
"shaun thornburgh" <[EMAIL PROTECTED]> wrote on 17/01/2005
14:57:39:
> Hi Guys,
>
> Thanks for your replies, i have also found SET which appears to do the
same
> thing, is there a reason why everyone suggested ENUM as opposed to SET?
SET and ENUM are different things. An ENUM can have only on
Mads Kristensen <[EMAIL PROTECTED]> wrote on 13/01/2005 12:42:13:
> Is it true that I can only store 65535 bytes (2^16-1) in a field of type
> BLOB? I thought that a BLOB was supposed to be able to hold 2^16 bytes
> of data.
>
> If it is indeed only possible to store 2^16-1 bytes I would like
Brent Baisley <[EMAIL PROTECTED]> wrote on 07/01/2005 17:03:36:
> I'm having a lot of trouble trying to get this to work. I've set the
> minimum word length to 2, restarted MySQL and rebuilt the indexes, but
> can't seem to get this to work. Is it because MySQL is not indexing #
> and ++? I can
Roger Baklund <[EMAIL PROTECTED]> wrote on 06/01/2005 12:25:31:
> Aji Andri wrote:
> > Hi all,
> > I'm make an inventory goods database, in one of my
> > table I need to make an automatic alert when my stock
> > reach it's limit (say for tires it's limit is 4), can
> > I make an automatic alert fo
"EP" <[EMAIL PROTECTED]> wrote on 15/12/2004 15:44:15:
> Thomas Spahni <[EMAIL PROTECTED]> wrote:
>
> > the column type will limit the number of characters per row. A column
> > of
> > type TEXT will hold up to 65,535 characters but with LONGTEXT you can
> > put
> > up to 4,294,967,295 charcter
Jason Lixfeld <[EMAIL PROTECTED]> wrote on 03/12/2004 03:32:32:
> I'm very new to mysql and replication. I've got a case where I have 2
> servers, each have database A and database B. I want server 1 to be
> master for database A and slave for database B and I would like server
> 2 to be slav
Stuart Felenstein <[EMAIL PROTECTED]> wrote on 26/11/2004 13:54:31:
> I'm trying to build an insert query that will add a
> value into a field , after the first insert query adds
> the record.
>
> Relevant table information:
>
> +-+-++--+
> | RecordID
Chenri J <[EMAIL PROTECTED]> wrote on 26/11/2004 10:52:51:
> What is 'binary' in column type stand for?
> is it describe how the data is stored (in biner value)?
> what do we want use it for?
> - encryption ?
> - space efficiency ?
> - fast index ?
> - or ?
>
>
> I've searched the mysql manu
João Borsoi Soares <[EMAIL PROTECTED]> wrote on 23/11/2004
12:34:01:
> First thanks for the answer Alec. But I think you didn't understood my
> problem. Maybe nobody replied because of that. Let me try again.
>
> Suppose I make a select which returns 100 ordered rows. I only want to
> read rows
I think the reason nobody has replied is that the term "row number" does
not really have any meaning in a DBMS. How the database stores rows
inteneally is the DBMS's private business, and should not be visible to
you. I think it is true that MySQL does not *have* an internal row number,
so ther
"Mojtaba Faridzad" <[EMAIL PROTECTED]> wrote on 18/11/2004
13:59:21:
> Hi,
> I need to expand the database to 3 different locations. We have 3
servers in
> 3 cities. So far the database has been in one city and 2 others have
been
> linked to it and worked. But sometimes for a day or more a ci
ped data which including millisecond
> format.
> What can I use for this? Which function can be made it possible?
No table type that I am aware of. The manual doeaz not contain msec,
millisec or millisecond, so I don't think there is any such type. When I
have to store such types, I
"Michael J. Pawlowsky" <[EMAIL PROTECTED]> wrote on 14/10/2004
17:01:34:
> Getting closer Thanks...
> This db had LOTS of tables... That's why I'm simply trying to get the
> total.
> Is there a way to only get one column of this. then I can do something
> like select SUM(show table stat
1 - 100 of 298 matches
Mail list logo
