> if i set a field as a primary key, does it automatically make sure its
> unique or should i declare a UNIQUE constraint as well? or will primary do
> the job by itself.
a primary key is always unique. No need to give it an extra unique index.
Greetings,
Ansgar
http://www.mysqlfront.de/
---
Hello mysql,
Resently MYSQL have introduced transaction support, which at least
in INNODB allows to make consistent backup/recovery. The bad thing
about this is - MYSQLDUMP does not support anything about this, so I
had to done the same things buy hands.
The Idea is quite simple - to
hi sql ppls,
if i set a field as a primary key, does it automatically make sure its
unique or should i declare a UNIQUE constraint as well? or will primary do
the job by itself.
thanks
- Josh
[EMAIL PROTECTED]
-
Before pos
Hi!
I posted this last week, but, haven't seen any replies yet, and,
generally, there seems to be a lack of replies in the archives on the "Got
timeout reading communication packets" related issues. Here is the issue
again:
We have started doing some rather large replace intos and inserts (~3M
> how do I OVERWRITE the previous entry in the
> table? ie. is there a SQL command to do like INSERT, but if duplicate
> found, overwrite with the new value.
See REPLACE into
http://www.mysql.com/doc/R/E/REPLACE.html
Take care,
seth
---
> -Original Message-
> From: Richard Kurth [mailto:[EMAIL PROTECTED]]
> I am trying to reinstall mysql on a cobalt server I removed the
> first version but when I go to install the new version I get this
> message below saying it conflicts with another version
> could you tell
>
Hi there
I am using the same setup as yourself, but developing with MYVBQL.dll which
is a DLL that some kind fella put together for dummies like me. Works well
and very similar to ADO, couple bugs that I have picked up, but there are
workarounds.
Check the MYSQL web site for the download.
Regar
hallo mailinglist!
With reference to Yee Chuan Loh on 25.06 00:11:
> connect to your database by
> mysql -p
> then type
> drop table ;
>
>
this i want to know too. thanx!
>
> > Hi, I need to delete a table from a database. I
> > looked through the manual, but it's not listed in the
> > tab
where in the manual does it explain how to set up the root password
after an install? i understand that should be the first thing done.
as the admin of mysql on my server, should the only method i use to
login be by root and said password? OR should i make another
username/password for myself
On Sun, 24 Jun 2001 21:06:16 -0700 (PDT), ricky gonzalez
<[EMAIL PROTECTED]> wrote:
DROP TABLE table_name;
>>Hi, I need to delete a table from a database. I
>>looked through the manual, but it's not listed in the
>>table of content.
>>
>>Thank you for your help.
Mike(mickalo)Blezien
("sql" to fool bad filter... why not just require that posters are subscribed?)
"Nisha Raju" <[EMAIL PROTECTED]> writes:
> Sincerely, Trond, don't u feel that making such special provisions would
> limit the distribution of packages ?
There are some options which can't be the same: File locatio
connect to your database by
mysql -p
then type
drop table ;
On Sun, 24 Jun 2001, ricky gonzalez wrote:
> Hi, I need to delete a table from a database. I
> looked through the manual, but it's not listed in the
> table of content.
>
> Thank you for your help.
>
>
Hi, I need to delete a table from a database. I
looked through the manual, but it's not listed in the
table of content.
Thank you for your help.
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-
Hello,
I have a table where for each row, the tuple is
unique (when creating the table, i did a UNIQUE INDEX index1 (col1, col2))
I wrote a perl program to read lines from a file and insert accordingly
into the table.
How do I prevent insertions of duplicates? (as in during the insertion
loop, i
I am trying to reinstall mysql on a cobalt server I removed the
first version but when I go to install the new version I get this
message below saying it conflicts with another version could you tell
me how I can correct this. I have looked through the entire directory
structure and can not f
Sincerely, Trond, don't u feel that making such special provisions would
limit the distribution of packages ?
IMHO we should be working out to make a unified system capable of
delivering
the same efficiency while using packages packaged in any format.
Raju
sql, database - added to avoid re
At 5:38 PM -0400 6/24/01, Bob Hall wrote:
>>Does anyone have any recommendations for a good book on MySQL SQL? What
>>about PerlDBI (I noticed that the O'Reilly one is over a year old)?
>>
>>Just realizing that there's so much out there that I haven't been told...
>>
>>-Chris
>
>Paul Dubois and N
At 2:00 AM +0200 6/25/01, c.smart wrote:
>Drop the quotes (') arround the NULL
>e.g.: 7,'Markovic Stevo',NULL,NULL
No.
To load a NULL value into a column using LOAD DATA, you must use \N.
NULL, with or without quotes, will insert as the word "NULL".
>Clive Smart
>WEBServ
>
>TomazSa wrote:
>
>>
wow, that was fast, tnx (new on this m. list)
why was mysql.com down for 2 days (or more)?
lp, tomaz
Drop the quotes (') arround the NULL
e.g.: 7,'Markovic Stevo',NULL,NULL
Clive Smart
WEBServ
TomazSa wrote:
> I get *.csv file like this (1 string) :
>
> 7,'Markovic Stevo','NULL','NULL'
>
> When I use LOAD DATA INFILE syntax I get word NULL in field (MySQL table)
>
> q: I want field to be empty
I get *.csv file like this (1 string) :
7,'Markovic Stevo','NULL','NULL'
When I use LOAD DATA INFILE syntax I get word NULL in field (MySQL table)
q: I want field to be empty (in table), where the NULL is (in *.csv), how?
tomaz, Slovenia
>Does anyone have any recommendations for a good book on MySQL SQL? What
>about PerlDBI (I noticed that the O'Reilly one is over a year old)?
>
>Just realizing that there's so much out there that I haven't been told...
>
>-Chris
Paul Dubois and New Riders are releasing 'MySQL and Pearl for the
Here it is at "bookpool.com" (my favorite source for tech books) for $31.95
http://www.bookpool.com/.x/nqmc5ymle4/sm/0735709211
And an interesting one on PHP and MySQL that I haven't seen 'reviewed'
yet...
http://www.bookpool.com/.x/nqmc5ymle4/sm/0672317842
- Original Message -
From: "F
Hi!
> "Jack" == Jack Challen <[EMAIL PROTECTED]> writes:
Jack> Hi,
Jack> First of all, this is irrelevant if you're not using HP-UX.
Jack> Second, apologies if this isn't the correct list, but I've been unable
Jack> to find
Jack> a more suitable one.
Jack> This is just some i
You might want to try:
http://www1.fatbrain.com/search/searchresults.asp?SearchFunction=key&qtext=m
ysql+perl&Submit.x=11&Submit.y=11
Fatbrain has it at $35.99 (20% off list). Amazon has it at $44.99.
Frank
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Su
[EMAIL PROTECTED] writes:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> database,sql,query,table
>
> If you just reply to this message, and include
But the INSTALL-SOURCE file you get after unzipping the tarred file says you
can.
And I have been using it the same way as listed there with success on a Red
Hat 6.2 machine.
Raju
> This is _not_ a recommended way to use it on a Red Hat Linux
> system. Get the srpm and do a "rpm --rebuild" of it
Mark Lo wrote:
>
> Hi,
>
> How to bind mysql to specific address if I am using my.cnf file.
>
> etc.
> [mysqld]
> --bind-address=xxx.xxx.xxx.xxx
>
> Is the above syntax correct ??
>
> Thanks
>
> Mark
>
Hi,
I am using :
[mysqld]
bind-address=xxx.xxx.xxx.xxx
in my own /etc/my.cnf, and
>Does anyone have any recommendations for a good book on MySQL SQL? What
>about PerlDBI (I noticed that the O'Reilly one is over a year old)?
Stay as far away from the O'Reilly book as possible. MySQL and mSQL was
really just an mSQL book until a few months before publication when
O'Reilly not
Try phpMyAdmin to upload the .sql file in your Database
you can get phpMyAdmin @ http://www.phpwizard.net
> -Original Message-
> From: Aek [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, June 24, 2001 5:37 PM
> To: [EMAIL PROTECTED]
> Subject: sql to .php
>
>
> hey,
> i have some sql to cre
Dear Friend,
AS SEEN ON NATIONAL TV :
''Making over half million dollars every 4 to 5 months from your
home for an investment of only $25 US Dollars expense one time''
THANKS TO THE COMPUTER AGE AND THE INTERNET!
=
BE A MILLIONAIRE LIKE OTHERS WITH
I am working to develope a software package using MS Visual Basic and MySQL, and so I
want know about connnecting MyODBC through ADO (ActiveX Data Object) of VB. The format
for ODBC connectivity through ADO is like :: ==>
' ' Open a connection without using a Data Source Name (DSN).
' Se
If I have a table:
CREATE TABLE film (
title CHAR(200) NOT NULL,
INDEX title_index (title(5))
);
What is the underlaying reason why it is faster to index only a prefix of the title?
Is it always faster? even if i have a trillions of title 200 characters long? wha
> is already out, but right now I am not able to access the
> front page of the MySQL website www.mysql.com, where
> you could download the latest version.
Try here:
http://mysql.ht.net.tw/mirrors.html
-
Before posting, please
Tomek,
have you defined the InnoDB startup options in your my.cnf or
my.ini? You can look at the manual at http://www.innodb.com
about example settings for InnoDB in Windows.
Did you compile MySQL yourself or are you using one of the
binaries in the binary distribution? MySQL -Max 3.23.39
is alr
Just to balance out the conversation, a couple years ago we had developed an
e-commerce site which was to be prototyped in Access, then moved to SQL Server for
production. The client decided that they didn't want to pay for the move to SQL
Server, so we launched with Access as the backend. The
hey,
i have some sql to create the tables for my small database in a text file
at home i can use sql batch mode to runt he sql commands from this text file.
id like to take this sql code and run it on the mysql server at my free
webhost, but i dont think i can connect to their mysql server with
> Hi,
>
> How to bind mysql to specific address if I am using my.cnf file.
>
> etc.
> [mysqld]
> --bind-address=xxx.xxx.xxx.xxx
>
> Is the above syntax correct ??
Close.
[mysqld]
bind-address=xxx.xxx.xxx.xxx
-
Before p
> Hi,
>
> I am not able to connect mysql server through other
> machine in a
> network. I have already assign the user using the command of
> "Grant all on
> *.* to user@ipaddress identified by "password". Then, try to connect using
> "mysql -u user@ipaddress -h firstserver -ppassword
Hi,
How to bind mysql to specific address if I am using my.cnf file.
etc.
[mysqld]
--bind-address=xxx.xxx.xxx.xxx
Is the above syntax correct ??
Thanks
Mark
-
Before posting, please check:
http://www.mysql.com/manua
Hi
I was going to use innodb table handler so i have downloaded
"mysql-max-3.23.38-win.zip" because there was said that max installation contains
innodb table handler. After intallation I have disabled innodb tables and when i write
"select version();" i get 3.23.37 ("mysql-max-3.23.38-win.
Hi,
I am not able to connect mysql server through other machine in a
network. I have already assign the user using the command of "Grant all on
*.* to user@ipaddress identified by "password". Then, try to connect using
"mysql -u user@ipaddress -h firstserver -ppassword".But, I go
Hi,
I am not able to connect mysql server through other machine in a
network. I have already assign the user using the command of "Grant all on
*.* to user@ipaddress identified by "password". Then, try to connect using
"mysql -u user@ipaddress -h firstserver -ppassword".But, I go
Hi!
When you issue a consistent read, that is, an ordinary SELECT
statement, InnoDB will give your transaction a timepoint according
to which your query sees the database. Thus, if transaction B deletes
a row and commits after your timepoint was assigned, the you will
not see the row deleted. Si
Hannes Niedner writes:
>
> Thanks Sinisa,
>
> So is there any command suffix in mysql that sends the query in the
> background (letting the server doing the query without talking back to the
> client) like using the & on the unix commandline - resulting in any query
> being completed after quitt
I am having trouble with DBI. I wrote a little script that should update
fields in one table (uid_test) based on values in another table (merge). I
updates one row and then dies with:
os prompt: blah blah
1 1011877 101
Error during processing for table uid_test
Error 19 (fetch() with
ALTER TABLE tblname ADD UNIQUE (column1, column2);
The index will automatically be used if you use it in your WHERE clause in
that order. If you want to do fulltext searching on those columns, repeat
the query with FULLTEXT in place of UNIQUE.
> Hello,
>
> I'm trying to create a table with colum
Hello,
I'm trying to create a table with columns A, B, C, D such that values in
columns A and B are not unique but if you consider them as a paired tuple,
then for every row, is
unique. Furthermore, I'd like to create a index to use for searching
through the database using this unique paired tup
48 matches
Mail list logo