> Connection Failed
> 2003 - Cannot Connect to MySQL server on 10.1.1.95 (10061)
Hi,
it seems that the MySQL Server is not running.
Try to start the server.
Best regards,
Roland
--
[EMAIL PROTECTED]
-
Before posting, plea
Hello All,
I m using linux with mysql server.
I wud like to print the correct error message if any
error occur while we r communicating with server eg.
access denied, connection failure, no data is
available , table does not exits, duplicate data etc.
How can i see the return error code value a
Hi all.
I've been trying to grant users the right to create temporary tables:
grant create temporary table on mydatabase.* to user;
flush privileges;
I've also tried:
grant create temporary table on mysql.* to user;
flush privileges;
When I check in the user table, the Create_tmp_table_priv
Hi,
If you mean the concept (in Oracle) where an instance is effectively one
database, the architectures differ a whole lot. Whereas Oracle, as I said,
creates an instance for each database it's running, MySQL can handle
several databases within one server process instance.
The concept of data f
Hi,
Those builds are horribly out of date, I recommend you get the binary
package (if available) from the MySQL.com site, Other wise grab the
source distribution and compile it your self.
Peter Lovatt wrote:
>
> Hi
>
> Dont use the rpm, go for the package at
>
> http://pkgmaster.com/package
Hi
I Dont think this will work coz I need the company which has serviceid = 1
AND serviceid = 2 and serviceid = 3
So let's take this Query ,
Select companyid, count(*) from CompanyServices where
serviceid = 1 or serviceid = 2 or serviceid = 3
group by companyid
having count(*) = 3
If i have an
Hi,
We, StarHub Pte Ltd, decided to use MySQL/Linux for one of our new projects.
Since all of our DBAs are Oracle trained, we need to speed up our MySQL
skills.
Therefore we already installed MySQL (3.23.51) on our Linux server (Red Hat
Linux release 7.2)
to play with this database. Using the boo
Hi All
I had installed MYSQL 3.23.51 on Solaris Sparc 2.8
The Login name i used to loginto Solaris is MySQL.I didnt use the root
account to install MySQL
When i try to connect to that MySQL Database from a Windows Machine using
MySql Front Client , it says that
Connection Failed
2003 - Cannot C
failed to insert BLOB data on multibyte charset
i'm using GBK charset. mysql 4.01
use PHP to insert, did addslashes before insert
however, failed.
i've read the mysql_escape_string() source code. noticed that, mb char is
processed differently, but is it a must ?
yes, php+libmysql is not up to d
It looks like the entire text object is retrieved, and then a substring is
returned from the text object. Are there any functions that only retrieve a
portion of the text object? Meaning the whole text object is not loaded
from the hard drive, and then a substring is returned. In other words, I
>What version of MySQL are you using?
Our host, Interland, is running a pre-3.23 version.
>back, 3.23.x supports them), then just issue a similar query and store
>the result yourself...
Should've thought of that myself. Thanks.
--
Hi.
On Wed 2002-07-17 at 03:21:34 +0200, [EMAIL PROTECTED] wrote:
> SELECT * FROM O_Sessions AS first, O_Sessions AS second WHERE
> first.iSession=MAX(second.iSession) AND first.iUser=second.iUser
>
> yes, nice idea, but in mySQL, grouping functions like MAX are only
> allowed in SELECT ... FROM
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 17 July 2002 1:59 p.m.
To: Defryn, Guy
Subject: Re: Joins, ANSI 92 or the "old way"
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass th
Hi,
I just encountered a problem when entering a datetime field. Using
'now()' in my SQL string input a time about 13 minutes before my other
method (a JSP System.currentTimeMillis() method - one that generates the
time from the CPU clock) Can anyone tell me why the time generated by now()
d
Salutations Robo,
You are very close.
Try:
Select * from O_sessions order by iSession DESC limit 1,1
Or if you don't care how many records are returned:
Select * from O_sessions order by iSession DESC
and then just take the top record.
No need to group by (that I can see)
And, as always, NEVER
Awesome, that will help. I am returning variable size pages. I now think
the queries are slow because some of the pages are relatively large (65 KB).
If I could return only a portion of the page, then that would cut down on
the query time. My hard drive is definitely NOT top of the line. Thank
To return the first 500 chars of a field us the substring(str, pos, len)
function:
example
Select substring(field, 0, 500) as First500 from my_table where
something=something else;
Matthew Scarrow
ComIT Solutions Inc.
www.comit.ca
Phone: 519-442-0100
Fax: 519-442-0429
-Original Messag
SELECT * FROM O_Sessions AS first, O_Sessions AS second WHERE
first.iSession=MAX(second.iSession) AND first.iUser=second.iUser
yes, nice idea, but in mySQL, grouping functions like MAX are only allowed in SELECT
... FROM, not
in the WERE part :-(
But i will remember this way to work around the G
Em Ter 16 Jul 2002 18:19, Elby Vaz escreveu:
> Hi,
>
> the date format of MySql is /mm/dd (2002/07/16) right?
Wrong. The date format of MySQL is -mm-dd.
> How I do to insert the date typing in my form dd/mm/ (16/07/2002)?
> It is possible?
You have to format your date to insert
At 06:00 PM 7/16/2002, you wrote:
>hello,
>
>this issue is important for me too. i have a few silly questions
>
>1. why innodb table type? what is its use? which one is default? (ISAM?)
Innodb Supports row locking and transactions which is very important when a
lot of users are updating the same
On Tue, Jul 16, 2002 at 08:59:12PM -0300, Alexander Burbello wrote:
> I would like to know if MySQL has the same concept
> like Oracle has about Instance? or phisical structure
> like datafiles, control files, etc.
If you explain the concepts, we can probably help answer your
questions.
Jeremy
-
I would like to know if MySQL has the same concept
like Oracle has about Instance? or phisical structure
like datafiles, control files, etc.
Regards
Alexander
sql, query
___
Yahoo! Encontros
O lugar certo para encontrar
I would like to know if MySQL has the same concept
like Oracle has about Instance? or phisical structure
like datafiles, control files, etc.
___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.
I apologize for giving yall the wrong query. The incorrect query simply
gives the matching webpages. The query that returns the page is simple.
select page where webpage='previously obtained page.html'
Additionally, for the sake of completeness, the table for the word is the
following:
table
I have a build an ASP page to enter data in a mysql database.
When I open the page I get the following error :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[TCX][MyODBC]Lost connection to MySQL server during query
/centraladmin/products.asp, line 88
When I refresh it wo
Have you tried something like this,
SELECT iSession FROM O_Sessions GROUP BY iUser ORDER BY iSessions DESC;
Mike
- Original Message -
From: "Robo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 16, 2002 3:39 PM
Subject: ??? Simple sql-question: SELECT iSession FROM O_Se
I have a build an ASP page to enter data in a mysql database.
When I open the page I get the following error :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[TCX][MyODBC]Lost connection to MySQL server during query
/centraladmin/products.asp, line 88
When I refresh it work
Hi,
Select companyid, count(*) from CompanyServices where
serviceid = 1 or serviceid = 2 or serviceid = 3
group by companyid
having count(*) = 3
Bye and Good Luck.
--- Arul <[EMAIL PROTECTED]> wrote:
> Hi All
>
> The Table design goes like this
>
> Company Table
>
> companyid
I have a build an ASP page to enter data in a mysql database.
When I open the page I get the following error :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[TCX][MyODBC]Lost connection to MySQL server during query
/centraladmin/products.asp, line 88
When I refresh it works
thank's for your replies, but that did not help :-(
this is the setting (also look below for example table):
O_Sessions contains multilpe recordsets for iUser (let' say iUser=42).
I want the last RECORDSET of this iUser=42, not the first.
With GROUP BY, all the various recordsets with iUser=42 ar
two pieces of advice.
1: Stop posting over and over again.
2: Check the archives. This is has been discussed in the past 3 months.
There is probably some very good advice there.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: K Frey [mailto:[EM
Walt,
InnoDb physically counts all the rows in the table (unlike MyISAM
tables which stores the row count in a separate location). So in your case
it went through all 99,994 rows. The more rows you have in the table, the
longer it will take. I don't know how accurate "Show table status
Well if you want the latest and greatest iSession irrespective of the user
use
select max(iSession) from O_Sessions;
If it is to be grouped by user, then
select user, max(iSession) from O_Sessions group by user;
This will give you the max iSession for a user.
Regards
Satish
-Original Mes
Hi,
the date format of MySql is /mm/dd (2002/07/16) right?
How I do to insert the date typing in my form dd/mm/ (16/07/2002)?
It is possible?
Thanks,
Elby
_
MSN Photos é a maneira mais fácil e prática de editar e
On Tuesday 16 July 2002 05:05 pm, Jeremy Zawodny wrote:
> On Tue, Jul 16, 2002 at 03:52:35PM -0400, walt wrote:
> > I have an INNODB table which has 4 records in it. customer_number is
> > the primary key.
> >
> > If I run
> > select count(cutomer_number) from customer;
> >
> > It takes about
On Tue, Jul 16, 2002 at 03:52:35PM -0400, walt wrote:
> I have an INNODB table which has 4 records in it. customer_number is the
> primary key.
>
> If I run
> select count(cutomer_number) from customer;
>
> It takes about 15 seconds to return the number of rows.
> I ran explain on the query
Hi,
will it work if I add some custom fields to the mysql user table?
Regards
-jm
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To req
Hello.
On Tue 2002-07-16 at 07:47:33 -0500, [EMAIL PROTECTED] wrote:
> >> Of the data? Or of the queries?
> > Not the data. Just your query, the output from explain and a create
> > table statement.
>
> Query:
>
> SELECT DISTINCT cards_crypt.*
> FROM user_haves, cards_crypt WHERE
> cards_cryp
On 16 Jul 2002, at 21:39, Robo wrote:
> I want the latest (highest) iSession to be selected:
>
> SELECT iSession FROM O_Sessions GROUP BY iUser
>
> Because of GROUP BY, allways the first(!) recordset for iUser is
> selected. But i want the last recordset to be selected :-(
I'm not sure wha
Hi
Dont use the rpm, go for the package at
http://pkgmaster.com/packages/raq/4/
and install it from there, just point and click!
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.su
Hi, I'm developing a system which will use transactions with InnoDB.
In principle, when you use transactions, there is some risk that a
deadlock will happen and MySQL will abort the transaction. In this
situation, you should generally try to do the transaction again. I'm
wondering
* Wh
USually all the databases sets up fine BUT recently, I have
had to adjust databases to 0777 in order to get them to
work and change the ownership.
I prefer the more secure model of mysql.
How can I fix this?
--
contact:
Dave Yadallee NetKnow The Internet Knowledge Company
[EMAIL PROTECTED]
[root@Alpha mysql]# pwd
/usr/local/mysql
[root@Alpha mysql]# ls -al
total 48
drwxr-xr-x 12 root mysql4096 Jul 15 01:31 .
drwxr-xr-x 14 root root 4096 Jul 15 01:27 ..
drwxr-xr-x2 root mysql4096 Jul 15 01:57 bin
drwxr-xr-x3 root mysql4096
Hello.
On Mon 2002-07-15 at 15:44:11 +0200, [EMAIL PROTECTED] wrote:
> Can someone plz send me the posting from mysqlab concerning the beta
> training , I deleted it accidentally...
> Thanks
You can find the same information here:
http://www.mysql.com/training/certification.html
Greetings,
Hello.
On Sat 2002-07-13 at 05:03:43 -0700, [EMAIL PROTECTED] wrote:
> If you are on the same OS and rsync happens fine, then you should not loose
> any data.
But only if he also somehow assures that no updates take place on the
master while doing the rsync. Additionally, he should do a flush
ta
I have an INNODB table which has 4 records in it. customer_number is the
primary key.
If I run
select count(cutomer_number) from customer;
It takes about 15 seconds to return the number of rows.
I ran explain on the query and it's using the unique key index on
customer_number.
If I run
S
David,
Tuesday, July 16, 2002, 3:55:46 PM, you wrote:
DB> Same thing here, mysql 3.23.51 works well during about 2 hours then
DB> suddently load average grow up to 200 and more ...
DB> Load average is less than 4 with 3.23.49.
DB> We're using binary tar.gz non max versions from Mysql.com
DB> OS
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
i configure/make/make install mysql-3.23.51 on sparc solaris using
gcc-2.95.2. i used the configure option --sysconfdir=/usr/local/etc.
i ran the mysql_install_db script, i performed all the chown/chgrp
operations, i copied mysql.server to /etc/rc3.
I plan to attempt installing MySQL on a Cobalt Raq4 this week - anyone have
experience/advice to share? My plan is to download the RPM from mysql.com
and follow the directions on the site, but I have read some things on the
internet that say to stay away from the rpm...
Kristy
---
Hi - I've been using MySQL for a variety of functions with great success
over the last year. However, I recently rebuilt my log database server
after a crash, and I've been having a lot of trouble with two tables getting
corrupted.
One table stores my syslog entries from Kiwi Syslod Daemon, and
I want the latest (highest) iSession to be selected:
SELECT iSession FROM O_Sessions GROUP BY iUser
Because of GROUP BY, allways the first(!) recordset for iUser is selected.
But i want the last recordset to be selected :-(
How can this be done ?
(mySQL)
(iSession ist the primary key => lat
A load of 2? Heck we have systems that run a load of 20 or more without
issues. If you are doing a lot of connections you might look at optimizing
your code. Also using indexes can increase the speed as well.
---
Brad Dameron
Net
Someone has a pretty lousy filter installed
At 02:56 PM 07/16/2002, you wrote:
>Your message cannot be posted because it appears to be either spam or
>simply off topic to our filter. To bypass the filter you must include
>one of the following words in your message:
>
>sql,query
>
>If you just rep
[snip]
CREATE TABLE order_cross
SELECT date_format(data_iniz_num,'%y') as anno,ord_tmp.soc,ord_tmp.ml,
ord_tmp.cod_agente, ord_tmp.linea,
CASE WHEN month(data_ordine) = 1 then qty else 0 END as jan,
CASE WHEN month(data_ordine) = 2 then qty else 0 END as feb,
CASE W
Hi!
If the master is idle, then a slave of MySQL release 3.23.51 prints:
...
020715 12:05:33 Error reading packet from server: (server_errno=1159)
020715 12:06:03 Slave: Failed reading log event, reconnecting to retry,
log 'mysql.001' position 73
020715 12:06:03 Slave: reconnected to master
Please
Do you have some information for install mysqlgui in Linux, i do not how do
it?
Thank you...
Luis R. De Freitas R.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
Dear Dirs,
I think I' ve found a bug.
Please run the following query
(I know you don' t have my db,
try something similar)
CREATE TABLE order_cross
SELECT date_format(data_iniz_num,'%y') as anno,ord_tmp.soc,ord_tmp.ml,
ord_tmp.cod_agente, ord_tmp.linea,
CASE WHEN
I've set up replication and the slave is updating any changes made to the
master, but these errors keep showing up in the error log. Any ideas??
020716 12:57:26 Slave: Failed reading log event, reconnecting to retry, log
'walt-bin.002' position 265
020716 12:57:26 Slave: reconnected to master
On Tue, Jul 16, 2002 at 02:51:59PM +0200, Mathias Bertelsen wrote:
> Hello
>
> Do you think MySQL is secure enough to keep peoples bookkeeping in?
> is it safe enough to use without risk of losing important data? Is
> it necessary to do anything to make it secure? (eg. use of
> transactions/backu
Victoria,
I see the problem is with sql/share/charsets/latin1.conf
because German umlaut 'ü' and 'Ü' is mapped to 59 'Y' in the
sort_order array. This is very much unlike the treatment
for the other umlauts ('ä' --> 5C and 'ö' --> 5D)
german1.conf does map 'ü' --> 55 'U' giving a correct sort o
Dear Dirs,
I think I' ve found a bug.
Please run the following query
(I know you don' t have my db,
try something similar)
CREATE TABLE order_cross
SELECT date_format(data_iniz_num,'%y') as anno,ord_tmp.soc,ord_tmp.ml,
ord_tmp.cod_agente, ord_tmp.linea,
CASE WHEN
http://www.thekompany.com/products/dataarchitect/
It's not free but it is cross platform and I think it supports pgsql.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Dusan Juhas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 16, 2002 10:33 A
Hi All
The Table design goes like this
Company Table
companyid integer
name varchar(100)
Services Table
ServiceIDinteger
Servicevarchar(50)
Company Services
---
companyidinteger - References Company(companyid
> Please tell me if the MySQL 4.0.2-alpha Windows 95/98/NT/2000/XP (17.2M)
> supports the subselect command.
No version of MySQL currently supports subselects.
>From http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
"Subselects are currently being implemented in the 4.1 development
sql,query
IMHO, I'd look at creating a view that postfix looks at instead of the
table. This way you could concat the data for the view but keep it separate
in the table. rename the table users_table or something and create a view
called users.
Other than that, the concat statement I and others
You said:
--
is there a way to calculate the number of rows retrieved by a mysql query,
without actually performing it?
I want to make a paginated result like in most search engines, and for that
I need to display the number of pages
the result would have, but I do not wa
Hi All
The Table design goes like this
Company Table
companyid integer
name varchar(100)
Services Table
ServiceIDinteger
Servicevarchar(50)
Company Services
---
companyidinteger - References Company(companyid
Hi,
Im using the MySQL C API for my clients and MyISAM tables for the
database (clients and server on W2k). I would now like to be sure that
the client never hangs when inserting tuples into a table (using
mysql_real_query()). This could happen if some other client holds (and
doesnt release) a
Hello,
don't somebody know about an application which allows
to create the ERA model of a database using GUI and generate
SQL code which makes this model real?
eg:
GUI: [table1]--[table2]
[table1]
|-attr1
|-attr2
...
SQL code:
create table1 (table1_id datatype,attr1 datatype1,attr2 datatype2...)
Got it,
Thanks to all of your replies!
W.D.F.
- Original Message -
From: "Cal Evans" <[EMAIL PROTECTED]>
To: "Walter D. Funk" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 16, 2002 11:44 AM
Subject: RE: Calculating rows in a result set
> Not without actually performing SO
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Matthew Scarrow wrote:
| Try adding a primary key to the table.
|
| alter table webpage add autoid INT UNSIGNED NOT NULL PRIMARY KEY
| AUTO_INCREMENT
|
| This will help the database functions search through the table quicker.
Probably not. If the pri
Hi Oleg,
I have similar problems on FreeBSD with one or two slow queries
hogging the CPU. I am running native threads. I am looking at a
parameter in the kernel (/usr/src/sys/i386/conf/LINT). It is the HZ
parameter and has to do with polling frequency. The default is 100,
I am experimenting
Please tell me if the MySQL 4.0.2-alpha Windows 95/98/NT/2000/XP (17.2M)
supports the subselect command.
Thank you !
_
Narcis GRATIANU
ICQ#: 13344551
More ways to contact me: http://wwp.icq.com/13344551
_
Patrick J Okui <[EMAIL PROTECTED]> wrote on 16.07.2002 15:47:50:
>
>I have two collumns in my mysql database like this
>
>+--++
>|id|domain |
>+--++
>|user@domain1com |domain1.com |
>|[EMAIL PROTECTED] |domain1.com |
>
well, #1, I would revision my data model. since user and domain are 2
distinct pieces of information, I would suggest that you consider pulling
them apart and placing them in separate fields.
#2
update users set is = concat(left(id,position('@',id)),'domain2.com') where
domain = "domain1.com"
o
update set id = replace(id, '1', '2');
hope this helps
anil
- Original Message -
From: "Patrick J Okui" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 16, 2002 9:47 AM
Subject: UPDATE command..
>
>
> I have two collumns in my mysql database like this
>
> +
Walter D. Funk wrote:
>Hi everybody,
>
>is there a way to calculate the number of rows retrieved by a mysql query,
>without actually performing it?
>
>I want to make a paginated result like in most search engines, and for that
>I need to display the number of pages
>the result would have, but I
Not without actually performing SOME kind of query. You could
select count(*) from...
and insert the rest of your query there. This would give you the count.
Then store this in a session variable (PHP) for subsequent pages.
Most of the time though, I just put a NEXT button. ADODB has some gr
Patrick J Okui wrote:
>I have two collumns in my mysql database like this
>
>+--++
>|id|domain |
>+--++
>|user@domain1com |domain1.com |
>|[EMAIL PROTECTED] |domain1.com |
>|[EMAIL PROTECTED] |domain1.com |
>+---
Try adding a primary key to the table.
alter table webpage add autoid INT UNSIGNED NOT NULL PRIMARY KEY
AUTO_INCREMENT
This will help the database functions search through the table quicker.
I think another area where the query is getting slowed down is in the
translation of the Java. Java is a
We use MySQL to store financial data and have never had a problem.
The things you mentioned (transactions/backup/power failure security) should
be used with ANY database that stores critical information that cannot be
lost. No database is completely bullet proof. Regular backups stored at an
of
Hi!
I found out, that the MySQL-daemon /usr/sbin/mysqld (Version 4.02, the rpm
version), installed under RedHat 7.3 (i386) doesn't like the option
"Randomize mmap() base" from the Grsecurity kernel patch suite...
Greetings,
tobias gablunsky
__
Te
Hi everybody,
is there a way to calculate the number of rows retrieved by a mysql query,
without actually performing it?
I want to make a paginated result like in most search engines, and for that
I need to display the number of pages
the result would have, but I do not want to actually retrieve
I have two collumns in my mysql database like this
+--++
|id|domain |
+--++
|user@domain1com |domain1.com |
|[EMAIL PROTECTED] |domain1.com |
|[EMAIL PROTECTED] |domain1.com |
+--++
in a
Hi,
This is not related with your issue but if you want to
do serious development, don't use Windows 98 in any of
its versions. It is going to give a lot of problems.
Bye and Good Luck.
--- Matthew Scarrow <[EMAIL PROTECTED]> wrote:
> I've built a whole program with vb6 and mysql
> database back
Difficult to answer without knowing what the
"unix-socket problem" is.
p shah wrote:
>Hi,
>
>I want to know one thing about MYSQl,
>Why does this software always give the unix-socket
>problem when compiled and installed.
>
>I am installing on redhat 7.1.
>
>Is there a remedy to this or this will
Hi list,
Same thing here, mysql 3.23.51 works well during about 2 hours then
suddently load average grow up to 200 and more ...
Load average is less than 4 with 3.23.49.
We're using binary tar.gz non max versions from Mysql.com
OS : Linux Red hat 7.2
kernel : 2.4.10
1 Go RAM
2 * Intel 1 Ghz
Du
Hello
I have a question for all you MySQL people out there
We are a group of people planning to make a small open source
ERP/accounting/finance program. We have earlier used MySQL to great
satisfaction in other areas and would like to use it here. My question is:
Do you think MySQL is secure en
>> Of the data? Or of the queries?
> Not the data. Just your query, the output from explain and a create
> table statement.
Query:
SELECT DISTINCT cards_crypt.*
FROM user_haves, cards_crypt WHERE
cards_crypt.name LIKE "%harrod%" AND
user_haves.card_name = cards_crypt.name AND
user_haves.tota
Hi list,
Same thing here, mysql 3.23.51 works well during about 2 hours then
suddently load average grow up to 200 and more ...
Load average is less than 4 with 3.23.49.
We're using binary tar.gz non max versions from Mysql.com
OS : Linux Red hat 7.2
kernel : 2.4.10
1 Go RAM
2 * Intel 1 Ghz
Du
Chris,
Tuesday, July 16, 2002, 2:13:57 AM, you wrote:
CK> Can MySQL bind to two or more IP addresses?
Nope.
CK> i.e. --bind-address 127.0.0.1 --bind-address x.x.x.x --bind-address y.y.y.y
CK> ?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is spon
AR>> I want to write sql query to duplicate a row. It has a PRI key called ID.
AR>> The MySQL database looks like
AR>> IDNameAddress
AR>> 345 Aman42, sb
AR>> 346
AR>> 347...
AR>> I want to duplicate the ID=345.
AR>> Any suggestions ?
VR> You can have d
[snip]
Can anybody tell me the query or procedure by which i
can generate the .sql file. So that I dont need to
write the query again and again on prompt.
[/snip]
Create a text file containing your query commands and then save it as
filename.sql (calling it whatever you wish of course) and then c
[snip]
sqltext2 = "Select sum(orders.amount * products.price) AS total from
orders,products where orders.product=products.productid AND cluster = '" &
cluster & "'and orderdate > '" & printdate & "';"
[/snip]
If the query conditioals are the same for both queries you can just include
sum(orders.a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ian M. Evans wrote:
|
| SELECT @totalVotes:=COUNT(titleid) FROM movieratings
|
|
What version of MySQL are you using? I just tried this on MySQL-4.0.2
and it worked.
If your version of MySQL doesn't support variables (they go pretty far
back, 3.23
Massimo,
Tuesday, July 16, 2002, 1:02:15 PM, you wrote:
MP> I am a new user of mysql
MP> I installed 3.23.51 on my nt
MP> this is my my.ini files.
MP> [mysqld]
MP> innodb_data_home_dir =
MP> innodb_data_file_path = ibdata1:30M:autoextend
MP> default-table-type=innodb
MP> [WinMySQLAdmin]
MP> S
Nick,
Monday, July 15, 2002, 5:58:31 PM, you wrote:
NM> I'm using version 3.23.53 on Win 2k.
NM> The same things happens to me.
NM> I've also noticed that if you don't specify a WHERE clause and you have a
NM> Auto-incrementing ID field, it is reset to zero and the next record you
NM> create st
Xinguang,
Monday, July 15, 2002, 6:01:35 PM, you wrote:
>> I have been trying to use the LOAD data command to load the data
XS> instead of using the sql insert into table. It works fine but I have
XS> got some warnings, how can I see these warnings, is there a log for
XS> it, how can I see the
Adnan,
Tuesday, July 16, 2002, 2:18:22 PM, you wrote:
AY> I am having a problem in referential Integrity in mySQL. I have
AY> created a parent table which have deptno from 1-10. When i insert a row in
AY> child table that has deptno as foreign key it accept a value 11 which is
AY> actuall
Aman,
Monday, July 15, 2002, 8:35:16 PM, you wrote:
AR> I want to write sql query to duplicate a row. It has a PRI key called ID.
AR> The MySQL database looks like
AR> IDNameAddress
AR> 345 Aman42, sb
AR> 346
AR> 347...
AR> I want to duplicate the ID=345
1 - 100 of 125 matches
Mail list logo
