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
.
Any solutions/suggestions.
Thank in advance.
Vikram.
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
nally).
Thank You.
Vikram
ear, R.rank, S.code, R.regarr , R.exam
Can i have advise Please?
Thank you.
Vikram
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
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
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
explanations?
Thank you
VIKRAM
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
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
is getting 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
: 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/
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
give me some more details on what you had in mind?
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
e part of the SELECT.
I 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 t
;t know if it's 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 yo
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 Matr
R ;
mysql> USE test2
Database changed
mysql> select 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
o 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.m
able, and not writing anything to the
'host' table.
So my question is: why does the 'if empty db.host field/look up in host
table' method suggested in the manual not work? What step am I missing?
Thanks in advance for your help. I'd appreciate it if you 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
#include
int
d at the online manual but am sorry to say 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]
a telnet window open to a Linux box (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]
uld be most welcome :)
Thanks,
Vikram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I will come 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.
the data. 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]
s:
ERROR 1093: 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://
ser 2 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]
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
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
;How about performance? and Performance tuning?
I am planning 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
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 refere
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 tab
>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
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: "T
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 t
stalling PHP 3 and 4 at the same time.
Please Be Quick
Vikram
Get free email and a permanent address at http://www.netaddress.com/?N=1
-
Before posting, p
78 matches
Mail list logo
