Hi,
just after a bit of advice on programming style
I have one main table which holds keys to records in other tables. There is also an
additional table that uses the main tables ID field as a key. I need to generate a
view that joins data from each of these tables. Should this be achie
On Wed, Sep 19, 2001 at 03:14:17PM +1200, Quentin Bennett wrote:
> Hi,
>
> If I have a large table (> 70million rows, nearly 4 GB Index, 2.5G Data),
> and I want to
>
> ALTER TABLE mytable TYPE=MYISAM;
> ALTER TABLE mytable change column col1 col1 tinyint unsigned not null;
> ALTER TABLE
On Tue, Sep 18, 2001 at 09:54:51PM -0700, Gabe E. Nydick wrote:
>
> I have a large set of tables that are 1-way replicating to an
> identical machine as the master db, and for some reason 1 table
> doesn't make it into the binary log. Why would updates to 1
> specific table not make it into the b
I have a large set of tables that are 1-way replicating to an identical machine as the
master db, and for some reason 1 table doesn't make it into the binary log. Why would
updates to 1 specific table not make it into the binary log?
Thanks,
Gabe E. Nydick
Hi,
If I have a large table (> 70million rows, nearly 4 GB Index, 2.5G Data),
and I want to
ALTER TABLE mytable TYPE=MYISAM;
ALTER TABLE mytable change column col1 col1 tinyint unsigned not null;
ALTER TABLE mytable DROP INDEX index_1;
ALTER TABLE mytable ADD INDEX index_1(col2, col1);
How to install MySQLGUI under redhat 6.2 ?
rgds,
A. Ridwan Yulianto
IT Department
PT Tabitha Express
Taman Niaga Soewarna AL-3
Soekarno Hatta International Airport
Jakarta - Indonesia
Tel. (62-21) 559 0811,559 0911
Fax (62-21) 559 0821,559 0921
E-mail: [EMAIL PROTECTED]
http://www.tabitha.com
Search the manual, check the archives, blah blah blah. This question was
answered yesterday. See forwarded message below.
dpk
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Jay Fesco" <[EMAIL PROTECTED]>; "Paul Reilly" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Mond
You will not get 3.22 to recognize MyISAM format tables.
You need to either:
1. Upgrade your server to 3.23
or
2. Find a running 3.23 server, copy your table files to that server, ALTER
TABLE xxx TYPE=ISAM; on all your tables to convert back to older ISAM
format, and copy your table files back
At 2:27 PM -0600 9/18/01, System Administrator a.k.a. The Root of the
Problem wrote:
>I am getting a
>
>Warning: Supplied argument is not a valid MySQL result resource in
>/usr/home/tsguide/html/ssi/phpfunctions.php on line 48
It means you didn't perform any error checking on the result of
your
At 3:30 PM -0500 9/18/01, Jay Paulson wrote:
>What is the command in MySQL to grab the last item that was inserted into
>the database?
>
>thanks...
>jay
If you mean the last record, there's no such command.
If you mean the most recent AUTO_INCREMENT value what was generated
during your current se
At 03:30 PM 9/18/2001 -0500, Jay Paulson wrote:
>What is the command in MySQL to grab the last item that was inserted into
>the database?
i'm 99% sure there isn't one.
a sql table is an unordered set. there is no concept of first or last. in
theory you could get the same SELECT statement retu
How do I reset the auto-increment, I have a very large value in my table,
how can I reset it or make it use a number that isnt already used. The
value is so large now that it wont increment.
Thanks in advance
Dave
-
Before po
At 7:40 PM -0400 9/18/01, Raymond Prisament wrote:
>In the course of using MySQL the following issue has come up a few times; I
>am unaware of the solution for it, but I am sure one exists, since it seems
>fairly elementary. It has to do with the COUNT(*) and GROUP BY functions.
>
>Let's say I ha
Hi Raymond,
I have been having the same problem using the GROUP BY statement, even
without the COUNT(*) function.
I'm working with PHP and the way I got around this is to use arrays. I
retrieved all rows from the table and then sorted them into seperate arrays
according to, in your case, ClientN
I was running a mySQL server under slackware for a while, it was
interacting with php on an apache webserver, and everything worked fine.
There were a few times where I would mess linux up and need to
re-install,in which case I would move my database files to my windows
partition, re-install linux
In the course of using MySQL the following issue has come up a few times; I
am unaware of the solution for it, but I am sure one exists, since it seems
fairly elementary. It has to do with the COUNT(*) and GROUP BY functions.
Let's say I have clients, and clients buy items.
table clients:
-
On Tue, Sep 18, 2001 at 01:45:30PM -0700, Dana Powers wrote:
> And my question is, if you've defined your column to have (10,2) precision,
> why would you try to insert a higher precision number?
Perhaps he's writing a report, and the application needs to know the
size of the data to expect. It'
OBLIGATORY TOPIC REFERENCE TO BYPASS FILTER: mysql
Just a quick question regarding how (if at all) the binary update log
consumes resrouces.
Are there any potential performance issues or limitations to be
expected (other than excessive consumption of diskspace) if this log is
not flushed/rotated
Hi!
> "Dana" == Dana Powers <[EMAIL PROTECTED]> writes:
Dana> Thanks for the reply! I can understand the situation with muti statement
Dana> transactions, but I'm not using transactions ( at least from my
Dana> perspective ); Im only issuing single 'atomic' statements. It would make
Dana> m
Head over to http://www.phpbuilder.com/forum/
There is an entire list there for just this problem.
Cheers
M;)
-Original Message-
FROM: Colin Faber
TO: System Administrator a.k.a. The Root of the Problem
CC: [EMAIL PROTECTED]
DATE: Tue 9/18/01 15:14
SUBJECT: Re: Error From Web Site
On 9/18/01 1:45 PM, Dana Powers at [EMAIL PROTECTED] wrote:
> And my question is, if you've defined your column to have (10,2) precision,
> why would you try to insert a higher precision number?
> dpk
>
> - Original Message -
> From: "Jim Dickenson" <[EMAIL PROTECTED]>
> To: "Dana Powers
I have deleted the Mysql 3.22.32 install and compiled
source for and installed Mysql 3.23.40.
The new installation resides at /usr/local/mysql.
Make Test did fail onlymerge
>From the command line The daemon starts perfectly with either
mysql.server startor
safe mys
Hi,
I'm getting this error with Mysql when trying to connect using a TCP
connection (not localhost connection):
"ERROR 2013: Lost connection to MySQL server during query"
This only happens on our Solaris Intel boxes. Our installations on
Solaris Sparc work fine. Also, if we downgrade to MySQL 3
Try the PHP list, This is not a MySQL error.
"System Administrator a.k.a. The Root of the Problem" wrote:
>
> I am getting a
>
> Warning: Supplied argument is not a valid MySQL result resource in
> /usr/home/tsguide/html/ssi/phpfunctions.php on line 48
>
> No results were found ...
>
> Point
And my question is, if you've defined your column to have (10,2) precision,
why would you try to insert a higher precision number?
dpk
- Original Message -
From: "Jim Dickenson" <[EMAIL PROTECTED]>
To: "Dana Powers" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, September 18,
Dear Monty and all,
In my application, on an SGI IRIX 6.5, I need to compile a program
which uses MySQL API to connect to our MySQL server. I need the -64
option to complie
my program since the lib I use are all compiled with that option. So I
need to
compile the MySQL client with '-64' optio
On 9/18/01 11:25 AM, Dana Powers at [EMAIL PROTECTED] wrote:
>
>> The problem is that a number that is in the
>> MySQL database might be a magnitude of 10 times larger than a number that
> is
>> in the PostgreSQL database.
>
> Could you explain this?
>
> dpk
>
>
> ---
On Tue, Sep 18, 2001 at 10:12:25AM -0500, Jeff Adams wrote:
> Greetings,
>
> We have an oracle database that we would like to explore using it as
> a "master" database in order to replicate it's data into, in real or
> near real time (like MySQL's replication), a set of MySQL servers.
>
> We nee
What is the command in MySQL to grab the last item that was inserted into
the database?
thanks...
jay
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the l
I am getting a
Warning: Supplied argument is not a valid MySQL result resource in
/usr/home/tsguide/html/ssi/phpfunctions.php on line 48
No results were found ...
Pointers please.
--
contact:
Dave Yadallee NetLine 2000 The Edmonton Internet Service Company
[EMAIL PROTECTED] http://www.nl2k
I believe the MyISAM format is so fast on simple SELECT count(*) FROM table;
because it actually keeps the current number of rows as a table statistic -
so it doesnt have to look at the data at all. Using a WHERE clause, however,
will force MyISAM to actually select all the rows and count how many
Hi !
)-Original Message-
)From: Mikko Lampinen [mailto:[EMAIL PROTECTED]]
)Sent: Tuesday, September 18, 2001 12:33 PM
)To: [EMAIL PROTECTED]
)Subject: MyODBC properties window / VB data environment / ADODB
)
)
)Hi,
)
)I'm using Data environment (Visual Basic) and MyOdbc to make a
)con
Sander,
>I'm thinking of switching to InnoDB, however - my application does a few
>COUNT(*) WHERE queries on large tables (somewhere between 50K
>and 2M rows)
>
>I've read up on InnoDB and its issues with COUNT(*) on entire tables,
>but is there a reason to assume that InnoDB is also sl
Run the RPM's Binaries provided by MySQL and all will work correctly.
There is something MySQL is doing in the RPM's that there not telling us
Source users.
Michael McConnell
- Original Message -
From: "djinn" <[EMAIL PROTECTED]>
To: "Rodney Broom" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECT
Hi!
I have no idea. log-update has nothing to do with InnoDB.
Try adding
skip-innodb
to your my.ini or my.cnf.
Regards,
Heikki
http://www.innodb.com
>Hi.
>I'm running mysql on NT. when I start it via mysqld everything works.
>when I try to do:mysqld --log-update,
>I'm getting message can't i
We've recently converted from MyISAM to BDB tables (transactions are
required and BDB is what was available), and have worked through all of
our problems except this one. Every so often (up to twice per day) mysql
decides to fill up gigs of space by writing out a seemingly endless
stream of 10MB l
Hi,
I'm using Data environment (Visual Basic) and MyOdbc to make a connection to
Mysql database. Every time my program establishes a connection using Data
environment, the MyOdbc property window pops up. This dialog does not appear
if connection is established using ADODB.
So, firstly, is there
Basically mysql doesn't let you use data from one table in updating another
table. If you look at the update syntax at
http://www.mysql.com/doc/U/P/UPDATE.html you'll notice the lack of a very
much needed FROM option.
later,
mike
At 01:14 PM 9/18/2001 +0100, you wrote:
>Hi everyone.
>
>I'm t
Hi.
I'm running mysql on NT. when I start it via mysqld everything works.
when I try to do:
mysqld --log-update,
I'm getting message can't initialize innodb as 'innodb_data_file_path' is not
set. I didn't see anything about innodb being related to log-update option
in the manual or MySQL book.
I'm thinking of switching to InnoDB, however - my application does a few
COUNT(*) WHERE queries on large tables (somewhere between 50K
and 2M rows)
I've read up on InnoDB and its issues with COUNT(*) on entire tables,
but is there
a reason to assume that InnoDB is also slower when ther
China Financial Guide 2002 has been published!
China has emerged as the most important market in Asia. The attractiveness of China
market is further enhanced with China joining the World Trade Organization. No
organization can afford to ignore this important market in Asia. The vast and untapp
I assume you've done the slow-query-log review thing... making sure all your
queries are fast, yes?
dpk
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Stefan Pinkert" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, September 18, 2001 11:22 AM
Subject: Re: AW: MySQL is hogg
(to answer a couple of posts at once):
Our machine was seeing less than 20 connects / sec. The problems
continued after we broke largeish (although only about 350,000 records,
indexed) tables into smaller ones and verified/optimized all code that
makes mysql queries. We have a good mix of selec
if you chmod a directory to 666, it will not be searchable.
robirossi wrote:
> I ve installed on my slackware 8.0 mysql + php 4.0.6
> I can connect mysql server on line command, but
> with the command connect in php, every time I try
> to connect, I recieve this message ( example)
>
> Warning
I am having a similar sort of problem, 88k+ records (syslog entrys) doing a
select * from db group by host takes 2.5seconds select * where with a host
with 87k records takes 5.7seconds. CPU useage jumps up to to between 10 and
99.9% With a single proc linux box the exact same happened but with les
> The problem is that a number that is in the
> MySQL database might be a magnitude of 10 times larger than a number that
is
> in the PostgreSQL database.
Could you explain this?
dpk
-
Before posting, please check:
http://
The quickest way to get this in front of developers is to provide a
reproducible test case. I know they like to use the new mysql-test stuff,
but its not heavily documented, so bash scripts or perl scripts are probably
fine too. This may also help other people confirm the problems that you are
see
> There are some others with a similar problem(including me). The question
> still remain,
> if it is all caused by the same bug(?).
> What table-types do you use? (MyISAM,Merge,BDB,...)
MyISAM
> How many entries are in the tables?
Up to 145000 in some of the tables. But its not the usual
Agreed. Definitely odd that it doesnt behave exactly as documented, but it
does provide (9,2) precision, non? The fact that you can squeeze (10,2) into
the column in certain cases doesnt bother me.
Of course, if you came up with a patch to fix it, I dont think anyone would
complain.
dpk
- Or
From: Stefan Pinkert <[EMAIL PROTECTED]>
> There are some others with a similar problem(including me).
Hi guys. I'd be really interested in knowing things like how many requests, and of
what type, are being made of your database(s). If you're making a couple of dozen
SELECTs per day, then I'd
I have posted before regarding a problem with mysql 3.23.41 hitting some
sort of threshold limit and spawing threads like crazy. I have seen
others post here with the exact symptoms, from what I understand these
are all linux boxen. I have personally tested it with the 2.4 series of
kernels, and
There are some others with a similar problem(including me). The question
still remain,
if it is all caused by the same bug(?).
What table-types do you use? (MyISAM,Merge,BDB,...)
How many entries are in the tables?
How many queries/second?
Do the queries use indices?
> Hi all, this is my first q
I ve installed on my slackware 8.0 mysql + php 4.0.6
I can connect mysql server on line command, but
with the command connect in php, every time I try
to connect, I recieve this message ( example)
Warning: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2) in /var/www/ht
> "Chase" == Chase Peeler <[EMAIL PROTECTED]> writes:
> There is alot of important info in those tables, and I really need
> them.
Sorry to broadcast this to the whole list, but Chase's supplied email
appears to be invalid, or at least bouncing at the moment:
Chase, I'm in the NCBI part of
I'm sorry. When did it start supporting raw disk devices? As
far back as I can remember, MySQL stores it's data files on an
existing filesystem, in 3 separate files: .frm, .MYI, .MYD.
Ah, InnoDB apparently supports raw disk files. I suppose I
should have said that the NATIVE MySQL backend doe
First, there is no need to reinstall.
For future reference, if you forget your password - check the manual for an
easy way to fix: http://www.mysql.com/doc/R/e/Resetting_permissions.html
For a mysql that wont start, check the error log and isolate what the
problem is ( it probably isnt that hard
Hi all, this is my first question on this list and I hope that you can
help me. I've got one dedicated box for MySQL and it's going downhill just
by starting the DB. The box is a dual PIII 800Mhz, 1 Ghz RAM, Linux RedHat
6.2 w/ kernel 2.4.6SMP, SCSI Drives and plugged to a 100Mb internal
networ
Thanks so much to everyone who replied I got it working perfectly you guys
rule!
Armando
On Tuesday 18 September 2001 09:56 am, you wrote:
> > I try the following command, and get that error every time:
> >
> >
> > mysql> select company, tele, contact, mariacust.comments
> > -> from
> >
On 9/18/01 8:01 AM, Chris Johnson at [EMAIL PROTECTED] wrote:
> On Sun, Sep 16, 2001 at 02:11:20PM -0700, Jim Dickenson wrote:
>> Does anyone have an opinion about the following? Are people using decimal
>> type fields? Is it important for the database to allow only allowed data?
>
> I use decim
Hi!
>Hi,I'm a beginner with MySql. Could anyone give me an example how transaction
>isolation works on InnoDB tables under Win2000? (If you have any examples
>I'll be happy). Thanks in advance.
>Adi
Below is pasted an example from the InnoDB
manual at http://www.innodb.com/ibman.html
When y
Hi,
> Odd numbers round properly at the half (3.5) but even numbers
> don't (4.5).
This sounds like you're misunderstanding an intentional feature. A lot of
applications or system libraries do this to avoid giving 'incorrect' figures
when summing large amounts of rounded numbers.
Here's an exam
>
> I try the following command, and get that error every time:
>
>
> mysql> select company, tele, contact, mariacust.comments
> -> from
> -> customers where tele = mariacust.tele GROUP BY company;
> ERROR 1109: Unknown table 'mariacust' in field list
> mysql>
>
>
> I don't quite underst
Valentin Kulikov wrote:
> while:I have set 'myname' as a user name. Somebody (MyODBC? Windows2000?)
> added a suffix '@mydialup-provider.com' to my db user name.
> Or maybe a problem is in something else and a diagnostic is incorrect?
Unless you connect to MySQL via a unix socket, the hostname o
I have a problem with MyODBC trying to connect to MySQL from Access 2000 on
Windows 2000 pro via dialup connection.
On my work machine everything is OK, I'm running WindowsNT 4.0, Access 2000
and have a permanent Internet connection. Connection to MySQL situated at
some Internet provider server i
Mariacust must be included in you FROM list:
SELECT ...
FROM customers, mariacust
WHERE ...
-Original Message-
From: Armando Cerna [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 12:16 PM
To: [EMAIL PROT
I try the following command, and get that error every time:
mysql> select company, tele, contact, mariacust.comments
-> from
-> customers where tele = mariacust.tele GROUP BY company;
ERROR 1109: Unknown table 'mariacust' in field list
mysql>
And yes... the talbe exists.
mysql> sho
Try this:
SELECT *
INTO OUTFILE 'mytable.txt' FIELDS DELIMITED BY '\t' LINES DELIMITED BY
'\r\n'
FROM mytable;
Then, in Access, use the Import wizard and specify tabs as your field
delimiter and set your field qualifier to (defaults to double-quote).
Optionally, you could prepend the text file
Peter Zaitsev wrote:
> I'm quite lucky with providing with bad tables which does not repear
> properly or having other strange behavior.
Sometimes when myisamchk does not work (or it says it has repaired the table
but it quickly become corrupted again), I find that dumping and reloading
the
Troy,
If you cannot connect to it, how do you use?
Christopher Reed
Application Analyst
Information Technology
City of Lubbock
[EMAIL PROTECTED]
>>> "Troy Montour" <[EMAIL PROTECTED]> 8:40:52 AM 9/18/2001 >>>
Christopher,
no this won't work for me because the hoster has it set-up weird tha
Can MySQL client be built from source using the Sun Forte compiler (i.e.
/usr/SUNWspro/bin/cc)?
If so, then what are the proper ./configure settings (in addition to
--without-server) for using this compiler?
Calling ./configure --without-server succeeds with /usr/SUNWspro/bin as my
default comp
Some thing like this mite work?
delete from b
where id.a != id.b;
Simon
-Original Message-
From: Lyubomir Simich [mailto:[EMAIL PROTECTED]]
Sent: 18 September 2001 16:15
To: [EMAIL PROTECTED]
Subject: need query
Hello,
May I use a query like this?
DELETE FROM b WHERE id NOT IN (
What logs will a oracle database output?
If these logs can be feed in to MySQL in the way replication works you are
sorted.
But I do not know much about oracle.
The only thing is MySQL will no do some of the stuff that Oracle will so
some thing mike fail.
Simon
-Original Message-
From:
>Description:
Odd numbers round properly at the half (3.5) but even numbers don't (4.5).
>How-To-Repeat:
mysql> select round(15.5);
+-+
| round(15.5) |
+-+
| 16 |
+-+
1 row in set (0.01 sec)
mysql> select round(16.5);
+-+
| round(16.5)
Hi!
On Sep 18, [EMAIL PROTECTED] wrote:
> >Description:
> I just moved all of our mysql files over from a machine Running
> Solaris 8 to a machine running Linux Redhat. I then installed the latest
> version of mysql. For some reason, I get an error when trying to access
> any table tha
Hello,
May I use a query like this?
DELETE FROM b WHERE id NOT IN (SELECT id FROM a)
What can I do for make it?
--
Best regards,
Lyubomir mailto:[EMAIL PROTECTED]
-
Before posting, please check:
Greetings,
We have an oracle database that we would like to explore using it as a
"master" database in order to replicate it's data into, in real or near
real time (like MySQL's replication), a set of MySQL servers.
We need only one way replication (oracle -> MySQL), but the replication
needs
"Mark Johnson" <[EMAIL PROTECTED]> writes:
> I must be a moron but I can't seem to figure out what I need to do to get
> mysql to work on RH, on Mandrake it just worked straight away.
"chown -R mysql.mysql /var/lib/mysql; chmod a+rX /var/lib/mysql"
An errata was issued when RHL 7 was release, a
On Sun, Sep 16, 2001 at 02:11:20PM -0700, Jim Dickenson wrote:
> Does anyone have an opinion about the following? Are people using decimal
> type fields? Is it important for the database to allow only allowed data?
I use decimal datatype fields all the time for my monetary amounts. I've
always t
On Tuesday 18 September 2001 14:14, Andrew Dixon wrote:
> Hi everyone.
>
> I'm trying to do the following update, which someone at Macromedia gave me,
> however I get a SQL error when I'm trying to use it with MySQL, any ideas
> on what is wrong.
A general lack of support in MySQL for this kind o
mySQl-to-Access 1.1 works great but it's not free. The trial version only
converts 5 records.
It's at http://www.convert-in.com/demos/sql2accd.exe
Chris
- Original Message -
From: "Troy Montour" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 17, 2001 22:56
Subject: Q
>Description:
I just moved all of our mysql files over from a machine Running
Solaris 8 to a machine running Linux Redhat. I then installed the latest
version of mysql. For some reason, I get an error when trying to access
any table that is of the ISM format. I can've even convert th
Hi Dean,
Thanks for the reply...
I indeed also thought of the mistake that I reversed the parameters...
Though I must say that all the other tables in the directory (luckily) still worked..
But reading your words it looks to me as if not a easy (unpossible) table to repair..
This really was ba
I had a similar problem on a win2k system when I started using mySQL. I
changed the user and password in phpmyadmin's config.inc.php. Or you can
change it in the my.ini file.
This might be alot more complicated with a unix system.
- Original Message -
From: "GUYOT Carole" <[EMAIL PROTEC
Christopher,
no this won't work for me because the hoster has it set-up weird that I
can't connect to it that way.. I have tried everything to go that way.
thats why I was looking for the dump import option..
Anybody have any other ideas??
Thank you
Troy
- Original Message -
From:
Hi!
I would like to know how to sort strings in MySQL according to the
national charakter set in Windows (CZECH). I have read about it on
other platforms - compiling issues, but could not get the right help
for me.
Thanks a lot !!!
Jan
database,sql,query,table
---
I've changed root's password via netscape with phpmyadmin and then
reloaded.
It's not possible to connect anymore. The system asked for a new
password but didn't accept the new one.
So, I've tryed to re-install mysql again
version : MySQL-3.23.38-1.i386.rpm on redhat Linux.
Now, when I try to con
The only think I did was copy 'my-medium.cnf' to 'my.cnf' and ran
mysql_install_db (successfully) and then ran mysqld & as instructed which
didn't run successfuly and reported the errors below. I didn't change
anything in my.cnf, I didn't touch anything at all...
Is there a way that I can start
On Tuesday 18 September 2001 03:16, powlow wrote:
> latest rpm on redhat
> MySQL-3.23.42-1.i386.rpm
>
> any ideas? i've installed and compile mysql on other machines before and
> never had any problems (appart from sock file which was easily solved).
Provide the output of mysqlbug...
Also, what
Hi everyone.
I'm trying to do the following update, which someone at Macromedia gave me,
however I get a SQL error when I'm trying to use it with MySQL, any ideas on
what is wrong.
update general_users
set rolling_total = sumUsr.rollingTotal
from
(
select id,sum(jan+feb+mar+apr+may+jun+jul+aug+s
SELECT * from tipps
WHERE (name like '%&name%' OR '$name' = '')
AND (stadt = '$stadt' OR '$stadt' = '')
AND (kueche = '$kueche' OR '$kueche' = '')
ORDER by $order ASC LIMIT $start, $limit
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 18 september 2001 13:05
To: M
If this is your query, you might have a problem at the first 'AND' :
SELECT * from tipps AND name LIKE '%$name%' AND stadt = '$stadt' AND kueche=
'$kueche' ORDER by $order ASC LIMIT $start, $limit
should be:
SELECT * from tipps WHERE name LIKE '%$name%' AND stadt = '$stadt' AND
kueche= '$kueche
am 18.09.2001 12:30 Uhr schrieb Chris unter [EMAIL PROTECTED]:
> Post your query
SELECT * from tipps AND name LIKE '%$name%' AND stadt = '$stadt' AND kueche
= '$kueche' ORDER by $order ASC LIMIT $start, $limit
Michael Paffrath
fatmedia - agentur für interaktive medien
Schillerstraße 6
50968 Köl
Post your query
- Original Message -
From: "Michael Paffrath" <[EMAIL PROTECTED]>
To: "MySql" <[EMAIL PROTECTED]>
Sent: Tuesday, September 18, 2001 12:10
Subject: multiple select
hi!
i am rather new to mysql and i have problems with a multiple select
statement.
i have a search form wh
Hi,
I'm a beginner with MySql. Could anyone give me an example how transaction
isolation works on InnoDB tables under Win2000? (If you have any examples
I'll be happy). Thanks in advance.
Adi
-
Before posting, please check:
h
hi!
i am rather new to mysql and i have problems with a multiple select
statement.
i have a search form where the user can choose 4 conditions, when all 4
conditions are chosen i get a result but when the user just chooses 1,2 or 3
conditions i get a mysql error...
does anyone know a workaround
I encounter this error using mysql and php (well, not I'm using mysql,
its a hosted server (not dedicated), so maybe just the disks are full or
so... has anyone another explanation?
little urgent, site is down (nobody changed the code, it just stop
functioning - maybe there have been new entries
latest rpm on redhat
MySQL-3.23.42-1.i386.rpm
any ideas? i've installed and compile mysql on other machines before and
never had any problems (appart from sock file which was easily solved).
-powlow
- Original Message -
From: "Sasha Pachev" <[EMAIL PROTECTED]>
To: "powlow" <[EMAIL PROTE
Rock,
>Hi,
>Does MySql support Synchronous or asynchronous I/O or
>both?
>What do they mean when they ask me if-
> copy Db is supported by mysql?
I am not sure what this means. MySQL has replication
capability yes.
> version db is supported by mysql?
The meaning is not clear. The InnoDB table
Hi,
I'm trying to install MySQL into my Mac OS X 10.0.4
But i encountered problems halfway through the installation. I created a new
netinfo directory mysql. After 'gunzip' and changed into the top-level
directory, the './configure --prefix=/usr/local/mysql doesn't seem to
workand there's no
Hello mysql,
Hello mysql,
I'm quite lucky with providing with bad tables which does not repear
properly or having other strange behavior.
Here is one more:
mysql 3.23.42
gnome:~ # mysqldump -d layers_st57 g01kw_engines
# MySQL dump 8.16
#
# Host: localhostDatabase: layers_st57
#--
1 - 100 of 102 matches
Mail list logo
