Hi,
I am trying the below sql statment:
mysql> select c.city, t.periodo, t.vitofferta from travel t, city c where
t.cityid=c.id and t.periodo>"2001-07-20" and
month(t.periodo)=month("2001-07-20") and
YEAR(t.periodo)=YEAR("2001-07-20") and rand() limit 7;
The result:
+---++---
John Birrell wrote:
> On Fri, Jul 20, 2001 at 12:29:52PM -0400, Britt Johnston wrote:
> > MySQL AB and NuSphere had a meeting over the phone, we exchanged
> > information and opinions and NuSphere will propose times for the
> > next meeting.
> Since these issues are between two private companies,
Hi All,
This problem is predominant and is being experienced
by all who are instaling mysql. please could someone
be of help and help us newbies.
Thanks
Ajay
--- peter_tkchoi <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
>I'm a beginner of MySql. I've just installed the
> lastest ver. MySql under R
Maybe I'm trying to use the wrong kind of join ... I was trying to do an
INNER JOIN but it wasn't working and I'm starting to think that maybe the
problem was my understanding of what an INNER JOIN does rather than how I
coded the INNER JOIN (although the code worked in Access but who says Access
You may want to understand what distinct and avg means. The
combination doesn't make sense.
Bob Rea schrieb am Samstag, 21. Juli 2001, 02:36:11:
> The SQL book I am using has this:
mysql>> select avg(distinct prod_price) as avg_price
> -> from Products
> -> where vend_id = 'dll01'
>
>From the German php FAQ:
version >= 3.23
SELECT * FROM tabelle ORDER BY RAND() LIMIT 1
version < 3.23
//see how many rows you have
$result = @mysql_query("SELECT COUNT(*) FROM $table");
$row = mysql_fetch_row($result);
//produce random number out of that
mt_srand((double)microtime()*100)
>From the German php FAQ:
version >= 3.23
SELECT * FROM tabelle ORDER BY RAND() LIMIT 1
version < 3.23
//see how many rows you have
$result = @mysql_query("SELECT COUNT(*) FROM $table");
$row = mysql_fetch_row($result);
//produce random number out of that
mt_srand((double)microtime()*100)
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 21, 2001 12:33 PM
Subject: Mysql syntax
> If I wanted to asssign John Doe to system1, how would I write the
statement in sql to pull the sysid from the > system table via the sysname,
and then to u
On Thu, Jul 19, 2001 at 03:15:02PM -0500, Tom Wheeler wrote:
>
> Our two most important requirements for the database engine are
> speed and scalability. We will be inserting probably 5,000,000
> records per day into our database
Sounds doable--on reasonable hardware.
> and will maintain around
On Wed, Jul 18, 2001 at 10:12:03PM -0400, Chris Anderson wrote:
>
> I have an include file that includes my mysql connect
> information. Its sole purpose is to login to mysql. Strangely on my
> Win9x development system with apache, sometimes, almost randomly,
> the connection will time out. Then i
On Fri, Jul 20, 2001 at 01:25:22AM -0700, Jeremy Zawodny wrote:
> >
> > If I specify just one database, I still get the "deprecated"
> > warning, but the hotcopy works...
>
> There are two bugs.
>
> (1) The "depricated" message. I'm submitting a patch for that.
>
> (2) The fact that if yo
On Mon, Jul 16, 2001 at 03:59:50PM -0700, Jose de Leon wrote:
> Hello All,
>
> I have need to modify users table in mysql database. I wish to
> expand the user column from 16 chars to 128 chars. Will this cause
> problems with MySQL server engine and will it recognize and use my
> changes? Wha
Hi.
I need to install mysql on Solrais (5.5.1 Generic sun4m sparc
SUNW,SPARCstation-20), but config procedure stop with this message:
>checking for restartable system calls... configure: error: can not
run test program while cross compiling
Looking in config.log i see some fatal errors:
- Original Message -
From: Derick Dorner
To: [EMAIL PROTECTED]
Sent: Tuesday, July 17, 2001 3:11 PM
Subject: tricky RAND() function...
I am using MySQL 3.22, and need to know how to randomly select a record, therefore I
can't just use the ORDER BY RAND() clause, because of my versio
What directory are you in when you 'unpack' the source distribution ?
What directory are you in when you issue the 'make' command ?
What directory are you in when you issue the 'scripts/mysql_install_db'
command ? (I usually go to the 'installed' directory "/usr/local/mysql" and
type "./bin/mys
Hi.
On Fri, Jul 20, 2001 at 11:22:56PM +0200, [EMAIL PROTECTED] wrote:
>
> > SELECTbrand.brandname,
> > SUM((productorders.quantity)*(productorders.price)) AS turnover
> > FROM orders
> > LEFT JOIN productorders ON productorders.orderid = orders.id
> > LEFT JOI
Hi,
I'm a beginner of MySql. I've just installed the lastest ver. MySql under RH7.1
Linux. First, I do have runned the "mysql_install_db" script. When I tried to up the
MySql server by running safe_mysqld script, it also failed and now I've got an error
message logged as follows:
0107
Michael,
MySQL worked beatifully for us on a vanilla FreeBSD system -- I simply
installed the binary (precompiled) package from the FreeBSD ports
collection. I recommend you get the binary rather than playing with the
configuration yourself ...
-
Tom Haapanen -- Software Metrics/Equitrac Co
I have been trying to figure out how to do this, and I am sure that I am just
overlooking somthing small.
Suppose I create two tables as follows:
CREATE TABLE system (
sysid INT NOT NULL UNSIGNED AUTO_INCREMENT PRIMARY KEY,
sysname VARCHAR(12),
os VARCHAR(10),
cpumhz INT
);
CRE
Hi All,
I am a new user of mysql. I too installed mysql on my
linux box. but i get the same message. what is this
message and how do we solve it.
I had the client and server RPM and installed them.
I once managed to start the server with mysqld. But
now the server also doesnt start saying host.f
Hello
I have mysqlgui-1.7.5-1-linux-static and semi-static, mysql-3.23.39, linux slackware
7.2. When I run the mysqlgui executable(in static & semi-static), I enter password and
the gui loads but says "Can't connect to local MySQL server through socket" (111). The
password is correct and I can
This is precisely what I did, only I left out the 'as max_hit_id' part, and
jumped right to pixels. Works quickly and neatly. Thanks very much.
Walter
On 7/20/01 6:35 PM, "Jonothan Farr" <[EMAIL PROTECTED]> wrote:
> LAST_INSERT_ID is the value of the auto increment field in the table that was
>
Yes, you are correct in assuming that, but ONLY if you use MyISAM tables.
BDB and ISAM tables reuse number, kind of.
Ex:
1
2
3
4
5
If you delete 5, the next record you insert will have an ID of 5. If you
delete 4 instead of 5, the next one inserted will have an ID of 6. So, BDB
and ISAM ta
That I'm trying to do here is get the VALUE of hit_id from the last row of
hits. It is an auto-increment number, but it is much higher than the count
of the rows, because people go through and delete their hits from time to
time. Am I correct in assuming that auto-numbers are never re-used?
Walte
Hi
I am a newbie to linux and mysql and would like some advice re
installing mysql source code on corel linux.
I have successfully installed a binary version of Mysql (now
deleted) but need to compile and install a source version, as I want
to next install PHP.which I understand needs the sou
The SQL book I am using has this:
mysql> select avg(distinct prod_price) as avg_price
-> from Products
-> where vend_id = 'dll01'
-> ;
and responds thus:
ERROR 1064: You have an error in your SQL syntax near 'distinct
prod_price) as avg_price
from Products
where vend_id = 'dll01'' at
Adding, For that thread.
selecting LAST_INSERT_ID() for a pseudo-foreign keys system is reliable.
The only case I can possibly think of, Of this being a problem is when
you're dealing with a persistent connection to the database which is
shared among multiple applications.
Jonothan Farr wrote
There are only 8,000 rows. Unfortunately, I was really hoping for some
sort of function within MySQL to do this. I'm not using PHP, but rather
Perl. I could pretty much do the same thing in Perl, I guess. Is there
any elegant solution or alternative within MySQL?
On Friday, July 20, 2001, a
select table1.colOne as one, table2.colOne as two from table1,
table2 where some condition...
Later fetch the values with names one and two.
Sie schrieben am Freitag, 20. Juli 2001, 23:55:45:
> I have two tables and both tables have a field name thats the same. I
> need to display
> both those
How many rows do you have? I'd do it in php along those lines:
read the rows from the old table in 3 arrays. randomize one or
all of them (built in function in version 4, else do it
yourself), then populate new table from those arrays.
Sie schrieben am Freitag, 20. Juli 2001, 23:56:38:
> I'm sur
Hi,
I am using mySQL on Windows 2000. I need to use the InnoDb table type to get
transaction support. I had initially installed mysql and was using the ISAM
table type and everything was working fine. My NT service was configured to
run the mysqld-nt.exe. For using the InnoDb type I un-installed
> $sql4 = "SELECT hits.hit_id as pixels from hits
> WHERE hit_id=LAST_INSERT_ID();";
>
> $result = mysql_query ($sql4, $connection)
> or die("error #" . mysql_errno() . ": " . mysql_error());
> $row = mysql_fetch_object($result);
> $pixels = number_format($row->pixels);
>
> It's staggering the dif
On Friday 20 July 2001 14:00, Steven Roussey wrote:
> > Locked table should not crash a server !!
>
> Oh.. I only meant in the cascade sense: Locked Table -> Queries waiting ->
> Threads fill up -> Run out of memory -> Crash
One thing to remember about row vs table level locking is that any que
> Currently, I have been counting the rows in PHP in order to get the value of
> the last hit_id in the database like this:
You have mysql_insert_id() in php to get the last autoincrement
value. This is _not_necessarily_ the same as the number of rows.
> It's staggering the difference in speed.
Read the manual again on last_insert_id(). That function only gives you the
unique id of the last insert *for that thread* If you connect, don't do any
inserts, and select last_insert_id, there is no guarentee what you will get.
If you are trying to find the number of rows, it would be much
LAST_INSERT_ID is the value of the auto increment field in the table that was last
inserted into. You probably want:
$sql4 = "SELECT MAX(hits.hit_id) as max_hit_id
as pixels
from hits;";
--jfarr
-
Before posting, please chec
I have been trying to install MySQL on my Cobalt RAQ3 and I seem to have
lost my mysql.sock file. I get the following error message when I tray to
carryout any mysql activity.
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
Pls advise
Michael J
On Fri, Jul 20, 2001 at 12:29:52PM -0400, Britt Johnston wrote:
> MySQL AB and NuSphere had a meeting over the phone, we exchanged
> information and opinions and NuSphere will propose times for the
> next meeting.
Since these issues are between two private companies, please take
your discussions
OK, I found some...
>From the manual at "MyISAM tables"...
"Internal handling of one AUTO_INCREMENT column. MyISAM will
automatically update this on INSERT/UPDATE. The AUTO_INCREMENT value can
be reset with myisamchk. This will make AUTO_INCREMENT columns faster
(at least 10 %) and old numbers w
> The problem is...if I delete the third entry (Edicao = 3), the next
> entry inserted should be 3, right?! Well it is not! It is 4.
Well, this may be debated. I suffered a lot from the behaviour
you want to have. I considered it bad design ...
An autoincrement field should not serve for counti
I have two tables and both tables have a field name thats the same. I
need to display
both those field names back to the browser using PHP. I have used php to
display all
the other fields but I can't display these fields, because of the
identical name. I know you can us the Select statement with
I'm sure I'm just missing something basic, but here goes...
I need to create a table, populated with data, from an existing table.
Easy enough:
"create table TEST select * from OLD_DATA"
Most cool. Now, let's say OLD_DATA has three columns: A, B, & C. I
want to create new table TEST, with a
OK guys,
Thank you all...
That's it... the problem is that I'm using MyISAM at this time and the
other tables I have are of ISAM type.
Sorry and thank you again!
William N. Zanatta
Ravi Raman wrote:
>
> hi.
>
> from the manual:
>
> If you delete the row containing the maximum value for a
In the last episode (Jul 20), Ravi Raman said:
> ok, first actual question to the list, hope someone can help:
> the following query -
>
> select pn.number, c.ID, c.cost, c.days_valid, c.description from
> pinnumbers pn, cardtype c where pn.cardtypeID = c.ID and pn.tmaster = 0
> order by c.ID, pn.
It is not a bug, it is a bug fix. The auto_increment is based on the last
number used. It is not supposed to decrement.
j- k-
On Friday 20 July 2001 11:53, William N. Zanatta wrote:
> Hello guys...
>
> I'm having problem with the auto_increment feature.
> I have a table like this...
Hi Benjamin,
Thanks for reading my message an taking some time to give some help/sugggestion..
First you are right that I should have written the query in a readable form..
You gave some comments:
> SELECTbrand.brandname,
> SUM((productorders.quantity)*(productorders.price)) AS t
I have a hit counter script that logs all its hits in one table, one row per
hit.
Currently, I have been counting the rows in PHP in order to get the value of
the last hit_id in the database like this:
$sql4 = "SELECT hits.hit_id from hits";
$result = mysql_query ($sql4, $connection)
or die("e
hi.
from the manual:
If you delete the row containing the maximum value for an AUTO_INCREMENT
column, the value will be reused with an ISAM, or BDB table but not with a
MyISAM or InnoDB table. If you delete all rows in the table with DELETE FROM
table_name (without a WHERE) in AUTOCOMMIT mode, t
Well, it's a feature not a bug, and you are right too. auto_increment
remembers the last value and keeps increasing it, no matter how many
"holes" are created. So when use it, better to create a status column to
change flag as deleted other than real delete it.
"William N. Zanatta" wrote:
>
>
> I added comments and a recipe to my debug function collection.
> You can download at the address
> http://pferdezeitung.de/php3/toosDebug.zip
Sorry - in adding comments I inadvertently dropped several lines
in function debugMsg. So if you downloaded version 0.4, please
fetch version 0.
Hello guys...
I'm having problem with the auto_increment feature.
I have a table like this...
++-+--+-+++
| Field | Type| Null | Key | Default| Extra
|
++-+--+-+--
That should work just fine. :)
Thanks!
- Original Message -
From: "John Meyer" <[EMAIL PROTECTED]>
To: "Tyler Longren" <[EMAIL PROTECTED]>; "MySQL List"
<[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 3:21 PM
Subject: Re: not selecting last row
> At 12:25 PM 7/20/01 -0500, Tyler Longr
At 12:25 PM 7/20/01 -0500, Tyler Longren wrote:
>Hi everyone,
>
>Is there a way to NOT select the last row that was inserted into a table? I
>want everything before it.
>
>I know how I could do this using 2+ queries, but can it be done by issuing
>just 1 query?
>
>Thanks everyone,
>Tyler
Assumin
On Fri, Jul 20, 2001 at 06:44:29AM -0400, Jonathan Buhacoff wrote:
> --
> >Description:
> I get errors when I try to compile the distribution. The first one happens
> in the gemini tree and is caused by a prototype mismatch between the bzero()
> defined in and the
Dear Frederic,
>localhost | jkasas | 1896f443280395b3
> And what I do and get :
>mysql> GRANT SELECT ON MEMBERS.users TO jkasas@'localhost';
>ERROR 1133: Can't find any matching row in the user table
Try GRANT SELECT ON MEMBERS.users TO jkasas@localhost (w/out quotes)! :)
On 20-Jul-2001 Nelson Goforth wrote:
> Thanks to Steve and Jeff for your replies.
>
>
> The new system will store the data in MySQL table(s) for retrieval
> not only of specific survey results, but (as I'm collecting industry
> type and demographic data as well) in more complex ways as well
Hi everyone,
Is there a way to NOT select the last row that was inserted into a table? I
want everything before it.
I know how I could do this using 2+ queries, but can it be done by issuing
just 1 query?
Thanks everyone,
Tyler
---
Dear Don,
congrats for changing from Access to a real DBMS!
I am not informed how complex your tables are (relations etc.). As for
the data concerned, simply export the Access tables into CSV format.
MySQL can import CSV very easily. Try PhpMyAdmin, a browser based PHP
tool with a graphical inte
Hello.
[...]
> Here is the query
>
[query reformatted... btw, it would have been nice if you had done this at first]
SELECTbrand.brandname,
SUM((productorders.quantity)*(productorders.price)) AS turnover
FROM orders
LEFT JOIN productorders ON productorders.orderid =
> What do I do next?
Check in to mysql.com, look for AccessToMySQL tools, fget a
distribution, set it up and convert your data.
--
Herzlich
Werner Stuerenburg
_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407
At 12:30 PM 7/20/01 -0400, you wrote:
>on 7/20/01 12:32 PM, Erich Kolb at [EMAIL PROTECTED] wrote:
>
> > When you query a MySQL Database, how do you set the order alphabetically?
>
>
>If it's a text field just say DESC
>
>Susan
>
isn't that reverse alphabetical
ASC is (default) alphabetical
Joh
At 08:50 AM 7/20/01 -0600, you wrote:
>My website, which included a Microsoft Access database, was on a server that
>went bye-bye. I signed up with a new host that doesn't support MS
>Access...and they suggested that I contact you to convert my database to
>Mysql.
First off, download mysql from
I have been trying for some months to use the C api with Borland
builder, so far with only limited success.
I can write a console application in the Builder environment, compile
it, but not link it. The error says the library routines are not found.
If I export the make file, edit it to includ
On Fri, Jul 20, 2001 at 06:20:00AM -0700, Mike Wexler wrote:
>
> I already increased table_cache from 128 to 2048. Which helped. And
> last night I increase key_buffer from 16MB to 64MB. Maybe it should
> be even larger?
Oh, you can easily make it quite a bit higher. On my 1GB systems, I
have i
MySQL AB and NuSphere had a meeting over the phone, we exchanged
information and opinions and NuSphere will propose times for the
next meeting.
Britt...
--
D. Britton Johnston 603-578-6707 Nashua
Chief Technology Officer 781-280-4954 Bedford
NuSphere Corporation 781-280-4600 Main
14
"Andrius Armonas" <[EMAIL PROTECTED]> wrote:
> I'm running mysql 3.23.39. Could anybody explain me how to do this in
mysql
> (without sub-selects):
>
> delete from IP where id in ( select id from USERS where MK='0032' )
One solution is to build a list of id values from the users table in your
app
Hello there.
When I install Mysql-3.23.39 at my OpenBSD 2.9 server, it works perfectly..
until i restart the server.. does anyone have had the same problems as I ?
plz write back.. I just get this command, when i try to start the mysqld
server. with safe_mysqld
# safe_mysqld
/usr/libexec/ld.so:
hi.
ok, first actual question to the list, hope someone can help:
the following query -
select
pn.number,
c.ID,
c.cost,
c.days_valid,
c.description
from
pinnumbers pn,
Quick question about the SHOW TABLE STATUS command and the Data_free info in
particular.
You say: "If it is high, then it's time to run OPTIMIZE TABLE..."
What is considered high? As I'm looking at my output, I see that most of my
tables show a value of 0, however, some have a value around 300 a
Hi everybody,
I use Replication on a windows NT4 Server.
There are 1 master and 2 slaves, all on the same machine.
One slave is started with the option skip-name-resolve, not the other.
For the 2 slaves : master-host=localhost
When adding a user (MYSQL.User), the replication is OK but,
when
I am a newbie to linux and mysql and would like some advice re
installing mysql source code on corel linux.
I have successfully installed a binary version of Mysql (now
deleted) but need to compile and install a source version, as I want
to next install PHP.which I understand needs the source
Thanks to Steve and Jeff for your replies.
A spreadsheet is how I've handled this for several years now.
Responses came in via a Scantron card reader (or manually) and the
resulting text file was fed into an Excel spreadsheet for graphic
output. I was in mind of the spreadsheet when devising
Under solaris 8 you can use
pmap -x 22889
which will give address space map.
-Igor
On Fri, 20 Jul 2001, Jeremy Zawodny wrote:
> On Wed, Jul 18, 2001 at 12:45:57PM +0200, Werner Stuerenburg wrote:
> > What I am stumbling about is this:
> >
> > > PID USERNAME THR PRI NICE SIZE RES STATE
I don't investigate the error -- why don't you put a unique index
on email? That's how you get what you want.
> I have this two tables : table1,table2 . I would like to include all emails from
>table2 into table1 removing duplicates.
> INSERT INTO table1 (email) SELECT email from table2 wher
Hi,
> Strange. My understanding was that RAID 5 was good for read bandwidth
> but that keeping the parity disk uptodate slowed it down for write
> bandwidth.
Well, what you say is almost true to a certain extent. Firstly, with RAID 5
parity is striped across the disks too, so there is no bottlen
My website, which included a Microsoft Access database, was on a server that
went bye-bye. I signed up with a new host that doesn't support MS
Access...and they suggested that I contact you to convert my database to
Mysql.
What do I do next?
Please respond ASAP!
Don Moor
[EMAIL PROTECTED]
http
If you are running Linux, man ldconfig.
add the path to /etc/ld.so.conf
and run ldconfig.
Michael Taney wrote:
> I've installed mysql and PHP4 according to instructions at mysql.com,
> but I'm getting the following error when I try to start httpd:
>
> Cannot load /etc/httpd/modules/libphp4.so
hello,
I'm running mysql 3.23.39. Could anybody explain me how to do this in mysql
(without sub-selects):
delete from IP where id in ( select id from USERS where MK='0032' )
Thanks.
.:: Andrius Armonas ::.
.:: [EMAIL PROTECTED] ::.
.:: http://baubas.andrius.org ::.
--
Hi boys,
I have a problem when I make mysql++-1.7.9 API with gcc 3.0.
Can somebody help me, where is the problem ?
Is mysql++-1.7.9 compatible with the last ANSI/ISO C++ rules ?
Matteo Limonta
-
Before posting, please check
Absolutely great! You are so keen and brave - I wouldn't dare to
and some others obviously neither!
We need people who calm things down to make negotiations and an
agreement possible, that's absolutely true, but we also need
people to emphasize the frontiers to make a correct agreement
possible i
Michael Taney <[EMAIL PROTECTED]> writes:
> I've installed mysql and PHP4 according to instructions at mysql.com,
> but I'm getting the following error when I try to start httpd:
>
> Cannot load /etc/httpd/modules/libphp4.so into server:
> libmysqlclient.so.10: cannot open shared object file: No
I experience something similar for a long time and try to find
out what's happening. I cannot see any rule, so far. Any ideas
what I could do to find out?
For some days now, I didn't have problems now except for a
duplicate entry error which shouldn't occur at all. Before, this
indicated a corrup
Hi,
> Thank you very much for the detailed analysis! One question:
> where did he get all this data from?
You can show all of MySQL's status and configuration parameters by issuing
these statements:
SHOW STATUS;
SHOW VARIABLES;
Also, the following can come in handy if you want to see info abo
--
>Description:
I get errors when I try to compile the distribution. The first one happens
in the gemini tree and is caused by a prototype mismatch between the bzero()
defined in and the one defined in the mysql source. Apparently,
the one on my system takes a vo
>
>
> Yes, you should definitely look at option #9 first. Here's a few pointers to
> some things that immediately spring off the screen at me:
>
> | Open_tables | 1296 |
> | Open_files | 2180712|
> | Open_streams | 0 |
> | Opened_tables
> It's normal that the mysqld is 795M big? If is not normal which could be the
> cause of this size?
Certainly not. But Jeremy gave some comments; I don't know
anything about this, I wonder myself. My processes are between
8 and 25 MB.
> PID USERNAME THR PRI NICE SIZE RES STATE TIMEC
The Best:
By Dave Carter
SELECT * FROM tbl_experience
WHERE knowledge like '%SQL%'
ORDER BY least_expense
GROUP BY by no_equal;
Result: MySQL
Ok so it's a little hokey, but it was the best I could after the conversion
project I just got out of, thank god for MySQL.
Dave Carter
Chief Web Archi
The web site is a off shot of the magazine, Ziff-Davis publishes most of the
"tech" magazines on the new racks. They Been doing it for a long time. The
class that this one is in I will call the "Movers and Shakers".
"Interactive week" they claim is a 200$ a year subscription, but I doubt
anyone ev
Basil Hussain wrote:
>
> Hi,
>
> > > We currently have a dedicate server for MySQL. The server is a dual
> > > pentium III (1Ghz) with 2GB of RAM in it. It also has 2 18GB 10,000
> > > RPM drives in it arranged in a Raid 1 configuration (mirror).
> > > Sometime in the next 3-6 months we will b
Sorry, I didn't use replace yet, I always work with update which
is what I want. Are you sure you want to use replace? See the
differences in the manual. The syntax for update is
UPDATE table_name
SET col1 = '$val1',
col2 = '$val2',
col3 = '$val3'
WHERE p
> i don't understand what does connecting from different host mean?
Where do you have this problem?
> 1. does it mean connecting from a different pc to the pc hosting the mysql
> server through telnet?
Why would you like to do that? looks like a masochistic
approach to me, under no
Jeremy Zawodny wrote:
>
> On Thu, Jul 19, 2001 at 04:21:05PM -0700, Mike Wexler wrote:
> >
> > We currently have a dedicate server for MySQL. The server is a dual
> > pentium III (1Ghz) with 2GB of RAM in it. It also has 2 18GB 10,000
> > RPM drives in it arranged in a Raid 1 configuration (mir
Take a look at :
http://www.mysql.com/doc/I/n/Installing_source_tree.html
- Original Message -
From: "Simon Green" <[EMAIL PROTECTED]>
To: "'Fournier Jocelyn [Presence-PC]'" <[EMAIL PROTECTED]>; "Carsten
Gehling" <[EMAIL PROTECTED]>; "Sergei Golubchik" <[EMAIL PROTECTED]>
Cc: <[EMAIL PR
I added comments and a recipe to my debug function collection.
You can download at the address
http://pferdezeitung.de/php3/toosDebug.zip
> Well, I don't know about David, but I'd be very interested in your
> stopwatch program
table, sql
--
Herzlich
Werner Stuerenburg
Hi
Where can we get V4.0?
Thanks Simon
-Original Message-
From: Fournier Jocelyn [Presence-PC] [mailto:[EMAIL PROTECTED]]
Sent: 20 July 2001 12:30
To: Carsten Gehling; Sergei Golubchik
Cc: [EMAIL PROTECTED]
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT fie
You can use Windows explorer to create new database (Not tables).
Just create new subfolder of mysql\data on your system.
-Original Message-
From: Donald Dahlman [mailto:[EMAIL PROTECTED]]
Sent: petak, 20. jul 2001 22:03
To: [EMAIL PROTECTED]
Subject: mysql manager
does anyone have
Hi all
When I start mysqld using /etc/rc.d/init.d/mysqld start it starts ok alhtough when I
say mysqld status I get the following error :
mysqld dead substatus locked
i cannot connect to the server at all
please help
thanks
Barry
I've installed mysql and PHP4 according to instructions at mysql.com, but
I'm getting the following error when I try to start httpd:
Cannot load /etc/httpd/modules/libphp4.so into server:
libmysqlclient.so.10: cannot open shared object file: No such file or
directory [FAILED]
So, it's locatin
This is the feedback from repair:
mysql> repair table hits
-> ;
+--++--+
-+
| Table| Op | Msg_type | Msg_text
|
+--++--+
-+
| counter.hit
INSERT INTO table1 (email)
SELECT email FROM table1, table2 WHERE table1.email <> table2.email;
the select is a "new" query, you have to join table1 and table2...
Regards,
Johan Nilsson
Software Developer
BeCon Mobile Internet AB, Sweden
Web: http://www.beconmobile.com
E-Mail: [EMAIL PROTECTED]
1 - 100 of 135 matches
Mail list logo
