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
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
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 field2?
You
[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 had other
Rhino [EMAIL PROTECTED] wrote on 21/03/2006 13:41:49:
- Original Message -
From: Zsolt [EMAIL PROTECTED]
To: MySql Mailing List mysql@lists.mysql.com
Sent: Tuesday, March 21, 2006 2:58 AM
Subject: How to shutdown mysql from Java
Hi,
my application starts mysqld (via
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 you probably
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 what is known. See the
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 upwards of 10
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 _sensor_date.
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
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:
event _sensor_date.
So for every
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` , `server`
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 merge or
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 that
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 questions:
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. I see no
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).
The
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:
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 invcount
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\ to
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? I had a
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 'id
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL
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 a
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 not
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 while I had been
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 which
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 use
'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 list
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 (I think) harming SCO in any way.
Alec Cawley
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 isn't a
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
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
Yui Hiroaki [EMAIL PROTECTED] wrote on 24/08/2005 10:57:20:
I created table for fulltext. I publish SQL:
sqlcreate table (test title longtext)TYPE=MyISAM;
sqlalter table test add fulltext title (4);
But title is so small to insert text.
what biggest text I can insert title column?
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't find the
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 ON
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
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.00 sec)
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 german umlauts
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,
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
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,
PRIMARY KEY
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 i create
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 always
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, which
[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
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 certify (part of?) SAP's
'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. See
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.
The
[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. If
it
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 all the users from
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 date
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 DEFAULT
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 io.
If MySQL
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
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 keyed
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 computer
[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 (42000):
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 WHERE
The command you need is
source filename ;
Alternatively, if you are outside the mysql clined
mysql filename
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
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, it
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.
I wrote
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 exercise
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 there a more
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
similar
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 into the
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 SET
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
queries
,
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 your table name;
For InnoDB tables try ALTER TABLE
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 a
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
mysql
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 updated
001
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 here, any
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 for id = 0.
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]
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]
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]
, 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]
of Operatiors applied to column names and constants.
See manual chapter 12: Operators. The WHERE clause restricts to rows where
the expression returns true.
Alec Cawley.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
XOR
1;) ;
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 to
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 one value
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 to
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't
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 for it so when
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 charcters into one row. I
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 slave for
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 manual but
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|
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 there
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
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 city lost
such type. When I
have to store such types, I use absolute milliseconds stored in BIGINTs.
Alec Cawley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 status
1 - 100 of 291 matches
Mail list logo