Howdy Folks,
Got a bit of a hassle. After some broken tries (got impatient) to
change the type of large table's column I found that, when I finally
got the patience, my disk went full and cancelled the operation again.
Since MySQL copies the table before such operation, my ibdata1 file
(using Inno
Howdy,
I'm running a website (dah) and chose to store images in the database.
What I didn't take into consideration however, was that some images
would be larger than the amount of data a BLOB can store. Just didn't
notice it while testing. (Stupid me). Currently, the site is stuck
with some half
I'm stuck here with my hands in my hair, and would very much appriciate any
clue to a solution,
Wouter van Vliet
(ps. I tried to post this message some days before too, but failed back
then. If it comes in twice, I apologize)
Hello everybody,
I'm back! (been a subscriber here before, a while ago .. was quite an active
one at that time .. ;)) .. and I'm back for a reason, having a very wicked
problem. The setup is one RedHat linux 9 machine (called "s007"), previously
in use as both our web and database server. As traf
On maandag 8 december 2003 14:08 Jay Blanchard told the butterflies:
> [snip]
> > Well Todd, it is a little more complex than this. How much do you
> > know about XML?
>
> In fact, exporting is quite simple. Just give
>
> > mysqldump --xml --password=[password] \
> [-u usernam
On woensdag 3 december 2003 22:56 Andrew Braithwaite told the
butterflies:
> You could try to use the "select into {OUTFILE | DUMPFILE}
> from tablename where blah=blah..."
>
> I think you may be able to do "select into local outfile from
> blah"
>
> Which will put the file on the same serv
George Georgeus wrote:
> Hi!
> I do not know how to use INSERT and UNION together.
> For example:
> INSERT INTO tmp_table_name (a)
> (SELECT a FROM table_name WHERE a=10 AND B=1 ORDER BY a LIMIT
> 10) UNION (SELECT a FROM table_name WHERE a=11 AND B=2 ORDER
> BY a LIMIT 10) ORDER BY a; It does not
On dinsdag 2 december 2003 14:44 news told the butterflies:
> In article <[EMAIL PROTECTED]>,
> "Director General: NEFACOMP" <[EMAIL PROTECTED]> writes:
>
> > [1 ] Hi group,
>
> > I want to do a LEFT JOIN that takes no condition.
>
> > For example I have the following tables:
>
> > table_1
On dinsdag 2 december 2003 14:06 Director General: NEFACOMP told the
butterflies:
> Hi group,
>
> I want to do a LEFT JOIN that takes no condition.
>
> For example I have the following tables:
>
> table_1table_2
> ---
On maandag 1 december 2003 15:40 Jay Blanchard told the butterflies:
> [snip]
> Is there a way to export/import MySQL tables in XML format? [/snip]
>
> Well Todd, it is a little more complex than this. How much do
> you know about XML?
In fact, exporting is quite simple. Just give
> mysq
On dinsdag 2 december 2003 4:07 Skippy told the butterflies:
> I must admit I'm pretty stumped here. I'm using MySQL 4.0.12.
>
> I have several tables with info, and one which servers as a
> link between them (has id's that refer the id's in all the others).
>
> The info tables hold people(table
On dinsdag 2 december 2003 9:41 Nitin told the butterflies:
> is this declared in php or javascript??
> depends on the syntax.
>
> - Original Message -
> From: "Caroline Jen" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, December 02, 2003 9:38 AM
> Subject: Select Reco
Francis Mak wrote:
> - I am 100% sure that all scripts are using include
> ("db.php"); so all pages are using the same login and
> password and hostname
>
> - since I am using password, so it shows "Using Password YES" as well.
>
> - The error indeed occured on the same page. e.g. when you
> are
Duncan Hill wrote:
> On Monday 01 December 2003 11:46, Francis Mak wrote:
>
>> it works successfully, however, sometimes it just give me "Error
>> 1045: Access Denied for user '[EMAIL PROTECTED]'"
>> it happens RANDOMLY.
>>
>> Could anybody please let me know how to fix this???
>
> R
Francis Mak wrote:
> Hi,
>
> sorry if this has been answered previously, however I
> tried to google, I found a few people having this issue, but no
> solutions provided.
>
> I am using PHP4.3.4 + MYSQL 4.1.0-alpha-standard(binary,
> not rpm and not compiled by myself) + REDHAT 9
>
>
Fella's,
First of all I'd like to welcome myself to this list. Have been here before,
but now that I need your help again I decided to return. For the following
question I've of course read the Manual, googled some .. Even checked the
archives. Found no answer that satisfied me.
For a website I'm
Heey Folks,
I've been wondering about something for quite a while now.. I know that it's
possible in some DBMS's to select a value in some variable, and then in some
other query use it again. Is this also possiblein MySQL and if so, how?
Thanks,
Wouter
-
Hmm .. isn't there any workaround for this .. Maybe something like:
select count(*) into :somerVar FROM table;
update sekce set pocet = :someVar WHERE ... blabla;
I've seen things like this in other databas servers but haven't been able to
find out if it's supported by MySQL, and
Yeah .. I want it too :) .. please tell us !
--
Alle door mij verzonden email is careware. Dit houdt in dat het alleen
herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde
en daar buiten. Als je het hier niet mee eens bent dien je mijn mailtje
binnen 24 uur terug t
Hmm, this all sounds indeed like a terrific feature .. if it would work !
So, I decided to try it and just see what'll happen. I did the following
things:
* first I created a table:
mysql> create table autoIncrement (
-> id int(11) NOT NULL AUTO_INCREMENT,
-> thingie varchar(20) NOT NU
This opens so many possibilities ... manage MySQL tables in MS Access using
MyODBC. Guess this works for remote MySQL servers too?. Almost don't dare to
ask, but is this also possible from PostgreSQL? I'm in two situations with
alike problems, one using MySQL and the other one PostgreSQL .. I'll s
Heey There Folks,
Maybe you can help me with the following questions:
* I was wondering, is there some application for Windows that gives a
frontend to MySQL similar to MS Access? Or maybe connect from access to
MySQL ? (guess not, right?)
* The mysql index and data files, can they be exchanged
So, you've got a text file with addresses to be deleted? Hmm, that's not too
hard to manage. I suppose that on each line, there is one email address and
only that address? With PHP, i'd do something like:
";
mysql_connect("host", "user", "pass");
mysql_select_db("database");
$textfile = file('dir
I'm not very sure of myself ... but maybe you'd try to use quotes around the
file path?
--
Alle door mij verzonden email is careware. Dit houdt in dat het alleen
herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde
en daar buiten. Als je het hier niet mee eens bent
Heey There Folks,
Well, I hope that this message gets through finallly. First I got it back
from the deamon because I had send it in html format, then because of I was
suspected from spamming this list. Only for not having used the words query
or sql once ... well, I have now so it should come th
e than 24 hours
stating the reason of disagreement.
-Oorspronkelijk bericht-
Van: Dicky Wahyu Purnomo [mailto:[EMAIL PROTECTED]]
Verzonden: maandag 1 juli 2002 09:13
Aan: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Onderwerp: Re: SQL - Fulltext search
Pada Mon, 1 Jul 2002 09:01:13 +0200
&qu
I would use
WHERE skill LIKE "%powerpoint%" OR skill LIKE "%PHP%"
but that is because I don't know the better way, which must be there, I feel
it .. anybody?
--
Alle door mij verzonden email is careware. Dit houdt in dat het alleen
herlezen en bewaard mag worden als je goed omgaat met
You can achieve a similar thing with the WHERE column IN (SELECT column FROM
table WHERE ..) subselect. In the current version of MySQL, this is not yet
supported, but I've heard fearies tell that it will be in version 4.1, or
else some other version to be released in the somewhere near future.
whow, this list is so very powerfull .. just give me your address and I'll
send you the beer .. what kind of it would you like?
-Oorspronkelijk bericht-
Van: Luc Foisy [mailto:[EMAIL PROTECTED]]
Verzonden: June 14, 2002 16:04
Aan: Wouter van Vliet; MYSQL-List (E-mail)
Onderwer
Heey Folks,
I'm having a slight problem with the timestamp column format. When I alter a
table and, add a column of type timestamp all records get the current
timestamp, that's ok. When i insert a new row, all records get the current
timestamp. That too is ok. But now, when I update one row of th
Looks like a MERGE table problem to me .. you can't insert data into this
table type because there's actually no data in it ;). You need to insert
data into one of the merged tables.
in version 4.x though, you can set something for the insert thing, so that
it will insert automatically in one of
Now for the folks who don't speak germen, I'll translate his msg:
Hallo,
Is there any possibitity to synchronise my Access datbase with a MySQL
database? If possible automatic or by user action.
While actualising between 2 access copies, there is a Conflict Manager who
helps with the actualisatio
What I think, is that your syntax for creating the primary key is slightly
incorrect. I'm not sure if this is also true vor MySQL but I got teached at
school that a foreign key can only point to the primary key of a table.
Perhaps you can try to do the following:
Create Table: CREATE TABLE `conn`
33 matches
Mail list logo