ks. Thanks very much.
Thanks,
Anoop
On Fri, Aug 21, 2009 at 8:26 PM, Anoop kumar V wrote:
> I am having trouble executing what you have sent. Below is output
>
> mysql> set @sql = concat( "select
> "> iams_id as iamsId
> "> ,div
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 datab
| 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:
> H
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 wi
AIL 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 ROU
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
s like 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 u
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
EMAIL PROTECTED]> wrote:
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
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 cal
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 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 |
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 '%';
Now I want to validate that the user-enterred-value is only a numeric
value...
(the major problem is where users ente
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
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 tables
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
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 you
--+-+
> | task_id | latest |
> ++-+
> | TASK23C6054B9D416C08:1284FD4:103FB047DF1:-7ECF | 2005-05-20 14:39:29 |
> ++---------+
> 1 row in set (0.02 sec)
>
> Mathias
>
>
> Selon Anoop kumar V &l
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 -
e this - I 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
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
++--
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
su
bit.
Thanks,
Anoop
On 5/24/05, [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 si
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 <mailt
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
again
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 the
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;
>
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 ha
hould I run mysqld-nt-max for this functionality to work??
>
> >j
>
> >jAlso - I need to run only myisam and nothing else - we do not use innodb
>
> >jor bdb or anything else but myisam.
>
>
> Anoop kumar V <[EMAIL PROTECTED]> wrote:
>
>
gt; >
>
> >well - how can i tell if i have disabled symlinks???
>
> >
>
> >I have not checked using 4.1.11.
>
> Anoop kumar V <[EMAIL PROTECTED]> wrote:
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> Thi
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
> sa
the data is there because the size of the .myd files is 50 MB -
>
> >well
>
> >none of the .myi or .frm file is missing or empty!
>
> >Also I noticed that the .sym files have numbers auto-enterred before the
>
> >file path I had specified - I guess it is in ru
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 cre
e_add('', interval 1 day),
> interval
> 1 day),'%Y%m%d') = date_format('','%Y%m%d');
>
> It will give you 1 if date is valid.
>
> Best regards,
> Mikhail.
>
>
> - Original Message -
> From: "Anoop kumar V" <[EMA
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 the
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 possi
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 o
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 insert
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 n
when data 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
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 surpr
42 matches
Mail list logo
