I wondered if you can get me started on selling MANY mailing list to
potential clients who are in need of millions of e-mail names and addresses.
This has collected for some time. I am needing to start a business doing this
Here in the United States and out of country yet I am not sure how
You'll probably need to create a database first (to host the table).
This can be done most easily from the GUI MySQL Administrator tool, or
from phpMyAdmin if you have it, or from a mysql command line:
http://dev.mysql.com/doc/refman/5.0/en/create-database.html
To create a table use the
: Monday, October 9, 2006 10:35:54 PM GMT-0500 US/Eastern
Subject: hello everyone
my name is alan madsen.
while i am very well grounded in complex systems and database
management that is archaic by today's standards, i am looking
at a creating a server-side php/mysql environment for a very
simple
my name is alan madsen.
while i am very well grounded in complex systems and database
management that is archaic by today's standards, i am looking
at a creating a server-side php/mysql environment for a very
simple database application with only the experience of recent
light reading and
my name is alan madsen.
while i am very well grounded in complex systems and database
management that is archaic by today's standards, i am looking
at a creating a server-side php/mysql environment for a very
simple database application with only the experience of recent
light reading and
That's a lousy subject line, but I don't know how to describe this problem.
I've been banging my head against this for a couple of days, and I'm certain
there's a simple solution I'm missing.
I've got a URL table, a keyword table, and a joining table, so each URL has a
list of keywords applied
select a.urlid,a.keywordid,b.url,c.keyword from tbl_url_keyword a inner join
tbl_url b on a.urlid=b.urlid inner join tbl_keyword c on
a.keywordid=c.keywordid where c.keyword=mysql or c.keyword=databases or
c.keyword=tutorial;
I think it´ll help you.
David Otton [EMAIL PROTECTED] escreveu na
David,
How do I find all the tags that are tagged with the
words mysql AND databases AND tutorial?
If there are no url-keyword dupes in tbl_url_keyword ...
SELECT u.urlid, u.url
FROM tbl_url_keyword AS uk
INNER JOIN tbl_url AS u USING (urlid)
INNER JOIN tbl_keywords AS k USING (keywordid)
Hi all,
I have got a database in mysql and i need to use the gis and that was in
VFOXPRO.I need to display my data which is mysql on the map which database
is in VFoXPRO.Is there any way to have communication betweeen these two DBs.
Thanks and regards,
venu.
Hi Venu,
I would like to know the OS your using (for mysql server), BTW if
your using window. Try installing the myodbc and configure it so that
vfoxpro can communicate with it.
check this site:
http://fox.wikis.com/wc.dll?Wiki~VFPCommandSQLStringConnect~VFP
At 06:28 PM 5/22/2006,
Hey, This is sabeer. Newly joined to this Group.
Hope I ll enjoy my best Here.
Sabeer MZ
__
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250
--
MySQL General Mailing List
For list
Sabeer-
Welcome to the list! I'm pretty much a lurker here, but I have learned
a lot. You've come to the right place to get your MySQL questions
answered.
Good luck!
- James
On Jan 10, 2005, at 2:06 PM, sanoj zubair wrote:
Hey, This is sabeer. Newly joined to this Group.
Hope I ll enjoy my
Sabeer-
Welcome to the list! I'm pretty much a lurker here, but I have learned
a lot. You've come to the right place to get your MySQL questions
answered.
Good luck!
- James
On Jan 10, 2005, at 2:06 PM, sanoj zubair wrote:
Hey, This is sabeer. Newly joined to this Group.
Hope I ll enjoy my
hello , mysql .first,sorry for my poor english .
I'm used CRecordSet to connected database of mysql(linux) . Read source data no
error , but can't write data , has a memory allocation error error in used
CRecordSet::Update() . into debug , this error (
CATCH_ALL(e)
{
lResult
if it just can't be done with a query please somebody
like Paul DuBois say so...
Colleen Dick wrote:
This stumped them in PHPbuilder...
I have a table lets call it moms
each row in the moms table can have many kids,
and some kids have 1 mom. I have a kid table
and I have a mxk map table to relate
Hi,
In the DOS database (EDIBASE) I use at home, each organization is
seperate, I exported all data as a text file, then I had to create
individual web pages for each one. I have a list of each numbered web
page. I would like to have only one database, instead of changing
individual ones as
From: Norm Lamoureux [EMAIL PROTECTED]
In the DOS database... each organization is seperate...
...exported all data as a text file
...individual web pages for each one.
Individual web pages for each one, does this refer to items like:
http://www.informsarnialambton.org/listing/36.HTM
I
Hi,
Sounds like I am confusing everyone...
I only have one database with over 800 records
The data on the website is the result of my database.
I wish to search on words in each record.
I might be able to export each record as a CSV file?
Clear as mud (I think)
Thanks again,
Norm
Rodney
From: Norm Lamoureux [EMAIL PROTECTED]
Sounds like I am confusing everyone...
I only have one database with over 800 records
The data on the website is the result of my database.
I wish to search on words in each record.
Search with what? Do you mean the page at:
there may be some willing to help, but having
trouble understanding.
i don't know about anybody else, but i've been
following this since his first posting, and my
simple mind is having trouble identifying his
problem. is it technical, organizational, or
sociological?
mysql
From: Norm
Hi,
Ok, I guess I was confusing everyone. I thought this was a simple
problem, we need a search engine to search through our data, I might be
able to convert to csv, or I found another way...
example...
-NO-
SAR1100
-COMMENTS-
999 try6
-ORG_LEVEL_1-
SARNIA COMPUTER USERS' GROUP
Hi Norm,
It sounds to me like we have some lack of clerity. Let me see if I can place some
useful definitions:
- CSV
A text format for representing data.
- CSV file
A file written in the CSV format.
- Database
A place to store data.
- Program
Software that does something.
- Database
so one of your questions is, if i may paraphrase,
what database manager should i use?
i believe that you said that it has only eight
hundred records?
and it's only a single table?
you can manage it manually with little trouble?
and it's a low volume web site?
pardon my sacrilege, but if
Hi,
Ok, I guess I was confusing everyone. I thought this was a simple
problem, we need a search engine to search through our data, I might be
able to convert to csv, or I found another way...
example...
[ snip ]
I think what Norm is trying to do (Norm correct me if I'm wrong) is
search a
From: Amer Neely [EMAIL PROTECTED]
I think what Norm is trying to do... is search a DOS-based database
using a script from Excite.
The data has to be updated on the server, but in a format searchable
by the script.
Ohhh, that makes sence for his descriptions so far.
Why not ask your ISP
Hi,
You got part right, the database I use at home is Edibase for DOS, the
program has been updated for Windows, too expensive for that and the web
plug in ($5,000.00 I think) I am trying to port it over to a Windows
Database. I downloaded the lastest version of MySQL the other day but it
all
From: Norm Lamoureux [EMAIL PROTECTED]
I downloaded the lastest version of MySQL the other day but it
all looks greek to me, not like a database like ACCESS or Alpha Five.
Now I'm with you! You're talking about a database being a program with a nifty front
end for the users as well as a back
Hi,
It is 760 organizations listed, when I said two, I meant that on the WWW
I have over 700 individual web pages that EXCITE does a search for and
my main database in DOS. I don't know whether my server has these
programs, I can check.
Thanks
Norm
Rodney Broom wrote:
Hi Norm,
I gather
From: Norm Lamoureux [EMAIL PROTECTED]
...700 individual web pages that EXCITE does a search for...
Are these web pages actual individual files, or are they simply information in a
database someplace that needs to get displayed?
I don't know whether my server has these programs, I can
lizard,
Sunday, November 10, 2002, 9:32:33 AM, you wrote:
l My name is Mike.
l I have a Linux RedHat 7.3 with Mysql ver 3.23.49.
l I want to grant access to databases and tables to users,but only to a certin
l databases and tables.
l I red the how-to but both grant and revoke commands does not
Also, make sure you're running FLUSH PRIVILEGES after your grants and
revokes. (Did I spell that right?)
-Mike
Hi all.
My name is Mike.
I have a Linux RedHat 7.3 with Mysql ver 3.23.49.
I want to grant access to databases and tables to users,but only to a certin
databases and tables.
I
Hi all.
My name is Mike.
I have a Linux RedHat 7.3 with Mysql ver 3.23.49.
I want to grant access to databases and tables to users,but only to a certin
databases and tables.
I red the how-to but both grant and revoke commands does not seems to work
(he execute the command but says that 0 records
Hi,
Mailing list: http://lists.mysql.com/
Joining three tables could be something like this.
Select * from t1 INNER JOIN t2 ON t1.id = t2.id INNER
JOIN t3 ON t2.id = t3.id
I highly recomend you to read some basic SQL books
before you carry on with your project. Trial and error
is not always
Hi.
On Sat 2002-07-20 at 22:23:06 -0700, [EMAIL PROTECTED] wrote:
And could not find where or if they have archives of the list for my to
search though so I guess I will ask my question.
Some searchable archives can be found here:
http://www.mysql.com/documentation/searchlists.html
I was
i've report this bug to php, they said it's not bug of php
but i've found the problem
* ALL is ok for SERVER, problem issue only by CLIENT(libmysql.a)
php-win-binary don't compile libmysql supporting GBK charset!
neight other multibyte charset.
also the one i compiled is linked with
Xuefer,
Monday, April 15, 2002, 8:55:08 AM, you wrote:
X mysql-4.01
X binary package
X windows
X also the same in linux source/binary package
X when SHOW VARIABLES
X got:
X -
X character_set gbk
X character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis
mysql:
mysql-4.01
binary package
windows
also the same in linux source/binary package
when SHOW VARIABLES
got:
-
character_set gbk
character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos
german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew
Konstantin,
Saturday, February 23, 2002, 11:49:35 AM, you wrote:
KY Hello!
KY Is there a way to find out bad query?
You can read info about EXPLAIN statement (give you info about each
table used in SELECT statement):
http://www.mysql.com/doc/E/X/EXPLAIN.html
Please, read about how MySQL
Hi all...
This is my first post to the list. I've been working on MySQL now for about a
week and really like it. I have a question that I can't find in any of the
books or how-tos.
When I add a line to my customer's table I need it to put today's date in the
indate column. Is there anyway
[mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 9:50 AM
To: [EMAIL PROTECTED]
Subject: Hello! Date question
=20
Hi all...
=20
This is my first post to the list. I've been working on MySQL=20
now for about a=20
week and really like it. I have a question that I can't find=20
in any
Hi Jim,
Welcome to our relatively?relationally happy band.
This is my first post to the list. I've been working on MySQL now for about a
week and really like it. I have a question that I can't find in any of the
books or how-tos.
A whole week and no post...
When I add a line to my
See the manual reference to the 'timestamp' type.
-Original Message-
From: Jim Hatridge [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 5:50 PM
To: [EMAIL PROTECTED]
Subject: Hello! Date question
Hi all...
This is my first post to the list. I've been working on MySQL
At 18:49 +0100 2/8/02, Jim Hatridge wrote:
Hi all...
This is my first post to the list. I've been working on MySQL now for about a
week and really like it. I have a question that I can't find in any of the
books or how-tos.
When I add a line to my customer's table I need it to put today's date
On Friday 08 February 2002 19:28, Eric Mayers wrote:
Jim,
What you're asking about is the timestamp data type.
Look at : http://www.mysql.com/doc/D/A/DATETIME.html
In a nutshell, if you assign 'null' to a timestamp column it will put in
value of 'NOW()'.
Eric Mayers
Software Engineer
Hi all...
This is my first post to the list. I've been working on MySQL now for about a
week and really like it. I have a question that I can't find in any of the
books or how-tos.
When I add a line to my customer's table I need it to put today's date in the
indate column. Is there anyway
At 18:49 +0100 2/8/02, Jim Hatridge wrote:
Hi all...
This is my first post to the list. I've been working on MySQL now for about a
week and really like it. I have a question that I can't find in any of the
books or how-tos.
When I add a line to my customer's table I need it to put today's date
:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 9:50 AM
To: [EMAIL PROTECTED]
Subject: Hello! Date question
Hi all...
This is my first post to the list. I've been working on MySQL
now for about a
week and really like it. I have a question that I can't find
in any of the
books
Hi Jim,
Welcome to our relatively?relationally happy band.
This is my first post to the list. I've been working on MySQL now for about a
week and really like it. I have a question that I can't find in any of the
books or how-tos.
A whole week and no post...
When I add a line to my
Hello List,
I have a question?
how can i add a few fields from a mysql database to another mysql database?
I mean, i use mysqldump to copy the information of a database or of a
table to a file, but, if i want to copy just a few fields from a table to
another table, how can i do this?
Thanks
Date |Thu, 16 Aug 2001 13:40:16 +
From |Brian Johnson Jaber [EMAIL PROTECTED]
Hello!
BJJ Dear Sirs
BJJ Hello, i have questions on mysql i create a table and i create an index key
BJJ in it i want to know how can i know in mysql if the date that i import it
BJJ into the table are fully
Dear Sirs
Hello, i have questions on mysql i create a table and i create an index key
in it i want to know how can i know in mysql if the date that i import it
into the table are fully indexd.
please reply.
best regards.
nabil jaber
Hi,everybody!
I want to write a Client GUI DBMS for Mysql,but I don't know how to start.
Anyone can tell me about the API,how to get it,how to begin?
(I should use create,drop,insert,delete,update...)
thank you very much
-Original Message-
From: Divakar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 4:50 AM
To: [EMAIL PROTECTED]
Subject: Hello please help me out
Hi list
I am a beginner in the field of mysql
I would like to know whether it is possible to run sql scripts(a .sql file)
in mysql.
if yes
[EMAIL PROTECTED] wrote:
try
echo file.sql mysql -u username -p password databasename
You mean:
^
cat file.sql | mysql -u username -p password databasename
^
Or, better:
mysql -u username -p password databasename file.sql
--
Jack Challen
whoops,
yip,
**blush**
-Original Message-
From: Jack Challen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 10:23 AM
To: [EMAIL PROTECTED]
Cc: Sean O'Donnell
Subject: Re: Hello please help me out
[EMAIL PROTECTED] wrote:
try
echo file.sql mysql -u username -p
Hi list
I am a beginner in the field of mysql
I would like to know whether it is possible to run sql scripts(a .sql file)
in mysql.
if yes please some body tell me how do we do that,.
regards
Div
-
Before posting, please
At 9:19 AM +0530 6/28/01, Divakar wrote:
Hi list
I am a beginner in the field of mysql
I would like to know whether it is possible to run sql scripts(a .sql file)
in mysql.
if yes please some body tell me how do we do that,.
The MySQL Reference Manual is your friend:
testing
I didn't get a confirmation mail or anything so here goes ...
I'm trying to compile a simple C program to access a db and dump out the
info (for testing purposes). Here is what I get when I try to compile it:
ebulon:/var/www/www.miester.org/cgi-bin# gcc -g -o miesterc miesterc.c
Hello!
How do you do!
I meet a problem when I install Mysql at Solaris 2.7 Sun SPARC.Please help me.
First I gzip and tar the mysql-3.23.36-sun-solaris2.7-sparc.tar.A error echoed
"tar:directory checksum error."Then I goto the /mysql/bin/ and excute ./configure,t
TED] wrote:
Hello!
How do you do!
I meet a problem when I install Mysql at Solaris 2.7 Sun SPARC.Please help
me.
First I gzip and tar the mysql-3.23.36-sun-solaris2.7-sparc.tar.A error
echoed "tar:directory checksum error."Then I goto the /mysql/bin/ and excute
./
PROTECTED]]
Sent: Thursday, 5 April 2001 3:34 p.m.
To: [EMAIL PROTECTED]
Subject: Hello!Help.
Hello!
How do you do!
I meet a problem when I install Mysql at Solaris 2.7 Sun SPARC.Please
help me.
First I gzip and tar the mysql-3.23.36-sun-solaris2.7-sparc.tar.A error
echoed
First I gzip and tar the mysql-3.23.36-sun-solaris2.7-sparc.tar.A error
echoed "tar:directory checksum error."Then I goto the /mysql/bin/ and excute
./configure,the prompt is configure not found.I don't know what is the
reason.I think maybe the tar of Solaris is not work in good
Dear Robert,
If I'm correct you've installed a mysql server on your webserver, I hope that you used
the documentation which is provided on
the mysql-website. I hope that you're sure about the ability to use
scripting-languages on your server and that they can interact with mysql. If you
To: [EMAIL PROTECTED]
Subject: Re: Betr.: Hello
...And.. a book called MySQL written by Paul DuBois. It's a great book and
will help you to get things up and running within a very short time..
It will cost you another 2-3 days (based on 8 hours per day) to work your
way through the book and all
i don't know what should i do to configurate the odbc driver with mysql.
can somone give me a procedure for release this operation
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
67 matches
Mail list logo