| |
thread by: zhengfish |
last post Nov 1 '05 by: zhengfish
Hi,All,
I try to install mysql-5.0.15 on RHEL3-U5.
But It give me a error.
MySQL-client-standard-5.0.15-0.rhel3.i386.rpm
MySQL-devel-standard-5.0.15-0.rhel3.i386.rpm
MySQL-server-standard-5.0.15-0.rhel3.i386.rpm
MySQL-shared-standard-5.0.15-0.rhel3.i386.rpm
MySQL-standard-debuginfo-5.0.15-0.rhel3.i386.rpm
|
thread by: Good Man |
last post Nov 1 '05 by: Good Man
Hi there
After posting a little bit earlier about many to many tables, I was
wondering how I can get the total number of logins for each store, if I'm
storing information like so:
Stores:
+---------+-------------+
| StoreID | StoreName |
|
thread by: Matt |
last post Nov 1 '05 by: Gordon Burditt
Hi everyone, still pretty new to MySQL. I was
wondering if there is a way to automatically filter
records based on a mysql userlogin name??
I have serveral databases that I want to combine
in order to manage the databases more efficiently.
- I'm currently using MySQL 4.1.12 and I'm currently testing 5.0.14
- I have a databases for each...
|
thread by: William Gill |
last post Oct 31 '05 by: William Gill
When I designed my db in several tables I used unsigned integer fields
to hold an integer that each bit was a 'flag'. Now I realize that the
set field type does just what I was trying to accomplish. Is it safe to
convert the field(s) from uint to set and keep their current values?
Obviously all external programming (queries) will have to...
|
thread by: binary-nomad |
last post Oct 31 '05 by: binary-nomad
Hello,
If I have a table, of say.... people, with their names, ages, addresses
etc., and some lines in the table have the ages BLANK, how do I make
sure that the blank fields are not taking up disk space? Does OPTIMIZE
TABLE do this, or is another command?
Thanks.
|
thread by: Jeff North |
last post Oct 29 '05 by: Jeff North
I'm stumped and my brains are fried!!!!
I have the following data
+-------+------------------------------+------------+
| resID | FLEName | VersionNbr |
+-------+------------------------------+------------+
| 1 | 35_laserdatandria2104.zip | 1.0 |
| 2 | 35_laserdatandria2104.zip | 1.23 |
| 3...
|
thread by: typingcat |
last post Oct 29 '05 by: Aggro
Hello.
I'd like to know the SQL query for the following operation.
Table
AUTHOR BOOK
Bill A
Bill B
Charles A
Bill C
....
|
| |
thread by: ss.wisch |
last post Oct 29 '05 by: ss.wisch
Ok here's the thing... I have a vBulletin forum database... there is a
table in there called "post" which has all of my forums posts in it.
What I have are many posts with regular titles like "Oh hello how are
you" or whatever, and many posts (which are replies) with "Re:" before
them and whatever message following that.
I have recently...
|
thread by: kimshapiro100 |
last post Oct 28 '05 by: Gordon Burditt
Question on PhP, MySQL
I am thinking of a consumer internet business for which I will have to
have a database driven site built.
I am thinking of using
PhP, MySQL as the main technologies amd Linux hosting( and some
Dreamweaver).
My question is:
|
thread by: Phil Latio |
last post Oct 28 '05 by: Phil Latio
I am following a book on PHP and MySQL and have come across the below SQL
statement.
CREATE TABLE users (
user_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
username VARCHAR(20) NOT NULL,
first_name VARCHAR(15) NOT NULL,
last_name VARCHAR(30) NOT NULL,
email VARCHAR(40) NULL,
password VARCHAR(16) NOT NULL,
|
thread by: Kiwifx |
last post Oct 28 '05 by: Kiwifx
Hi
I'm running mysql 4.1 on Intel 4 Linux gcc 2.4.
Have found serious problem with memory leak - can't call calloc repeatedly without a seg fault.
problem comes after a connect call has been made.
help sought.
|
thread by: rossz |
last post Oct 28 '05 by: Bill Karwin
I have this query to get the 10 most common products from in stock,
based upon which parent category they are in:
SELECT p.*,i.sql_inventory AS quantity
FROM products AS p
JOIN inv_cnt AS i ON p.sql_id=i.sql_product_id
JOIN catxprod AS x ON p.sql_id=x.sql_product_id -- product/category
index
JOIN cats AS c ON x.sql_cat_id=c.sql_id --...
|
thread by: yasaswi |
last post Oct 27 '05 by: Markus Popp
Now that MySQL 5.0.15 is production ready, are there any functions to
use with mysqlimport, so I can load a string such as, MM/dd/yy, in a
text file into a MySQL database as a yyyy-MM-dd date value.
Thanks,
Yasaswi
|
thread by: Nick name |
last post Oct 27 '05 by: Nick name
Hello,
I am creating a Database Architecture and there is a volume problem
with MySQL.
My tables are quite simple. Problem is they will record million of
lines.
Within 10 seconds, MySQL could receive 1.000 querries to insert raws in
the same table.
|
thread by: Banx |
last post Oct 27 '05 by: Banx
Hi everyone,
i'm trying to copy data from a table in Pervasive database to a table in MySQL
Does anyone know how to do it? :confused:
Is it posible to copy data from another database prog to MySQL? :confused:
Thanks for the help....
|
| |
thread by: Christopher Harrison |
last post Oct 26 '05 by: Rich Ryan
Is there a way to store an indefinite number of keys in one field and
self join them? Imagine, for example, you have a table of users with a
"friends" column. Say user 1 is friends with users 9, 7, 24 and 6; then
would it be possible to store this
array/list/whatever-you-want-to-call-it into user 1's friends cell and
extract the join in a...
|
thread by: Lynda Kilgore |
last post Oct 26 '05 by: Lynda Kilgore
jGu
----qtHwhORV90yyhqJMOc
Content-Type: text/html;
Content-Transfer-Encoding: quoted-printable
<html><head><style type=3Dtext/css>.eyebrow { FONT-WEIGHT: bold; FONT-SIZE=
: 10px; TEXT-TRANSFORM: uppercase; COLOR: #ffffff; FONT-FAMILY: verdana,ar=
ial,helvetica,sans-serif; TEXT-DECORATION: none } A.eyebrow:link { TEXT-DE=
CORATION: none...
|
thread by: hamvil79 |
last post Oct 26 '05 by: Thomas Bartkus
I'm implementig a java web application using MySQL as database.
The main function of the application is basically to redistribuite
documents. Those documents (PDF, DOC with an average size around 2Mb)
are stored in BLOB column.
The amount of documents for the first year should not exceed 5/6 Giga,
but I cannot make prevision for the next...
|
thread by: wzhao6898 |
last post Oct 26 '05 by: Markus Popp
Hi there,
I'm trying to figure out if it's going painless to upgrade our oooold
mysql 3.23 to the latest MySQL 4 or 5.
Any suggestions?
Thanks in advance!
David
|
thread by: Cormier |
last post Oct 25 '05 by: Cormier
Hi,
We sent you an email a while ago, because you qualified for a
much lower rate based on our records from a national database.
Why is this? Because currently it is a buyers market with the
lowest rates in years.
You can now get $325,000 for as little as $709 a month!
We realize many homeowners struggle and that makes it difficult
to...
|
thread by: voipcanada |
last post Oct 25 '05 by: voipcanada
NEED CONVERSION FOR "14:10:01.000 GMT Sat Oct 22 2005" AS
"2005-10-22 14:10:01"
thanks
|
thread by: Sean |
last post Oct 24 '05 by: Sean
I have a MySQL 4.1.11 database, table and table columns all configured as
utf8 as I need to accept data in a number of languages. The MySQL database
is hosted so I use SET NAMES utf8 in the connection string in ASP e.g.
sCon = "dsn=mydsn;uid=user;pwd=pass;stmt=set names utf8;option=3;".
The ASP pages are all charset utf8.
Now the ASP...
|
thread by: Evil Bert |
last post Oct 24 '05 by: Neeper
Is there anyway to compare a field with multiple string values using
LIKE?
Here's the statement I have now:
SELECT * FROM list
WHERE email LIKE CONVERT( _utf8 'hotmail@hotmail.com' USING latin1 )
OR email LIKE CONVERT( _utf8 'john@hotmail.com' USING latin1 )";
I know how to do it using the IN operator,
SELECT * FROM list
|
| |
thread by: DG |
last post Oct 24 '05 by: Markus Popp
Hi,
I'm trying to ensure all entries in the database are upper case to keep the
data looking consistent. I've written the following proc but the UPPER()
function doesn't do anything.
For example:
CREATE PROCEDURE hospitals_AddHospital (IN HospitalName char(150))
BEGIN
|
thread by: Brent |
last post Oct 23 '05 by: Brent
In the usual case, this SQL
select count(*) from mytable where ...
returns an accurate count of the rows you want.
But how do I go about counting rows from this SQL (the sum...if
statements function as a pseudo pivot query)?
|