is it possible? If yes, how ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To
I have inherited a client with a flat file shopping cart. I have added a
MySQL database to record the orders, and am using DBI with Perl and PHP3 to
do the interaction with the MySQL database.
The site is a local theater that sells concert tickets. They have sold as
many as 4 tickets per
At 08:55 4-4-01 +0200, Nicolas Villatte wrote:
is it possible? If yes, how ?
Yes.. BLOB (BinaryLargeOBject) Check the archive, and manual.
Bye,
B.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
my code attempt
#!/usr/bin/perl -w
#for test using socket input from
$remote_host = "linus.chemeketa.edu";
$port = "10152";
$hostname = '127.0.0.1'; # localhost
$portdb ="3306"; # default mysql port
$database = "track"; # database name
$user = "david"; # database user name
$password =
Chinese OS: Read the manual on how to set the default character set and
language in mysql.
English OS: You will need to build a UI to be able to enter Chinese
characters. Chinese characters should go in as ASCII garbage but will be
displayed as Chinese characters on a Chinese OS without any
We are getting problems in running mysql after installation.
Since you have already running mysql we seek your advise on the
following.
Do you already have a mysqld running (ps -ax).
Also please guide how users are created and groups are set to user
mysql.
Read the manual and/or buy the book
Hi,
I have a table that I'd like to set up along the following lines:
table events:
...
next_event datetime
period varchar(5)
period_tvarchar(15)
...
and at some point, do an update on every row to the tune of:
UPDATE events SET next_event = DATE_ADD(NOW(), INTERVAL period
On Tuesday 03 April 2001 17:12, Jean-Luc Fontaine wrote:
On my replicated linux machines with the latest 3.23.36 rpm from mysql.com,
I have been getting the following errors lately:
010403 17:08:35 Slave: received 0 length packet from server, apparent
master shutdown: (0)
010403 17:08:35
On 04.04.2001 08:55:04 Nicolas Villatte wrote:
is it possible? If yes, how ?
Could someone *PLEASE* add this to the FAQ?
There are two answers you'll get:
a) Don't store the binary data in the database. Instead store nothing but the
metadata.
b) Also store the binary data in the database.
HHG You must go to control panel of windows in Data Sources(ODBC) section and add
your DSN of you new MySQL database and then you can explor the database by browsing
your ODBC avilable databases .
HHG You can check MyODBC manual for this .
Yes, this worked for me too.
However ... I can only
L Ok i'm still a little bit lost. I have a database in MySQL called "irm"
L In the ODBC Data Source 32 bit I went in user dsn and added user data source
L called irm the driver is mysql
L not this is were i dont understand .
L In the field that says Windwos DSN name I put "irm"
L MySQL I put
Hi,
I'm using BDB, and I had the same doubts you ask for.
For install BDB:
- You need the source version 3.23.34a +
- You need to compile using the BDB option
You can create a BDB table by using "TYPE = BDB" at the end of create table.
In order to check if the BDB is working you can:
- try
I would rather store the files on disk and the filenames in the database for more
speed.
I'm a developer on a website which members have an uploaded image of theirself..
We just have a image directory with filenames as [username].jpg
This dir is therefore easily mapped to the web with an Alias
Hi friends ...
I have sent once my problem, but don't know why, I haven't recieved any
answer or solution for it ...
Actually, I have installed MySql 3.22.21 on my SERVER NT4, and installed the
MyODBC, I have installed them on my D drive ( the WINNT is installed on D
drive) , and when I type
Hi Friends ...
When I type mysql from the command prompt ... an error occured :
ERROR 2003: Can't connect to MYSQL server on 'localhost' (10061)
What is the problem?
Hanan
_
Get Your Private, Free E-mail from MSN Hotmail
Statically Compiled MySQLGUI 1.7.4
../Downloads/mysqlgui/mysqlgui-linux-static-1.7.4.tar.gz
I need to know whether I have to compile or do anything else with the above other than
download and unzip it. When I do that (into c:\mysql\ directory) the file mysqlgui is
not an application file so
On Mon, 2 Apr 2001, Derek Sivers wrote:
Date: Mon, 02 Apr 2001 19:42:18 -0700
From: Derek Sivers [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: NEW "MAKE" BUG? sigcontext.h
Doing a "make" on the newest MySQL stable 3.23.36 source tarball - on a
stock Cobalt RaQ3 (Linux 386) which I've
Hello,
I have created a table in mysql that has a date field, i have written
an asp code which saves the date in Mysql -MM-DD format but when
retrieving the content of the field it returns in m/d/yy format although
i have set the system format of date as DD/MM/. Is there any
Ouch! I don't know if many people would recommend this method - that's a
fair bit of unnecesary overhead to place ony our server...depending, of
course, on how often these images are created/modified/read.
P
Here's how I do b) in PHP:
1) Get the MIME type of the image.
2) Read the
Hi,
I'm trying to install mySQL on a BSDI machine. But this is not working.
Could someone help me on this ?
I have downloaded the version for BSDI en unzipt it whit the tar and gz.
So far so good, but then
You have to do all kinds of things that are not allowed.
I am just a user on the
You may look at the MySQL related code in phpAds from phpwizard.net:
http://www.phpwizard.net/projects/phpAds/
It will bring you all you need in code, but I've tested that system on a website
with 30 concurrent users with 2 ads (2 image SELECTs) per pageview and
that was a bg performance
"Martin van Wilderen" [EMAIL PROTECTED] wrote:
I am just a user on the system, so NOT root. The system is from our ISP
and webhoster (named xs4all). They say that I have to setup and install
it my self.
Your web hosting company must not be familiar with MySQL. It must be
installed by the
Hi,
I dowloaded and installed the source distr 3-23-36 for Solaris, and tested
the BDB+INNOBASE features.
I tried to do the same for NT-Win2000, but the source 3-23-36 seems not
include the BDB+INNOBASE sources!
if (this si true)
How we can bypass that?
else
where the sources
I just had my mysql server go down - the processes still appeared to
be running, but were not accepting connections. The only entry in my
hostname.err log was as follows...
010404 11:12:07 Aborted connection 31 to db: 'unconnected'
user: 'root' host: `localhost' (Got an error writing
At 10:41 4-4-01 +0200, hanan khader wrote:
Hi friends ...
I have sent once my problem, but don't know why, I haven't recieved any
answer or solution for it ...
Perhaps because you try to run MySQL on Windows.. I think most people on
this list are familiar with MySQL on Linux.
I found a link
When I type mysql from the command prompt ... an error occured :
ERROR 2003: Can't connect to MYSQL server on 'localhost' (10061)
What is the problem?
Hanan
Don't send me a copy of your message.. I'll get mine from the list..
Did you follow all instructions as found in the manual and from
I am just a user on the system, so NOT root. The system is from our ISP
and webhoster (named xs4all). They say that I have to setup and install
it my self.
Someone out there ? That knows?
Try to install to another location, like your userdir.
If that's not working find yourself another
Thanx Everybody,
it worked and now it is running ...)))
Hanan
From: "Steve Werby" [EMAIL PROTECTED]
To: "Martin van Wilderen" [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re: BSDI 4.1
Date: Wed, 4 Apr 2001 06:09:20 -0400
"Martin van Wilderen" [EMAIL PROTECTED] wrote:
I am just
Hi ,
One of my Tables Got Corrupted , when i ran the myisamchk i got the error mentioned
below and later the table does not have any data . Is my Data Lost or is there any way
i can recover the data ?
Kiran
Data records: 4113
Wrong bytesec: 31-139- 8 at 0; Skipped
Found
Hi!
On Apr 03, Oson, Chris M. wrote:
Hello,
I have a site that I'm trying to implement a search engine on existing and
archived news stories on a medium text datatype in a database.
I read the documentation and got it running, but unless I missed something
it's not doing what I want
On 04.04.2001 11:21:46 Peter Skipworth wrote:
Ouch! I don't know if many people would recommend this method - that's a
fair bit of unnecesary overhead to place ony our server...depending, of
course, on how often these images are created/modified/read.
Do you mean the base64 part, or what?
On 04.04.2001 08:49:07 Nanjunda BM Prasad wrote:
i have set the system format of date as DD/MM/. Is there any
additional things to do ? pls. send me the solution.
use date_format to return the date in any format you want.
Dear sir,
I have downloaded mm.mysql driver. it is working with Sun Java. But i
don't know where i have to place in Tomcat server as per your documentation it jhas to
be put in WEB-INF/lib as a jar file i tried this also but it is not taking the
driver still it is
Hi,
When you do a query inside a while loop in PHP,
does it dramatically slow down the loading of the
page? For example,
while($row = mysql_fetch_row($result)) {
$id = $row[0];
$query2 = "select field from some_table
where(id='$id')";
$result2 = mysql_result($query2, $link);
}
Does it
John Dillon writes:
Using Windows and Statically Compiled MySQLGUI 1.7.4, it appears to refuse to
connect until I go to Options and Apply again every time I wish to connect.
Grant/revoke crashes the application, while appearing to be downloading data through
my modem. I don't get to
Hi!
On FreeBSD there was a problem that ALTER TABLE and any operation
involving more than about 150 rows hung, with CPU running at 100 %.
I found now the reason. FreeBSD does not seem to reschedule
threads even after the time quota of some 10 msec, if a thread is
spinning and constantly
Dillon, John writes:
Statically Compiled MySQLGUI 1.7.4
../Downloads/mysqlgui/mysqlgui-linux-static-1.7.4.tar.gz
I need to know whether I have to compile or do anything else with the above other
than download and unzip it. When I do that (into c:\mysql\ directory) the file
mysqlgui
Paolo Michetti writes:
Hi,
I dowloaded and installed the source distr 3-23-36 for Solaris, and tested
the BDB+INNOBASE features.
I tried to do the same for NT-Win2000, but the source 3-23-36 seems not
include the BDB+INNOBASE sources!
if (this si true)
How we can
"Bob Hall" [EMAIL PROTECTED] wrote:
Quorting someone else who's name is no longer present:
Is there any way to make one field in a table calculate another field.
I'm making a DB that calculates commissions. So in the money_made
field would have the # of sales (sales field) times
"Cody Law" [EMAIL PROTECTED] wrote:
When you do a query inside a while loop in PHP,
does it dramatically slow down the loading of the
page? For example,
while($row = mysql_fetch_row($result)) {
$id = $row[0];
$query2 = "select field from some_table
where(id='$id')";
$result2 =
I'm working on a MySQL db and I was just curious what type of query was
faster.
e.g.
I have this table1
id (auto# primary key) | date| Name | address | email
I want to insert a new name into the DB.
Which method would be faster?
1.
INSERT INTO table1 VALUES(null,null,'Bryan',null,null);
2.
Yippee!
What shall we do with our prize money? Buy something new to
the MySQL kitchen :)?
Heikki
.
Dear MySQL Kitchen List,
Congratulations!
You just won US$10.00!!
We just gave away US$25,000.00!!
And you MySQL Kitchen List are among the lucky
2500 people
randomly selected to
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Are you bored and want some excitement?
Las Vegas Has Just Showed Up In Your Neigbourhood!
In fact, you wont even have to leave your computer!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Queensclub Online Casino
not for speed, but i defitively prefer your second query. Reason for this is
simple: you name the field you want to insert.
with your first query, if you'd ever alter the table you would have to check
all your source code that interacts with this table.
speed difference should be very minimal
Not sure how helpful I'll be able to be for you. I installed
MySQL-3.23.36-1.i386.rpm and MySQL-client-3.23.36-1.i386.rpm packages. I
verified that everything worked as root and then shutdown the server. I
then followed the steps outlined on p. 476 of the manual (also p. 419 of
Monty
TheCasino.com - Serving ''Winners'' Since 1999!!
Dear MySQL List,
Congratulations and welcome to TheCasino.com!!
To confirm, you have successfully registered as a Real Player. From
now on, every time you log on your Email Address will appear automatically.
And for security, you will need
I frequently get a error 127 on merged tables. The query is a join of two
merged table with each merge table have 4 base tables. If I flush tables
the query works. I notice that when have about 190 tables in memory this
situation is more likely to happen. I am using 3.23.32.
Using
I got into trouble the other day trying to delete gobs of rows. Actually
I was selecting 90% of the rows from table1 and inserting them into a
table2, then deleting from table1. It was way too slow! So I stopped all
activity (inserts) from table1 and flipped table1 with table2 using rename
in access File MenuExport or Import, depending which
way youre goin' Follow on screen inst.
scott
At 03:06 PM 4/3/01, you wrote:
Ok i'm still a little bit lost. I have a database in MySQL called "irm"
In the ODBC Data Source 32 bit I went in user dsn and added user data
Hi,
My problem is specifically concerning syntax for mysqldump.
I can successfully execute the following SQL commands from within MYSQL:
mysql USE cDatabase
mysql SELECT * INTO OUTFILE "/root/cTable-data.dump"
- FIELDS TERMINATED BY ',' ENCLOSED BY '"'
- FROM cTable WHERE myfield='1';
Apache can be set to run your cgi as you user which means that it could
be set world unreadable I think.
On Wed, 4 Apr 2001, Taing Nguon wrote:
Date: Wed, 4 Apr 2001 07:14:33 +0700
From: Taing Nguon [EMAIL PROTECTED]
To: "William R. Mussatto" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Dear Sir/Madam,
I am a student and my teacher want's to try to break in into my mysql-database. I
won't give him a change. I know Mysql have serveral options for security and
encryption. But I do not know, how I can use them and which one I can use the best.
Could you help me? The mysql
I sincerely hope this is the result of a virus.
# Nathan
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 04, 2001 8:54 AM
Subject: TheCasino.com: Registration Confirmation
TheCasino.com - Serving ''Winners'' Since 1999!!
Dear MySQL List,
Does anyone know of a good site or reference on database design? That would
be efficient database design. I can make a database but I want to know how
to plan one and make it very good. Any ideas? Thanks in advance.
--
Jonathan Duncan
nacnud.com administrator
Nacnud, Inc.
TheCasino.com - Serving "Winners" Since 1999!!
Dear Members of the '[EMAIL PROTECTED]',
I am in receipt of your email regarding an unsolicited email.
STOP SPAMMING THE MAIL LISTS ASSHOLE
We have a very strict anti-spam policy, and we take extreme measures to
adhere to these
No this is not true... a lot of the stability of the database server has
to do with the #1 the load, and #2 the design of the database. But no
MySQL should not be crashing this much.
Scott
At 05:26 PM 4/4/2001 +0200, Gunnar von Boehn wrote:
Hello
My provider 11-Puretec (www.puretec.de)
We've been running on RedHat distribution (starting with 5.2 or so) and
Slackware before that for the last few years (currently running mysql
3.23.32... that update bug introduced in 3.23.34 really spanked us hard,
we'll be moving to "latest" again soon).
Currently, we've got dual and quad PII
On Wed, 04 Apr 2001, Gunnar von Boehn wrote:
Hello
My provider 11-Puretec (www.puretec.de)
hosting more than 1.000.000 domains
runs about 14 Databaseserver with MySQL 3.22.32-log
on Linux dual Penti-III 500Mhz machines.
In the last 6 month the average uptime of the mysql-servers was
I checked my RH6.2 install cd's and found zlib-1.1.3-6.src.rpm, I went to
install the package with the following command and get the following error:
rpm -ivh zlib-1.1.3-6.src.rpm
Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory.
When I originally installed the os I
This is an open plea to the MySQL team. The amount of spam and other noise
on the list has been growing more and more every day. I would like to make
a couple basic plea's. The first, is that you require a poster to the list
have an actual account on the list, that should help cut out some of
Under the laws of the State of Washington spamming is illegal.
RCW 19.190.040
Violations -- Damages.
(1) Damages to the recipient of a commercial electronic mail message
sent in violation of this chapter are five hundred dollars, or actual
damages, whichever is greater.
(2) Damages to an
I'm wondering if it is required to name int varibable in PHP any different
then a string variable.
I'm trying to get an ICQ number from my database with an query, but it gives
me a Resource #2 in stead of an ICQ number.
Does anyone know what I'm doing wrong?
Thanks
Guido
Unfortunately not it's plain old SPAM!
It's on other lists as well.
Andy Woolley
www.databasewatch.com
- Original Message -
From: "Nathan" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 04, 2001 5:19 PM
Subject: Re: TheCasino.com: Registration Confirmation
I
Hey everyone
Does anyone know of any sites that teach more advanced PHP and MySQL?
Tutorials are the best to learn from, but I'm willing to take anything.
Thanks all
-
Before posting, please check:
After further asking I got a personal answer that says:
"it's normal the mysql-servers die because of heavy load".
"We can't help that the mysql task keeps crashing if to many users access it.
That's totally normal for a mysql database"
Running 3.22.32 that's prehistoric (sort of).. I think I
At 10:19 4-4-01 -0600, Nathan wrote:
I sincerely hope this is the result of a virus.
Dunno, one of the PHP lists is also being harrased by this kind of
messages.. Perhaps Billy boy G. has to much time to spend ;-)
Or it might be a programm in a nasty loop.
The PHP list admin has blocked all
Hello Listers,
I am using mysql and I am trying to get a SQL statement to work. I have
designed a query in Microsoft Access and I am changing the syntax so that
it will run from Perl against a mysql database. Here is the code:
# from Access
#SELECT DISTINCTROW Query1.licenceNo,
At 16:25 4-4-01 +, Jonathan Duncan wrote:
Does anyone know of a good site or reference on database design? That would
be efficient database design. I can make a database but I want to know how
to plan one and make it very good. Any ideas? Thanks in advance.
www.devshed.com (database
Hi!
Alex Baumeister reported a couple of days ago that Innobase is
slow when a big DELETE is concurrent with UPDATES.
The bug can cause slowing down several database operations
on non-Linux platforms.
You have to edit mysql/innobase/os/os0thread.c.
About on line 140 it is now:
I've searched manyh places and can't get a good answer .. i hope I can get
help here.
I'm trying to dump all the data in my database to separate files (per table)
and be able to specify a field separator character.
for example, I'd like to use || as my field separator, I did the following:
Hi All,
I have installed PHPTriad V1.0 on my Win98 and it is about the best
programme I have ever used. What I need to know is, when I have created my
site and upload it to my ISP's server (Linux / FreeBSD / MySQL + PHP 4) are
there any pitfalls or code differences I should be aware of?
Hi,
I'm facing an issue with my primary mySQL server. It powers a web site,
which loads almost 100% dynamic data. At peak times of the day, it
seems to me that the Database is becomming maxxed. (Thus bogging the
site)
I'm aware that there are simply too many variables to completely answer
Peter Skipworth wrote:
mysql --username=xxx --password=xxx -e "SELECT * INTO OUTFILE
"/root/cTable-data.dump" FIELDS TERMINATED BY ',' ENCLOSED BY '"' FROM cTable WHERE
myfield='1'" dbname
On Wed, 4 Apr 2001, James
Salinas wrote:
Hi,
My problem is specifically concerning syntax
This is an open plea to the MySQL team. The amount of spam and other
noise
on the list has been growing more and more every day. I would like to
make
a couple basic plea's. The first, is that you require a poster to the
list
have an actual account on the list, that should help cut out some
"Eric Fitzgerald" [EMAIL PROTECTED] wrote:
The amount of spam and other noise
on the list has been growing more and more every day.
Agreed. Same thing's happening with my own email accounts.
Second, perhaps setup some basic moderation, I'll help if
need be :)
I think most people asking
Hello,
I have redhat 7.0 with Mysql Ver 8.8 Distrib 3.23.22-beta. This was the
Mysql version that came on the redhat cd's. Perl and the Perl DBI are
installed and working correctly. MySql seems to be working correctly as
well(i.e. no problems with permissions, created db's, tables, etc).
"Jim Hamer" [EMAIL PROTECTED] wrote:
I am using mysql and I am trying to get a SQL statement to work. I have
designed a query in Microsoft Access and I am changing the syntax so that
it will run from Perl against a mysql database. Here is the code:
# from Access
#SELECT DISTINCTROW
Let's say I've got a database on primary server (cluster1) and
periodically I need to purge data from it to a remote archive database.
What's the best way? I thought about replication, but I don't want the
data to stick around in the cluster1 database. Is a dump via SSH the
best/easiest way?
I can understand the concern of longer delays in moderation. My problem
with anti spam filters is simply because they are too much like anti-virus
filters. TOO many false positives.
- Original Message -
From: "Steve Werby" [EMAIL PROTECTED]
To: "Eric Fitzgerald" [EMAIL PROTECTED];
test
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
I agree with the Paul DuBois book on MySQL. Another good one to get if you
are just getting started with databases and is somewhat system-agnostic is
"Database Design For Mere Mortals" by Michael Hernandez.
- Original Message -
From: "B. van Ouwerkerk" [EMAIL PROTECTED]
To: [EMAIL
Jim Hamer wrote:
Hello Listers,
I am using mysql and I am trying to get a SQL statement to work. I have
designed a query in Microsoft Access and I am changing the syntax so that
it will run from Perl against a mysql database. Here is the code:
# from Access
#SELECT DISTINCTROW
"Eric Fitzgerald" [EMAIL PROTECTED] wrote:
I can understand the concern of longer delays in moderation. My problem
with anti spam filters is simply because they are too much like anti-virus
filters. TOO many false positives.
Since you were volunteering...why not volunteer to moderate the
I actually wouldn't have a problem moderating the false positives and
approving them. Coarse, this is all just theoretical untill we get some
kind of official word from the MySQL team (You guys listening there?) :)
- Original Message -
From: "Steve Werby" [EMAIL PROTECTED]
To: "Eric
I've searched many places and can't get a good answer .. i hope I can get
help here.
I'm trying to dump all the data in my database to separate files (per table)
and be able to specify a field separator character.
for example, I'd like to use || as my field separator, I did the following:
Two ideas that come immediately to mind--
1) Is the web server on the same machine as MySQL?
2) Have you looked at replication? You could have n slaves/webservers that
display data, and all wrtes go back to the master. There's a rather
detailed analysis in the docs that explain how to figure
Saludos.
Creo que soy el nico hispano y necesito de ustedes.
Construyo la siguiente consulta.
Select * from coniarticulos
left join conpproveedores use index (prov_codigo) on
prov_codigo=arti_proveedor
left join conimarcas use index (marc_codigo) on marc_codigo=arti_marca and
Eric,
Download the source tarball for mysql from the website and reinstall
using that - the necessary
include files do not come with the redhat rpm.
regads,
P
On Wed, 4 Apr 2001, Eric Fegraus wrote:
Hello,
I have redhat 7.0 with Mysql Ver 8.8 Distrib 3.23.22-beta. This was the
Mysql
In the last episode (Apr 04), John Smith said:
I've searched manyh places and can't get a good answer .. i hope I can get
help here.
I'm trying to dump all the data in my database to separate files (per table)
and be able to specify a field separator character.
for example, I'd like to
hi.
don't know how much light this will shed on your situation, but mysql.h is
in the include directory under the directory where you installed mysql.
(i.e /opt/mysql/include or /usr/local/mysql/include)
hth. hand.
-ravi
-Original Message-
From: Eric Fegraus [mailto:[EMAIL
Msql-Mysql-modules-1.2215.tar. For the life of me I can't find the
mysql.h file that it keeps asking for? Any ideas where this is...is it
a bug with this version.
Type find -name mysql.h
I found mine (MySQL 3.23.36) in /usr/local/mysql/include
Sometimes it helps to use a very basic method to
Sorry if this is mundane for some, but I have searched the manual and I
cannot find the answer to itTwo issues here
.
1)
Doesn't mysql support begin and rollback transactions? If so what is the
correct procedure to make it happen. I logged in and ran my query..
select * from host_info;
Hello,
I am trying to install mysql version 3.23.26 on my sun machine running
solaris 7. I have installed gnu make, tar, and gcc-version 2.95.2. I
have also tried doing everything that is reccomended for my error
such as editing config.cache and even using the reccomended configure
line. The
I was just wondering, I've been using MySQL and while still a beginner,
quite like it.
As MySQL is an db engine, how readily would my skills be translatable to
PostgeSQL.
I have a friend asking me to work on a project with him and he wants to use
PostgeSQL and PHP.
From what I've seen the the
Hi all,
We are modifying one of our db tables to include two fields, 'votes' and
'tally' for allowing to display a "rating" system. The 'votes' column will be a
running total of all votes, the 'tally' will be a column to hold the 'votes'
values. Example, if a person submits a vote of 3(with a
On Wed, Apr 04, 2001 at 02:52:39PM -0700, Kristopher Briscoe wrote:
Doesn't mysql support begin and rollback transactions? If so what
is the correct procedure to make it happen. I logged in and ran my
query..
Depends on the table type. Check the manual for details on the
different table
If I understand the manual correctly when I do a "select blah from blah where blah
= blah order by blah limit 10" Mysql finds the first 10 matching records and then
sorts those records. How do I have it first sort the database and then take the first
10 records?
Thanks for your help,
The MySQL manual is one of the best I've seen
1)
http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html
#Commit-rollback
2)
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#JOI
N
Regards,
Gary "SuperID" Huntress
Look very carefully at the mysql database by typing in
mysql -u root -p mysql
Look at the manunal for how you can INSERT INTO the user table or how you can
use GRANT
On Thu, 05 Apr 2001, J.Heegsma wrote:
%_Dear Sir/Madam,
I am a student and my teacher want's to try to break in into my
At 14:52 4/4/2001 -0700, Kristopher Briscoe wrote:
Hi,
See the sample below:
C:\mysql\binmysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.36
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql create table
1 - 100 of 118 matches
Mail list logo