This may be useful to you:
http://www.mysql.com/doc/en/REPLACE.html
> -Original Message-
> From: Zysman, Roiy [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, January 19, 2003 11:16 PM
> To: [EMAIL PROTECTED]
> Subject: What is the best known practice for insertion...?
>
>
> Hi All,
> I'm try
greetings nug
how can we access mySQL installation (from entropy.ch, Marc Liyanage)
through TCP/IP on a network
we are able to access mySQL on localhost, but tcp fails
regards, ram
--
+--+
Mac Solutions
http://www.macs
Hi All,
I'm trying to insert multiple lines to a table with 3 col. All 3 of them
are a part of the primary key.
But while inserting the data , sometime occurs the situation where I
want to insert an already exist entry with the same keys. And mysql
barfs out that this key already exist in the table
re: Question 1:
You are right that windows does not ship the ODBC provider but MS has actually created
one and is available for free download. You also need the MyODBC driver which is
created by MySQL folks (also free). Apart from these two there are a few other pieces
of software that you
Hi all,
I'm woundering if Mysql can use Database link, like Oracle can???
Eg. If i have some tables at my labtop, and want to make the same table(s) at my
server with this command:
create table test as select * from test@database_link (This is how you do it on
Oracle), but how do I do this in
I have come across the following bug in MySQL Control Center 0.8.8 Beta for Windows:
When you have two databases that are identicle (ie, a master and a slave) and you
connect to both databases (one on a server and one on the local machine) when you
open a table listing for one database and open a
What language are you using? In PHP use this:
http://www.php.net/manual/en/function.session-id.php
You could also experiment with mySQL's built in
NOW or CURRENT_TIMESTAMP or UNIX_TIMESTAMP
or ENCRYPT or MD5 or SHA or AES_ENCRYPT
or RAND
And some combination of those (hint hint)
> -Original
Hello:
I am trying to find a way to create a random ID for use as a session ID in a
MySQL table.
In MS SQL I use NewID(). Does anybody know an equivalent to use for MySQL,
running on RedHat Linux 8.0?
I'd be greatful for any tip.
thks!
Dietrich
-
I've written an article, "Using the Ruby DBI Module," that discusses
using Ruby DBI to write programs that access databases. The article
is available here:
http://www.kitebird.com/articles/
I'd be interested in feedback, especially corrections if there
are errors.
The article follows an e
I compiled gcc 2.95.2 on Solaris 9 and was then able to
successfully compile 3.23.54a under Solaris 9 (sparc)
without any unsual steps or configuration options.
>From my tests today, it seems neither gcc 2.95.3 or
3.x will compile mysql 3.23.54a under Solaris 9, in
case anyone is interested.
On
Could anyone please tell me how I write an SQL statement to seperate
text from one field into multiple fields based on a aprticular character
(i.e. tab/comma/space). For example, I have a text field containing:
Text=Robyn Bailey Brisbane
I want to seperate this (per query) into 3 fields so that I
Hi mySQL Support,
I am a small programming company and I currently use VB6 and MS Access as my database.
I am currently in negotiations to develop new applications with a number of different
companies. I am finding the number of entries the companies desire will exceed MS
Access to unsafe lev
At 15:40 -0800 1/19/03, Melissa Stranzl wrote:
I am trying to get my program to be searchable by
date, but it doesn't work. I get an error message in
perl, that follows the code I included. Any
suggestions are greatly appreciated.
PERL
--
@currenttime= localtime();
$y= $currenttime [5]
On Sun, 2003-01-19 at 19:09, Nasser Ossareh wrote:
> Isn't there a typo somewhere...
> Shouldn't you expect 5 instead of -5 (15 - id where id = 10)??
>
> Nevermind, let's assume that there is a typo somewhere and the correct expected
>value is -5... however, in the domain of unsigned arithmet
I am trying to get my program to be searchable by
date, but it doesn't work. I get an error message in
perl, that follows the code I included. Any
suggestions are greatly appreciated.
PERL
--
@currenttime= localtime();
$y= $currenttime [5] + 1900;
$m= $currenttime [4];
$dom= $currentti
Hi!
I'm new to MySQL and I´m trying to understand how
Innodb works. So far I have set up the InnoDB data
files and directories and have MySQL up and running.
I set my "my.ini" file with the following:
# Uncomment the following if you are using Innobase
tables
innodb_data_home_dir=
innodb_data_fi
Brian,
> > create table test(id int unsigned);
> > insert into test values(10);
> > select 15 - id from test;
> > The result is 18446744073709551611 instead of -5.
Trying to confirm this with MySQL 4.0.7 on a Win2K box:
mysql> create table test(id int unsigned);
Query OK, 0 rows affected (0.56 s
Isn't there a typo somewhere...
Shouldn't you expect 5 instead of -5 (15 - id where id = 10)??
Nevermind, let's assume that there is a typo somewhere and the correct expected value
is -5... however, in the domain of unsigned arithmetics -5 is precisely
18446744073709551611... don't you belie
Octavian,
Sunday, January 19, 2003, 7:31:57 AM, you wrote:
> Hi all,
> I've tried the following query:
> create table test(id int unsigned);
> insert into test values(10);
> select 15 - id from test;
> The result is 18446744073709551611 instead of -5.
I ran this.. and it worked for me
MySql 4
Carlos,
- Original Message -
From: ""Carlos Proal"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, January 19, 2003 7:13 PM
Subject: Innodb enable/disable keys
>
>
>
>
> Hi, i have a simple question:
> The sql statement: alter table _table_name_ disable keys;
>
On Sun, 2003-01-19 at 14:48, M A wrote:
> HI
>
> i am new to mysql.. i have just installed the source code under
> /user/local/mysql
> but the commnads don't work unless i have "./" infront of the command
> for example: mysqladmin won't work unless its written "./mysqladmin".
>
> please let me kn
> telnet: Unable to connect to remote host: Connection refused
> I don't understand this problem. I've never had this problem.
This simply means that mysqld is not running on your server. the result of the telnet
test (i.e. Connection Refused) confirms that. You need to start mysqld before try
Hi,
I am working with MySQL v 3.23.51
I wanted to know whether there is any scheduling policy employed for the
numerous threads created for the clients on the server side. I couldnt
figure that out while going through your source distribution or your
documentation.
Thanks.
*
Ryan,
this line is not correct:
> $line = mysql_fetch_array($result, MYSQL_ASSOC);
Instead, you will need to loop through the result set, like:
while($row = mysql_fetch_array($result)) {
for($i=0; $i < mysql_num_fields($result); $i++) {
echo $row[$i];
}
}
You can find more info her
Hi,
> but the commnads don't work unless i have "./" infront of the command
> for example: mysqladmin won't work unless its written "./mysqladmin".
If you're logged in as root, log out and log in as another Linux user.
(I'm a Windoze fan, but AFAIK root must type ./ for command for security
reaso
Nedim,
> I am new to MySql. I need to obtain information about tables including
the
> names and types of each column, the primary keys etc.
SHOW TABLE STATUS;
To see only tables starting with "t": SHOW TABLE STATUS LIKE 't%';
http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html
Regards,
--
Ste
Thanks for the help, folks.
I see how the reference tables (either for the dates or the possible
number of days in the range) would work -- pretty slick solutions. I
worry about tables like that being able to scale, though, should a user
choose a large date range... I think, instead, I'll use the
Ok, I know some of the differences to both of these, but is there any
strong reason to use mysqldump over issuing a SQL to BACKUP tables?
*Note. I will be looping through known tables of a particular
database and issuing the BACKUP TABLE command, are there any other
implications for issuing thi
At 18:48 + 1/19/03, M A wrote:
HI
i am new to mysql.. i have just installed the source code under
/user/local/mysql
but the commnads don't work unless i have "./" infront of the command
for example: mysqladmin won't work unless its written "./mysqladmin".
please let me know if i am doing som
HI
i am new to mysql.. i have just installed the source code under
/user/local/mysql
but the commnads don't work unless i have "./" infront of the command
for example: mysqladmin won't work unless its written "./mysqladmin".
please let me know if i am doing something wrong
Thanks
__
At 10:18 -0700 1/19/03, Jeff Donnici wrote:
> That would work, but it's not necessary. He should use a
LEFT JOIN, which will produce a row in the output for the
left table, whether or not any right table rows match it.
The syntax is in the MySQL manual.
I appreciate the pointer to LEFT JOI
At 17:18 +0200 1/19/03, Octavian Rasnita wrote:
Hi all,
For the query:
show columns from table like 'column';
... I want to get the type field.
How can I do that?
Into another table?
You can't. You have to write a program that captures the result
and processes it.
I've tried:
select typ
Hi all,
For the query:
show columns from table like 'column';
... I want to get the type field.
How can I do that?
I've tried:
select type from (
show columns from table like 'column');
But it gave me an error, (as expected).
Thank you
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMA
Hi all,
I've tried to create the following type of field in a table:
create table temp(id float(100,50) unsigned);
insert into temp
values(123.1234567890123456789012345678901234567890123456789012345);
select * from temp;
This prints:
123.12345886230469
What's wrong with MySQL?
Hi all,
I've tried the following query:
create table test(id int unsigned);
insert into test values(10);
select 15 - id from test;
The result is 18446744073709551611 instead of -5.
Am I doing something wrong?
Thank you.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
-
Hello everyone,
I'm not sure if this is the proper place to be asking this question as I
believe it is more of a question on how to traverse through php arrays and such
but it is using a mysql_query function. So if this not the place pleace don't
read any further and ignore and/or delete this mess
Hi all,
I am new to MySql. I need to obtain information about tables including the
names and types of each column, the primary keys etc.
I understand that the describe command does this. But are there
some system tables (similar to MS SQL server or IBM DB2) that I can query
for more detailed inf
Thanks, Harald. I'll experiment with this approach!
J
--
You need a helper table containing just the numbers 0..N, where N is
greater than the maximum number of days in the query above. For
example:
CREATE TABLE seq (val INT NOT NULL
> That would work, but it's not necessary. He should use a
> LEFT JOIN, which will produce a row in the output for the
> left table, whether or not any right table rows match it.
> The syntax is in the MySQL manual.
I appreciate the pointer to LEFT JOIN and have read through the site's
docume
Hi, i have a simple question:
The sql statement: alter table _table_name_ disable keys;
has any action on "INNODB" tables ?, helps improving bulk inserts ?.
thanx
Carlos
_
Help STOP SPAM: Try the new MSN 8 and get 2 months FR
I have a page with many ads that stores both the number of times an ad is
displayed and how many times it gets clicked. These are stored in two
different tables (since different information is stored for each) but both
have identical name columns. I am trying to display both # times displayed
On Sun, 2003-01-19 at 10:44, Paul DuBois wrote:
> At 7:18 + 1/19/03, Nasser Ossareh wrote:
> > >a row gets inserted into this table
> >whenever a visitor uses a certain tool on the site
> >
> >based on this approach your table does not have any entries for the
> >days that no one uses the cer
I have a table (TABLE1) which contains multiple fields for user-IDs.
Some examples are - the user who created it (FLD_U1), who last updated
it (FLD_U2), who is the current owner (FLD_U3) and so on.
If I want to make a query and resolve all these IDs to the corresponding
user-names, do I need to jo
At 7:18 + 1/19/03, Nasser Ossareh wrote:
>a row gets inserted into this table
whenever a visitor uses a certain tool on the site
based on this approach your table does not have any entries for the
days that no one uses the certain tool on the site. As a result
your query can not pull out
>Description:
I can connect on my database at localhost, but not at real hostname. Example when i
want to change the password :
darkvador:/usr/bin# /usr/bin/mysqladmin -u root -h darkvador password 'newpassword'
/usr/bin/mysqladmin: connect to server at 'darkvador' failed
error: 'Can't connect t
Has anyone run into this? I did a search on the web site
looking for information before posting, didn't see
anything..
3.23.54a - Compiling with gcc 2.95.3, Solaris 9 sparc..
# snip
Making all in sql
make all-recursive
Making all in share
source='sql_lex.cc' object='sql_lex.o' libtool=no \
d
mysqlÄúºÃ:
È«¹ú¶À¼ÒÃâ·ÑÇÀ×¢. cn¶¥¼¶ÓòÃû£¡
±¶ÊܹØ×¢µÄÖйú¹ú¼Ò¶¥¼¶ÓòÃû(.CN), CNNIC½«ÔÚ2003Äê3ÔÂ17ÈÕ¿ª·ÅÖ±½ÓÒÔ.CN½áβµÄ¹úÄÚÓòÃû
Äþ²¨Íø»ùÈí¼þÓÐÏÞ¹«Ë¾ÏÖÔÚÍƳöÈ«¹ú¶À¼ÒÃâ·ÑÇÀ×¢»î¶¯,¸Ï¿ìÇÀ×¢ÄãÐÄÒÇÒѾõÄÓòÃû.
.CN¶¥¼¶ÓòÃûµÄÕýʽע²á¼Û¸ñΪ260Ôª/¸öÿÄê¡£
Äþ²¨Íø»ùÈí¼þ
Hy Ali,
> ld.so.1:bin/mysqld : fatal : libCstd.so.1 : open failed : No such file
> or Directory
if you're using a sparc machine then you need to install the following
patches, please do not change to order of the patches :
109147-09
108434-02
108435-10
You can obtain theese patches via http://s
48 matches
Mail list logo
