e
can help me? thank a lot.
--
Best Regard
*
Roger chen
Mail: jirong1...@gmail.com*
something like: empty table, but it didnt work...
> thanks a lot
--
Roger
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
`subject_id`)
> )
Try adding an index with subject_id as the first column.
ALTER TABLE `citation_subject` ADD INDEX (`subject_id`,`citation_id`);
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
possible.
>
> Any help will be appreciated, as I'm new to such a problem.
>
There's a 'ged2db' utility that converts from GED format to a database.
I believe it converts from GED to mysql, postgresql and other formats.
--
Roger Morris
[EMAIL PROTECTED]
--
MyS
Hi,
Anyone know how to use MySQL in
an ISAPI (Borland Delphi 5 Web Broker technology, or genl ISAPI)
application?
Thanks,
Roger
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Hi All,
Anyone know if the MySQL API
can be called from GPC (GNU Pascal Compiler)
programs? (instead of just C)
Thanks,
Roger
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Is there any way to turn off collation in mysql 4.1? PHPadmin is showing a
new colation dropdown menu which I need to get rid of.
Thanks,
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
yes it is true, you have to check if the constant CLIENT_MULTI_STATEMENT is
set or not.
basically this constant has for value 65536.
HTH
Alain
On 4/25/06, Juri Shimon <[EMAIL PROTECTED]> wrote:
>
> Hello Juri,
>
> Tuesday, April 25, 2006, 5:49:25 PM, you wrote:
>
> JS> mysql=mysql_init(NULL);
> J
Hi,
I would like to make a dump of my database.
however, i have some stored procedure and they are not exported to the *.txt
file i've created via mysqldump.
So, how can i dump stored procedure ?
thanks a lot,
Alain
Pooly wrote:
Hi,
I try to convert a varchar to a char, but it doesn't seems to work.
From the manual: "...all CHAR columns longer than three characters are
changed to VARCHAR columns."
http://dev.mysql.com/doc/mysql/en/silent-column-changes.html >
--
Roger
--
MySQL Ge
I am pretty
sure that I can solve this using left outer join but am not able to
get it working hence any help would be appreciated!
Try something like this:
SELECT A.date,B.date
FROM A LEFT JOIN B ON B.date=A.date
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
fter you know what problem you want to solve, you can start
solving it. Even if you are doing this just for fun, or for learning,
you should come up with a specification or at least a description of
what you want your database-enabled information system to do.
--
Roger
--
MySQL
ot the reason for the error message. :)
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
tml output. Many web pages have a variable width... there is a reason
for why whitespace usually is not significant in html.
The problem you describe above is not related to mysql, and you could
probably solve it another way. You should take a look at the html
element.
--
Roger
--
MySQL Gene
on't have to use "MySQL
Administrator". phpMyAdmin and SQLYog are two web-based alternatives.
Or you could use your favourite programming language. Download an API
from http://dev.mysql.com/downloads/ > and write a program that
edits your table data.
--
Roger
--
MySQL Genera
/mysql/en/problems-with-null.html >
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
del Challenge", "SA Pro Model" and so on,
and you want to add the numeric value of all these columns into one
column named "total_points", you must use `backticks` because of the
spaces in the names:
joining_points + `E-Model Challenge` + `SA Pro Model` + ...
http://d
***
id: 8002
GeoQuality: 2a
lon: -0.361080
lat: 9.99
You have created your columns with a max width of 7, out of which 6 are
decimals, but you are trying to insert a number with 8 digits.
--
Roger
--
MySQL General Mailing List
For list archives: htt
set (0.00 sec)
Bye
C:>
You can combine with --skip-column-names and --batch to change the output.
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
l,Data.Mar),
...
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. Simpler put: it would seem to
work until you inserted a customer without a note, and additional
customers with notes after that.
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I installed Mysql using the .dmg package. I can use System Preferences to
start and stop the program. When I open a terminal window, I think this is the
way to us the program, any Mysql command I inter is not recognized.
Thanks
Roger
--
MySQL General Mailing List
For list archives: http
I use a Python program to write text containing Unicode characters to a
MySQL
database. As an example, two of the characters are
u'\u2640' a symbol for Venus or female
u'\u2642' a symbol for Mars or male
I use utf8mb4 for virtually all character sets involved with MySQL. Here is
an ex
Five months ago I posted the query shown below on StackOverflow. I got
one reply which was not of much help. So I am trying again, hoping a
more MySQL-centric forum might be able to solve my problem.
Roger House
How to get the MySQL Command-Line Tool to display Unicode properly?
I use a
only when I am running mysql and I issue a SELECT command to
see what is in a row. Then the UTF-8 is not rendered properly. I
believe the problem is with mysql.
Roger
On 03/13/2018 03:11 PM, Reindl Harald wrote:
Am 13.03.2018 um 22:59 schrieb Roger House:
In all respects except one, the
On 03/15/2018 11:30 AM, shawn l.green wrote:
Hi Roger,
(please note, this is a bottom-post forum)
On 3/13/2018 7:54 PM, Roger House wrote:
>
> On 03/13/2018 03:11 PM, Reindl Harald wrote:
>>
>>
>> Am 13.03.2018 um 22:59 schrieb Roger House:
>>> In all resp
On 03/15/2018 02:06 PM, Roger House wrote:
On 03/15/2018 11:30 AM, shawn l.green wrote:
Hi Roger,
(please note, this is a bottom-post forum)
On 3/13/2018 7:54 PM, Roger House wrote:
>
> On 03/13/2018 03:11 PM, Reindl Harald wrote:
>>
>>
>> Am 13.03.2018 um 2
m not mistaken, ALL combinations are now tested in the standard
test suite so any bug would block a release going out.
Sounds good. :)
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
al,pic.pic
FROM animal_pic
LEFT JOIN animal ON
animal.id = animal_pic.animalid
LEFT JOIN pic ON
pic.id = animal_pic.picid
http://dev.mysql.com/doc/mysql/en/join.html >
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
other date/time
functions are documented here:
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html >
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ROUP BY ID,NAME
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Roger Baklund wrote:
Try something like this:
SELECT ID,NAME,COUNT(*)
FROM tableA
LEFT JOIN tableB ON
tableA.ID = tableB.ID
GROUP BY ID,NAME
Nope, sorry, that won't work, ID exists in both tables thus it must be
prefixed with table name or alias: SELECT tableA.ID,... GROUP BY
tabl
e computation on the act_date
column which must be executed for each row:
SELECT * FROM activities WHERE
(act_date + interval 1 day) >= NOW()
SELECT * FROM activities WHERE left(act_date,10) >= CURDATE()
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysq
value is 0, which is never > 0.
BTW, there is no version 4.18, you probably meant 4.0.18.
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jan Bartholdy wrote:
Thanks Roger, but it does not work:
SELECT CASE
when Species_1_e > 0
THEN 'extern'
when Species_3_e > 0
THEN 'intern'
ELSE ''
END AS `species_1_l` from species where statsample=1820;
--Gives at
mysql> select from_unixtime(1108738332);
+---+
| from_unixtime(1108738332) |
+---+
| 2005-02-18 15:52:12 |
+---+
1 row in set (0.00 sec)
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
,'.join(map(str,Lkeys
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
k
and month. They don't seem to match up.
The TIMESTAMP column type is NOT a UNIX timestamp...! It is a 'normal'
datetime column, you should use just WEEK(cdate), MONTHNAME(cdate) and
so on.
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rd'", -1,
PREG_SPLIT_NO_EMPTY));
The result should be:
SELECT * FROM TAB1 WHERE searchword REGEXP
'[^a-z0-9]*a[^a-z0-9]*p[^a-z0-9]*p[^a-z0-9]*l[^a-z0-9]*e[^a-z0-9]*'
Any index on 'searchword' will of course not be used.
--
Roger
--
MySQL General Mailing List
F
ur data in
separate columns and in separate tables. You can search in the XML
column too, but it is harder/slower: By using the LIKE operator and your
knowledge of the XML structure, you could search for a date within an
XML column with something like this: ... LIKE "%2005-02-26%".
--
Roger
lastname) contact_name,
COUNT(*) as count
FROM Contacts
GROUP BY contact_name
HAVING count > 1
It's hard to give better examples as I don't know exactly what you are
trying to achieve... :)
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ts of date/time functions available in version 3.23, for
example unix_timestamp():
SELECT start_time, end_time,
unix_timestamp(end_time) - unix_timestamp(start_time) AS seconds
FROM mailings_sendstats order by start_time desc;
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mys
Gerald Preston wrote:
[...]
I get "DBI connect<'club','gjwpp88',..> failed; Client does not support
authentication protocol requested by server"
Check this:
http://dev.mysql.com/doc/mysql/en/old-client.html >
--
Roger
--
MySQL General Mailing List
For list ar
after col3;
You must separate each action with a comma. Try this:
alter table MyTable
add newcol1 float after col3,
add newcol2 float after col3;
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
he value 'FOOBAR' but still I receive these results.
Anyone have a clue what is causing this?
iImo is a numeric field, mysql knows it, and automagically converts the
string 'FOOBAR' to a numeric value: 0. You are actually querying for
iImo=0. Try this:
SELECT 'FOOBAR&#x
tion" column is
aliased to "Destination". This is necessary to avoid two columns from
having the same name, in this case both columns would have been named
"Location".
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
x27;,'unknown') NOT NULL DEFAULT 'unknown'
);
# unique name, relates to other tables (using id)
CREATE TABLE names (
id integer NOT NULL PRIMARY KEY,
name varchar(30) NOT NULL,
age tinyint NOT NULL,
sex enum('f','m','unknown') NOT NULL DEFAUL
y
in memory, when failing it would build the disk-based temporary table
anyway, thus it would take more time.
http://dev.mysql.com/doc/mysql/en/select.html#id2674115 >
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
ead t1/t2 first, then i1/i2 and finally productos.
http://dev.mysql.com/doc/mysql/en/explain.html >
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dto. Sistemas de Unitel wrote:
Hi Roger,
That was just I need. The order isn’t like you say:
++-+---++---+-+-
++---+-+
| id | select_type | table | type
Dto. Sistemas de Unitel wrote:
Hi Roger,
You are ok, there was an index problem in one table, they name of the rows
wasn't equal and MySQL didn't recognize they as the same index. I have
changed the row name and now is working fine, but I have a little question,
How can I use in
RE clause dictates which columns are related, not the name of the
columns.
I don't know why your index did not work at first.
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rom a;
DISTINCTROW and DISTINCT are synonyms:
http://dev.mysql.com/doc/mysql/en/select.html#id2828077 >
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At this stage, when you create the link, you allready know what page you
are on. Why waste time and try to calculate it again?
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
c/mysql/en/string-functions.html >
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ea. Each expression in the ORDER BY clause returns 0 (false)
or 1 (true). Because 0 is smaller than 1, and ASC is the default sorting
order, we want each expression to be FALSE, so that it is sorted first.
That's why I negated all expressions. An alternative would be to use
DESC after each ex
shell
script and cron or the equivalent if you are on a non-unix platform.
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 row in set (0.00 sec)
mysql> select inet_ntoa(2130706433);
+---+
| inet_ntoa(2130706433) |
+---+
| 127.0.0.1 |
+---+
1 row in set (0.00 sec)
http://dev.mysql.com/doc/mysql/en/miscellaneous-functions.html >
--
Roger
--
MySQL
this is a blob.
I suggest you don't discuss this 3rd column with PHP at all...? ;)
$res = mysql_query("select col1,col2 from table");
Should I be using 1 or 2 tables?
There is no reason to use two tables to solve this problem. There could
be other reasons why you should use two ta
27;,'B4076','B4069','B4041',
'A4710','58282','58220','56751','56728',
'45003','09234','04200','04035','04026')
order by
FIELD(fieldname,'B4079','B
LECT TABLE_A.First_Name, TABLE_A.Last_Name, TABLE_B.Data
FROM TABLE_A, TABLE_B
WHERE
Activity = 'draw' AND Age > 24 AND TABLE_A.Data_ID = TABLE_B.Data_ID;
(Aside: Would this query give me the same results as the above query?)
Yes, I think so, if all rows in TABLE_A have a correspondi
with the two tables (resulting
in a 5,000,000,000 row table)
and then finding the matching rows based on the WHERE clause?
If there is no index on A.lastname and B.id, probably yes...
Use the EXPLAIN SELECT command to see how MySQL plan to solve the query.
http://dev.mysql.com/doc/mysql/en/
NULL,
DROP PRIMARY KEY,
ADD PRIMARY KEY(USERID);
This would only work on an empty or a single-row table, or you would get
duplicate key errors.
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ON
T.TransID = TD.TransID AND
T.TransDate > '$SelectedDate'
WHERE
ISNULL(T.TransID)
The idea is to join the rows you do NOT want, i.e. rows with transactions
after the selected date, and then only return the results where such
transactions was NOT found, i.e. TransID is NULL
. If you don't want this,
change the first LEFT JOIN to a normal join.
When I say "in some cases" it is because this can be very heavy on the
server if there are many status_info rows per project. 'Many' in this case
means hundreds, but this will depend on the server &
ut if the semantics of the communication are intimate enough,
> exchanging complex
> internal data structures, that too could be a basis to consider the two
> parts as combined into a larger program.
One could argue that the product delivered by "company 1" is a "co
hnically, i.e. you won't get errors, but only one of them
will give you the right data in the columns.
Good luck!
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
itions.
> I'm having a time deciphering this stuff. The mediumint and int
> say they use
> 3 bytes and 4 bytes each, respectively, but using that in the table
> definition yields invalid numbers.
What do you mean with 'invalid nunmbers'? Did you try MEDIUMINT+I
ame
The first statement will give an error if the database allready exists, the
second will not. Both statements will create a database if it does not
allready exist.
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I don't know which...
You should probably also have an index on boy.name.
If you need more specific information, please include some details about
your application: what kind of queries, how many simultaneous users, how
much data, what kind of hardware, what OS...
HTH,
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
> It's because the subselects are supported from version 4.1.
Yes.
> If you use older MySQL version then it's not possible to do
> it with a single query :(
Yes, it is. :)
http://www.mysql.com/doc/en/example-Maximum-column-group-row.html >
See the "MAX-C
ww.mysql.com/doc/en/Table_types.html >
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ad three different types of reports for
> Helsinki and Turku, how can I get them all in one query?
Use a sub-select if you can, or see the MAX-CONCAT trick:
http://www.mysql.com/doc/en/example-Maximum-column-group-row.html >
--
Roger
--
MySQL General Mailing List
For list archives
ing like this:
SELECT award_type, award_image
FROM award_types,awards
WHERE
award_types.id = awards.award_id AND
awards.chosen = 'enabled' AND
awards.user_id = $userid
(Not sure about the chosen = 'enabled', just looked like that was what you
wanted from your example
+---+
>
> Now my problem: how to write a statement to select all 'p' and
> 'v' from 'pl' and 'ln' where 'o=1' and 'l=de' or 'l=null if
> l=de is unavailable'.
Maybe something like this could work:
SELE
ductId"],row["MarketId"],row["Type"]
if ((P == p) and (M == m) and (T == t)):
if counter < 3:
print row["Price"],
counter = counter + 1
else:
print "\n"+P,M,T,row["Price"],
counter = 1
p,m,t = P,M,T
That sh
n run them on the same machine at the same time, just make sure they
don't listen on the same port, share the same pid-file, data files or log
files and so on.
http://www.mysql.com/doc/en/Multiple_servers.html >
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql
nested selects.
Version 4.1 (Alpha status) and later however _does_ support nested selets:
http://www.mysql.com/doc/en/Subqueries.html >
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ng a non-true WHERE clause:
CREATE TABLE new_table SELECT * FROM table WHERE 1=0
http://www.mysql.com/doc/en/CREATE_TABLE.html >
You can get the schema for an entire database by using the --no-data option
for the mysqldump utility.
http://www.mysql.com/doc/en/mysqldump.html >
--
Roger
--
Insert the user_roles row:
INSERT user_roles SET uid=$uid,rid=$rid;
If the final INSERT fails, the user/role combination allready existed. If
any of the other INSERTs fails you have a "collision": two users are
creating the same user or role at the same time. In that case
Y should work
anyway.
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t; in
> there won't work, because any row in metadata can only have one facetid.)
You can join the metadata table twice:
SELECT photos.*
FROM photos,metadata m1,metadata m2
WHERE
photos.photoid = m1.photoid AND m1.facetid = 1 AND
photos.photoid = m2.photoid AND m2.facetid
you didn't get the subtle hint: I guess there will be some
competition from http://www.oracle.com > and http://www.borland.com/delphi/ >.
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
abase server can have different "speeds" outside the
server: the speed of developing/maintaining the database.
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ath,'/',popbox.mbox_name) AS path
> FROM popbox, domain
> WHERE popbox.domain_name = domain.domain_name
That should do it. :)
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
d
> data from text into right place on table ?
You can use the LOAD DATA statement or the mysqlimport utility:
http://www.mysql.com/doc/en/LOAD_DATA.html >
http://www.mysql.com/doc/en/mysqlimport.html >
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
servers to use GMT time, regardless
of the geographical placement of the server. That way you would only need an
$usertimezone offset.
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ven't found it on the MySQL
> roadmap yet.
Woudn't the "proper way" be the way that leads to a result you can live
with? Of course support in the server would have been better, but why can
you not use a mechanism as described above?
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
thout first having done an INSERT in the same session,
and even with connection pooling you would usually use the same connection
for all statements related to a session. What am I missing?
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
allowing separate statements from separate users
intermingeled on the same connection was... well, at least special, if not
broken. Besides LAST_INSERT_ID(), user variables would also be broken in
such a system.
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ect to
MySQL, making connection pooling not so usefull as it may be in other
environments, but on very high traffic systems I suppose it will do some
gain... others on this list probably have experience with running different
connection pooling systems, including the PHP thingy and Tomcat... usefull?
s
> this can be an important issue.
I agree again. But it doesn't answer my question... I suppose you can live
without timezones untill mysql supports it in the server? :)
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
n when connection pooling is involved. :)
> Or is that connection-pool-implementation dependent?
No, the server does not know about the connection pooling, and the
connection pool implementation can not change the internal mysql "process
id" (actually connection id) without creating a new
am I still misinterpreting something?
No, that sounds right. I would expect all queries from one user (=one
session) coming together, then all queries from the next session and so on.
This is not the case with Tomcat?
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
* Hassan Schroeder
> Roger Baklund wrote:
>
> > ok... If you did this:
> >
> > - create temp table
> > - use temp table
> > - drop temp table
> >
> > for each session, I would expect it to work. (atleast until a session
> > crashes before i
lank set c=NULL where c="a";
ERROR 1062: Duplicate entry '' for key 1
Note that the last statement is actually trying to update the column to "",
not to NULL.
The reason for this behaviour is to get better performance. There is no
attribute constraint checking in mysql, leaving more work to the developers,
but the server is running faster. We can stand a little extra work if it
runs extra fast, right? :)
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
* Hassan Schroeder
> Roger Baklund wrote:
>
> > Ouch. Very special, imo... this means the connection is
> > re-negotiated for each statement? Sounds strange. Maybe the
> > client connection is 'virtual' or 'by proxy', so that multiple
> > users a
By the way, if you also need to store the offset of the server, you should
use minutes or maybe even seconds, depending on your the need of your
application for accurate time. That way you can adjust for servers with
wrong clocks, in cases where the server is not in your own server room.
--
Roger
n US different states can have different DST, even within the same
timezone. In addition there are local transitions every year: some country
may change DST that particular year because of some special happening or
other local conditions. You can read more about DST here:
http://www.timeanddate.c
retrieve it. If your search criteria can contain
words with a + or - prefix (or other operators, see the manual), you must
handle that in the code. I suppose the + character should be ignored or
increase the score, and when a - character prefix is encountered, the word
should be ignored.
http://www
1 - 100 of 915 matches
Mail list logo
