This should do what you want:
UPDATE Table2, Table1 SET
Table2.DataDestination=Table1.DataSource WHERE
Table1.col1=Table2.col1 AND Table1.col2=Table2.col2
AND Table1.col3=Table2.col3;
--- PandaCoop-Krasimir_Slaveykov <[EMAIL PROTECTED]>
wrote: > Hello mysql,
> I have 2 tables :
>
> Table1:
Hello mysql,
I have 2 tables :
Table1:
col1
col2
col3
DataSource
Table2:
col1
col2
col3
DataDestination
How to update Table2.DataDestination with value of Table1.DataSourse
where table1.col1=table2.col2 and table1.col2=table2.col2 and
table1.col3=table2.col3
--
Best
On Thursday 20 February 2003 09:28, saravanan saravanan wrote:
> I am using mysql for my project.I am finding
> problems of using FOREIGN KEY and STORED procedures in
> version 4.0.please help me and send the details as
> earlier as possible
Stored Procedures are not supported in MySQL yet.
F
Dear sir
I am using mysql for my project.I am finding
problems of using FOREIGN KEY and STORED procedures in
version 4.0.please help me and send the details as
earlier as possible
by
Saravanan
__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculat
Veysel Harun Sahin wrote:
select vanNumber, sum(grossPay) from usertableDaily group by vanNumber;
The above is the correct query, to save yourself some time. As for your
problem:
But when I execute I get this:
Resource id#3
Resource id#4
This means you're using a resource resp
Geek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 15, 2003 10:09 AM
Subject: Need Help With MySQL Query
> hello,
>
> I've performed searches on this site and php.net to try and figure out
> why this is occuring. I can't find any i
Hi
Interesting problem, normally to get a total by type, you would have a query
like,
select van, sum(pay) from ($usertableDaily) group by van;
However you are individually quering each total, your approach is correct, but
slower.
The problem you have though is the return of
Resource i
select vanNumber, sum(grossPay) from usertableDaily group by vanNumber;
[EMAIL PROTECTED] wrote:
hello,
I've performed searches on this site and php.net to try and figure out
why this is occuring. I can't find any instance in my searches that
helped me. So, I'm posting my very first question
hello,
I've performed searches on this site and php.net to try and figure out
why this is occuring. I can't find any instance in my searches that
helped me. So, I'm posting my very first question to this list
Here's my table ($usertableDaily):
vanNumber|grossPay
-
D]
To: mysql
cc:
Subject:Need help with JOIN
Heyho folks,
I am sitting now for a few weeks on a tricky problem. I don't get it -
maybe
anyone of you could give me a hint.
Let's say I have two tables :
Table One has a lot of information about travels, hotels, flights etc.
Table
Heyho folks,
I am sitting now for a few weeks on a tricky problem. I don't get it - maybe
anyone of you could give me a hint.
Let's say I have two tables :
Table One has a lot of information about travels, hotels, flights etc.
Table Two has an entry for each hotel and each day where I store info
At 9:24 -0600 2/5/03, Jaime Teng wrote:
I have a MySQL table:
++--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-++
| id
DISTINCT?
-Original Message-
From: Tab Alleman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 12:31 PM
To: Jaime Teng; [EMAIL PROTECTED]
Subject: RE: need help with GROUP BY
SELECT id,account FROM tablename WHERE detail LIKE '%pattern%' GROUP BY
Account;
---
Jaime,
You should be using the DISTINCT function.
SELECT DISTINCT account, id, FROM etc.
This should give you one instant of 'account' in your SELECT output.
At 09:24 AM 2/5/03 +, Jaime Teng wrote:
I have a MySQL table:
++--+--+-+-+-
Jaime,
You should be using the DISTINCT function.
SELECT DISTINCT account, id, FROM etc.
This should give you one instant of 'account' in your SELECT output.
At 09:24 AM 2/5/03 +, Jaime Teng wrote:
I have a MySQL table:
++--+--+-+-+-
SELECT id,account FROM tablename WHERE detail LIKE '%pattern%' GROUP BY
Account;
-Original Message-
From: Jaime Teng [mailto:[EMAIL PROTECTED]]
I have a MySQL table:
...
It should only return *one* result per account.
I have a MySQL table:
++--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-++
| id | int(10) unsigned | | PRI | NULL
* [EMAIL PROTECTED]
> I've been a member of this mailing list for quite a long time and very
> thankful that most of my difficulty in creating queries are being answered
> by just reading responses to questions. Right now I have a problem in
> creating a query (in fact I'm not sure if this is possi
Hi to All,
I've been a member of this mailing list for quite a long time and very
thankful that most of my difficulty in creating queries are being answered
by just reading responses to questions. Right now I have a problem in
creating a query (in fact I'm not sure if this is possible) that will
Hello all:
I have a production server that is currently down and am looking for
help. WIN2k Server, mysql 3.23
The background is this - I was creating an index, and someone decided to
reboot the system. When the system came back up, mysql would not
start. When we looked at the service, it
What does mysqld.log say?
Manuel Velasco wrote:
I'm getting the following messages after running
safe_mysqld (as root):
leo:/usr/bin # ./safe_mysqld &
[1] 4798
leo:/usr/bin # Starting mysqld daemon with databases
from /var/lib/mysql
030121 19:38:15 mysqld ended
[1]+ Done./
On Wednesday 22 January 2003 12:10, Haydar KOCAK wrote:
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
> [1]+ Exit 1 ./bin/mysqld_safe --user=mysql
Check with
ps ax | grep mysqld
that MySQL server is running.
--
Fo
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
[1]+ Exit 1 ./bin/mysqld_safe --user=mysql
-
Before posting, please check:
http://www.mysql.com/manual.php (th
I'm getting the following messages after running
safe_mysqld (as root):
leo:/usr/bin # ./safe_mysqld &
[1] 4798
leo:/usr/bin # Starting mysqld daemon with databases
from /var/lib/mysql
030121 19:38:15 mysqld ended
[1]+ Done./safe_mysqld
leo:/usr/bin # cd /var/lib/mysql
leo:/v
umber from members where fd_status = "A");
Andy
> -Original Message-
> From: Garry Rothert [mailto:[EMAIL PROTECTED]]
> Sent: 16 January 2003 14:11
> To: [EMAIL PROTECTED]
> Subject: Need help with UNION
>
>
> Hi
> I am attempting a simple union.
>
PROTECTED]
Subject: Need help with UNION
Hi
I am attempting a simple union.
select cnumber from spouse where fd_status = "A"
union
select cnumber from members where fd_status = "A"
When I run this SQL statement I get the following error.
ERROR 1064 : You have are an error in
Hi
I am attempting a simple union.
select cnumber from spouse where fd_status = "A"
union
select cnumber from members where fd_status = "A"
When I run this SQL statement I get the following error.
ERROR 1064 : You have are an error in your SQL syntax near 'union
select cnumber from members wher
I had a query that was working fine before for a
sports project .. basically, 3 tables .. one stored
goal data, one stored team data, and the other player
data. To get all the scoring data (player names,
jersey #'s), I left joined to the player table 3
different times (on GOAL, ASSIST1, and ASSIS
Hello Dolly,
Kindly state and share with us the error encountered if there were any.
Your source code would also be of help :-)
Fred.
dolly wrote:
Hi,
I installed MySQL 4.0 on Red Hat 8.0 server and able to connect from
mysqlgui application. I couldn't connect from ODBC ver 2.50 nor 3.51. A
Hi,
I installed MySQL 4.0 on Red Hat 8.0 server and able to connect from
mysqlgui application. I couldn't connect from ODBC ver 2.50 nor 3.51. Any
sugestion would be appriciated.
-
Before posting, please check:
http://www.mys
Gloria L. McMillan wrote:
I recently posted this query and it doesn't seem to be getting any responses.
Is there something important that I left unsaid, making this one tough to
answer or is it, perhaps, not addressed to the right list?
I'm sure you could find a full app that already does thi
Hi. I noticed a couple of weird things with your script:
- The error "DBI->connect(myd) failed: Couldn't connect to..." is
happening I think because 'DBI:mysqlPP:myd' is in single quotes when you
call DBI->connect, and the syntax seems off. Maybe you'll have better
success if you follow the syn
Hi, all,
I recently posted this query and it doesn't seem to be getting any responses.
Is there something important that I left unsaid, making this one tough to
answer or is it, perhaps, not addressed to the right list?
I would like to redo my CREATE TABLE very much to allow me to do
more efficie
Hi all:
I am sending a perl program I am trying to run which
doesn't connect to the database. The error message is
at the bottom of the e-mail. I think the program is
going to the sock file and not TCP/IP and I don't know
how to change this, but I'm not sure whether this is
the error, so any help
ailto:[EMAIL PROTECTED]]
Sent: Saturday, December 21, 2002 9:10 AM
To: [EMAIL PROTECTED]
Subject: i need help
I keep getting this message what can i do to correct this problem ?
Warning: Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) in
/web/repo
-
> From: Rich Dodge [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, December 21, 2002 11:10 AM
> To: [EMAIL PROTECTED]
> Subject: i need help
>
>
> I keep getting this message what can i do to correct this problem ?
>
>
> Warning: Can't connect to local MySQ
]
Onderwerp: i need help
I keep getting this message what can i do to correct this problem ?
Warning: Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) in
/web/repository/sites/www/inc/generate-pag
I keep getting this message what can i do to correct this problem ?
Warning: Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) in
/web/repository/sites/www/inc/generate-page.php on line 4
-
Be
Greetings and happy holidays!
This is a query about how to better structure an existing mysql table.
I want to make a rather complex SELECT off an opinion poll.
Thus:
SELECT Those who answered Q3 as "1"
SELECT these people's answers for Q4, Q5, Q6
(Any size array of the rest of the questions.
Rachid Abdelkhalak [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 16, 2002 1:28 PM
> To: [EMAIL PROTECTED]
> Subject: Need Help phpMyAdmin !!
>
>
>
> Hello every one
>
> At the first, I'm Sorry for my bad english.
>
> I want to install phpMyAdmin for mana
id Abdelkhalak [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, December 16, 2002 1:28 PM
> > To: [EMAIL PROTECTED]
> > Subject: Need Help phpMyAdmin !!
> >
> >
> >
> > Hello every one
> >
> > At the first, I'm Sorry for my bad english.
> >
&g
Hello every one
At the first, I'm Sorry for my bad english.
I want to install phpMyAdmin for managing My MySql databases, I Downloaded
ths zip file frome here:
http://sourceforge.net/project/showfiles.php?group_id=23067
the file name is phpMyAdmin-2.3.3pl1-php3.zip
I unzip this file on my Mysq
Keys: sql, query
Hi Steve,
I got your email from the MYSQL list, and I undertood that you have
some experience about using Mysql tables in an application developed
by Delphi.
I am just at the begining of the way. Still I am dying to get any response
or see the already existing defined tables of
> I need help. I am building a database for a small college that wants to be
> able to update their program information for each department through an
> web/gui program.
>
> I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my
> web page this way)
3 AM
Subject: Re: Data base driven web page idea - need help!
> Hi Grant:
>
> The answer to your question depends on a lot of details. In most cases,
the
> solution you have chosen is just fine. The real question you need to
answer
> is, "Does your solution meet your needs?&q
On Wed, Nov 27, 2002 at 09:39:52PM +0100, Benjamin Pflugmann wrote:
> 5. Another hybrid: Do not create the cache pages yourself. Simply
>build the back-end as in solution 1. and put a caching proxy
>(e.g. squid) before it. The main drawback in comparison with.
>Depending on proxy, may
Hi.
On Tue 2002-11-26 at 22:38:56 -0800, [EMAIL PROTECTED] wrote:
> I need help. I am building a database for a small college that wants to be
> able to update their program information for each department through an
> web/gui program.
>
> I've decided to use, MYSQL, Apache
anowski
Data Manager, Office of Educational Assessment
University of Washington
- Original Message -
From: Grant Cooper <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 26, 2002 10:38 PM
Subject: Data base driven web page idea - need help!
> I need help. I a
On Tue, Nov 26, 2002 at 10:38:56PM -0800, Grant Cooper wrote:
> Here's my QUESTION! Because some of the program information is large I don't
> want to query the data base everytime do I?
Profile it first. You may find MySQL handles the load just fine on the hardware
you're using and you don't ne
#x27;s going to punish me if this blows up in my face. hehe.
="one man...sinful"???
No, I'm not going there...
=dn
> - Original Message -
> From: "DL Neil" <[EMAIL PROTECTED]>
> To: "Grant Cooper" <[EMAIL PROTECTED]>; <[EMAIL PROTEC
> Here's my QUESTION! Because some of the program information is
> large I don't
> want to query the data base everytime do I?
Define large? Are we talking mixed media types (PDF/Word/PowerPoint) or
plain text/HTML? As someone has already suggested, you might be better to
save the files on the d
er" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 27, 2002 12:55 AM
Subject: Re: Data base driven web page idea - need help!
> Grant,
>
> > I need help. I am building a database for a small college that wants to
be
> > able to update their program
Grant,
> I need help. I am building a database for a small college that wants to be
> able to update their program information for each department through an
> web/gui program.
>
> I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my
> web page
I need help. I am building a database for a small college that wants to be
able to update their program information for each department through an
web/gui program.
I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my
web page this way)
Here's my QUESTION! Becau
David,
Monday, November 18, 2002, 2:53:33 AM, you wrote:
DW> I am trying to install mysql-3.23.53a-pc-linux-gnu-i686 to my linux kernel
DW> 2.2.14(Caldera OpenLinux 2.4). I follow throught the installation porcess
DW> in the documentation in the mysql.com web site.
DW> I am using bash shell, here
Hi guys,
I am trying to install mysql-3.23.53a-pc-linux-gnu-i686 to my linux kernel
2.2.14(Caldera OpenLinux 2.4). I follow throught the installation porcess
in the documentation in the mysql.com web site.
I am using bash shell, here is the list of commands i went through:
shell> groupadd mysql
s
I have been successful (after days of trying) with Apache 2.0.43 ,
PHP 4.2.3 on Redhat 7.3
I compiled php with ./configure --with-mysql --with-apxs2=/apth/to/apxs
(apxs is under /path/to/apache2/bin)
After 'make' and 'make install' you will find libphp4.so in
/path/to/apache2/modules
Then I add
On Mon, 2002-10-21 at 13:07, Chip Rose wrote:
> I can't get PHP-4.2.3 compiled to work with MySQL and Apache, despite months
> of trying. Apache compiled ok, and so did MySQL -both work, on my Debian
> Linux box.
>
> I've tried various combos of installing the Deb packages, compiling from
> so
I can't get PHP-4.2.3 compiled to work with MySQL and Apache, despite months
of trying. Apache compiled ok, and so did MySQL -both work, on my Debian
Linux box.
I've tried various combos of installing the Deb packages, compiling from
source, and various combinations thereto. I started out usi
Hello jantos,
Tuesday, October 15, 2002, 2:03:50 PM, you wrote:
jamdd> when I'm connecting to mysql-server via tcp/ip then the mysql-server
jamdd> cuts the connection and it restarts the mysql-server.
jamdd> when I don't make connections from other hosts than it's runnin
>Description:
when I'm connecting to mysql-server via tcp/ip then the mysql-server
cuts the connection and it restarts the mysql-server.
when I don't make connections from other hosts than it's running well
until i make connections via tcp/ip from other hosts.
>H
Greetings, I am struggling trying to get good performance
using indexes.
I'll spare the details and narrow down the situation. I have about
100,000 rows of data with the following fields:
title - vachar(64)
description - text
state - varchar(2)
priority - int
modified - date
People type in
On Thursday, September 26, 2002, at 10:46 AM, Darrell A. Sullivan, II
wrote:
> I am sure I am going to feel ignorant when I get the answer to this
> question
> because it will be something simple that I have overlooked, but here
> goes
> anyhow.
>
> I am using MySQL Version 3.23.51-max.
>
> I
I am sure I am going to feel ignorant when I get the answer to this question
because it will be something simple that I have overlooked, but here goes
anyhow.
I am using MySQL Version 3.23.51-max.
I am developing an N-tier application using Java on the server side
accessing MySQL through JDBC.
Stephen Sokalski wrote:
>
>
> Stephen Sokalski wrote:
>
>> I'm running this on a RAQ.
>>
>> Here is the problem. Something very strange has happened to my older
>> version of mysql (3.23.37).
>>
>> Not only can I not get it to shut down with
>> "/usr/share/mysql/mysql.server stop" but even if
Stephen Sokalski wrote:
> I'm running this on a RAQ.
>
> Here is the problem. Something very strange has happened to my older
> version of mysql (3.23.37).
>
> Not only can I not get it to shut down with
> "/usr/share/mysql/mysql.server stop" but even if I do a "ps -ef | grep
> mysql" and do
I'm running this on a RAQ.
Here is the problem. Something very strange has happened to my older
version of mysql (3.23.37).
Not only can I not get it to shut down with
"/usr/share/mysql/mysql.server stop" but even if I do a "ps -ef | grep
mysql" and do a kill -9 on the pid, if I try to res
eptember 10, 2002 6:26 PM
Subject: need help on DROP.
I am unable to find the specific DROP command to remove only test@%,
test\_%@%,
snort@localhost, and snort@%.
I am trying to clean up my db information.
Thank you.
m
Paul,
Thank you. That did it.
You are correct I needed to DELETE.
Paul DuBois wrote:
>
> At 16:26 -0700 9/10/02, Daniel Curry wrote:
> > I am unable to find the specific DROP command to remove only test@%,
> >test\_%@%,
> >snort@localhost, and snort@%.
>
> I think you want DELETE, not DRO
At 16:26 -0700 9/10/02, Daniel Curry wrote:
> I am unable to find the specific DROP command to remove only test@%,
>test\_%@%,
>snort@localhost, and snort@%.
I think you want DELETE, not DROP.
DELETE FROM db WHERE Db='test' AND Host='%';
DELETE FROM db WHERE Db='test\_' AND Host='%';
DELETE FR
I am unable to find the specific DROP command to remove only test@%,
test\_%@%,
snort@localhost, and snort@%.
I am trying to clean up my db information.
Thank you.
mysql> select * from db;
+---+--++-+-+-+-+---
You wrote:
> I apologize for asking such a basic SQL question, but I am failing in
finding
> the solution...
> Consider the following table:
>
> id | option
> ---
> 1 | a
> 2 | a
> 2 | b
>
> I want to find the ids with only a specific set of options.
> For example, if I wanted to get t
I wrote:
>I apologize for asking such a basic SQL question, but I am failing in finding
>the solution...
>Consider the following table:
>id | option
>---
>1 | a
>2 | a
>2 | b
>I want to find the ids with only a specific set of options.
>For example, if I wanted to get the ids which hav
It is just a config file.
You don't run it.
PathFinder Software wrote:
>Hi,
>
>I am a not yet that experienced with System Administration and
>need a little holding hand here if possible.
>
>I am running Red Hat 6.2 with MySQL installed and running.
>
>Frankly I have read the README and HELP and
PathFinder,
Wednesday, September 04, 2002, 10:25:46 PM, you wrote:
PS> I am a not yet that experienced with System Administration and
PS> need a little holding hand here if possible.
PS> I am running Red Hat 6.2 with MySQL installed and running.
PS> Frankly I have read the README and HELP and s
Does this work?
select t.id,t.option,t2.option from tableName t left join tableName t2 on
t.id=t2.id and t2.option!=t.option where t.option="a" and isnull(t2.option);
HTH,
Jed
On the threshold of genius, [EMAIL PROTECTED] wrote:
> I apologize for asking such a basic SQL question, but I am fail
Hi,
I am a not yet that experienced with System Administration and
need a little holding hand here if possible.
I am running Red Hat 6.2 with MySQL installed and running.
Frankly I have read the README and HELP and still not sure as to
what I am suppose to do with the my.cnf.
When I try to run
I apologize for asking such a basic SQL question, but I am failing in finding
the solution...
Consider the following table:
id | option
---
1 | a
2 | a
2 | b
I want to find the ids with only a specific set of options.
For example, if I wanted to get the ids which have option a only,
Hi,
The best way to speed up your query would be to create a compound index
on (first,last):
create index first_last on subscriber(first,last);
In this case, mysql will use it for both fields instead of doing a
linear search for the second one.
In order to reduce index size without loo
On Tuesday 13 August 2002 06:50 pm, Steinar Kolnes wrote:
Just create indexes on first and last, that should improve the speed of your
query drastically. It will of course be a BIG index. You might experiment
with only making the width of the index small, like maybe 8 or 10 characters
might be
: Re: Need help how to make Directory system in MySQL with 6.5 mill
subscribers ?
In the last episode (Aug 14), Steinar Kolnes said:
> I have to make a large 6.5 million names and numbers database in
> MySql(maybe not so large for some of you). Yet it is very simple,
> here is my
From: Steinar Kolnes [mailto:[EMAIL PROTECTED]]
| Sent: Tuesday, August 13, 2002 4:50 PM
| To: Mysql List
| Subject: Need help how to make Directory system in MySQL
| with 6.5 mill
| subscribers ?
|
|
| Hi there,
|
| I have to make a large 6.5 million names a
In the last episode (Aug 14), Steinar Kolnes said:
> I have to make a large 6.5 million names and numbers database in
> MySql(maybe not so large for some of you). Yet it is very simple,
> here is my sql file:
>
> create table subscriber
> (
> id bigint unsigned not null auto_increment
You need an index, it should drastically cut the query time. See:
http://www.mysql.com/doc/en/CREATE_INDEX.html#IDX1466
Mike Hillyer
Dynamergy Software
-Original Message-
From: Steinar Kolnes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 13, 2002 4:50 PM
To: Mysql List
Subject: Need
Hi there,
I have to make a large 6.5 million names and numbers database in MySql(maybe
not so
large for some of you). Yet it is very simple, here is my sql file:
create table subscriber
(
id bigint unsigned not null auto_increment primary key,
subscr_id
At 23:19 2/8/2002 +, Tien Lim wrote:
Hi,
>To Whom It May Concern:
>
>Environment:
>Operating System Windows XP Home Edition
>Using MySQL 3.23
>Using Apache 1.3.12
>
>Initially it started working suddenly after trying all of the commands
>below... : )
>
>The next day I started the computer an
To Whom It May Concern:
Environment:
Operating System Windows XP Home Edition
Using MySQL 3.23
Using Apache 1.3.12
Initially it started working suddenly after trying all of the commands
below... : )
The next day I started the computer and it does not work : (
Tried to intall from the C:
Hi,
I m using MySQL 4.0.2 which now supports multi-table
update query
I am getting error while throwing multi-table UPDATE
query, I don't know what the problem is
To generate an error run below query, it will create a
2 InnoDB table and inserts a dummy record in it
CREATE TABLE `systemdefault`
Hi,
I m using MySQL 4.0.2 which now supports multi-table
update query
I am getting error while throwing multi-table UPDATE
query, I don't know what the problem is
To generate an error run below query, it will create a
2 InnoDB table and inserts a dummy record in it
CREATE TABLE `systemdefault`
Nitesh,
Friday, July 26, 2002, 1:45:35 AM, you wrote:
ND> I need help with tables. I have created my table with some attributes in
ND> it.
ND> I need to modify my table attributes, can any one help me with the
ND> modify command or can give me the short cut to the web.
ND> Exa
E.html
On Thu, 2002-07-25 at 23:45, Nitesh Divecha wrote:
> Hello All,
>
> I need help with tables. I have created my table with some attributes in
> it.
>
> I need to modify my table attributes, can any one help me with the
> modify command or can give me the short c
Hello All,
I need help with tables. I have created my table with some attributes in
it.
I need to modify my table attributes, can any one help me with the
modify command or can give me the short cut to the web.
Example:
Mysql> create table test(ID int(4), Name varchar(20), Sex varcha
Hello Nitesh,
You can find that and more at...
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
Good Luck,
--- Nitesh Divecha <[EMAIL PROTECTED]> wrote:
> Hello All,
>
> I need help with tables. I have created my table
> with some attributes in
> it.
>
> I need to
Hello!
Nitesh Divecha wrote:
>Hello All,
>
>I need help with tables. I have created my table with some attributes in
>it.
>
>I need to modify my table attributes, can any one help me with the
>modify command or can give me the short cut to the web.
>
>Example:
>M
ord'
WITH GRANT OPTION;
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent
_id (i think its the same
network id used for login to a NT domain) to BO database' or at times 'the
mysql does not support this version']
P.S. My table name is outnum which is the same as the file name, MySQL
version is 3.23.51.
What am i doing wrong here? Need help please (could so
--On Sunday, July 14, 2002 5:24 PM -0500 Dan Nelson
<[EMAIL PROTECTED]> wrote:
>> > The correct thing to do is probably to fix include/my_net.h. poll
>> > requires , not . In addition, there should be
>> > an autoconf check for , instead of assuming that because
>> > you have a poll function
In the last episode (Jul 14), R Blake said:
> --On Sunday, July 14, 2002 2:04 PM -0500 Dan Nelson <[EMAIL PROTECTED]> wrote:
> >In the last episode (Jul 13), R Blake said:
> >>BUG #1:
> >> does not seem to exist in BSD variants (cref:
> >>http://www.netsys.com/bsdi-users/2001-11/msg00093.html), bu
dan,
thx for your reply!
--On Sunday, July 14, 2002 2:04 PM -0500 Dan Nelson
<[EMAIL PROTECTED]> wrote:
> In the last episode (Jul 13), R Blake said:
>> BUG #1:
>> does not seem to exist in BSD variants (cref:
>> http://www.netsys.com/bsdi-users/2001-11/msg00093.html), but
>> nonetheless, ".
In the last episode (Jul 13), R Blake said:
> BUG #1:
> does not seem to exist in BSD variants (cref:
> http://www.netsys.com/bsdi-users/2001-11/msg00093.html), but nonetheless,
> "./configure" sets HAVE_POLL as defined, causing make to fail with
> sys/poll.h "not found".
>
> WORKAROUND:
> ==
601 - 700 of 940 matches
Mail list logo