Dear All,
I have the following table (MYISSAM or INNODB)
Tablename Filed Type size
app_colid_Examid registerno varchar 15
app_colid_Examid subcode varchar 15
app_colid_Examid mode varchar 2
app_colid_Examid programmeid Integer
app_colid_Examid subjectorder Integer
app_colid_Examid colle
Hi,
Is it possible to hide the VIEW definitions from query browser ? Or any
other solution to hide the views ? Because I have used views for
report purpose; where I have used AES_DECRIPT() function or decipher. When view
is visible, this function and KEY also visible. I want to disable this.
Hi Neil,
thank you for your response,
The admission number/register number will contain text/symbol(-,/,#). Is it
possible to keep this as increment ?
From: Neil Martins
To: Vikram A ; MY SQL Mailing list
Sent: Thursday, 21 July 2011 12:06 PM
Subject: Re
Hi there,
I need a technical help fro you,
I have developed a software for college & school. Here we have concept called
register number/admission number. These are two unique umber for each student.
My application resides Client/server model.
These numbers will be generated (some defined form
Mr. Jerry/and all,
I am drooping this idea of making schema encryption . As it leads to lots of
confusion as Mr. John said.
I am following the data level encription.
Thank you for the comments.
Vikram
From: Jerry Schwartz
To: 'Vikram A' ; 'Jo
enough by having accounts as you suggested?
Thanks You.
Vikram
From: Johan De Meersman
To: Vikram A
Cc: MY SQL Mailing list
Sent: Friday, 17 June 2011 11:50 AM
Subject: Re: Encoding "Table Name" and "Filed Name"
- Original Message --
d our idea.
Thank you
Vikram A
Sir,
Ok sir, thank you for your advise. We shall keep the logs in another
Disk/Drive.
From: Johan De Meersman
To: Vikram A
Cc: MY SQL Mailing list
Sent: Fri, 11 March, 2011 2:43:33 PM
Subject: Re: Table Records Deleted by anonymous user!
From: "V
Dear Experts!
Our institution has a centralized MySQL server which is accessed by several
clients. Today we found that a particular table's records are missing. We could
say that it is done intentionally but could not point anyone because we did not
enable the logging feature in MySQL. I w
Hi,
MySQL (version 5.1.45 , windows based) AES_DECRYPT () function is not working
properly,
If I removed Order by clause from the following query it works Fine.
If I add order by it resulting blob[empty] value.
>> select
S.semyear as semester, S.part as part,
S.code as code, S.subject as
Dear Sir,
As you advised we will keep the "key" as well documented.
Thank you
Vikram A.
From: Johan De Meersman
To: Vikram A
Cc: MY SQL Mailing list
Sent: Tue, 9 November, 2010 7:05:39 PM
Subject: Re: Best encription method?
Seems like a better
use the AES_ENCRYPT and AES_DECRYPT by using the "key string"
as a parameter. We can keep this key string as our security point. We found it
is giving better performance in all cases.
Can i have your advise please?
Thank you in advance!
Vikram A
____
Fr
Sir,
I must adopt the encryption. I shall bear the cost of the memory.
Thank you for the guidance.
Vikram A
From: Johan De Meersman
To: Vikram A
Cc: MY SQL Mailing list
Sent: Tue, 28 September, 2010 2:08:57 PM
Subject: Re: Best encription method?
On
To: Vikram A
Cc: MY SQL Mailing list
Sent: Mon, 27 September, 2010 6:55:04 PM
Subject: Re: Best encription method?
Both have benefits.
Application level:
* data is encrypted during transmit, too
* processing is offloaded from your hard-to-scale database server
question is, which is portable, which is consistent? or altogether the
encryption should not degrades the performance.
Note: The application is going to be across an intranet
Suggestions are appreciated!
Thank you in advance.
Vikram A
Whether it will make any
misconduct on other MYISSAM databases?
Thank you!
Vikram A
Hi,
I have doubt on the execution time. Can any one help me!
Which operation will take much time INSERT or UPDATE ?
Thank you
Vikram
Hi All,
In this case how the images of a book will be stored, a chapter may contain
number of images with different size.
Or It deals only text?
Thanks.
Vikram A
From: Jerry Schwartz
To: Andy ; mysql@lists.mysql.com
Sent: Fri, 11 June, 2010 9:05:26 PM
Sir,
I am Sorry,
My request is related to "binlog_format" variable.
Thank you
From: ewen fortune
To: Vikram A
Cc: MY SQL Mailing list
Sent: Tue, 4 May, 2010 3:31:44 PM
Subject: Re: Best Bin log - type in MYSQL
Vikram,
> I am using win-serv
Hi,
I am using win-server and xp for my master, slave setup. when i do the
beginTrans with bin-log = STATEMENT it is causing error. If i defined this with
any one of the following, its working quite fine. MIXED, ROW.
Which is the best one in the above two? Or how it differs?
Can I have your ex
From: Johan De Meersman
To: Vikram A
Cc: MY SQL Mailing list
Sent: Wed, 28 April, 2010 9:55:38 PM
Subject: Re: My sql Security
Rip out the DB authentication part, and store those credentials in-code, in
some config file or the registry, or some remote mechanism like LDAP.
If your
from the other GUI/connecting tools though they have given a access to db?
Thank you for the information.
Vikram
From: nwood
To: Vikram A
Cc: MY SQL Mailing list
Sent: Wed, 28 April, 2010 3:39:23 PM
Subject: Re: My sql Security
On Wed, 2010-04-28 at 13:58
[which is for Application]. By using DB the user name and the password,
people who know the mysql are opening the DB using some GUI tools. How this can
be avoided; because it is major issue right now in my work place.
Please Can any one can help me?
Thank you
VIKRAM A
suggest Which is the best format?
Thank you
VIKRAM
From: Max Bube
To: Vikram A
Cc: MY SQL Mailing list
Sent: Thu, 22 April, 2010 2:17:29 AM
Subject: Re: Fw: BIN LOG Error when use Begin Trans in Replication.
Hi Vikram,
Add binlog_format=row to your my.ini master's conf file
2010/4/21 V
sed?] format for
bin log. I left it as such. I hope it is enough.
As you said, in the my.ini file which part i suppose to add this binlog-format
= statement ?
Thank you
Vikram
From: Max Bube
To: Vikram A
Cc: MY SQL Mailing list
Sent: Thu, 22 April, 2010 2:17:29
Hi Hao Ding,
I attached in my request mail it self. Please find the attachment.
Thank you
From: hao ding
To: Vikram A
Sent: Wed, 21 April, 2010 7:25:05 PM
Subject: Re: BIN LOG Error when use Begin Trans in Replication.
Vikram,
I don't find my.ini.
i point my slave as server[I have done for checking beginTrans]; it is
running quite well.
Can I have help from any one. It will be useful to me.
I am attaching the my.ini for your reference.
Thank you
Vikram A
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
Hi,
I would like to export my table structure from MYSQL from a particular db. Is
there any tool for doing this?
Please guide me.
Thank you
VIKRAM A
Hi,
I have problem in the insertion of 0 in auto_increment.
I have set in my.ini file as follows,
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,
NO_ENGINE_SUBSTITUTION,NO_AUTO_VALUE_ON_ZERO"
Even now the auto increment filed is not allows to insert a zero; If i insert
zero, 1 is getting i
: Ian Simpson
Subject: Re: Replication - LINUX to WIN
To: "Vikram A"
Cc: "MY SQL Mailing list"
Date: Thursday, 18 March, 2010, 9:33 AM
Hi Vikram,
There are a couple of potential problems with Linux to Windows
replication, but they are easily avoidable.
1) Table names: There
Hi,
I have done replication with Win to Win servers with mysql version
5.0.41-community-nt.
Now,
We have Enterprise Linux(Red Hat 4.1.2-14) and windows server2003.
Is it possible do the replication LINUX(Master) to WINDOWS SERVER2003(Slave) ?
It will be great help to me.
Thank you.
VIKRAM A
? I am using mysql 5.1.32
Please, Can any one you help me?
Thank you
VIKRAM A
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
http://in.yahoo.com/
you experts will agree with this. Or your comments and suggestions are
welcome for the better design.
Thank you
VIKRAM A
From: Jerry Schwartz
To: Vikram A
Cc: Johan De Meersman ; MY SQL Mailing list
Sent: Tue, 23 February, 2010 3:53:38 AM
Subject: RE
default it is 1 MB.
Thank you
VIKRAM A
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
http://in.yahoo.com/
system, can you the idea about the archive system[If
needed i will give the table structures].
It will be grate help to me.
Thank you
VIKRAM A
From: Jerry Schwartz
To: Vikram A ; Johan De Meersman
Cc: MY SQL Mailing list
Sent: Tue, 16 February, 2010 9:32
Dear Sirs,
I would like to have the MYSQL master and slave on my application setup.
I am using windows vista and mysql 5.1.x
what are the needed things for this master salve setup?
So that, I can proceed further with manuals available.
Thank you
VIKRAM A
The INTERNET now has a
folder has kept.
C:\ProgramData\MYSQL - this i have removed after another uninstallation. Then I
tried once again the service has started successfully.
Thank you
I hope it ll help you
VIKRAM A
From: Miguel Cardenas
To: Mysql
Sent: Sun, 14 February, 2010 6:52
Sir,
Thanks for your suggestion,
I will go for blob storage, because our application will maintain the data on
yearly basis[stupersonal2008, stupersonal2009 etc.]. So i feel we may not face
such kind of performance issue in our application.
Thank you
VIKRAM A
on this binary storage issue.
Thank you.
VIKRAM A
From: Johan De Meersman
To: Martijn Tonies
Cc: mysql@lists.mysql.com
Sent: Fri, 12 February, 2010 1:09:32 PM
Subject: Re: how things get messed up
On Fri, Feb 12, 2010 at 8:27 AM, Martijn Tonies wrote
helping time of the experts.
Sorry for wasting such experts time by posting simple queries.
Thank you
VIKRAM A
From: Johan De Meersman
To: Vikram A
Sent: Wed, 10 February, 2010 7:22:18 PM
Subject: Re: BLOB Filed - Image Store
On Wed, Feb 10, 2010 at 2:08 PM
Hi,
What is the basic functionality of the MyISAM, InnoDB etc ?
Vikram A
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
http://in.yahoo.com/
NULL);
I can store and i can retrieve the image to local machine as a file.
I NEED TO SHOW ALL THE FIELDS IN THE CRYSTAL REPORT.
Thank you
VIKRAM A
Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!
http://downloads.yahoo.com/in/internetexplorer/
Hi experts,
I have blob filed, which contains the image.
I am using BV6.0 as my front end application. And i have some pre-defined
[defined by me] .rpt file. Along with the details, i would like to add the
photo on the report.
Can you help how to do this?
Thank you
Regards,
VIKRAM A
hi
It is not working,
select * from table_name group by movid having max(movid)
but it is working fine
select * from table_name order by movid desc limit 1
From: Roland Kaber
To: armando
Cc: tech list ; mysql@lists.mysql.com
Sent: Sat, 6 February, 2010 8:
From: Thiyaghu CK
To: Vikram A
Sent: Sat, 6 February, 2010 3:05:25 PM
Subject: Re: MY SQL Slave Server
Hi Vikram,
Ya sure, slave can be in vista. Yes, you can install 2 or more setups in same
system but port has to be different, and if its linux platform change the sock
name
Dear Experts,
I would like to configure the slave for my main server. My server is running in
the FEDORA 11.
I would like to make another mirror of the DB in the same server/ The copy of
the DB can be kept at win server / another Fedora server.
Can you suggest how to do the above?
Thank you
sorry the link i given is wrong. Please follow this
http://dev.mysql.com/tech-resources/articles/vb-blob-handling.html
- Forwarded Message
From: Vikram A
To: MY SQL Mailing list
Sent: Sat, 30 January, 2010 7:04:01 PM
Subject: IMAGE STORE @ FEDORA 11
Dear One,
I found nice
Dear One,
I found nice solution on the following citation
http://dev.mysql.com/tech-resources/articles/vb-cursors-and-locks.html
It was really helpful to me.
Thank you
VIKKI A
Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!
http://downloads.yahoo.com/in/internetexp
may have the following, when ever i want the image of a i
need look for the share machine! If it is not available it may cause some
difficulties.
Please share your knowledge
Thank you
From: Walter Heck
To: Vikram A
Cc: MY SQL Mailing list
Sent: Sat, 30
Dear Walter Heck,
I am happy to receive immediate response from you.
I am not clear with your answer, can you please explain it?
Thank you
From: Walter Heck
To: Vikram A
Cc: mysql@lists.mysql.com
Sent: Sat, 30 January, 2010 2:29:43 PM
Subject: Re: Image
Hi,
I am using MYSQL with VB 6.0. We have fedora11 my sql (version 5.1.32).
We have an client server application, server is located at another end of an
intranet and the nodes are connected from different ends of intranet.
In this modal, I need to store image of the student from one node that h
Dear Admin,
I would like to share and get inputs from experts on MYSQL Db.
I request you to grant access to me.
Thank you
Regards,
Vikki A
Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!
http://downloads.yahoo.com/in/internetexplorer/
52 matches
Mail list logo
