If you use
literal strings MySQL may assume that these have the default collation
and comparing them to columns with other collations or performing things
like cast operations may produce errors about invalid combinations of
collations.
--
Met vriendelijke groet,
Jigal van Hemert.
--
MySQL General
use Gmail which obviously lacks a button Reply to
list.
--
Met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hi,
On 10/12/2014 09:02, Johan De Meersman wrote:
- Original Message -
From: Jigal van Hemert ji...@xs4all.nl
Subject: Re: forum vs email [was: Re: table-for-column]
On typo3.org there used to be mailing lists only in a distant past.
Later on newsgroups were set up which communicate
reply for details on the software that
was used.
--
Met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
.
--
Met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
socket is not the
same as connection via a network.
See:
http://bugs.mysql.com/bug.php?id=69570
http://dev.mysql.com/doc/refman/5.5/en/connecting.html
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
for the application that has SELECT rights on the
view but not on the table.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
of functions
available to manipulate the data itself.
[1] http://dev.mysql.com/doc/refman/5.5/en/update.html
[2] http://dev.mysql.com/doc/refman/5.5/en/functions.html
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
permits multiple NULL values for columns that can contain NULL.
Only for 5.0 there is the exception that the BDB storage engine does not
allow multiple NULL values in a column with a UNIQUE index.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
where you only use values of zero or larger you can use
e.g. -1 as a special value.
If you insist on using NULL and the crazy = operator you can use NOT
to invert it:
SELECT NOT(A = B);
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives
.
http://www.net-security.org/malware_news.php?id=1853
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
cardinality) it might be faster
to do a full table search instead of first reading the index and then
having to go through the table anyway.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
an index which includes gmtdate, but it can make
the result set before the limit a lot smaller.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
in the data can
lead to changes in the behaviour.
You can make suggestions for the indexes to be used and you can even
force the use of an index if the query optimizer makes the wrong
decisions in a case.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
having to look for all possible
combinations of the encoded data.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
offering you tutoring for money. Nobody else saw those messages and your
replies looked a bit odd because of this.
Please keep track of whether a message came from the list or from
someone personally...
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing
Hi,
On 2-4-2011 2:18, Thomas Dineen wrote:
Can't find file: './mysql/host.frm' (errno: 13)
http://tinyurl.com/3sc3ydx
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
with 'solutions' such as
ignore this, found it myself, never mind, solved, etc.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
of the
application was enough.
It really depends on the situation of your application which table
structure is the most suitable. Test the performance of all kinds of
operations you need to do with realistic data and various amounts of
data to see how it scales.
--
Jigal van Hemert
--
MySQL General
the questions.
--
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
and InnoDB tables.
--
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
GROUP BY `account_id`
ORDER BY avg_hits DESC
--
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
.
If you ask yourself if normalizing a column in a table is useful and if
you really need the constraint and if the view, stored procedure,
function or whatever you use is really useful, chances are that the
application is a lot simpler, faster and easier to maintain.
--
Jigal van Hemert
- and software
for their application are simply forgetting that they were supposed to
produce a working application and not the most normalized database with
all the fancy views and other stuff.
--
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
to be ultimately flexible and creating
a solution for problems which simply don't exist.
In almost all cases a simple solution will be the best.
Regards,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Claudio Nanni wrote:
If he really cared about MySQL he would have not sold it or prevent from
selling it to Sun.
Initially her was convinced that MySQL as a division of Sun would really
benefit the future of MySQL [1]. Obviously his relationship with Sun
changed a bit later on.
It shows that
Claudio Nanni wrote:
Due to selling MySQL to Sun, Widenius earned about 16.6 million € in
(...)
I fail to see the relevance of this quote for this thread...
Regards,
Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Chris,
I might be being an idiot.
Yes, you are :-)
-122.1529 is between -121.148 and -121.1575
This is not true!
-122.something cannot be between -121.somethingother and -121.somethingelse
-121.1529 is between -121.148 and -121.1575
Regards,
--
Jigal van Hemert.
--
MySQL General
My approach would be the opposite:
SELECT t1.`STY`, t3.`STY` FROM `table_b` AS t1 JOIN `table_a` AS t2 ON
t1.`CUI` = t2.`CUI1` JOIN `table_b` AS t3 ON t2.`CUI2`=t3.`CUI`;
table_a determines which records from table_b must be connected.
--
Jigal van Hemert.
--
MySQL General Mailing List
Xiaobo Chen wrote:
Hi, all
I am trying to use this with error:
drop temporary tabel temp_a if exists 'temp_a';
it said syntax error.
Try:
DROP TEMPORARY TABLE IF EXISTS `temp_a`;
('table' instead of 'tabel'; table name only once; backticks around
table name instead of quotes)
Ben Clewett wrote:
But the index does not seem nearly as fast as liner (normal) indexes.
Hence using a less effective liner index may be better...
After this method I still need select a radius within these data points,
more effort.
This could be an excellent case for using HAVING expr
The
Jan M schreef:
How do I update a record obtained from a query result while ensuring that:
1) The record is the actual record in the database not a possible duplicate,
e.g. is there a built-in record number identifying the actual DB record or
do I have to organise that in the table structure.
Javier Diaz wrote:
I would like to know if there is any problem which cause Mysql to not
use date indexes at least you use the = operator, because if that is
the case we will need to re-visit a few queries
If you do a select instead of a delete, will the index be used? (You can
check
Javier Diaz wrote:
EXPLAIN SELECT * FROM process_times
WHERE date = date_sub(now(), INTERVAL 2 day)
possible_keysdate_idx,date_proc_idx/possible_keys
key(NULL)/key
rows10778561/rows
EXPLAIN SELECT * FROM process_times
WHERE date = date_sub(now(), INTERVAL 2 day)
Jonathan Chong wrote:
I have a table on my forum that's frequently accessing with reads and
writes. On a busy day, the table is locked when people are posting
messages and the page hangs when you try to read a topic.
Is it worth me converting the table to InnoDB, as I've heard that
InnoDB
Joseph Alotta wrote:
greetings,
I know this is pretty basic stuff, but I couldn't find an answer in
google.
1. I want to set the @maxdate variable, but mysql complains. What am I
doing wrong?
set @maxdate = select max(date) from positions where account =
111200512343222;
select
[EMAIL PROTECTED] wrote:
#1064 - 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 '.manufacturers_id = m.manufacturers_id )
LEFT JOIN specials s
USING ( p.produc' at line 4
What's the error in the query?!!?
[EMAIL PROTECTED] wrote:
Hi,
I resolve my problem...
select count(p.products_id) as total from products_description pd,
products p left join manufacturers m using (manufacturers_id),
products_to_categories p2c left join specials s using (products_id)
where p.products_status = '1' and
Scott Haneda wrote:
Hello, with the release of 5, I seem to have all dead links to my old docs
for mysql 4. The way they keep changing the urls is a little maddedning :-)
I usually search using: http://www.mysql.com/keyword
http://www.mysql.com/subquery will lead to:
Eamon Daly wrote:
I don't know why I have so much trouble visualizing indexes,
but such is life. Imagine a simple table with only two
columns: user_id and foo_id. I will only ever be looking up
records in this table by user_id, but I will always retrieve
both fields. Figure a million rows and
Noel Stratton wrote:
more thing that I can not figure out. I would like to sum all calculations
created out of the Total Amount Owed field that was created.
Noel,
Take a look at the WITH ROLLUP modifier of GROUP BY [1]. This is
available since version 4.1.1.
Regards, Jigal.
[1]
InterNetX - Andreas Prasch wrote:
Hi,
I have a master and a slave mysql server. On the master I write binlogs
needed for replication. From time to time I have chronological
auto_increment problems, here's a short explanation.
- the table structure :
| Field | Type| Null | Key | Default |
Paul DuBois wrote:
At 10:49 +0100 11/8/05, Jigal van Hemert wrote:
Lindsey wrote:
but do you know how to use the * in regexp searches. err what i mean
if i want to search for * and not use it as asterix?
To use a literal instance of a special character in a regular
expression, precede
Lindsey wrote:
Lets say the table contains the following brands
SAMSUNG
SIEMENS
SONY
If you do a fulltext boolean search with the term:
-S*Y
-(S*Y)
everyting that starts with an S will be excluded... any solutions?
Although I couldn't find a question in your post, I guess you want to
know
Lindsey wrote:
ok thanks, then i know!
but do you know how to use the * in regexp searches. err what i mean if i want
to search for * and not use it as asterix?
i have tried \* but that did't work, it just does the same as *.
The manual comes again to the rescue ;-)
Appendix G [1] tells
Marc Pidoux wrote:
I've been using ASP for years but I have to work on a bigger project
involving many users and data so of course, Access is not an option
anymore. Since it's a project requiring thousand of files and several
applications all linked together, I can't create it once and change
Scott Haneda wrote:
I have a field `fedex`, in it is text date, in tab sep \n delimeted form,
for example:
90FedEx Home Delivery (Residential) 14.06
20FedEx Express Saver 22.63
(...)
Is there some way I can do some string parsing on the text field and get to
the
[EMAIL PROTECTED] wrote:
Jigal van Hemert [EMAIL PROTECTED] wrote on 11/02/2005 03:29:14 AM:
If I understand
http://dev.mysql.com/doc/refman/5.0/en/table-and-index.html
correctly, the index of the primary key is stored as the clustered index
together with the data. To me this means
Hi Joerg (and other list readers),
Joerg Bruehe wrote:
Jigal van Hemert wrote:
Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to
Linux/Apache/MySQL/PHP (aka LAMP). The license costs for a LAMP setup
will probably be higher. Both will be able to do the job
Shankar Unni wrote:
[EMAIL PROTECTED] wrote:
If I understand the InnoDB engine correctly, I don't see how they
could speed it up unless they start tracking how many records belong
to each active version within a database.
But one thing you can do to speed it up somewhat is to do a
Barry wrote:
Can someone plaese help? I have three tables 1st is a collection of
propertys, 2nd is a list of facilities(98 in total) and the third is a
list of property id's corresponding to the facilities id's offered at
each property,
The query I am running:
'SELECT'
'`'.$type.'`.`id`,'
[EMAIL PROTECTED] wrote:
wang shuming [EMAIL PROTECTED] wrote on 10/31/2005 01:11:06 AM:
How could run mysqld-nt.exe in background on win2000/XP, not as a
would be useful in HIS operating system. AFAIK, there has never, ever,
been a Windows (or DOS) command or command modifier to launch an
David Blomstrom wrote:
I have a PHP script that displays data like this:
Eurasia
Eurasiasupisland/sup
Africa
Where Eurasia and Africa are mainland parents of
ecological regions and Eurasiasupisland/sup is a
parent of an ecological system that is associated with
a continent. For example, Borneo
Aleksandra wrote:
I've written a search machine. It's working quite well, but I have two
problems:
1. When I give the following syntax : cat and dog , as a result I get
everything with at least one of the words: 'cat', 'dog' but also 'and'.
What can I do, so that it's not looking for the
Wenca wrote:
SELECT * FROM tab_p WHERE d_id = 20602 AND name LIKE 'Machico'
- no results
Try it with ...AND `name` LIKE '%Machico%';
I have encountered it once when there were non printable characters in
front of or after the text itself. Very frustrating!
You can see what extra characters
Tom Brown wrote:
hmm i'm not entirely sure i fancy adding another data file on the fly -
Can you give me a brief run down about how you would go about this?
My collegue the sysadmin usually takes care of keeping the databases
happy. But AFAIK it's a matter of modifying the setting in the .cnf
Eldon Ziegler wrote:
We have a geographically dispersed system with a database of student
status information that needs to be replicated in as near to real time
as we can get. The MySQL master-slave method of replication doesn't seem
applicable as students can login to any server and pickup
Stefan Kuhn wrote:
Am Thursday 27 October 2005 12:56 schrieb Raphaël 'SurcouF' Bordet:
Le vendredi 16 septembre 2005 à 18:14 +0200, Stefan Kuhn a écrit :
I'm using it with four machines (geographically separate) and it works
fine. Stefan
And can writes on each server in simultaneous time ?
Aleksandra wrote:
Jigal van Hemert wrote:
I assume that you use Full-Text searches (but somehow you have managed
to change the default minimum word length to three).
As far as I understand what you've written - if I change the minimum
word length to 4, I won't get any result with the word
From: Tom Brown [EMAIL PROTECTED]
(...)
starting at say 1GB and then 'extending' to 25GB. So is it possible for
all datafiles, rather than just the last one, be 'autoextending'
The short answer: no.
http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html states:
The autoextend
mem bob wrote:
| id | model | service_id |
||---||
| 1 | 500 | 1 |
| 2 | 500 | 3 |
| 3 | 500 | 10 |
| 4 | 600 | 1 |
From this table i want to extract all distinct models which have
service_id=1 *AND* service_id=3
The JOIN-construction is something like:
SELECT `model`
G G wrote:
I have two tables:
Records:
member_id - int
question_id - int
Questions:
id - int
I'm looking to select a random id from the questions table, given that there
is no record of the user already answering that question.
SELECT * FROM `Questions` AS t1 LEFT JOIN `Records` AS t2 ON
zhou bin wrote:
hi,
mysql is a very goode software,so i made mysql_3.23_58 and mysql_4.1
in two of my server, and i changed the root password, but why i can't
connect to the mysql server from a client pc(use mysqlcc or any other
tools)?
the error message is:
[206] ERROR 1130: Host
Andrew Roth wrote:
Hi all,
We are a group of three students in Professor Ric. Holt's Software
Architecture class at the University of Waterloo. As our project, we
would like to examine the MySQL source to determine the best way to
implement materlialized views.
It would be wise to hang
Martijn Tonies wrote:
| Warning | 1264 | Out of range value adjusted for column 'a' at row 1
Could be me ... but isn't this a little too late?
eg: AFTER you have lost your data?
IMO, it should raise an error UNLESS you force it to truncate the data.
This would contradict the MySQL design
Octavian Rasnita wrote:
Is there a command for renaming a MySQL database?
Sorry, there is no command for that. For small databases you can use
administration tools like phpMyAdmin, etc. which will do it for you by
duplicating the database structure and data, and then drop the 'old'
C.R. Vegelin wrote:
What about renaming the folder indicating the database name.
I work with Windows XP and renaming a folder works well.
Cor,
Have you tried it with InnoDB tables or anything other than MyISAM
tables? InnoDB uses a single tablespace per server (unless specified
that it
- Original Message -
From: Hiu Yen Onn [EMAIL PROTECTED]
if i uncomment it, then mysql server wont start at all. if i comment it,
then, that's ok. please advise. thanks again
If the mysql server does not start it will probably leave a lot of messages
in the error log. If you send the
Dan Buettner wrote:
I tend to disagree - at my place of employment, a newspaper, we have
hundreds of gigabytes of BLOB data (ad and page layouts digital
artwork) stored in SQL databases. Granted we are using Sybase for that
and not MySQL but there are a lot of advantages to it - access
Ananda Kumar wrote:
Hi Friends,
I want to set the default date format as dd-mon-. How do i do this in
mysql.
The short answer: not.
http://dev.mysql.com/doc/refman/5.0/en/dynamic-system-variables.html
lists the variables you can change by the SET GLOBAL or SET SESSION
command.
Kane Wilson wrote:
But when i try to store little but huge gif files it wont store .
First of all, use the method described at
http://www.php.net/manual/en/features.file-upload.php for a safe way to
handle file uploads. It could be that you run into a server limit which
will show up if you
Merlin wrote:
I am wondering if it is possible to find words inside words with the
help of fulltext search.
Is this possible? Google does that, so somehow there should be a way.
Somehow I don't think that Google runs on a single MySQL database. Full
text indexes in MySQL mean that words
C.R. Vegelin wrote:
Hi, I am looking for a method to use variable table names.
I have various download-tables, all having the same structure.
All I want is to run a series of queries on each of these tables.
I tried
SET @mytable = 'Download200501';
SELECT count(*) FROM @mytable;
but this
Remo Tex wrote:
1) that's common problem when doing custom install on PATH containing
spaces like C:\Program Files. Solution - try custom location with
short(er) path and without spaces like C:\mysql5013\. Probably that
will solve problem 2. if not then..
Remo Tex,
That is not a good excuse
Matthew Lenz wrote:
anyone using openoffice:base to design mysql db's? back when I tried it
earlier this year it wasn't able to define relationships which made it
pretty much useless as a time saving tool.
Hi Matt,
Although it's slightly OT here, there is still a lot of development
going on
Merlin wrote:
Hi there,
I am facing problems with fulltext search on MySQL 4.0.18
Problem is, that words which are not seperated by space are not found.
Example:
A search for dsl will not find DSL-Modem
I looked it up on mysql.com help, but despite the fact that this is not
seperated by space
Gleb Paharenko wrote:
I'm not giving an exact answer on your question, however, it might be
interesting for you. Usually queries are faster if you define the column as NOT
NULL.
What's the reason behind this? NULL 'values' are a bit of strange
phenomenon. In the EXPLAIN output a query with
Stephen A. Cochran Lists wrote:
I'm getting a strange ordering when using ORDER BY on a int column.
The rows are being returned sorted as follows:
The list is typically the way to order a string.
You are most likely to get meaningful suggestions to solve the mystery
if you include the
Balazs Rauznitz wrote:
I have replication set up. Is it OK to alter one of the slaves and add
several indexes ? It did seem to work, but I'd like to be sure.
Replication does nothing more or less than copying the queries that
alter the tables (inserts, updates, alter table, delete, etc.) to
Jason Ferguson wrote:
The data is split into about 60 files, average file size of 5 MB (varying
from 1 to 10 MB). Since there are many files, I'm trying to minimize the
required work (if there was just one consolidated file, no problem).
The work can be automated easily with the right tools
Mysql Lists wrote:
I'm hoping they get replication setup by diffs, only sending the diffs
that are tracked from the master.. replicated to the slave.. That would
be sweet :)
On 9/27/05, *Jigal van Hemert* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
wrote:
Balazs Rauznitz wrote:
I
C.R. Vegelin wrote:
Hi All,
Does anyone know how to use the format() function in such a way that is
displays numbers right justified.
For example, see the following query, where I want no decimal places:
SELECT 123456.789 AS X, FORMAT(123456.789, 0), FORMAT(123456.789, 0)+0;
The 1st column is
Martijn Tonies wrote:
Given that the OP did not state that there were any issues with an
existing website, logical requirements come first. Period. No discussion ;)
Logical requirements may come first, but may be overruled later by
requirements caused by performance issues or system
- Original Message -
From: Chris Kantarjiev [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, September 19, 2005 9:06 PM
Subject: very large key_buffer on amd64?
We're starting to use mysql (4.0.25) on an amd64 machine (running
NetBSD-3). One of the reasons for doing this is
Eli wrote:
Is it possible, or probably will be possible, to define indexes spanned
on more than one table?
I mean that if I have column col_a from table tbl_A, and col_b from
table tbl_B.. Can I define a KEY with both those columns? Where will the
index be saved?
Just out of curiosity and to
Eli wrote:
The reason I thought about this is that I got several tables that hold
their own specific data and are indexed inside themselves. But I got an
issue to search on JOIN of 2 or more tables with comparison and/or
ordering on combinations of fields from the various tables. This usualy
Bill Whitacre wrote:
printf(trtd {$thearray[org]} /td
td align=right {$thearray[COUNT(*)]} /td
td align=right $ {$thearray[cost]} /td/tr);
If I replace
{$thearray[cost]}
with
number_format({$thearray[cost]}, 2)
Although this is a MySQL mailing list and your problem is
Kane Wilson wrote:
I wanted to check the following condition and if it is
success i wanted to display a massage.I tried as
follows. but no luck. nothing displayed.
$dbQuery = results;
$result = mysql_query($dbQuery) or die(Couldn't get
file list);
if (!isset($result))
{echo NULL;}
Schalk Neethling wrote:
You guys should subscribe to the Planet MySQL RSS feed. The entire issue
was cleared up there by a member of the MySQL AB staff.
http://www.planetmysql.org/
Maybe the MySQL AB staff could take the trouble of answering posts
about this issue on this list? Maybe the
Jeff Pflueger wrote:
Hi. Thanks for any help on this. I've been beating my head over it for
hours.
Here's what I am trying to do: I have four tables I am joining via a
unique key (Fellow_id).
The results I want to group into three categories, each alphabetized
within the group.
Is this too
Pooly wrote:
Hi,
I would like to display a list of members who have their birthday a
given day (today for instance).
For such an application I've used a single integer column to store a
number consisting of the month and day (day as 2 digits!!!) concatenated.
So dates range from 101 to 1231.
Gyurasits Zoltán wrote:
Hello All!
I have a little problem. I can't do serial number in result of select.
I guess you want to display a sequential number for each row in the result.
First of all a warning: if there is no ORDER BY in the query there is no
specific order in which the results
- Original Message -
From: Kishore Jalleda
as per
http://dev.mysql.com/doc/mysql/en/replication-compatibility.html
there should be no problems
On 8/17/05, Jeff [EMAIL PROTECTED] wrote:
Does anyone know if there are any problems replicating from a master
database on version 4.0.16 to a
Konrad Billewicz wrote:
Hello,
I would like to do thing exactly like CREATE TABLE a LIKE b. But... I have MySQL
3.23 and this command is available since 4.1. How would you handle this task
using this, older MySQL?
http://dev.mysql.com/doc/mysql/en/show-create-table.html
Use output of SHOW
[EMAIL PROTECTED] wrote:
MySQL has moved WELL past the 3.23.x lineage and is getting close to
retiring the 4.0.x lineage (it's only a rumor). So I suggest you update
Not completely a rumor; on August 2, Heikki wrote: As far as I know,
one release of 4.0 will still be built.
Considering the
Tim Johnson wrote:
grin it get worse . most of my commercial work is running on
servers with ver 3.23.X (sun and RH servers). I enjoy a
great relationship with my domain hoster (who is also a
programmer who uses mysql a lot), but he has been very
cautious
Sebastian wrote:
this query runs slow because AVG and COUNT on maps_rating table i think.
can anything be done to improve?
You may want to include:
- table definitions (output of SHOW CREATE TABLE table)
- output of EXPLAIN query
This way the list members can make better suggestions.
Joseph Cochran wrote:
Some countries have multiple timezones, so it is not sufficient to
know the country code in order to get the timezone. If they have
previously posted the timezone, however, then it should be possible to
store that information in a cookie on the client machine that your web
Philippe Poelvoorde wrote:
Enrique Sanchez Vela wrote:
I would like to have MySQL differentiate between 'abc'
and 'ABC' both the server and clients. so far anything
I've done has not worked.
Is altering the column type an option ? If yes, you would change any
'text' for 'blob' and any
1 - 100 of 319 matches
Mail list logo