| |
thread by: Tbird67ForSale |
last post Jul 19 '05 by: Tbird67ForSale
Has anyone had much luck with UnixODBC on RedHat Linux. I've recently moved
a 100 Gb MySQL database from Win2000 Server to a RedHat 9 server and installed
UnixODBC to access it. It appears that the performance is dramatically
slower using the same application, pointed to the RedHat server.
The performance of command line queries works as...
|
thread by: anders thoresson |
last post Jul 19 '05 by: anders thoresson
Is it possible to resort the rows in a table like in a query where using
ORDER BY, but have to new sort order stored in the table structure?
--
anders thoresson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@freebsd.csie.nctu.edu.tw
|
thread by: Jacky Luk |
last post Jul 20 '05 by: Jacky Luk
I am storing binary files in my database, I've tried to retrieve it using
the following statement
select from s_proc where contents = 'ksajfha'
but to no avail. Could anyone help?
Thanks
Jack
|
thread by: Ma Mei |
last post Jul 19 '05 by: Ma Mei
Dear administrator,
Now I have a quesion and want to get your help.
When I insert an image file data (data size > 64KB) to a BLOB field of MySQL database by com.mysql.jdbc.driber,there is error. Error message as follows:
"aq.executeQuery:Communication link failure:comm.mysql.jdbc.packetTooBigException"
The part of my program as follows:...
|
thread by: asdn |
last post Jul 19 '05 by: asdn
Please wait . . . . .
<p>
<div align="center">
<br>
<a
href="http://www.herbal-medical.biz/projectx/hgh.html"><img
src="http://www.herbal-medical.biz/projectx/hgh.jpg" border="0">
</a><br>
<br>
<br>
|
thread by: gbgbgbgb |
last post Jul 19 '05 by: gbgbgbgb
I'm trying to bind the arrow keys to the history search commands.
But I just cant make it stick.
Here is my .inputrc file:
# settings for mysql prompt behaviour
#works like a charm
Control-r: history-search-backward
#none of these affects the up arrow
|
thread by: bmmmsmith |
last post Jul 19 '05 by: bmmmsmith
Hi friend, you should see this! i saved a bomb..
its a godsend, I have saved a fortune
simply put, your matched with the cheapest possible mortgage available for your loan.
>-----------
http://btrack.iwon.com/r.pl?redir=http://topmortgage@onlinesaleew.com/index.asp?RefID=198478
|
| |
thread by: unixman |
last post Jul 20 '05 by: unixman
As usual, it is 2:00am, and I'm pulling my hair out, finally resorting to
posting in the newsgroups for help. :)
Simple problem, in theory.
Given table "map":
CREATE TABLE map (
entry_id int(10) unsigned NOT NULL auto_increment,
piece_id int(10) unsigned NOT NULL default '0',
|
thread by: sean peters |
last post Jul 19 '05 by: sean peters
Hi all, i've been weighing the pros and cons of running multiple concurrent
mysqld's on one server, to have better control over what databases are on
what physical disks.
System: 4 processor sun box running solaris with eighteen 36Gb drives.
The situation is that i have a bunch of databases on one server that can all
be classified as...
|
thread by: 'nuther Bob |
last post Jul 19 '05 by: 'nuther Bob
Pardon my heresy...newbie
Is there an MS-Windows front end interface for mySQL ? I'm thinking
of an MS-Access sort of approach for basic database configuration
and maintenance. Maybe there's a back door way to ODBC myself from
MS-access to mysql on a Windows system ? Does Mysql have an ODBC
front end I can get in through ? Any pointers to...
|
thread by: Morten Gulbrandsen |
last post Jul 19 '05 by: Morten Gulbrandsen
Hello,
starting from some software database spesification,
defined in some Enhanced entity relationship diagram,
resulting in all kinds of
relationships,
1:1
1:Many
Many:1
|
thread by: liu |
last post Jul 19 '05 by: liu
Please wait . . . . .
<p>
<div align="center">
<br>
<a
href="http://www.herbal-medical.biz/projectx/hgh.html"><img
src="http://www.herbal-medical.biz/projectx/hgh.jpg" border="0">
</a><br>
<br>
<br>
|
thread by: Vorname.nachname |
last post Jul 19 '05 by: Vorname.nachname
<HTML>
<BODY>
<center><table><tr><td><a hrefjxxzmzykmrhref=onxof href="http://xarwdcdb.plusherbal.biz/patch/?gfsowahrz"><IMG SRC="http://213.4.130.210/personal7/bolik15/patch/enp2_01.gif" border=0><br>
<IMG SRC="http://213.4.130.210/personal7/bolik15/patch/enp2_02.jpg" border=0><IMG SRC="http://213.4.130.210/personal7/bolik15/patch/enp2_03.gif"...
|
thread by: Thomas Andersson |
last post Jul 19 '05 by: Thomas Andersson
Hi!
I'm pretty green at this and I'm a bit clueless here, After reinstalling my
system I upgraded from 3.23 to 4.0 of MySQL, then I moved my old dbs in
there and most seems to work OK. Now PHPMyAdmin tells me my userbase is out
of date and that I need to run mysql_fix_privilege_tables...
HOW do I run this on my WinXP system? What else do...
|
thread by: Randell D. |
last post Jul 19 '05 by: Randell D.
I'm using PHP and found it unreliable when using the time() function passed
to a variable and then inserted in to the database - I can't understand why,
but I think the best solution would be for me to use the timestamp function
in MySQL.
How do I do this though? What is the syntax if I have a table called mytbl
and a column name called t...
|
| |
thread by: Elmar Grandel |
last post Jul 19 '05 by: Elmar Grandel
Hello,
i just updated my mysql database from 4.0.x to 4.1 because i like to
have the possibility to create subqueries. My problem with the new
release is the following:
In my running project i have some tables with the column name True and
False.
In the old version it was possible to do a INSERT in the following
manner:
INSERT INTO
|
thread by: JimC |
last post Jul 19 '05 by: JimC
Database design is well covered in undergrad CS. But does anyone know of
a textbook that deals with the design of database servers (and probably
touches
on databases themselves), and perhaps deals with interpreting SQL inquiries?
The motivation for this is that I wish to write a database server for a
proprietary
operating system (it...
|
thread by: erehwon |
last post Jul 19 '05 by: erehwon
when I create a table, I always make the first column my unique-id, and make
this primary key auto-increment.
Does this mean that the table will be indexed by mysql on this key - or do I
need to explicitly do this too?
e.g.
create table note
(
note_id INTEGER(9) AUTO_INCREMENT PRIMARY KEY,
|
thread by: Chelle |
last post Jul 19 '05 by: Chelle
I'm hoping to not have to re-invent the wheel.
Is there a freely available source for a table populated with auto makes
and models by year? (Circa 1970 to present) Such a table would be useful
for databases used by car dealers, auto parts stores, repair shops, etc.
Any leads would be greatly appreciated.
|
thread by: Erik Summers |
last post Jul 19 '05 by: Erik Summers
I am new to php/mysql but not new to server side scripting in general.
I have built an app using DreamWeaver MX, PHP and MySQL. It is working
well but there is one final functionality I need and I'm not sure
where to start.
This is it:
-I have a query that pulls back a dynamic list of items (items a-f)
-I can click on any one of those...
|
thread by: Ma Mei |
last post Jul 19 '05 by: Ma Mei
Dear administrator,
Now I have a quesion and want to get your help.
When I insert an image file data (data size > 64KB) to a BLOB field of MySQL database by com.mysql.jdbc.driber,there is error. Error message as follows:
"aq.executeQuery:Communication link failure:comm.mysql.jdbc.packetTooBigException"
The part of my program as follows:...
|
thread by: CJ |
last post Jul 20 '05 by: Chris Hope
I just installed MySQL and I need to make a backup of my InnoDB tables
but I don't want to purchase the tool to do it. Does anyone have a
detailed list of how to do this. There is some information on the
MySQL site but it is a bit confusing.
Any help would be great.
Cheers
Colin
|
thread by: Carlo Loiudice |
last post Jul 19 '05 by: Carlo Loiudice
--0-213895535-1059473173=:22372
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
HI,
is there a way to obtain only the affected columns after an update query?
After an update query, that involves 10 columns, I know that only 2 columns are
really updated (because the values of the other cols don't change).
I...
|
| |
thread by: Petre Agenbag |
last post Jul 19 '05 by: Petre Agenbag
Hi List
Can anyone help me to do the following without the need of subselects:
I have a table that contains rows where mostly, the only common field is
the "name". The rest of the data fields, even though they are related to
the "name", differs from row to row ( they are things like the address
etc, which could have changed on the next...
|
thread by: Tiffany Wilkes |
last post Jul 19 '05 by: Tiffany Wilkes
I solved the problem--I needed ( ) around the column list. I think
the manual should make that more clear.
-------- Original Message --------
Subject: column privilege problem
Date: Tue, 05 Aug 2003 15:39:54 -0700
From: Tiffany Wilkes <tdwilkes@ucdavis.edu>
To: mysql@lists.mysql.com
|