Hello mysql,
after FLUSH QUERY CACHE
in error.log
021127 17:25:17 mysqld started
021127 17:25:19 InnoDB: Started
/usr/local/mysql/bin/mysqld: ready for connections
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it w
>Is there a good tutorial somewhere on the join command. No matter what
I do
>it just doesn't work. Obviously I'm doing something wrong, but the
MySQL
>manual just doesn't help at all.
Try this link.
http://www.devshed.com/Server_Side/MySQL/Join/page1.html
One of the best books for understanding
Hello,
I recently upgraded to Visual Studio .NET to realize that I can no longer
compile my Visual C++ 6.0 projects that use the MySQL++ classes with Visual
C++ .NET. I get an error relating to the iterator and how it is templated (I
don't have the exact error with me now). Has anyone else run i
I had a problem that required a proper sort of the following:
IT66
ITD38
IT68
ITD39
ITD40
IT69
ITD55
ITD56
IT72
ITD57
ITD58
ITD59
ITD60
IT73
ITD73
ITD67
IT74
ITD69
ITD70
IT78
IT79
IT83
ITD71
IT81
ITD75
ITD76
IT84
ITD96
ITD97
ITD98
ITD99
ITD100
ITD101
ITD102
IT
On 12/4/02 9:04 AM, "Mike At Spy" <[EMAIL PROTECTED]> wrote:
>
> How can I tell what port number mysql is running on? I need it for a chat
> program. :)
>
> Thanks,
>
> -Mike
>
Default is 3306
/h
-
Before posting, plea
Show Variables Like 'port';
PB
-
> How can I tell what port number mysql is running on? I need it for a chat
> program. :)
>
> Thanks,
>
> -Mike
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manua
On Wed, Dec 04, 2002 at 12:04:52PM -0500, Mike At Spy wrote:
>
> How can I tell what port number mysql is running on? I need it for a chat
> program. :)
3306
A google search would have found the answer in no time.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAI
mysql> show variables;
3306 is the default.
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 9:05 AM
To: [EMAIL PROTECTED]
Subject: mysql port number
How can I tell what port number mysql is running on? I need it for a chat
program
On Wed, Dec 04, 2002 at 12:21:06PM -0500, Jason Hall wrote:
> I have a problem here.
>
> I cannot connect to a particular server remotely at certain times.
> I get the error remote connection is blocked because of many
> connection errors. I can login locally on the box.
Ok.
> To resolve this p
I have used Access to MySQL pro and it worked for a few of my databases.
http://www.convert-in.com/acc2sqlp.htm
Chris
-Original Message-
From: Sandeep Murphy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 8:39 AM
To: MySQL List
Subject: access->mysql
Hi,
Can anyone pleas
Is there any program out there for windows or linux that will take a
mySQL database (either natively [preferred] or via ODBC or something)
and show it graphically as boxes with the schema in them. It would be
great if it handled foreign keys (with lines drawn between boxes or
something). MS Access
Michael,
I was able to repeat the bug on Linux now.
It seems to happen if I set max_binlog_size to 2M in the SLAVE. The relay
binlog gets split into several 2 MB pieces. It does not happen always, but I
have a randomized test which produces the error in 1 minute.
I was not able to repeat the bug
The problem shows up when receiving the response of the query which
tells me that the query was OK but rows affected.
Cesar L. Aracena
[EMAIL PROTECTED]
[EMAIL PROTECTED]
(0299) 156-356688
Neuquén (8300) Capital
Argentina
-Mensaje original-
De: Egor Egorov [mailto:[EMAIL PROTECTED]]
En
I can concur - you pay a little, but you get a much better product with this one.
Ian Zabel wrote:
> The only one I found that creates a good schema that only needs minimal
> massages, and imports all the data correctly is Access-To-MySQL. It's
> not free though, but they have a trial. Once I wen
On Sat, 2002-11-30 at 13:42, Pae Choi wrote:
> I do not know about MySQL marketing strategies. But as far as
> GPL goes, it even encourge to sell.
>
>
> "Does the GPL allow me to sell copies of the program for money?
> Yes, the GPL allows everyone to do this. The [1]right to sell copies is part
>
> I had a problem that required a proper sort of the following:
>
> IT66
> ITD38
.
.
.
.
> ITD100
> ITD101
> ITD102
> ITD103
> ITD104
> ITD105
>
>
> Because of the different lengths, this was a nightmare for "order by" and so
> it led me to my first experiments with case
> and I go the followin
On Sat, 2002-11-30 at 10:51, Mark wrote:
> - Original Message -
> From: "Mark Matthews" <[EMAIL PROTECTED]>
> To: "Pae Choi" <[EMAIL PROTECTED]>
> Cc: "Tonu Samuel" <[EMAIL PROTECTED]>; "Darney Lampert"
> <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Saturday, November 30, 2002 5:30 AM
>
The default port for MySQL is TCP 3306. If the connection can't be
established and you are sure that mysqld is running maybe check netstat -a
whether MySql runs on an alternative port or only uses only UNIX sockets.
HTH,
Mike Bunzel
- Original Message -
From: "Mike At Spy" <[EMAIL PROTECT
On Sat, 2002-11-30 at 12:43, Pae Choi wrote:
> Didn't you the previous posting that contains two paragraphs
> from GPL?
He probably did but since you misread the GPL. I have talked to Richard
Stallman and Eben Moglen who wrote the GPL about these issues. And you
misread the GPL.
/David
> And if
On Mon, 2002-12-02 at 14:45, Darney Lampert wrote:
> Sorry continue this subject ... I´m the author original question, "LEGAL
> information about MySQL".
> But I Think that my question is simple and the other answers do not make
> sense to me.
> I never said that I change original MySQL source co
Hello,
I am running MySQL 4.0.5 64 bit on a Sun Solaris and I am using MyISAM
Indices.
I would like to set replication (one master and one slave).
My question is:
When I OPTIMIZE TABLE table1, ... on the master will the slave be updated
or if I want to optimize the same tables on the slave I n
Look!
I already unsubscribed this. Do you understand what that mean?
I have no interest to dealing with MySQL and have no time for
this.
You must understand that this thread was started from someone
who were interested to sell his/her product that utilize MySQL. And
I was trying to help both side
On Thu, 2002-12-05 at 14:42, Beauford.2003 wrote:
> Adolfo,
>
> Thanks for the info, but can you elaborate on it, 'cause basically I am just
> not getting the concept. No way no how can I get these joins to work.
>
> mysql> describe songs; (this contains an ID field and the title of the song
> a
I'm looking for something that will take mySQL databases and show me
graphically how the tables all relate to each other. At the very least,
show me boxes with the schema in each one and allow me to draw lines as
I see fit (or use the foreign keys of InnoDB tables). This could then be
printed to pa
Hallo.
I have this query:
SELECT table1.id
FROM table1
LEFT JOIN table2 USING(id)
WHERE table1.a=1 and table2.b=1
table1 is MyISAM and table2 is InnoDB.
I want a shared mode lock on the table2. Is it possible, or i should
split this query?
--
Have a nice day.
-
On Wed, Dec 04, 2002 at 05:18:26PM -0500, Adam Nelson wrote:
>
> Don't let this list fool you. SQL Server is a very good product.
> It is far superior to Mysql in every way except cost and the fact
> that it doesn't run on unix.
This smells a lot like flaim bait on a MySQL list...
Jeremy
--
Jer
John,
> Am I mistaken or does 2002-02-31 translate into February 31, 2002? If it
does ...
Your observation is interesting.
The MySQL manual says the query should set all zeroes if the date value is
illegal. This does happen if you enter 32 days for a month, for example.
Furthermore, I got two d
>From: DELETED TO PROTECT THE GUILTY
[Four original lines and SEVERAL HUNDRED quoted lines deleted]
PLEASE folk, trim up your quotes a bit!
Nothing spells "newbie" so much as mindlessly including everything anyone has ever
written on a topic. And when two of you go at it with each other, it's e
Sorry,
should be the lpad function:
http://www.mysql.com/doc/en/String_functions.html
LPAD(str,len,padstr)
Returns the string str, left-padded with the string padstr until str is
len characters long. If str is longer than len' then it will be
shortened to len characters.
mysql> SELECT LPAD('hi',
What you want is the rpad function:
http://www.mysql.com/doc/en/String_functions.html
RPAD(str,len,padstr)
Returns the string str, right-padded with the string padstr until str is
len characters long. If str is longer than len' then it will be
shortened to len characters.
mysql> SELECT RPAD('hi'
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 4 Dec 2002, R. Hannes Niedner wrote:
> On 12/4/02 9:04 AM, "Mike At Spy" <[EMAIL PROTECTED]> wrote:
> >
> > How can I tell what port number mysql is running on? I need it for a chat
> > program. :)
> >
> Default is 3306
And with -P=123
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 4 Dec 2002, Philip Molter wrote:
> Compiling on Solaris 8 x86
> - mysql 3.23.53
> - gcc version 2.95.2 19991024 (release)
>
> CC=gcc CFLAGS="-O3 -fno-omit-frame-pointer" CXX=gcc CXXFLAGS="-O3
>-fno-omit-frame-pointer -felide-constructors
No. It is not what I want.
This is a normal aggregation.
The sum function will be called once for each
group (SalespersonNm) and it will return one row.
What I have asked is : if I have 10 rows, can I return 12?
It's rude, but that's the idea.
Thanks,
Felix
DL Neil wrote:
> Felix,
>
> > Is is
The idea is simple:
I want to implement some temporal computation
on timeseries like normalization and interpolation
to smooth the data and fill the missing values.
So, for example if have a table like that:
starttime,endtime,counter
12:00,12:30,34
13:00,14:00,25
you see that for 12:00 the measur
i read in several places (like in recent osnews.com newspiece and some
other prior postings to this list) that mysql 4.0.x is supposed to be
"stable" now. but the front page of mysql.com still lists 4.0.5 under
"development".
so does the mysql developers suggest that mysql is still "unstable" o
On Wednesday 04 December 2002 22:35, Stefan Hinz, iConnect \(Berlin\) wrote:
Hello Stefan,
>
> The communication buffer (between client and server) is set to 1 MByte by
> default. You can change this either by starting the server with a different
> option or by setting the appropriate variable in t
Its more to do with the amount of memmory than its speed.
As MySQL will try and load as much data (tables) into memmory as posible the
more the better. The next thing is disc speed.
Simon
-Original Message-
From: Nicolas MONNET (Tech) [mailto:[EMAIL PROTECTED]]
Sent: 04 December 2002 15:46
Hi
Just try this
select distinct(a.id) from test a , test b where a.code = 23 and b.code = 45
and a.id = b.id
Regards,
-Arul
- Original Message -
From: "Robert Gehrig" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Wednesday, December 04, 2002 10:52 PM
Subject: Select Pro
> -Original Message-
> From: David Axmark [mailto:[EMAIL PROTECTED]]
>
> In this case there is not distribution so no fee is needed. We would
> like to be paid in this case also but there is legal requirement for a
> license if you do not distribute.
Missing 'no'?
- rick cronan
-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ledet, Mike wrote:
| I'm running Mysql 3.23.52 on a Redhat 8.0 installation booting to Gnome.
| The machine is a dual AMD 1800, 1 gig of ram, one Ultra ATA IDE drive, and 2
| 18 gig scsi 10,000 RPM drives on a RAID controller running Raid 0.
|
| I've g
Thanks for advice,
--- Adam Nelson <[EMAIL PROTECTED]> wrote:
> I've posted my comments before but the important
> thing is that P4 is
> largely unnecessary as it doesn't have instructions
> that apply to server
> applications (mostly).
thats mainly what I was asking for. I'll go with pIII
than.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 5 Dec 2002, Andrew Sitnikov wrote:
> after FLUSH QUERY CACHE
>
> key_buffer_size=402649088
> read_buffer_size=2093056
> sort_buffer_size=2097144
> max_used_connections=115
> max_connections=200
> threads_connected=6
> It is possible that
Cesar,
Wednesday, December 04, 2002, 2:31:13 AM, you wrote:
CA> I'm using MyCC to make changes to a remote DB, but I found a problem
CA> while trying to update a record... does anyone knows what's wrong with
CA> this?
CA> UPDATE maraadmins SET adminpassword = password("1234") WHERE adminid = 3
T
Hello list. I'm new here. I programmed dBase several lifetimes ago and now
fumble with Access when I have to. I've just purchased a license to a
vBulletin message board, which employs PHP and MySQL, so it's time I FINALLY
get around to learning these two.
I am at my first hurdle. I uploaded all
Neal:
What you are really asking is: "Does MySQL support stored procedures?"
The answer is ... at this point ... no. Implementation of stored procedures
is on the 'to-do' list, but it will be awhile before you see it.
There are some work-arounds ... do a search of the archive for this list, or
p
Hi Michael,
The ten last dates appear as a default result of a Archives page. When I
enter for the first time in the page, it give me the last ten Files that was
uploaded. In the same page, I can ORDER BY the ten last dates results by
COD, DATE, NAME or FILE. So, when I click in some os then, I
On Wed, 4 Dec 2002, Heikki Tuuri wrote:
> what MySQL version you are running? On what OS?
Version 3.23.53-max-nt-log on Windows Professional 2000
> What does SHOW CREATE TABLE tabdocumentoconsultado; print?
I created again all the tables of the database called "bdatena".
Now that the table is
Neal,
> I need to build a cache mechanism for a website and I thought I'd use
MySQL
> for persistance. The problem is that I need it to schedule a cleanup task
> every 24 hours - to remove old cache records. MS SQL Server provides a
> trigger for scheduling such tasks - I am looking for the func
How can I know if the process mysqldump.exe is run in the process list of
the windows through of the Delphi?
Best regards,
Sil
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
- Original Message -
From: "David Axmark" <[EMAIL PROTECTED]>
To: "Darney Lampert" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Thursday, December 05, 2002 3:55 AM
Subject: Re: [OT] LEGAL information about MySQL.
> I am the licensing guru for MySQL AB and one of the
> founde
DBTools works great on this matter. You find it at
http://www.dbtools.com.br/EN and is totally free.
[]s
Crercio
- Original Message -
From: "Sandeep Murphy" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Wednesday, December 04, 2002 12:39 PM
Subject: access->mysql
Hi,
Datanamic is a very useful tool.
http://www.datanamic.com
-Original Message-
From: Daevid Vincent [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 8:58 PM
To: [EMAIL PROTECTED]
Subject: Graphical data visualization for RDBMS/SQL schema?
I'm looking for something that will t
On Wed, 2002-12-04 at 22:32, Richardson, David E (MVC Corporation)
wrote:
> On a single Linux box w/mysql 3.23.52 I have mysqld running and there are
> about 20 databases live in the environment. I want to take one of the
> databases offline but leave mysqld running with the other db's - without
>
thnx to all!
am checking this links out.. looks great! :)
-Original Message-
From: Crercio O. Silva [mailto:[EMAIL PROTECTED]]
Sent: quinta-feira, 5 de Dezembro de 2002 12:30
To: MySQL List
Subject: Re: access->mysql
DBTools works great on this matter. You find it at
http://www.dbtools.
Hello!
I want to copy one table's structure to another (non existing) table, but i
didn't find any command or example to do that. Exactly, the situation is the
following:
A dynamic database structure has tables. We want to copy any of tha tables
(while we don't know that table's structure) to anot
I recently installed the following RPM's:
MySQL-3.23.41-1a.s390.rpm
MySQL-devel-3.23.41-1a.s390.rpm
MySQLclient9-3.23-22-6a.s390.rpm
MySQL-server-3.23.41-1a.s390.rpm
Afterwards, I was able to start the mysqld daemon ok and install an application I
downloaded for a demonstration of the viability
Hi,
I get this error/warning each time server reaches 623 connections and thus
no new clients can connect. What may I do to allow more clients?
I know that the limit on the size of `alarm_queue' is set in
mysys/thr_alarm.c, but is increasing the value in call of init_thr_alarm()
safe?
Regards,
Ma
Hi all and thx in advance for trying to fix my problem.
I'm instaling for the first time MySQL and when I try to test the program, I
receive an error like "Cannot connect to localhost (100060)"...How can I
configure the MySQL.
Thx again
Alex
-
Hi,
can anybody tell me how can i select,update, delete the records from two
table having same structure in the mysql.
For ex
MainTable
---
id(int)|val (varchar)
---
1 a
2 b
3 c
--
select req_number,
right(concat('00',trim(req_number)),6) as sort_req,
case
from req
order by sort_req;
Haven't tried it but it should work.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Norris, Joseph [mailto:[EMAIL PROTECTED]
Cesar,
Thursday, December 05, 2002, 2:50:30 AM, you wrote:
CA> The problem shows up when receiving the response of the query which
CA> tells me that the query was OK but rows affected.
How many row were affected? 0? Was the password changed?
--
For technical support contracts, goto https://
Mariella,
Thursday, December 05, 2002, 4:15:52 AM, you wrote:
MDG> I am running MySQL 4.0.5 64 bit on a Sun Solaris and I am using MyISAM
MDG> Indices.
MDG> I would like to set replication (one master and one slave).
MDG> My question is:
MDG> When I OPTIMIZE TABLE table1, ... on the master will
Richardson,
Thursday, December 05, 2002, 12:32:27 AM, you wrote:
RDE> On a single Linux box w/mysql 3.23.52 I have mysqld running and there are
RDE> about 20 databases live in the environment. I want to take one of the
RDE> databases offline but leave mysqld running with the other db's - without
R
I am running a few AMD based servers in our offices here and have no
issues with them. The big question is, What kind of operations are you
most likely to see with your servers?
If the servers will be doing some heavy floating point operations stay
away from the Intel P4.
Hello
I have a Red Hat 7.1 server with mysql 3.23.49a installed. Recently I get an
error when run mysqldump in order to backup my dbs. The error is following:
/usr/local/bin/mysqldump: Got error: 2013: Lost connection to MySQL server
during query
when retrieving data from server
I ran mysqldump w
I saw some discussion on this topic last night, and forgot to put in my .02:
Whomever said that memory and hard disk hardware should be the focal point
in a new mySQL DB server, and not processors, I very much disagree with.
While I agree that ample and fast memory, in addition to an efficient,
re
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kenneth,
I would download the source packages from php.net and explicitly
compile the mysql options into PHP. As an alternative, you can look
for the mysql-php library rpms on rpmfind.net. My linux webserver
(running apache and PHP 4.1.2) has php-my
On 5 Dec 2002, at 14:44, Ol h Barnab s wrote:
> "SELECT * INTO [temptablename] FROM [sourcetablename] WHERE id is null"
>
> and the SQL server creates a [temptablename] table with no records (or we
> hope that ;) )
> But we can't do this on MySQL server, 'cause MySQL isn't know the
> "SELECT...INT
Hi,
I tried to compile mysql-3.23.49 on HPUX 11.11 system.
When I run:
CC=cc CXX=aCC CFLAGS=+DD64 CXXFLAGS=+DD64 ./configure
Everything is fine, no errors.
But when I run: make
I got:
cc: "password.c", line 95: error 1000: Unexpected
symbol: "char_val".
cc: panic 2017: Cannot recover from ea
Hi,
is there a possibility to query a column with a FULLTEXT-INDEX for a word fragment?
I mean if there's the word "skyscraper" in a column I want to find it looking for
"sky" and also looking for "crap".
It seems to me it does not work with something like:
match(column) against("*crap*")
Regar
Alejandro,
Thursday, December 05, 2002, 4:03:23 PM, you wrote:
ACG> Hi all and thx in advance for trying to fix my problem.
ACG> I'm instaling for the first time MySQL and when I try to test the program, I
ACG> receive an error like "Cannot connect to localhost (100060)"...How can I
ACG> configure
Daya,
Thursday, December 05, 2002, 4:14:02 PM, you wrote:
DKD> can anybody tell me how can i select,update, delete the records from two
DKD> table having same structure in the mysql.
DKD> For ex
DKD> MainTable
DKD> ---
DKD> id(int)|val (varchar)
DKD> ---
Oláh,
Thursday, December 05, 2002, 2:44:24 PM, you wrote:
OB> I want to copy one table's structure to another (non existing) table, but i
OB> didn't find any command or example to do that. Exactly, the situation is the
OB> following:
OB> A dynamic database structure has tables. We want to copy any
Mysql, sql,query
--- [EMAIL PROTECTED] wrote: > Your message
cannot be posted because it appears to
> be either spam or
> simply off topic to our filter. To bypass the filter
> you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message,
* Daya Krishan Dubey
> can anybody tell me how can i select,update, delete the records from two
> table having same structure in the mysql.
"select", "update" and "delete" are three different operations. From your
example data, it looks like you want to do "select".
> For ex
>
> MainTable
> -
* Michelle de Beer
> I believe this question is solved by a join, but I
> haven't really got a hang of it.
>
> My table:
> --
> | uid | rootid | parentid | name |
> --
> | 1 | 0 | 0| name1|
> | 2 | 1
- Original Message -
From: "Michelle de Beer" <[EMAIL PROTECTED]>
> I believe this question is solved by a join, but I
> haven't really got a hang of it.
>
> My table:
> --
> | uid | rootid | parentid | name |
> -
Hi:
You might find these articles from O'Reilly Network will help clear the
water.
http://www.onlamp.com/pub/ct/19
Doug
On Thu, 5 Dec 2002 07:46:03 -0800 (PST), Michelle de Beer wrote:
>I believe this question is solved by a join, but I
>haven't really got a hang of it.
>
>My table:
>-
On Wed, Dec 04, 2002 at 04:32:35PM -0500, Michael T. Babcock wrote:
> information from "a" to "b". Any ideas for a one-shot SQL command to do this?
> I'm about to try selecting everything from "b" and the CommID from "a" as a
> join into a temporary table, then "REPLACE" it back into "b".
In ca
I believe this question is solved by a join, but I
haven't really got a hang of it.
My table:
--
| uid | rootid | parentid | name |
--
| 1 | 0 | 0| name1|
| 2 | 1 | 1| name2|
| 3 | 1
On Wed, Dec 04, 2002 at 05:06:54PM -0500, Ledet, Mike wrote:
> I tried your TOP suggestion but didn't see anything out of the ordinary.
> Swap size was constant (6400 or so) and didn't increase or decrease under
> load.
Familiarize yourself with vmstat if you aren't already and then run
`vmstat 1`
Thanks - this is even better - I will give it a try.
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 6:19 AM
To: Norris, Joseph; Mysql_List (E-mail)
Subject: RE: WoW SQL is something!
select req_number,
right(concat('00',trim(re
Vinay,
Wednesday, December 04, 2002, 3:05:03 PM, you wrote:
VM> I m developing a web based application using Tomcat, Struts, JSP, mysql.
VM> I m using mysql 3.23.39-max-nt and mysql-connector-java-2.0.14 to access
VM> mysql through java 1.3.1.
VM> But sometimes the select query on 1 particular t
Michal,
Tuesday, December 03, 2002, 7:19:08 PM, you wrote:
MF> Its possible to use index on this query ??
MF> select ..
MF> from ..
MF> where timestamp_col<2002110100 and timestamp_col>2001110100
MF> I have index on timestamp column, but EXPLAIN says that not using any of
MF> possi
Michelle,
Thursday, December 05, 2002, 5:46:03 PM, you wrote:
MdB> I believe this question is solved by a join, but I
MdB> haven't really got a hang of it.
MdB> My table:
MdB> --
MdB> | uid | rootid | parentid | name |
MdB> -
another trick that might work is just to deny access to everyone to the
database. if no one has access to it, then its as good as gone.
i don't know if MySQL would allow just
grant blah on *.* to user;
revoke all on disabled_db.* from user;
and alot of it depends on how the security is setup a
Ç×°®µÄÅóÓÑ£º
ÄúºÃ£¡
ÕâÊÇÀ´×ÔÏÃÃÅÊÐӯͨԶº½µç×ӿƼ¼ÓÐÏÞ¹«Ë¾µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ÎÒÃÇÕæ³ÏµÄÏ£
ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒÖÂÁ¦ÓÚ»¥ÁªÍøÐÅÏ¢·þÎñ¡¢µç×ÓÉÌÎñ·þ
ÎñºÍÆóÒµÓ¦Ó÷þÎñµÄ¸ßм¼ÊõÆóÒµ¡£ÎÒÃÇÓÐ×ŶàÄê´ÓʲÙ×÷ϵͳµÄ¾Ñé,ÕâΪÎÒÃǵĿռä
Îȶ¨ÌṩÁ˱£Ö¤.ÎÒÃǵķþÎñ×ÚÖ¼ÊÇ:Îȶ¨
I am using BSDI 4.3, and downloaded MySql source code
3.23.53.
After untarring it, it passed ./configure
--prefix=/usr/local/mysql. But when I run make,
finally it says
make: don't know how to make mi_test_all. Stop
*** Error code 1
Your help will be appreciated
Shawn Xu
_
hi
MySQL 3.23.52
could not make my way throuh the JOIN statement.
i would like to accomplish something like what EXCEPT
does in other databases, with a full SQL-statement
after the EXCEPT.
xxxIDref is a foreign key.
first i have a table with users
ID Name
1 John Doe
2 Jane Doe
3 Me Myself
th
Hola,
Tenia instalado MySQL 3.23.53 en mi pc. He reinstalado todo el sistema y lo
he vuelto a instalar, pero no consigo arrancar el servidor sql. La
instalación la he hecho según indica el manual y tal como la habia hecho en
la otra ocasión.
Cuando quiero arrancar el servidor (/bin/safe_mysqld --u
Colin,
According to the docs this function wants a string and when I use the field
name it says "unknown column".
Thanks anyway.
-Original Message-
From: Colin Kettenacker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 5:32 PM
To: Mysql_List (E-mail)
Subject: Re: WoW SQ
Evgeny,
- Original Message -
From: "Evgeny Chuykov" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, December 05, 2002 12:28 PM
Subject: InnoDB shared lock with JOINs
> Hallo.
>
> I have this query:
> SELECT table1.id
> FROM table1
> LEFT JOIN tabl
I'm attempting to import 36 files of varying size from about 500kb to 80mb.
I've found that using the "local infile import" query on files that are
several mb in size takes up to a min per mb and much longer if it get's over
100mb. The system we're using has 500mb RAM and a 1600mHz processor. Is
Hola de nuevo, he mirado el log de mysqld, y pone lo siguiente:
bind on unix socket : permission denied
Donde reside el problema?
Gracias
___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis!
Descárgalo ya desde http
Dear Carlos,
> Got error: 2013: Lost connection to MySQL server
> during query
> when retrieving data from server
In your my.cnf / my.ini configuration file, set the value for the
communication buffer high (maximum is 16 MB):
[mysqldump]
set-variable = max_allowed_packet=16M
Restart the server,
Dear Oláh,
> "SELECT * INTO [temptablename] FROM [sourcetablename] WHERE id is
null"
In MySQL, you simply do:
CREATE TABLE temptable SELECT * FROM sourcetable LIMIT 0
That's even simpler, 100% reliable and FAST! :)
HTH!
--
Stefan Hinz <[EMAIL PROTECTED]>
Geschäftsführer / CEO iConnect GmbH
I am forwarding Shawn's real question to the list, since I haven't got a clue :)
> -Original Message-
> From: shawn xu [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 05, 2002 12:42 PM
> To: Luc Foisy
> Subject: RE: I can not post to this list after I have joined
>
>
> Hi, Luc Fo
Oops. I should have been paying more attention to the lost connection
thread. What does the "Lost connection to MySQL server during query" error
message mean and where can I find more information about it?
I just installed the DBTools on a XP box. When I try to connect to by Linux
box, it gives m
yes...
it seems that you do not have mysql in the PHP module.
you can use --with-mysql in the php configure, but you should use
--with-mysql=/your/mysql/directory
PHP has included code for the default mysql build. try to use your own libs
and headers.
HTH
brian
sql, query, mysql
On Th
On Thu, Dec 05, 2002 at 09:41:24AM -0200, Felipe Moreno - MAILING LISTS wrote:
>The ten last dates appear as a default result of a Archives page. When I
> enter for the first time in the page, it give me the last ten Files that was
> uploaded. In the same page, I can ORDER BY the ten last dates
1 - 100 of 170 matches
Mail list logo
