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
this.
Any solutions/suggestions.
Thank in advance.
Vikram.
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
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 neil.mart...@exactuscorp.co.in
To: Vikram A vikkiatb...@yahoo.in; MY SQL Mailing list
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 je...@gii.co.jp
To: 'Vikram
by having accounts as you suggested?
Thanks You.
Vikram
From: Johan De Meersman vegiv...@tuxera.be
To: Vikram A vikkiatb...@yahoo.in
Cc: MY SQL Mailing list mysql@lists.mysql.com
Sent: Friday, 17 June 2011 11:50 AM
Subject: Re: Encoding Table Name and Filed Name
.
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 vegiv...@tuxera.be
To: Vikram A vikkiatb...@yahoo.in
Cc: MY SQL Mailing list mysql@lists.mysql.com
Sent: Fri, 11 March, 2011 2:43:33 PM
Subject: Re
).
Thank You.
Vikram
have advise Please?
Thank you.
Vikram
to 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
From: Vikram
Dear Sir,
As you advised we will keep the key as well documented.
Thank you
Vikram A.
From: Johan De Meersman vegiv...@tuxera.be
To: Vikram A vikkiatb...@yahoo.in
Cc: MY SQL Mailing list mysql@lists.mysql.com
Sent: Tue, 9 November, 2010 7:05:39 PM
Subject
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 vegiv...@tuxera.be
To: Vikram A vikkiatb...@yahoo.in
Cc: MY SQL Mailing list mysql@lists.mysql.com
Sent: Tue, 28 September
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
the encryption output] than its original size. It increases the db size. I am
known that if it is secure i have to choose encryption. but when i choose
encryption it leads the more memory usage.
Any comment on this?
Thank you
Vikram
From: Johan De Meersman
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 je...@gii.co.jp
To: Andy listan...@gmail.com; mysql@lists.mysql.com
Sent
explanations?
Thank you
VIKRAM
Sir,
I am Sorry,
My request is related to binlog_format variable.
Thank you
From: ewen fortune ewen.fort...@gmail.com
To: Vikram A vikkiatb...@yahoo.in
Cc: MY SQL Mailing list mysql@lists.mysql.com
Sent: Tue, 4 May, 2010 3:31:44 PM
Subject: Re: Best Bin log
[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
from the other GUI/connecting tools though they have given a access to db?
Thank you for the information.
Vikram
From: nwood nw...@plus.net
To: Vikram A vikkiatb...@yahoo.in
Cc: MY SQL Mailing list mysql@lists.mysql.com
Sent: Wed, 28 April, 2010 3:39:23 PM
Sir,
I will drop the authentication part. If stored in the code, the db password is
subject to change when needed. In this case i can not change my part of the
code. So I will go for the config file for the credentials.
Thank you for the solutions/suggestions.
Vikram
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 maxb...@gmail.com
To: Vikram A vikkiatb...@yahoo.in
Cc: MY SQL Mailing list
VIKRAM
From: Max Bube maxb...@gmail.com
To: Vikram A vikkiatb...@yahoo.in
Cc: MY SQL Mailing list mysql@lists.mysql.com
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
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/mysql
To unsubscribe
Hi Hao Ding,
I attached in my request mail it self. Please find the attachment.
Thank you
From: hao ding fire9di...@gmail.com
To: Vikram A vikkiatb...@yahoo.in
Sent: Wed, 21 April, 2010 7:25:05 PM
Subject: Re: BIN LOG Error when use Begin Trans
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 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
...@it.myjobgroup.co.uk wrote:
From: Ian Simpson i...@it.myjobgroup.co.uk
Subject: Re: Replication - LINUX to WIN
To: Vikram A vikkiatb...@yahoo.in
Cc: MY SQL Mailing list mysql@lists.mysql.com
Date: Thursday, 18 March, 2010, 9:33 AM
Hi Vikram,
There are a couple of potential problems with Linux to Windows
inserted.
I have attached my.ini file for your reference.
Please help me.
Thank you
VIKRAM
Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!
http://downloads.yahoo.com/in/internetexplorer/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
? 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 jschwa...@the-infoshop.com
To: Vikram A vikkiatb...@yahoo.in
Cc: Johan De Meersman vegiv...@tuxera.be; MY SQL
. By 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 jschwa...@the-infoshop.com
To: Vikram A vikkiatb...@yahoo.in; Johan De Meersman vegiv
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
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 renit...@gmail.com
To: Mysql mysql
on this binary storage issue.
Thank you.
VIKRAM A
From: Johan De Meersman vegiv...@tuxera.be
To: Martijn Tonies m.ton...@upscene.com
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
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
NOT 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,
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/
the helping time of the experts.
Sorry for wasting such experts time by posting simple queries.
Thank you
VIKRAM A
From: Johan De Meersman vegiv...@tuxera.be
To: Vikram A vikkiatb...@yahoo.in
Sent: Wed, 10 February, 2010 7:22:18 PM
Subject: Re: BLOB Filed - Image
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
From: Thiyaghu CK theyaho...@gmail.com
To: Vikram A vikkiatb...@yahoo.in
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
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 roland.ka...@education.lu
To: armando armand...@gmail.com
Cc: tech list
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
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
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 wal...@openquery.com
To: Vikram A vikkiatb...@yahoo.in
Cc: mysql@lists.mysql.com
Sent: Sat, 30
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 wal...@openquery.com
To: Vikram A vikkiatb...@yahoo.in
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!
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 vikkiatb...@yahoo.in
To: MY SQL Mailing list mysql@lists.mysql.com
Sent: Sat, 30 January, 2010 7:04:01 PM
Subject: IMAGE STORE
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/
Hi
I'm new to replication and looking through some docs on how to use it. Could
someone please tell me if the following terms mean the same thing or, if
not, what is the difference:
master-master replication
dual-master replication
bidirectional replication
TIA
-BT
possible to write a SELECT that
compresses a 1:n relationship into a single row. Is this possible, and
if yes, could someone show me how? Or could you suggest another way in
which I could achieve the above required output?
Thanks,
Vikram
--
Operator: So what do you need? Besides a miracle.
Neo
did consider a procedure but the problem is that the client is still
using MySQL 4.x, which afaik doesn't support stored procedures. An
upgrade is not something they can do at this point, as they're using s
shared host so the server isn't really under their control.
Vikram
--
MySQL General
?
Thanks,
Vikram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi all
I am new to stored procedures and have just started using them. Is there
any Web site you could suggest which discusses common optimization tips
for MySQL SPs?
Vikram
--
Operator: So what do you need? Besides a miracle.
Neo: Guns. Lots of guns.
-- The Matrix
--
MySQL General
get_area(11);
ERROR 1305 (42000): FUNCTION test2.get_area does not exist
Can someone tell me what I'm doing wrong? Thanks.
Vikram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
to the
appropriate documentation or post an example. Thanks.
Vikram
--
Operator: So what do you need? Besides a miracle.
Neo: Guns. Lots of guns.
-- The Matrix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
could reply to
me directly as well as the list.
Vikram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I need to write a simple C client for a project. I am using the MySQL C
API. Attached is the code. It occassionally segfaults with no visible
pattern. Could someone help me figure out why? Or any other comments on the
code to help me make it better?
/* client.c */
#include stdio.h
it didn't really help much.
I tried starting the server with --character-set=big5 but it didn't seem to
make much difference...
Thanks!
Vikram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
(which has the
MySQL client/server)
Thanks,
Vikram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
with indexes.
The issue is confounded further (at least for me) by the fact that mySQL
seems to require an index on both primary and foreign keys, and the manual
suggests KEY as a synonym for INDEX. Are the concepts of key and index
distinct or not?
Any thoughts would be most welcome :)
Thanks,
Vikram
back to you after I created the tables and made it sure.
Sorry for the confusion.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 25日 金曜日 14:42、Nils Valentin さんは書きました:
Hi Vikram,
just read the post once more. I made a mistake. You want to delete the
clients with no branches you said, so
: You can't specify target table 'clients' for update in FROM clause
Does any one know why I am getting this error (MySQL 4.1)? Can you help me
rewrite this operation *using a subquery only*?
TIA,
Vikram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
. Any ideas why?
TIA,
Vikram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
group2, group3, etc
and so on
Any idea how to do this?
TIA,
Vikram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to me. Or if you could point me
to a link, that would be great too!
TIA,
Vikram
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Hi,
Does anyone know which version of MySQL first exposed an API for
developers? Is there a changelog somewhere that might have this info? I'm
interested in seeing how the API has evolved over time.
TIA,
Vikram
--
Luke: I don't believe it!
Yoda: That, is why you fail.
--Star
Jeremy - the first one ;)
Any comments on the TOC?
Vikram
At 02:46 PM 2/8/03 -0800, Jeremy Zawodny wrote:
On Fri, Feb 07, 2003 at 03:20:47PM +0500, Vikram Vaswani wrote:
My name is Vikram Vaswani, and I'm currently working on the outline for a
MySQL reference book. This is supposed
to cover this, but in the latter sections of the book.
Fundamentally, my problem is with the Section 2 - I am not sure what level
of detail to go to in this section. Any assistance you or other list
members could provide would be very helpful :)
Thanks for your response,
Vikram
Hello all,
My name is Vikram Vaswani, and I'm currently working on the outline for a
MySQL reference book. This is supposed to be a comprehensive reference to
MySQL 4, covering all aspects of the software, including the new
transaction/subquery features.
I have put together a draft table
Hi there,
Can someone point me to amn (exhaustive) list of features in MySQL Max that
are not present in MySQL Standard? Or any other documentation that lists
the differences between the two?
Thanks in advance,
Vikram
--
Luke: I don't believe it!
Yoda: That, is why you fail
Hi all,
I get this error when compiling MySQL 4.0.9-gamma on Windows
.\debug\Strings.obj
LINK : fatal error LNK1181: cannot open input file .\debug\Strings.obj
Error executing link.exe.
Am using VC++ 6.0
Any help you can offer would be appreciated. Thanks!
Vikram
Is there anyone on this list who can point me to a link that talks about MySQL history
- how it began, original creators and vision, evolution over time to 4.x, etc?
TIA,
Vikram
-
Before posting, please check:
http
Dear friend ,
I want to connect to MySql server thru telnet ...it ask for Handshake
command so any budy can tell me what r the commands for communicating with server and
where can i find list of command ...actually i want to write mysql gui client so i
need to know what command
at the same time.
Please Be Quick
Vikram
Get free email and a permanent address at http://www.netaddress.com/?N=1
-
Before posting, please check:
http
78 matches
Mail list logo