Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
X-Sender: [EMAIL PROTECTED]@teton.kitebird.com
Date: Thu, 19 Sep 2002 08:54:55 -0500
From: Paul DuBois <[EMAIL PROTECTED]>
News-Group: list.mysql
Reply-To: <[EMAIL PROTECTED]>
At 20:47 -0500 9/18/02
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
Date: Thu, 19 Sep 2002 08:46:10 + (UTC)
From: Chris <[EMAIL PROTECTED]>
X-X-Sender: <[EMAIL PROTECTED]>
- Machine "A" has a crontab running to check the network status every
second. When the netwo
Hi all,
anyone knows a good method to retrieve 1 random selevted record out of
thouseands?
right now I'm using
select ID from table ORDER BY rand() LIMIT 1
however, this seems like a very slow method, like mysql first organizes a
few thousand records in a random 1 and only returns 1
Any
Hello Everyone
I have been using MySQL on Linux for over two years and am a devoted fan. I
have been using MySQL for very ordinary applications till now.
Now there may be a requirement that we need to build an enterprise
application running on MySQL. The application must be very reliable, very
Hi Steven,
Some precisions : after taking a look at my mail, I noticed the very first
time I saw this error was with PHP 4.2.1 and MySQL 4.0.2 (reported on this
list on 27 june 2002).
Regards,
Jocelyn
- Original Message -
From: "Steven Roussey" <[EMAIL PROTECTED]>
To: "'Jocelyn Fournie
Does anyone know how to capture data as it comes out of MySQL, goes
through MyODBC, is processed by IIS, and delivered to the browser using
ASP? I'm looking for the data as it goes from the following points:
1. From MySQL to MyODBC
2. From MyODBC to IIS
3. From ASP to the Browser
Background: I
I am having some problems in getting mysql to initaiate the inodb option.
The relevant section of my.cnf is:
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /
innodb_data_file_path =
data1/ibdata1:100M:autoextend;data2/ibdata2:100M:autoextend;data3/ibdata3:10
0M:au
Hi,
MY_system:= macos 10.2
Darwin kernel version:= 6.0
Mysql server version:= 3.23.52
Mysql server is installed and work great except...
I can't run the mysql executable localted in the bin directory
The terminal returns me:
dyld: bin/mysql Undefined symbols:
bin/mysql undefined
Hi all,
I have recently downloaded mysql version 3.23.45 and I am struggling to get it to
start.
Every time I type in ./safe_mysqld the program starts and then shuts down immediately
with the following being written to the error log:
---
>Description:
MySql-4.0.3-beta invokes a system call to "OpenSSL_add_all_algorithms".
OpenSSL-0.9.7 no longer provides this function call. The same is true
for MySql-4.0.2-alpha.
From: "Lutz Jaenicke via RT" <[EMAIL PROTECTED]>
Subject: [openssl.org #263
whenever I post any mail to mysql list, I too received these mails
> -Original Message-
> From: Paul DuBois [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, September 20, 2002 6:59 AM
> To: Joel Rees; Franz, Fa. PostDirekt MA
> Cc: [EMAIL PROTECTED]
> Subject: Re: WG: ABUSE? , myisampack
Could anyone provide a couple of web sites which are currently using a
searchable database created with mysql, for us to preview? We would like to
develop our own database, and are not sure of its capabilities..
Regards,
Michael Forbes, Pres.,
design development industries, LLC
t 219.759.3831
e [
dear all,
i've problem when i want to query mysql data using asp command.
this is my error message in browser...
---
Process ID: 1
Subject: TEST INPUT PERTAMA KALI
News:
ADODB.Field error '800a0c93'
The operation requested by the application is not allowed in this context.
/scripts/asp/qmknwp.a
Hi,
I was able to crash MySQL every time with the following -- it is
incorrectly formatted I know and I should be using GROUP BY in this
particular case
When I do the following query:
SELECT DISTINCT * FROM CUSTOMER INNER JOIN PRODUCT ON CUSTOMER.CUST_NO =
PRODUCT.CUST_NO
Without the distinc
It's also possible someone subscribed abuse@verizon to the mySQL mailing
list I think.
Perhaps someone has a grudge against verizon.
> -Original Message-
> From: Joel Rees [mailto:[EMAIL PROTECTED]]
> Sent: 19 September 2002 18:07
> To: Franz, Fa. PostDirekt MA
> Cc: [EMAIL PROTECTED]
At 10:07 +0900 9/20/02, Joel Rees wrote:
>...
>> i received this message , after sending a request to mysql-mailing-list:
>>
>> >Thank you for bringing this matter to our attention. We are sorry for
>> >any inconvenience it has caused you.
>...
>> It wasn't my intention to abuse , offend or s
...
> i received this message , after sending a request to mysql-mailing-list:
>
> >Thank you for bringing this matter to our attention. We are sorry for
> >any inconvenience it has caused you.
...
> It wasn't my intention to abuse , offend or spam anyone or anything and
> i think i didn't do s
Since MySQL does not have views or queries that can be within the database,
is there a way to make tables which are subtables of the main table? For
example, I have an ID that goes from 0010-10010 to 7000-. I want a table
that will show only those items with LIKE '0080-%'. This table should be
I've always used pconnect.
- Original Message -
From: "Steven Roussey" <[EMAIL PROTECTED]>
To: "'Jocelyn Fournier'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: "'Mysql'" <[EMAIL PROTECTED]>
Sent: Friday, September 20, 2002 2:38 AM
Subject: RE: MySQL errors in newer PHP 4.2.3
> Hmm, do y
Hmm, do you use pconnect or connect?
I noticed someone changed our PHP script to use persistent connections
(likely why the server is running slower). I am wondering if a cancelled
connection is being reused or if it just is a more general bug in the
mysql client code in PHP
Sincerely,
Stev
Hi,
Same problem for me, although it was already here with 4.2.0 for me (well it
seems to be also a high QPS problem...). The problem seems to disappear with
an apache restart, but sometimes appear again randomly.
Regards,
Jocelyn
- Original Message -
From: "Steven Roussey" <[EMAIL PR
Since updating to 4.2.3, we have been getting intermittent errors of
"Commands out of sync". Anyone else see this?
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
php,sql,query
-
Before posting, please check:
http://w
Me too received the same but dont know why
- Original Message -
From: "Franz, Fa. PostDirekt MA" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 19, 2002 8:03 PM
Subject: WG: ABUSE? , myisampack , sql , admin [T2002091901XL]
-Ursprüngliche Nachricht-
Von
Hi,
On Fri, 2002-09-20 at 08:30, Csaba Kiss wrote:
> this is my first mail to the mailing last, since I am new to the mysql
> world. I would like to create a "cell-bank" mysql database. We freeze
> down cells in small tubes. These tubes are stored in boxes and the
> boxes are in big freezer
Hi Peter,
On Fri, 2002-09-20 at 08:03, Peter M. Flor wrote:
> I have been beating my head against a wall to try and get this to work.
> Apparently in version 2.22 a bug preventing ORDER BY in a SELECT statement
> from working was fixed in 2.23. Well I think that this bug also exists in
> 2.23 whe
Hi all,
I am writing a PHP web page that displays some statistics based on
information in a database.
The database has a table (stats) with three fields:
ID, Sender, Text, UserID, Timestamp
I have set it up so that I get basic statistics with the following query:
SELECT Text, Count(*) FROM st
Hi,
I'm having some trouble with a sizable (but certainly not huge)
multi-row insert statement. I can successfully execute the query with
up to 7365 rows, but any more and it fails (ERROR 2006: MySQL server has
gone away). More complete info:
Total working query size: 1047426 bytes
wait_timeou
While I have no solution for you, I am curious: why would you need to
specify the order rows are deleted in?
Mike
-Original Message-
From: Peter M. Flor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 4:03 PM
To: [EMAIL PROTECTED]
Subject: MySQL 2.23 DELETE ORDER BY bug
Hello guys,
this is my first mail to the mailing last, since I am new to the mysql
world. I would like to create a "cell-bank" mysql database. We freeze
down cells in small tubes. These tubes are stored in boxes and the
boxes are in big freezers. Sometimes we freeze 10-20 new tubes with
new
I have been beating my head against a wall to try and get this to work.
Apparently in version 2.22 a bug preventing ORDER BY in a SELECT statement
from working was fixed in 2.23. Well I think that this bug also exists in
2.23 when using ORDER BY in conjunction with a DELETE statement, and
possibly
i have mysql in redhat and i would liket o automate the backup process..
i would like to use mysqldump without password.. any idea how to do this..
thanks for the help..
-Antz
---
This email was brought to you by Foothill.net
http://webmail.foothi
Hi All;
I have been writing a VB app that has been very quick and responsive across
the DSL modem connection I have to the server. Yesterday I populated the
tables with about 100,000 rows, and then I started having a problem: When I
run a query through a SSH session to the server, the query is re
> I am trying to find the records whose create dates (field name
> =create_date) are between the ones I want .For example , I want to seee
the
> records between $start_date and $end_date ..So I tried the code
> below..But it looks not that right to me?...
>
> select * from bug where ..
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 7:59 PM
To: Savaidis; mysql list
Subject: RE: insert and deletind dublicating
At 17:54 +0300 9/19/02, Savaidis wrote:
>I had already done the first (insert ignore into bla-bla ) solution
I have message rules to move Emails to the proper lists. If you would send
this to the list(s), with CC to person I would see it. I get hundreds of
Email a day and have to organize them to stay sane.
As it is now, I just see names I don't know and delete.
Tom
- Original Message -
Fro
In the last episode (Sep 19), Steven Kreuzer said:
> >What is the SQL to get the created AutoInc ID from a row that I have
> >just inserted?
>
> SELECT MAX(id_field) FROM table
Nope. If someone else inserted a record between the time you inserted
yours and the time you run that select, your answ
If i use a replace query, and there isn't an error, then either
a new row was inserted, or an existing row was updated.
The primary key in the table i'm replacing to is defined as
mprid int not null auto_increment primary key
whether an insert or update actually occurs, i want to get the value o
- Original Message -
From: <[EMAIL PROTECTED]>
To: "William Martell" <[EMAIL PROTECTED]>
Sent: Thursday, September 19, 2002 2:33 PM
Subject: Re: Dynamic Links
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter y
At 16:00 +0300 9/19/02, Victoria Reznichenko wrote:
>deep,
>Thursday, September 19, 2002, 2:28:07 PM, you wrote:
>
>dk> I am using MySQL 4.0.3 and Innodb tables for my
>dk> application, I have created a unique index on
>dk> multiple column but its not working, here is sql
>dk> script to generate
I believe this approach work in a single connection environment and it has a
potential problem when it is running in a concurrent system.
What happens if there is another insert occurred through another connection
just before this statement being executed??
The result of this statement would no
From: Steven Kreuzer <[EMAIL PROTECTED]>
> SELECT MAX(id_field) FROM table
> On Thursday, September 19, 2002, at 12:55 PM, Davis, Tim wrote:
> > What is the SQL to get the created AutoInc ID from a row that I
> > have just inserted?
More formally, you can do this:
SELECT LAST_INSERT_ID();
-
At 13:23 -0400 9/19/02, Steven Kreuzer wrote:
>SELECT MAX(id_field) FROM table
That won't give you the correct answer if some other client gets in
there an inserts a row before you have a change to get the MAX()
value. LAST_INSERT_ID() is designed for this; it's not affected
by whatever other cl
Hello All,
How do I load data from different text files. IE. Suppose I have a table
set up and I have 3 text files that have the data I want to load into the
table. How do I tell MySQL to load this data from 3 different text files?
How much control do I have with this option???
Thanks in Adva
Hi,
Have been trying to connect to a remote MySQL server from Matlab through an
ODBC connection, however the error is receive is
[TCX][MyODBC]Can't connect to MySQL server on
'' (10060)
I have searched the docs and archives and google... But can't see any answer
to what this error means.
Any
SELECT MAX(id_field) FROM table
SK
On Thursday, September 19, 2002, at 12:55 PM, Davis, Tim wrote:
> What is the SQL to get the created AutoInc ID from a row that I have
> just
> inserted?
>
> Tim Davis
> Sunbelt Systems Concepts, Inc
> [EMAIL PROTECTED]
> Client/Server Database Programmer/Ana
At 11:58 -0500 9/19/02, Robert Fox wrote:
>Hello-
>
>I've just started using MySQL so this is absolutely a 'newbie'
>question. I'm used to working with Oracle's SQL*Plus which is a very
>different tool. In SQL*Plus, I could type 'l' or 'list' at the
>SQL*Plus prompt and see a printout to STDOUT
At 12:55 -0400 9/19/02, Davis, Tim wrote:
>What is the SQL to get the created AutoInc ID from a row that I have just
>inserted?
SELECT LAST_INSERT_ID();
Seems like there's an echo in here...this question has been asked about
4 times in the last couple of days. :-)
>
>Tim Davis
>Sunbelt Syste
Hello Shravan,
Thursday, September 19, 2002, 5:45:59 PM, you wrote:
SD> I am able to stop the server when i specify the
SD> password for the user root.
SD> But if the user "shravan" (who does not have a
SD> password) who tries to stop the server started by
SD> himself, then it fails.
User "shr
Michael Boudreau wrote:
> I can't tell if this is an SQL question or a MySQL question, so please
> forgive me if it's not germane. I'm wondering whether I'm expecting
> MySQL's "LEFT JOIN" to do something it can't, or if I just don't know
> my SQL well enough.
>
> Given a database with these
At 17:54 +0300 9/19/02, Savaidis wrote:
>I had already done the first (insert ignore into bla-bla ) solution with
>personal e-mail from a friend. It works fast and fine. But the word "ignore"
>leds me to missunderstanding: insert the row inspite of the unique key!
That's why it's a good idea to r
Hello-
I've just started using MySQL so this is absolutely a 'newbie' question.
I'm used to working with Oracle's SQL*Plus which is a very different tool.
In SQL*Plus, I could type 'l' or 'list' at the SQL*Plus prompt and see a
printout to STDOUT (the screen) of the current command in the buff
What is the SQL to get the created AutoInc ID from a row that I have just
inserted?
Tim Davis
Sunbelt Systems Concepts, Inc
[EMAIL PROTECTED]
Client/Server Database Programmer/Analyst
-
Before posting, please check:
http://w
Is there a way to see what temporary tables exist for the connection.
SHOW TABLES
doesnt list the temp tables for the connection. Is there some other command
i can issue?
thanks
sean peters
[EMAIL PROTECTED]
sql, query
-
At 12:01 -0400 9/19/02, Jamie Beu wrote:
>Whenever I run a command from the MySQL prompt, The command executes and
>outputs the time to process the command.
>However, if I put the same command in a script file, and run it in batch
>mode from the shell prompt (or even use SOURCE from the mysql prom
Thank you for your time and response.
I have checked if the text is surviving the paste buffer - it is. (I did
a character by character comparison of the text one pasted in the web
form, but before hitting submit.)
The problem characters are the ASCII backslash and the ASCII tilde -
Good to kno
On Thursday, September 19, 2002, at 07:44 AM, Clayburn W. Juniel, III
wrote:
>
> On Thursday, September 19, 2002, at 03:19 AM, [EMAIL PROTECTED] wrote:
>
>> linux:/usr/local/mysql # ./bin/mysqld_safe
>> The file /usr/local/mysql/libexec/mysqld doesn't exist
>> or is not executable
>> Please do
now() will give current time and work in all contexts (unix timestamp or
datetime forma)
Try...
delete from table_name where now()-user_login_time > interval 15 minute
in this statment, user_login_time is the time the user logged in.
Regards
Torbjørn
On Thu, 19 Sep 2002 [EMAIL PROTECTED] wrot
Whenever I run a command from the MySQL prompt, The command executes and
outputs the time to process the command.
However, if I put the same command in a script file, and run it in batch
mode from the shell prompt (or even use SOURCE from the mysql prompt),
I do not get the same timing info.
I wa
Thank you so much for your time & the sample code. It is the same as
what I have except for
I added the above, but it does not fix the 'morphed' characters. It
helps immensely to know that you have the same environment & HTML/ASP as
I do. What does the "Transitional//EN" part in the above
Hello all, I am trying to write a delete statement in
which a record is deleted if the time a user logged in
is more than 15 minutes. As a result I would need to
compare login times to the current time. Is there a way
in MySQL to do this? Can the current time be calculated
by SQL?
thanks,
S
EMS HiTech company is announcing the next version (1.91) of MySQL
Manager -- A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
What's new in version 1.91?
1. A possibility to
I can't tell if this is an SQL question or a MySQL question, so please
forgive me if it's not germane. I'm wondering whether I'm expecting MySQL's
"LEFT JOIN" to do something it can't, or if I just don't know my SQL well
enough.
Given a database with these (partial) tables for manuscripts and
[ this mysql spam filter sucks -- including a query in one's message
isn't good enough ]
[EMAIL PROTECTED] wrote:
>>you could store them as 3 integers. The integral part, the numerator
>>of the fraction and the denominator of the fraction - then interpret
>>them at the client side.
>>
>
I had already done the first (insert ignore into bla-bla ) solution with
personal e-mail from a friend. It works fast and fine. But the word "ignore"
leds me to missunderstanding: insert the row inspite of the unique key!
"continue" I think it is more meanfull as without this I get an error
messag
Hi there
I've got the following problem scenario.
After inserting a new record into a table with a auto_inc
id, I need to get the new id back to insert into another table.
I use the following code to do this:
dim rs as recordset
dim newid as long
'this works
set rs = dataenvironment.connection
ÐáñÜèåóç Gerald Clark
<[EMAIL PROTECTED]>:
> chown -R mysql.mysql /usr/local/mysql
Thanks, but apparently it still cannot find it:
linux:/usr/local/mysql # chown -R
mysql.mysql /usr/local/mysql
linux:/usr/local/mysql # scripts/mysql_install_db
Installing all prepared tables
020919 22:44:19
On Wed, 18 Sep 2002, William Martell wrote:
> Can anyone tell me whether we can represent fractions in MySQL 4.0. I have
> data representing different lengths of objects measured in inches. Can I
> load this data as is into a field in MySQL or do I have to convert it first
> into an floating po
Exactly
Rob Hutton
Web Safe
www.wsafe.com
**
Introducing Symantec Client Security - Integrated Anti-Virus,
Firewall, and Intrusion Detection for the Client.
Learn more:
http://enterprisesecurity.symantec.com/symes238.cfm?JID=2
chown -R mysql.mysql /usr/local/mysql
[EMAIL PROTECTED] wrote:
>Trying to install 4.03 from the tarball...
>Any idea whay I am doing wrong??
>Thanks, S.Alexiou
>
>Here is what I get
>...linux:/usr/local/mysql # scripts/mysql_install_db
>Installing all prepared tables
>020918 21:55:07 ./bin/my
Alex,
Wednesday, September 18, 2002, 9:25:33 PM, you wrote:
AK> I've got a weird conundrum here that I'm hoping I can get some help on. I'm
AK> attempting to install a chat board system called Ikonboard
AK> (www.ikonboard.com) with MySQL as the database; setup on it went smoothly
AK> until it t
bhushan,
Wednesday, September 18, 2002, 5:32:04 PM, you wrote:
b> Can anybody tell me source for getting information on
b> 4.6.3 Adding a New Character Set in MySQL.
b> I read the manual, it's not clear to me.
b> The steps there does not give enough information to start.
Some info you can
Shravan,
Wednesday, September 18, 2002, 10:17:29 PM, you wrote:
SD> I am completely new to MySQL. I installed the source
SD> version of MySQL on Solaris 2.8. I did
SD> "mysql_install_db".
SD> I started the server by saying
SD> "bin/safe_mysqld --user=mysql &". The server started
SD> my creatin
At 12:06 +0300 9/19/02, Savaidis wrote:
>Hello!
>
>I have to add a .sql file from MySQL-Front
>
>(insert into mytable ('0','asdf',ecc))
>
>that containts some dublicates in the unic key.
That sounds self-contradictory.
>
>How can I do this and later to delere the dublicate records?
>
>The
you could store them as 3 integers. The integral part, the numerator of
the fraction and the denominator of the fraction - then interpret them
at the client side.
William Martell wrote:
> sql,query,database,odbc
>
>
> Hello All,
>
> Can anyone tell me whether I can represent fractions in My
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Peter Goggin wrote:
| I followed the advice given but get these errors:
| If I use rpm -Uvh MySQL-3-23-52-1.i386 I get;
| error failed dependencies
| MySQL-server conflicts with mysql-server-3.23.49-3
| followed by a list of dependencies on libmysql
Hi there,
I am tring to locate some errors which pop up once in a while.
Now I have tracked them done to a point where permanent db connections could
be involved. Every Page in my system where a db (mysql) is involved connects
to the db server. This seems to be the reason why in some cases the v
sql,query,database,odbc
Hello All,
Can anyone tell me whether I can represent fractions in MySQL 4. I have
data representing different lengths of objects measured in inches. Can I
load this data as is into a field in MySQL and still retain the same value
or do I have to convert it first to a
At 20:47 -0500 9/18/02, William Martell wrote:
>Hello.
>
>Can anyone tell me whether we can represent fractions in MySQL 4.0. I have
>data representing different lengths of objects measured in inches. Can I
>load this data as is into a field in MySQL or do I have to convert it first
>into an flo
Hello.
Can anyone tell me whether we can represent fractions in MySQL 4.0. I have
data representing different lengths of objects measured in inches. Can I
load this data as is into a field in MySQL or do I have to convert it first
into an floating point interger or decimal value???
Thanks in a
Savaidis,
Thursday, September 19, 2002, 12:06:47 PM, you wrote:
S> I have to add a .sql file from MySQL-Front
S> (insert into mytable ('0','asdf',ecc))
S> that containts some dublicates in the unic key.
S> How can I do this and later to delere the dublicate records?
S> The unic key has
McIrvin,
Thursday, September 19, 2002, 2:41:35 AM, you wrote:
M> No,, I dumped the table and put it on a different server and tried it there.
Could you send a dump of the table to test it?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by
Mark,
Thursday, September 19, 2002, 12:24:45 PM, you wrote:
MC> Can I change the data type of a column in a table from varchar(10) to
MC> smallint(5) unsigned zerofill. The column that is set to varchar(10) is
MC> populated with values from a primary key column in another table that has a
MC> dat
deep,
Thursday, September 19, 2002, 2:28:07 PM, you wrote:
dk> I am using MySQL 4.0.3 and Innodb tables for my
dk> application, I have created a unique index on
dk> multiple column but its not working, here is sql
dk> script to generate an bug
dk> CREATE TABLE TESTING
dk> (
dk> ID INT AUTO_INC
There was a comparison run on eweek.com a few months ago that tested the
top databases, including MySQL, using a JDBC interface. Oracle came on
top, as you would expect, and it should for the money. MySQL was second,
MSSQL was dead last. All were "professionally" tuned as I recall.
However, MS
Hi,
after being mailed from a spam filter (and i still don't know why) ,
i am sorry , if my question my appear a second time.
Myisampack crashes with 'segmentation fault' anytime i try to use it.
MySQL-Version is 2.23-41-log.
Linux-kernel is 2.4.10-4GB.
Everything installed from SUSE 7.3-distrib
Tim,
Thursday, September 19, 2002, 1:09:42 PM, you wrote:
TF> I'm implementing a search feature on one of my sites and I would like
TF> to have a Google-style "X is a very common word and was not included
TF> in your search" for stop words. I believe the stop words in fulltext
TF> searching are
he may want "SELECT table1.* prefix t1,table2.* prefix t2"
which not seems to be supported.
instead of "select table1.c1 as t1c1,table1.c2 as t1c2,
table2.c1 as t2c2.."
>From: z <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>Subject: Re: Aliasing all fi
×ð¾´µÄmysql:
ÄúºÃ£¡
´Å¿¨¡¢ÌõÂëÉ豸֮¼Ò--º¼ÖÝÕýÔµç×Ó www.zymc.com
»¶ÓÄúµÄÝ°ÁÙÖ¸µ¼£¡
º¼ÖÝÕýÔµç×ÓÓÐÏÞ¹«Ë¾ÊÇÒ»¼ÒרҵÖÂÁ¦ÓÚÐÅÏ¢×Ô¶¯Ê¶±ðµÄ¸ß¿Æ
¼¼ÆóÒµ¡¢×Ô¶¯Ê¶±ðÉ豸µÄרҵ¿ª·¢É̺ÍOEMÖÆÔìÉÌ¡£ÕýÔªÅÆZYϵÁÐ
´Å¿¨¶ÁдÆ÷¡¢´Å¿¨ÔĶÁÆ÷¡¢ÌõÂëË¢¿¨Æ÷ºÍÃÜÂë¼üÅ̵ÈÉ豸£¬ÊÇÓɱ¾
¹«Ë¾×ÔÐÐÑÐÖÆ¡¢¿ª·¢ºÍÉú²ú£
Stefan,
Thursday, September 19, 2002, 9:45:52 AM, you wrote:
SF> I want to change the varibale "max_connections" from 100 to 250. how can
SF> I do that? I use MySQL 3.23.52 under Windows XP professional
SF> Is the place I take the set-variable = max_connections=300 wrong?
SF> I have the fallowi
There are several major differences that you will need to consider.
1. So far as I know MySQL does not allow you to assign tables and indexes to
table spaces, hence load spreading is much more difficult. You cannot split
tables and indexes so that they reside on differentt disks.
2. There are no
My point was that unless you were worried about tens of thousands of simultaneous
connections, MySQL is a better choice in terms of costs. If you are worried about tens
of thousands of connections, MS-SQL still isn't a good solution because it won't
handle the load and it will cost even more mo
hi,
my mysql is crashing from time to time,
on nothing more than just count(*) on a table.
its 3.23.52 compiled from the sources, running on openbsd 3.1
i have compiled with debug turned on,
but there is no backtrace in the log file when it happens,only
this:
020918 16:16:20 mysqld restarted
Hi,
I am using MySQL 4.0.3 and Innodb tables for my
application, I have created a unique index on
multiple column but its not working, here is sql
script to generate an bug
CREATE TABLE TESTING
(
ID INT AUTO_INCREMENT NOT NULL PRIMARY KEY ,
FLD1 VARCHAR(100) NOT NULL ,
FLD2 VARCHAR(15) NOT NUL
-Ursprüngliche Nachricht-
Von: Franz, Fa. PostDirekt MA
Gesendet am: Donnerstag, 19. September 2002 13:00
An: '[EMAIL PROTECTED]'
Betreff: AW:ABUSE? , myisampack , sql , admin [T2002091901XL]
Hi there,
i received this message , after sending a request to mysql-mailing-list:
>Thank yo
MySql doesn´t support boolean data type.
Try TinyInt unsigned, with two values: 0 False, 1 True.
Regards,
Rafa
RE: Boolean Data Type in MySQL
__
The NEW Netscape 7.0 browser is now available. Upgrade now!
http://channels.netscap
Hi Andrew,
DATE_FORMAT is the function you're looking for.
Check the documentation on it, chapter 6.3.4 "Date and Time Functions".
DATE_FORMAT works like the following:
SELECT DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
BTW, SQL Server offers the CONVERT function for this purpose. No nee
Peter,
Try this query:
SELECT a.name, a.field1, a.field2,
b.field3, b.field4,c.field5, c.field6
FROM
t1 as a left join t2 as b on (a.name = b.name)
left join t3 as c on (a.name = c.name)
having b.field3=5 OR c.field6=16
Best regards,
Mikhail.
- Original Message -
From: "Peter Stöcker
Good Morning Ladies and Gentlemen,
there is a real bad problem with myisampack , that never occured before.
I wanted to pack some of my Tables via myisampack and at any condition
you i can imagin (server up , server down , database directory , different directory ,
running myisamchk with mostly
Trying to install 4.03 from the tarball...
Any idea whay I am doing wrong??
Thanks, S.Alexiou
Here is what I get
...linux:/usr/local/mysql # scripts/mysql_install_db
Installing all prepared tables
020918 21:55:07 ./bin/mysqld: Shutdown Complete
To start mysqld at boot time you have to copy su
Hi CH!
Thanks a lot! That's it!
I thought there is no differece between "ON (condition)" and "USING(field)", but there
is!
Thank you very much!
CU,
Peter
[EMAIL PROTECTED] schrieb am 19.09.02 12:02:58:
> Hi Peter,
>
> pls try this query. but its not tested.
>
> select t1.name, t1.f1, t1.f
1 - 100 of 114 matches
Mail list logo
