Hi guys,
i have installed red hat linux 7.2 and mysql server version 3.23.42. but i need
mysql++ also.but it seems that gcc version 2.96 will give lot of problems for mysql++.
can any one pls give me a solution to use mysql++ on linux 7.2.
Get Your Private, Free E-mail from Indiatimes at htt
You'd probably want to make sure the tables are at least in 3rd normal form.
1st: each column contains only ONE attribute. The means you can't
have a list of people for "members" or the such. And each row must
have a primary key. No two rows can be identical in a table.
2nd: no column is parti
Might wanna try MySQL Front at http://www.mysqlfront.de.
It's pretty good.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: "John Mayson" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, December 24, 2001 6:
- Original Message -
From: "John Mayson" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, December 24, 2001 4:40 PM
Subject: How many tables?
> How far should I go with this? Right now when I look at my frequency
table, it's mostly a
> list of numbers. I suppose t
I think I'm getting the hang of SQL now. Thanks to all who have answered my
questions.
I do have one other.
I am an amateur radio operator and radio hobbyist. I have built a database for radio
frequency information. Some of the fields in my frequency table include frequency,
callsign, age
Eventually my databases will be on my Linux system. In the meantime, is there a
Windows program that builds a quick and dirty GUI interface for my SQL databases?
Thanks,
John
--
John Mayson KC4VJO Linux/Perl/HP-UX/ICT
Austin, Texas 78729 30.4560N 97
You should join the MySQL win32 list. There are MySQL & ASP developers there.
Milder Lisondra wrote:
> Has anyone used or tried to use Activer Server Pages with MYSQL.
> I am currently working on a project currently only has access to these 2 dev
> tools.
> Thanks,
> Milder
>
>
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 U.S. Dollars expense one
time''
THANKS TO THE COMPUTER AGE AND THE INTERNET!
==
Has anyone used or tried to use Activer Server Pages with MYSQL.
I am currently working on a project currently only has access to these 2 dev
tools.
Thanks,
Milder
-
Before posting, please check:
http://www.mysql.com/manual.ph
I need to replace some data with data from a backup. Here's the scenerio...
I have 2 databases. a and abak
a and abak are the same (but, ones a few hours old with the right data ;) )
a and abak have a table, posts and a field 'attach'. I'd like to take
the data from abak.posts.attach and place
On Mon, Dec 24, 2001 at 11:31:45PM +0200, Heikki Tuuri wrote:
: Use the following:
:
: CREATE TABLE `wishlist` (
: `wishlist_id` int(11) NOT NULL auto_increment,
: `user_id` int(11) NOT NULL,
: PRIMARY KEY (`wishlist_id`),
: INDEX `w
Patrick,
>Heikki,
> I did end up reading that bit before you sent this to the list, but before I
>could send the follow up I wanted. I have added the creation of the index to
>my create statement, but I get the same error. Here is the sql as it stands
now:
>CREATE TABLE `user` ( `user_id
>From: Bogdan Stancescu <[EMAIL PROTECTED]>
>To: Leon Heller <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: ISP in UK with MySQL and PHP
>Date: Mon, 24 Dec 2001 23:08:07 +0200
>
>Why don't you install a Linux box at home instead? You'd have the advantage
>of
>learning about configura
Why don't you install a Linux box at home instead? You'd have the advantage of
learning about configuration as well, plus the ability to tweak the packages as
you please. If you have no Linux experience you can always check out Mandrake
Linux which is extremely easy to install, even in dual-boot m
MySQLers in the UK might be interested in this ISP I came across:
http://www.uklinux.net/
They offer free hosting for non-commercial use with MySQL and PHP in return
for at least one hour dial-up time per month. I've registered with them, in
order to get some experience setting up a web-enable
Heikki,
I did end up reading that bit before you sent this to the list, but before I
could send the follow up I wanted. I have added the creation of the index to
my create statement, but I get the same error. Here is the sql as it stands
now:
CREATE TABLE `user` (
`user_id` int(11)
Amit,
when you recreate a dropped table, its table definition must match existing
foreign key references to it.
Since MySQL silently changes many char columns to varchar columns, it is
best to use varchar in all foreign key columns currently. Upcoming 3.23.47
fixes the problem, because in .47 yo
Patrick,
>I wasn't on the list when the thread below started, but I saw it on google
>and wanted to add some more information, but this time, my columns aren't
>char based and I get the same error. Here's my SQL:CREATE TABLE `user` (
> `user_id` int(11) NOT NULL auto_increment,
> `username` v
On Mon, 24 Dec 2001 12:37:21 -0800, Joel Wickard used a
few recycled electrons to form:
| Hello,
| I've looked around on mysql.com, and through the directories of my mysql
| install I'm looking for information on benchmarking my mysql database, but
| I'm not interested in seeing how it performs ag
Hi folks,
Here is a bug report using the bug tool...
~~~BUG REPORT~~~
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: mcook
To: [EMAIL PROTECTED]
Sub
Hello,
I've looked around on mysql.com, and through the directories of my mysql
install I'm looking for information on benchmarking my mysql database, but
I'm not interested in seeing how it performs against other databases, I'm
interested in testing how my designs will perform when scaled. If an
Dear sir,
I used Slackware 7.1.
Now I can compile Apache-1.3.22 with MySql-4.0.1.
But I can't run Apache-1.3.22 with Mysql-4.0.1.
I think this problem may cause from Mysql-4.0.1.
./configue at Php-4.0.1 state shown below.
./configure --with-apache=../apache_1.3.22 \
--with
Dear sir,
I used Slackware 7.1.
Now I can compile Apache-1.3.22 with MySql-4.0.1.
But I can't run Apache-1.3.22 with Mysql-4.0.1.
I think this problem may cause from Mysql-4.0.1.
./configue at Php-4.0.1 state shown below.
./configure --with-apache=../apache_1.3.22 \
--with
At 05:53 PM 12/24/01 +, you wrote:
>Is the mysqld daemon set to run as root?
>do either
> ps -auxw | grep mysql
>or
> ps -ef | grep mysql
>
>and see what mysqld is running as. You can set the server to run as
>a particular user regardless of what the file ownership of mysqld is.
Oops. Yep,
Is the mysqld daemon set to run as root?
do either
ps -auxw | grep mysql
or
ps -ef | grep mysql
and see what mysqld is running as. You can set the server to run as
a particular user regardless of what the file ownership of mysqld is.
Also, have you installed the mysql database with
mysql_in
I forgot to mention that /var/lib/mysql is owned by root and I'm in as
root. I've also changed permission to mysql ownership of said directory
with no luck. Any ideas?
At 08:31 AM 12/24/01 -0800, you wrote:
>Hi;
>I've successfully installed mysql from source. However, I've run into a
>problem
Hi;
I've successfully installed mysql from source. However, I've run into a
problem with trying to create databases or users:
mysql> create database cc_store;
ERROR 1006: Can't create database 'cc_store'. (errno: 13)
Furthermore, I can't edit the root password. What fundamental step have I
mis
If you are doing lots of similar sql statements, you could use the following
instead:
--- start
my $dbh = DBI->connect("DBI:mysql:database=prepaid;host=localhost",
"root", "sascha28",
{'RaiseError' => 1});
my $sql=qq{
INSERT INTO pins (pin, msis
Dear Sirs and Madams,
EMS HiTech Company wishes you Merry Christmas and a Happy New Year! We
also wish you prosperity and success in your business.
We are very glad to announce the Special Xmas Offer - 20% discount for
each our product! Please visit our site http://www.ems-hitech.com/ for
gettin
> Is this a bug in MySQL 3.23.37? Could it have something to do with my OS
> (OpenBSD 2.9)? Or am I doing something wrong with the statement "update
> time_worked set total = start - finish;"?
Umm. Don't you mean 'finish-start'?
--
Amer Neely [EMAIL PROTECTED]
Softouch Information Services: w
Cafetechno writes:
> Hi,
>
> When The Stored Procedure Capability will be
> included in mySQL
>
> Regards
> cafe
>
Take a look at myperl on http://freshmeat.net
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\
Cafetechno writes:
> Hi,
>
> When The Stored Procedure Capability will be
> included in mySQL
>
> Regards
> cafe
>
Take a look at myperl on http://freshmeat.net
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\
> If I type something at the MySQL prompt and it's taking too long to run,
> how do I abort it? I'm using a Windows telnet app to telnet to a Linux
> machine, and running MySQL from the command line. But if I type "ctrl-c"
> (which I'm in the habit of doing, to kill slow UNIX and DOS programs
> Hi!
>
> I have a proplem using my perl code to write some data into my mysql
> database. When running in consolemode anything works fine, but when
> executed by the wwwserver the scripts is processed without errors,
> except the data is not written into the database! Any idea how to fixit?
> Th
mysql is slow when finding the last value before a period of time (I'm
plotting the temperature values during a period of time and want the last
value before the period begins).
The query is:
select DateTime, Target, Value from log
where DateTime < "2001-12-21 00:00:00"
and Source = "S
a good windows gui mysqlfront from : www.mysqlfront.de
24/12/2001 12:41:04, "Matthew Darcy" <[EMAIL PROTECTED]> wrote:
>
>Hi,
>
>a week or so ago I requested some info on mysql gui's. I got some great info
>and feedback. The PHP admin tool seems to be one of the most popular. As I
>was cleaning
Hi,
a week or so ago I requested some info on mysql gui's. I got some great info
and feedback. The PHP admin tool seems to be one of the most popular. As I
was cleaning out my mailbox I deleted a lot of mails I shouldn't have. Can I
have some good links for some linux gui's (pref tools or source
Hi,
When The Stored Procedure Capability will be
included in mySQL
Regards
cafe
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To req
The Windows download is still 4.0.0a .
for mail filter: database,sql,query,table
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To r
Hell o all.
I edit the my.cnf file addinn a line default-character-set=value
and then i try to reindex the tables according to the manual:
(If you change the character set when running MySQL (which may also change the sort
order), you must run myisamchk -r -q on all tables. Otherwise your indexe
40 matches
Mail list logo
