Hi All,
I am facing a problem in porting an application written for oracle to run on
mysql.
The application uses a sqlmap (ibatis) at the heart of which is basically a
file that defines all sql's used in the application. It is very well
organized this way. The application uses Oracle as the
.
Thanks,
Anoop
On Fri, Aug 21, 2009 at 8:26 PM, Anoop kumar V anoopkum...@gmail.comwrote:
I am having trouble executing what you have sent. Below is output
mysql set @sql = concat( select
iams_id as iamsId
,division_name as divisionName
,region_name
Hi Experts,
I need a small help - I think the solution is not complex, but I am not sure
where to start.
Here is my problem. I have a table that defines the employee to manager
relationship. This table will interface with another system and the users
would be created in the other system. There
| Nigel Tufnel | 1003 |
| 1006 | Derek Smalls | 1003 |
+--+---+--+
The number happened to be sorted here - but that may not be the case - there
are new manager hires etc..
Thanks.
On Dec 1, 2007 4:48 PM, Anoop kumar V [EMAIL PROTECTED] wrote:
Hi Experts,
I
PROTECTED] wrote:
Thanks!!
It helps me a lot!! But now, I just need to know how I do to block
subqueries (if it's possible...)
Anoop kumar V escreveu:
http://dev.mysql.com/doc/refman/5.0/en/revoke.html
You can use:
REVOKE ALTER ROUTINE, CREATE ROUTINE, EXECUTE ON * TO USER;
Anoop
http://dev.mysql.com/doc/refman/5.0/en/revoke.html
You can use:
REVOKE ALTER ROUTINE, CREATE ROUTINE, EXECUTE ON * TO USER;
Anoop
On 5/28/07, Ricardo Conrado Serafim [EMAIL PROTECTED] wrote:
Hi,
I need to know if it's possible block things like store procedures,
triggers, etc in MySQL 5.0
Can you post your table definitions and some sample data.
Also what is the end requirement - how should the end result look like?
Anoop
On 4/23/07, Clyde Lewis [EMAIL PROTECTED] wrote:
Guys,
I have the following table that contains some information about a
cars. I'm trying to write a query
DDLUTILS is what you need:
check this out:
http://db.apache.org/ddlutils/
and better still (if you are using Ant as a build tool):
http://db.apache.org/ddlutils/ant/
Then you can store these ant scripts in your VCS (version control system).
To create or destroy the schema with data just run an
perhaps an unnecessary complication, why would this be
better than the root SQL CREATE statements?
-Micah
On 04/01/2007 12:41 PM, Anoop kumar V wrote:
DDLUTILS is what you need:
check this out:
http://db.apache.org/ddlutils/
and better still (if you are using Ant as a build tool):
http
:
Why do you recommend using trigger instead of unique index?
I think when unique index works I don't have any reason to use trigger.
If the field you want to be unique is big one, like char(1000) or TEXT,
You have to use trigger to save the uniqueness, though.
On 3/2/07, Anoop kumar V [EMAIL
I would suggest you put an after insert trigger which does the validation
for you. If 2 fields are already null then it will just return an error and
rollback else it will allow the insert to be committed.
regards,
Anoop
On 3/1/07, Kory Wheatley [EMAIL PROTECTED] wrote:
I have a database
This may help you:
mysql create table locais(
- id int,
- type varchar(2),
- `desc` varchar(10));
Query OK, 0 rows affected (0.12 sec)
mysql select * from locais;
+--+--+---+
| id | type | desc |
+--+--+---+
|1 | t1 | sk|
|2 | t2 | dsk |
|
Hey Scott -
I dont think you can use , with mysqlimport as a field separator if it is
part of the data. use something else - I used the pipe | character...
This is what worked for me:
C:\mysqlimport --fields-enclosed-by= --fields-terminated-by=|
--lines-terminated-by=\r\n --ignore-lines=1
This is very useful.
Can you please also show how this can be used to validate user input like
for example:
We have this query currently:
select id from users where id like 'user_enterred-value%';
Now I want to validate that the user-enterred-value is only a numeric
value...
(the major problem
hi All,
I have 2 tables used for reporting and there are no primary keys or
indexes for either. I am trying to run a select query to identify some
rows that need to be removed. But for around 100,000 rows the query is
taking too long. Can somebody please help me in tuning this query?
The 2
enhancement?? (Maybe I am scanning the tables once too
many.. or)
Need help please.
Thanks,
Anoop
On 10/19/05, Jasper Bryant-Greene [EMAIL PROTECTED] wrote:
On Wed, 2005-10-19 at 17:39 -0400, Anoop kumar V wrote:
I have 2 tables used for reporting and there are no primary keys or
indexes
Alternatively, you can parse the text files using application logic
(java, c++, etc) and then after extracting (and cleaning) your data
insert them into mysql.
matter of fact we do something very similar - read from a host of text
files - massage the data and then send them to be inserted into
The reason i sthat you have not provided authorisation privileges to the
database or to the tables within the database for that user...
Very often we think granting all to the database is enough to make our app
work with a particular user - this may be true for some databases - but in
mysql
:1284FD4:103FB047DF1:-7ECF | 2005-05-20 14:39:29 |
++-+
1 row in set (0.02 sec)
Mathias
Selon Anoop kumar V [EMAIL PROTECTED]:
Hi mysql-ers,
I need help in a basic query:
I have this table:
select * from
Hi mysql-ers,
I need help in a basic query:
I have this table:
select * from isr2_aud_log where
id_secr_rqst IN ('TASK23C6054B9D416C08:1284FD4:103FB047DF1:-7ECF')
--and name_rec_type = 'Assignment'
order by id_secr_rqst, dt_aud_rec
just need the id_secr_rqst if and
only if it has the latest name_rec_type as 'Assignment' - I do not care what
the earlier records contained.
help please,
Anoop
On 6/2/05, Anoop kumar V [EMAIL PROTECTED] wrote:
Hi mysql-ers,
I need help in a basic query:
I have this table:
select
SOLVED:
I changed my query to include max(t1.dt_aud_rec) instead of t1.dt_aud_rec.
I had guessed that it required just a tweak here and there...
Does anybody have any other suggestions apart from this??
Thanks,
Anoop
On 6/2/05, Anoop kumar V [EMAIL PROTECTED] wrote:
OK - I have found
You can use joins instead of subqueries if you cannot upgrade to 4.1.x of
mysql.
Actually in my opinion joins are more efficient than subqueries. Subqueries
(more often than not) tend to become bottlenecks in the long run..
http://dev.mysql.com has a some reference material about converting
is that it only returns the record related to the second
largest date for each id_secr_rqst.
any suggestions how to get both the second and the largest date records in
the same query?
Thanks,
Anoop
On 5/23/05, Peter Normann [EMAIL PROTECTED] wrote:
Anoop kumar V mailto:[EMAIL PROTECTED] wrote
, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Anoop kumar V [EMAIL PROTECTED] wrote on 05/24/2005 03:02:11 PM:
Thanks Peter - you gave me some ideas...
here is what I have so far (simplified for simplification..)
select t2.dt_aud_rec, t1.id_secr_rqst from isr2_aud_log t1
hi All,
I need to create a query using no subqueries as I use 4.0.23 which does not
support subqueries. I cannot upgrade for some compellimg reasons (the
product does not support anything later than 4.0.23nt as of now). I also
cannot use any thing that is native to mysql - in the sense that
Thanks Peter - but I see two issues:
1. It returns data about only one id_secr_rqst - I want it to return data
about every id_secr_rqst in the table.
2. Limit IMO is mysql specific (I hope I am wrong) is there something
generic so I dont need to bother about which database I am running it
and nothing else - we do not use innodb
jor bdb or anything else but myisam.
Anoop kumar V [EMAIL PROTECTED] wrote:
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://Ensita.NET
http://www.ensita.net
how about this:
select substr(datetime,0,8) AS date, count(datetime) from userLog group by
date;
I could not clearly understand what you wanted to average upon.
HTH,
Anoop
On 5/6/05, Graham Anderson [EMAIL PROTECTED] wrote:
how do I get the average number of hits per day
I have a
ohh one correction:
select substr(datetime,0,8) AS date, count(date) from userLog group by date;
Anoop
On 5/6/05, Anoop kumar V [EMAIL PROTECTED] wrote:
how about this:
select substr(datetime,0,8) AS date, count(datetime) from userLog group by
date;
I could not clearly understand
am running mysql.exe (I think it is the
same as mysqld-nt).
No - when I do a select * from on a table in the moved database - I get
the error that the table does not exist.
well - how can i tell if i have disabled symlinks???
I have not checked using 4.1.11.
Anoop kumar
in advance,
Anoop
Anoop kumar V [EMAIL PROTECTED] wrote:
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://Ensita.NET
http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
Is there a link that someone can suggest which details out how to move
databases from one location to another in mysql?
Thanks in advance.
Anoop
On 5/4/05, Anoop kumar V [EMAIL PROTECTED] wrote:
I am not sure about max - but I am running mysql.exe (I think it is the
same as mysqld-nt
I use mysql 4.0.23-nt on win XP.
In order to shift some of my databases I followed the following steps as per
a recent post:
1. I moved the folders containing the database files that I wanted to move
to a new folder (from data to data2) after stopping mysql of course.
2. In the data folder I
for your answers.
Anoop
On 4/28/05, Paul DuBois [EMAIL PROTECTED] wrote:
At 19:39 -0400 4/28/05, Anoop kumar V wrote:
I mean:
Should I enable something like 'strict checking' / verbose so that
MYSQLcomplains and refrains from inserting truncated data in the
tables??
Yes, but you'll need
Is it possible to do a date field validation using an sql query.
Its like we have an html field- its a free form text field and the end user
should type in a valid date, of course in a predefined format only
(MM/dd/yyy). I tried using javascript but either it works on some browsers
and not in
So is there a function in mysql that I can call to validate dates??
Or do I need to build it?
Thanks,
Anoop
On 4/29/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Anoop kumar V [EMAIL PROTECTED] wrote on 04/29/2005 11:00:11 AM:
Is it possible to do a date field validation using an sql
No problem - I followed up and found out that this function is not
available. THought probably you were referring to a later version of Mysql..
anyways...
We use Java - and maybe I could use that - I was just wondering if I could
help reinventing something already there.
Thanks so much for
),
interval
1 day),'%Y%m%d') = date_format('yourdate','%Y%m%d');
It will give you 1 if date is valid.
Best regards,
Mikhail.
- Original Message -
From: Anoop kumar V [EMAIL PROTECTED]
To: Chris Ramsay [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Friday, April 29, 2005 6:10 PM
I am using MySQL and SQL server with Tomcat.
Our application writes into both databases (mysql and ms sql server) at once
based on some data collected from an end user. Now if the end user enters
more data (characters) than the column can hold, the data obviously gets
truncated.
But the
was not even inserted!!)
Should I enable somethink like strict checking so that MSSQL complains and
refrains from inserting truncated data in the tables??
Thanks and r,
Anoop Kumar V.
On 4/28/05, mathias fatene [EMAIL PROTECTED] wrote:
Hi,
I think you shoul dcatch the show warnings command cause
I mean:
Should I enable something like 'strict checking' / verbose so that
MYSQLcomplains and refrains from inserting truncated data in the
tables??
Thanks,
Anoop
On 4/28/05, Anoop kumar V [EMAIL PROTECTED] wrote:
Thank you,
But the show warnings does not seem to work on my prompt. I am
42 matches
Mail list logo