department_master dm ON um.department_id = dm.department_id
WHERE um.role_id = rm.role_id
=
Has the left join syntax changed?
--
Terence Le Grange
Senior IS Executive - ITS
Sunway University College
Email: [EMAIL PROTECTED]
Phone: (+603) 7491 8623 ext. 8078
Website: http://www.sunway.edu.my
Turn off your auto commit (if using innodb) and run the queries. See how
many rows it updates and compare them. If it matches commit it. Else
rollback.
C.F. Scheidecker Antunes wrote:
Another thing is that table2 might not have a match.
C.F. Scheidecker Antunes wrote:
I actually forgot
[EMAIL PROTECTED] wrote:
Does this make better sense?
Yes, many thanks and regards,
Terence
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi All,
I get a duplicate column error on 5.0.13 when creating a view. Am I
doing something wrong here or do I submit a bug report? This should be
allowed as the col names
are not duplicated.
Reproduce:
create table `ticket_master` (
`ticket_id` int (5) NOT NULL AUTO_INCREMENT ,
Johan Höök wrote:
Hi Terence,
I think your problem lies in your SELECT *
If you look at the columnheaders below you get category_id twice.
I guess you have to specify your columns with aliases.
/Johan
Hi Johan,
Nope, if I change the column name to category_id1 then it's okay. See
Scott Haneda wrote:
Unless I am totally off base here, the mysql docs tell very little in
regards to how to performance tune mysql.
So far I have found this article to help:
http://www.databasejournal.com/features/mysql/article.php/10897_1402311_3
But it still leaves me with a ton of
various timezones, and so I plan to store everything
in GMT (server time) and select the time based on their timezone
preference which is stored in a user preference table.
Suggestions always welcome :)
Thanks
Terence
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Wouldnt that only work for the current year? For example I was born on
1970-08-25, select id from members where birthday = now(); wouldnt
return my birthday if it was today. Or am I missing something new in
5.0.11?
Gleb Paharenko wrote:
Hello.
Why don't you want to use just:
select id
Try to avoid running functions against columns, unless you have very
little data, as it doesnt scale well (I'm talking 6 figure tables).
Two options I can suggest are:
1. Write a scheduled job using your MONTH() DAY() to replace the values
into a birthdays table on a daily basis
2. Use 2
You should be asking the snort people whether it works with mysql version 4.
Alternatively you should provide more information if you are getting
errors from mysql.
[EMAIL PROTECTED] wrote:
Could you let me know if
mysql-standard-4.1.13-sun-solaris2.9-sparc works with snort-2.4.0.
I was
Try
DROP database `ÃáãÃáÃ`;
Gary Huntress wrote:
I need to drop a database named ÃáãÃáà using the mysql client. I'm
getting you have an error in your sql syntax for the command
DROP database ÃáãÃáÃ;
I'm sure this is a character set issue. How can I drop this database?
Regards,
:10:51 +0800
From: Terence [EMAIL PROTECTED]
To: mysql@lists.mysql.com mysql@lists.mysql.com
Hi List,
I belive version 5 does not allow me to grant access to execute
procedures, but deny updates to tables directly? I am attempting to
ensure that
all data modification is done through procedures
Also check your kernel version. We had the same problems running on the
old RH 7.3 kernel (2.4.17 was it?) After upgrading to RH9 it was fine.
Chris McKeever wrote:
MySQL 4.0.16
I am having this annoying persistent corruption issue, and am
wondering if anyone has any suggestions. I have two
It's a bit weak on foreign keys, no support for procedures and views (if
you're looking at MySQL 5) from a gui perspective (from what I have
found). Other plus points are it has a http tunnel feature if you host
your mysql database with someone (requires php on the hosted server), so
you can
Hi List,
I belive version 5 does not allow me to grant access to execute
procedures, but deny updates to tables directly? I am attempting to
ensure that
all data modification is done through procedures. Any tips or ideas when
this will be available or work-arounds?
Thanks,
Terence
wrap it in ``
e.g. `keys`
James Black wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a db named keys, and when I tried to do
grant select,insert,update,delete on keys.* to [EMAIL PROTECTED]
I get an error, about SQL syntax near 'keys.*'.
Should this work?
I am using mysql 5.0.6
on a particular master_id, and ordering by ticket_id, along
with the limit I think MySQL would be able to use such an index in an
optimization.
-Daniel
-Original Message-
From: Terence [mailto:[EMAIL PROTECTED]
Sent: Friday, May 27, 2005 10:52 PM
To: mysql@lists.mysql.com
Subject: performance
tables for each
helpdesk? Such as:
helpdesk_tickets_1
helpdesk_tickets_2
helpdesk_tickets_3 etc.
and then using a session value to query the table?
3) Any other tips or advice? (I notice my query time doubles from 100k
rows to 150k rows)
Thanks for any help...
Terence
--
MySQL General Mailing
Hi List,
When using EXPLAIN, the key length on an integer column is stated as 4.
However the column is running into 7 digits, and that's affecting our
performance. Anyway to increase the key length?
From the manual I have found that it can be done for varchar cols.
Thanks for any help.
--
MySQL
Hi,
After reading the docs I realise that in order to use mysqldump with
innodb tables i need to include
SET FOREIGN_KEY_CHECKS=0;
at the top of my dump file. Is there anyway to do this when my slave
starts up or some other way. The dump file is huge and it takes ages to
open and put the line
Hi,
I am trying to setup replication on MySQL.
Version 4.1.0alpha
Using:
./bin/mysql -h IPADDR -u replication -p
I can connect successfully, but my error logs show
041221 1:12:41 Slave I/O thread: error connecting to master
'replication # MU@IPADDR # MUST BE SET:3306': Error: 'Can't connect to
instance is trying
to connect (with tcpdump, netstat for example).
Terence [EMAIL PROTECTED] wrote:
Hi,
I am trying to setup replication on MySQL.
Version 4.1.0alpha
Using:
./bin/mysql -h IPADDR -u replication -p
I can connect successfully, but my error logs show
041221 1:12:41 Slave I/O thread
Hi all,
My system reports:
Open_tables 512
Opened_tables 24,429
The docs say that if the latter is high I should increase the table
cache size. (currently at 512)
How does one decide what size to increase it to? And is there a problem
with one of the applications that's making this figure so
Is there any kind of performance / tuning guide software for MySQL?
I am looking for something which can look at the SHOW VARIABLES and SHOW
STATUS commands, do some calculations and give some tips on how to
improve the system?
Any such product available?
--
MySQL General Mailing List
For list
According to:
http://dev.mysql.com/doc/mysql/en/COMMIT.html
With START TRANSACTION, autocommit remains disabled until you end the
transaction with COMMIT or ROLLBACK. The autocommit mode then reverts
to its previous state.
Is there anyway to disable the revert? I don't want to have to SET
Apparently OpenMosix won't work with MySQL because MySQL uses Shared Memory.
There is apparently a component called MAASK which might help.
Roy Nasser wrote:
Hi All,
We have recently acquired some new machines for our ASP service, and I
am investigating different options and setups to optimize
We're looking for a client-server instant messaging system (opensource),
powered by MySQL if possible. Anyone know of one?
I've been taking a look at Gaim, Sim etc, but these all piggyback on Yahoo,
MSN etc which is not what we're looking for since it must run on our lan.
Thanks for any ideas...
-
Hash: SHA1
On Tuesday 08 June 2004 01:56 am, Terence wrote:
We're looking for a client-server instant messaging system (opensource),
powered by MySQL if possible. Anyone know of one?
I've been taking a look at Gaim, Sim etc, but these all piggyback on
Yahoo,
MSN etc which is not what we're
i had the same problem,
for me it was here:
c:\mysql\lib\opt
and I copied it to
c:\mysql\bin\
that got me up and running. maybe it'll work for you.
cheers
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 01, 2004 10:38 AM
Subject: error
I've
Hi List,
When can we expect limits in sub-queries? I am currently on 4.1.0.
1235 - This version of MySQL doesn't yet support 'LIMIT IN/ALL/ANY/SOME
subquery'
Query:
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
nope i don't think it's possible
BUT you can use the concat feature to get the result:
select concat('NEW-',running_id), concat('DEP-',running_id')
so long as your running numbers are the same...we use this for our helpdesk
system too :)
good luck.
- Original Message -
From:
or some other process uses
all available memory. If not you may have to use 'ulimit' to allow mysqld to
use more memory or you can add more swap space
Any help is appreciated.
Thanks
Terence
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
) / count(total records) * 100)
FROM table
I need to be able to divide the number of absent by the total number of
results (eg how many times the student attended class). Right now it's in
two queries and I was wondering if it's possible.
Thanks
Terence
--
MySQL General Mailing List
For list archives
This works on 4.1.1, not sure if it works on 4.0.14:
show databases like '%backups%'
- Original Message -
From: A Z [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 12:33 AM
Subject: If DataBase Exists
MySQL 4.0.14
Possible to query for existence of a DB.
Will be fixed in 4.1.2? When can we expect that to be out? Anyone with an
idea?
(Also facing this problem here)
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 22, 2004 3:57 PM
Subject: Re: Strange behavior, Table Level
Hi,
Is there a short way to return the results from a query grouped by months
and return zero if no results found: eg:
SELECT count(*) as total, monthname(col)
FROM table
GROUP BY monthname(col)
To return:
5 - Jan
0 - Feb
3 - Mar
0 - Apr
etc.
Just wondering. I know the long way to do it, by
Hi,
Can somebody tell me whether this is good or bad:
Our mysql server has
key_buffer_size = 402,653,184 (without the commas)
The MySQL administrator tool indicates a 100% usage most of the time, and
362,324,992 as current usage within 24 hours which builds up very fast. Are
there memory leaks
Pendleton [EMAIL PROTECTED]
To: 'Terence ' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 10:41 PM
Subject: RE: Privilege to single database being revoked occasionally
Is it the same database, same user? Does it follow any maintenance or large
import?
-Original Message
for debugging purposes, please let me
know.
Thanks
Terence
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
you'll need to create temporary tables in one of the servers based on the
results of the other and then join.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 17, 2004 2:54 PM
Subject: Query to another server
Is it possible to query one server
procedures and hence the
question...thanks!
Terence
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Just to help you along, why test 100m when you can test 1b
SELECT FORMAT(count(*),0) as one_billion_rows
FROM test2.test_size
1,027,346,573
And so as we can see, mysql can handle pretty big tables.
Rgds
- Original Message -
From: Andrew Braithwaite [EMAIL PROTECTED]
To: 'Paul DuBois'
Just do a check and repair: (or just repair to fix it)
CHECK TABLE your_table
REPAIR TABLE your_table
- Original Message -
From: Jacob Joseph [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 22, 2003 12:36 PM
Subject: Error: 127
Hi All,
I have a MySQL4.0 installation
Try something like this:
INSERT INTO table1 (common_field)
SELECT common_field FROM table 2;
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 19, 2003 10:42 AM
Subject: Updating table1 from table2
Hi:
I am new to MySQL and can not find how to
We just developed and re-wrote applications on PHP from a previous ASP
environment.
The performance improvement from ASP-ODBC-MySQL to PHP-MYSQL ranged
from 20-50% in some cases, so it's pretty normal to expect a much slower
response.
Also sorry to hear about the decision.
Terence
SELECT user
FROM mysql.user;
- Original Message -
From: Binay [EMAIL PROTECTED]
To: mysql users [EMAIL PROTECTED]
Sent: Friday, December 05, 2003 3:25 PM
Subject: Mysql user
Hi all,
Can any one tell me the command to list all mysql users ???
Thanks in advance
Binay
--
MySQL
!
Terence
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
We had the same problem when running on linux with the 2.4.18 kernel.
Upgraded to the 2.4.20 and no problems since.
Don't know if that's your problem, since you didnt mention kernel versions.
Cheers
Terence
- Original Message -
From: Quentin Bennett [EMAIL PROTECTED]
To: [EMAIL
Dear All,
We recently upgraded from 3.23 to 4.1.
We used to use queries such as:
SELECT field FROM table WHERE date_field like '2003-10-10%'
(The date_field is a datetime field)
Since we found the performance quicker than using the date functions.
However this no longer works in 4.1, and the
Dear All,
Has the alpha release mysql-standard-4.1.0-alpha-pc-linux-i686.tar.gz
changed since April 12 2003? Just want to save myself a few hours
downloading...
I am putting it into production shortly, and was wondering too if there's
any news on the stable release of the same?
Thanks
Terence
select count(*), monthname(yourfield)
from yourtable
where year = '2003'
group by monthname(yourfield)
- Original Message -
From: Scott Haneda [EMAIL PROTECTED]
To: MySql [EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 12:38 PM
Subject: month by month count
I need to generate record
,
timeaccess datetime ,
remote_addr varchar(30) ,
include varchar(50) ,
PRIMARY KEY (id),
UNIQUE id (id),
INDEX others (include,username)
);
Thanks alot for your help.
Rgds
Terence
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Dear All,
Is it possible to add the the running total of a column to the next row,
something like this:
item,amount
-
x,100
y,200
z,50
and get a result like this:
item,amount
-
x,100
y,300
z,350
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Redhat 7.3
Kernel linux-2.4.18-3
Rgds
Terence
- Original Message -
From: Richard Gabriel [EMAIL PROTECTED]
To: Terence [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, August 12, 2003 2:02 AM
Subject: Re: Error 127, some questions
What OS/kernel are you running? Thanks.
Richard
Thought I might share this with others.
I recently upgraded MyODBC from 2.50-39 to 3.51.06
When I ran simple select statements from an ASP page in which the fields
were empty, I would get the following errors:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation
SELECT
LIMIT 1;
- Original Message -
From: [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Friday, June 27, 2003 1:08 PM
Subject: SELECT single record
Thanks everybody for all you great help!
Ok, this statement will select all of my records nicely:
I asked the same question 2 or 3 months ago, and was told a week or two.
The guys from MySQL have to make sure the release is stable first.
- Original Message -
From: Sebastian Bergmann [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 3:51 PM
Subject: Re: ETA on 4.1
hostname: localhost
username: root
password: leave blank
rgds
- Original Message -
From: Richard Adler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 06, 2003 11:13 AM
Subject: mySql Command Console
can you help me with mySql control console.
it is presenting me with a
Try,
insert into user ('host', 'user', 'password')
values ('localhost', 'chicken', password('soup'));
flush privileges;
the password field needs to be encrypted with the one-way password function.
rgds
- Original Message -
From: Helge Moulding [EMAIL PROTECTED]
To: [EMAIL
seconds
- Original Message -
From: Martin Hudec [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 3:55 PM
Subject: processlist
Hello all at mysql list,
can anyone tell me, please, what kind of format is Time in PROCESSLIST?
thanks
--
Martin Hudec
Check the log for error messages, it's in the data directory...
/usr/local/mysql/data/
- Original Message -
From: b b [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 6:27 AM
Subject: MySQL and Redhat 7.3
Greetings,
I am new to this list so I don't know if this
Hi All,
Can MySQL give some indication of how many questions are being asked to each
database?
Using the show variables, I can get the total questions, but was wondering
if it's possible to get
it broken down on a per database view?
Rgds
Terence
query sql
try using a double slash \\ - the first one acts as the escape character.
also works for the '
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 6:52 AM
Subject: Help with a putting a slash into a record in mysql...
I have mysql
,'COSU84413670',14724.72,'2003-03-05');
INSERT INTO lcreceive VALUES
(53,42.7090,'COSU84413690',29042.12,'2003-03-04');
INSERT INTO lcreceive VALUES
(54,22.0430,'COSU84413730',13887.09,'2003-03-05');
Best regards,
Terence Ng
--- [EMAIL PROTECTED] wrote: Hello,
Yes I think I see what you
First of all, thanks for your help.
I have discovered that the result from:
SELECT
bank,
SUM(unit_price_us * order_cbm)
FROM lcopen
GROUP BY bank;
is different to the query you provided (row OPEN).
How can I solve it?
Terence Ng
--- [EMAIL PROTECTED] wrote: Hello Terence,
I posted
Please help! I already know that my query is wrong.
I have identified it. But what is the solution to my
query?
--- gerald_clark [EMAIL PROTECTED]
wrote: I answered this yesterday.
Your FROM must precede your WHERE.
Terence Ng wrote:
How do I correct this SQL code:
2 tables
SELECT
lcopen.bank,
SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS
open,
#
SUM(lcreceive.amount_us) where lcreceive.due_date
current_date,
#
# the above statement is not correct
#
FROM lcopen, lcreceive
AND lcopen.id=lcreceive.id
GROUP BY lcopen.bank;
Terence Ng
SELECT
lcopen.bank,
SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS
open,
#
SUM(lcreceive.amount_us) where lcreceive.due_date
current_date,
#
# the above statement is not correct
#
FROM lcopen, lcreceive
AND lcopen.id=lcreceive.id
GROUP BY lcopen.bank;
Terence Ng
SELECT
lcopen.bank,
SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS
open,
#
SUM(lcreceive.amount_us) where lcreceive.due_date
current_date,
#
# the above statement is not correct
#
FROM lcopen, lcreceive
AND lcopen.id=lcreceive.id
GROUP BY lcopen.bank;
Terence Ng
=lcreceive.id GROUP BY lcopen.bank;
Like this?
-Original Message-
From: Terence Ng [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 7:09 PM
To: mysql
Subject: RE: Question - SELECT
Thanks for your help, but I just want
/* this condition */ lcreceive.due_date
,
#
# the above statement is not correct
#
FROM lcopen, lcreceive
AND lcopen.id=lcreceive.id
GROUP BY lcopen.bank;
#this condition :lcreceive.due_date current_date
#only affect to : SUM(lcreceive.amount_us)
#and not :
#SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS
open
Terence Ng
lcreceive.due_date
current_date AS receive,
#
# the above statement is not correct for the
# additional condition
#
FROM lcopen, lcreceive
AND lcopen.id=lcreceive.id
GROUP BY lcopen.bank;
Terence Ng
_
Lonely Christmas(³¯«³¨³)¡A·ºå»P·(Twins)¡AµL¶¡¹D
current_date AS receive,
#
# the above statement is not correct for the
# additional condition
#
FROM lcopen, lcreceive
AND lcopen.id=lcreceive.id
GROUP BY lcopen.bank;
Terence Ng
_
Lonely Christmas(³¯«³¨³)¡A·ºå»P·(Twins)¡AµL¶¡¹D(¹q¼v)...
¦ÜIn¤â
lcreceive.due_date
current_date AS receive,
#
# the above statement is not correct for the
# additional condition
#
FROM lcopen, lcreceive
AND lcopen.id=lcreceive.id
GROUP BY lcopen.bank;
Terence Ng
_
Lonely Christmas(³¯«³¨³)¡A·ºå»P·(Twins)¡AµL¶¡¹D
Thanks for your help, but I just want
/* this condition */ lcreceive.due_date current_date
/* affect to */ SUM(lcreceive.amount_us)
/* and not */
SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS
open
Terence
--- Christensen, Dave [EMAIL PROTECTED]
ªº¶l¥ó¤º®e¡G SELECTlcopen.bank
How do I correct this SQL code:
SELECT
lcopen.bank,
SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS
open,
#
SUM(lcreceive.amount_us) where lcreceive.due_date
current_date AS receive,
#
# the above statement is not correct for the
# additional condition
#
FROM lcopen, lcreceive
AND
Hi!
How can I print the results to the printer in
Windows2000 environment? Is there any MySQL command
for this purpose? How about the MySQL Control Center?
I have tried to search for an answer, but mostly for
the unix system. Is there any simple solution since I
am not a programmer?
Terence
Hi,
I have just upgraded to 3.23.54
How to input bulk data into table?
I have tried:
LOAD DATA LOCAL INFILE lcopen1.txt INTO TABLE
lcopen;
but it shows:
ERROR 1148: The used command is not allowed with this
MySQL version
What did I miss?
What method can I use to input bulk data?
Terence Ng
Hi,
I have just upgraded to 3.23.54
How to input bulk data into table?
I have tried:
LOAD DATA LOCAL INFILE lcopen1.txt INTO TABLE
lcopen;
but it shows:
ERROR 1148: The used command is not allowed with this
MySQL version
How come? What method can I use to input bulk data?
Terence Ng
Hi all,
Is there a way to sort records based on a particular column, varchar(3),
which contains days of the week, mon, tue, wed, thu, fri, sat, sun
I need the order to be mon, tue, wed, thu etc.
Select day_of_week from my_timetable
order by day_of_week
Gives
fri
mon
sat
sun
thu
tue
wed
Is is
;DATABASE=mydb;UID=user;PWD=pwd;PORT=3
306;OPTION=16384;
myConn.Open
Hopefully this works.
Cheers
Terence
Hi All!
I've Select like this:
SELECT ExpDepDate, ActArrDate FROM oceandata
It works beautifully
But When I modify it like this
SELECT ExpDepDate, ActArrDate
sql,query
I have noticed an entry in the processlist which reads
UserHostDBCommandState
unauthenticated userconnecting host[blank]connectlogin
Can someone shed some light on this for me? Where is it coming from? Is it
anything to be concerned about?
Thanks
Terence
---
Uptime: 90471 Threads: 10 Questions: 3071980 Slow queries: 3 Opens: 1274
Flush tables: 1 Open tables: 64 Queries per second avg: 33.955
- Original Message -
From: Bryce C [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 10, 2002 1:14 PM
Subject
well the result is correct. the sum of first is 1 for the first record. the
sum of first AND second would be 3.
select first, second, sum(first + second) from example;
is that what you want?
Rgds
Terence
- Original Message -
From: Kevin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent
show tables from database;
- Original Message -
From: Mark Worsdall [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 06, 2002 2:42 PM
Subject: How to read table names within database?
Hi,
I notice that lots of mysql gui's all can find out the contents (tables)
of any
I personally have never had a problem with Redhat.
Andrew try this:
grant all privileges on *.*
to 'amp'@'%'
identified by 'blah'
(with grant option)
;
let me know if it works.
- Original Message -
From: Matt Hargraves [EMAIL PROTECTED]
To: Andrew Pierce [EMAIL PROTECTED]; [EMAIL
did you flush privileges after setting the password? % stands for wildcard
:)
- Original Message -
From: neal [EMAIL PROTECTED]
To: mySQL [EMAIL PROTECTED]
Sent: Thursday, August 29, 2002 10:47 AM
Subject: RE: JDBC - Access denied REVISED = simply won't accept passwords
when logging in
You need a combo of cron jobs (man crontab) and use either mysqldump or
mysqlhotcopy.
cron:
* 3 * * * path_to_your_script
script
./mysqldump --opt -A path_to_output_sql_file -u username
this is just one of the many ways.
- Original Message -
From: Ilyas Keser [EMAIL PROTECTED]
To:
The key words are over which I have no control. See if you can figure it.
- Original Message -
From: Andrew Conkling [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 22, 2002 12:36 PM
Subject: Error
Hey, I'm trying to create a db on a server (over which I have no
try this:
selectwhere WHATEVER LIKE 'whatever%'
notice the '%' at the end not the beginning...hope this is what you
wanted...
lekker dag verder boet.
- Original Message -
From: Chris Knipe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, August 18, 2002 5:54 AM
Subject: Re:
it means access denied. either cos you dont have permissions in your mysql
privilege table or your password is wrong. did you supply a valid username
and password in the command string?
- Original Message -
From: Dave Reinhardt [EMAIL PROTECTED]
To: MySql Support [EMAIL PROTECTED]
Sent:
)
If not, what do I need to look into? perl?
Thanks
Terence
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
www.mysqlfront.de
- Original Message -
From: Thomas Edison Jr. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 1:27 PM
Subject: Connectiing mySQL db on Localhost to mySQL DB on Server
Hi,
I would like to export Table Data which is on my
localhost mySQL Server,
simplist way i know and use, is through mysqlfront
www.mysqlfront.de
- Original Message -
From: Chip Wiegand [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Monday, July 08, 2002 1:11 PM
Subject: export table?
Where is info on exporting a table? I checked the mysql docs and the
where's your execute line?
oconn.execute (sqltext)
all you're doing is putting the sql statement into a variable and nothing
else.
- Original Message -
From: Defryn, Guy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 03, 2002 12:41 PM
Subject: Insert with ASP into mysql
it's in the docs.
use mysql;
or
update databasename.tablename ...
- Original Message -
From: Page Works Web Solutions [EMAIL PROTECTED]
To: MySql mailing list (E-mail) [EMAIL PROTECTED]
Sent: Wednesday, July 03, 2002 1:51 PM
Subject: Root pass
Hi,
any ideas on this one
[admin
have you run the grant command? this adds users SEPERATE from your unix
user list.
- Original Message -
From: [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Thursday, June 27, 2002 2:39 PM
Subject: Access denied @locahost
I've been scowering (sp?) the docs but I can't get
Dear list,
ERROR 1031 at line 5167: Table handler for 'total' doesn't have this option
I am trying to use mysqldump to backup my server to another. Can anyone tell
me what the above error means? Is it a column name or perhaps some data
that's conflicting?
Rgds
Terence
- Original Message
merge/union...which i guess is the problem? is it not fully supported by
mysqldump yet?
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 12, 2002 5:33 PM
Subject: Re: MySqlDump
Terence,
Wednesday, June 12, 2002, 10:20:03 AM, you wrote
look for a program called DBTools, best in it's category for this kinda
thing.
- Original Message -
From: Ahmed Farouk [EMAIL PROTECTED]
To: César Aracena [EMAIL PROTECTED]; 'MySQL General'
[EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 7:06 AM
Subject: Re: ACCESS to MySQL
just
1 - 100 of 103 matches
Mail list logo
