Hi, All.
Help me to understand why such different speed of two queries. These queries do the
same and differ only in superfluous information (marked by red). Speed of the first is
0.37 second. Speed of the latter is 3.95 second.
The first:
SELECT DATE_FORMAT(visits_1.date_time_visit,
skick writes:
I am havving the same problem. I even tried compiling a version. If it
is a window manager problem then how do I fix it. It seems like it
should work wiith both the kde 2.0 window manager and the enlightenment
window manager that is part on gnome.
Hi!
Please try to
On Tue, 26 Jun 2001 16:21, [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:
database,sql,query,table
If you just reply to this
Hi!
Last time I sometimes get this messages:
ERROR 1049: Unknown database 'stat
Database exist and I put many records to tables in this DB.
But sometimes I get this message.
This DB have many tables, now ~730.
Why I get this messages. Can I fix this?
PS
OS - FreeBSD 4.3-STABLE
max open file -
hi everybody,
i have a problem with installation of mysql ++ api 1.7.9.
os: sun solaris 5.6
mysql version 3.23.33
after unpacking the archive with tar, autorun and autoconf i started configure.
everything was working fine ,
but make gave me the following message:
hiya,
I've had exactly the setup you describe running on a laptop,
(I've since switched to nt / linux ), download mysql,myodbc,
and optionally mysqlfront. Just run the setup programs for mysql
and myodbc (very easy), and you are all set up. If you create
a odbc connection for you database you
Nick,
What happens to the time if you run the following on your database:
SELECT DATE_FORMAT(visits_1.date_time_visit, '%Y-%m-%d') AS dt,
Count(DISTINCT visits_1.id_visitor) AS cnt, visits_1.id_visitor,
visits_1.id_visit, visits_2.id_visitor, visits_2.id_visit,
visits_1.visit_number,
hello
I am engeneer and i use mysql .
can you help me please in this questions:
1- tell me what is the language(arabic,french,english...) of the mysql
database data.
2- can we create a database that contain melange of arabic and latin data if
it is possible , how?
Hi,
Even i am getting the following error while doing ./configure:
os: solaris 8 sparc
mysql: 3.23.39
/configure
loading cache ./config.cache
checking host system type... sparc-sun-solaris2.8
checking target system type... sparc-sun-solaris2.8
checking build system type... sparc-sun-solaris2.8
We're having quite a lot of difficulty with MySQL's fulltext search. The
problem is that it does partial matches. E.g., john matches johnson. Thus
a match of author against dickens takes about 0.09 seconds with a 700,000
record table, but a match of a shorter word takes a good deal longer - a
hey bob,
thanks for getting back to me - here's the full set up
i have a pc running windows98, apache, php and mysql. it sits on our
ethernet network and i connect to it via my mac using the ip address i have
set up in the network control panel on the pc. i use the mac for building
and the
Hi All,
I've been reading up on how to do joins on the mysql site.
Is there not an inverse function for DISTINCT, so that I can pull out
duplicate data as opposed to DISTINCT data...or will I have to get this
information by using joins?
Thanks very much for your help.
Anna
Your question has been answered already.
http://marc.theaimsgroup.com/?l=mysqlm=99348999221821w=2
Hi All,
I've been reading up on how to do joins on the mysql site.
Is there not an inverse function for DISTINCT, so that I can pull out
duplicate data as opposed to DISTINCT data...or will
Hi,
I have a Linux machine (Linux cartman 2.4.2-2smp #1 SMP Sun Apr 8 20:21:34 EDT 2001
i686 unknown) that is running MySQL 3.23.38-log and now I have a table that is getting
VERY near to the ext2 filesystem limitation of 2gb. Exact size of the table is:
2039867196 :) So my question is. What
Hello there - I have this weird problem using MySql (version 3.23.39).
It seems that MySql interpretation of a SELECT statment using HAVING is
completely random.
I have a table called RobotRun which stores information about when a robot
has been running (start, stop and the id of the robot).
Hello Matthew
I would be quite interested to know how you managed to make a
partial search. I built a search engine recently using fulltext, and
partial searches would never work. Say I type in child, I would never
get any results with children.
This is quite weird since you seem to want it the
Hello everybody,
I thing, that I have a problem that needs a sequence and that
auto-increment can't do the job this time.
I already consulted the manual and the mailarchive.
I saw several different proposals, now I'm a bit confused and don't
know exactly what the rigth way is to do it.
Could
If you searched for '% john %' - note the spaces, you would not find
'johnson' etc..
-Original Message-
From: Matthew Brealey [mailto:[EMAIL PROTECTED]]
Sent: Tue, 26 June 2001 11:29
To: [EMAIL PROTECTED]
Subject: Full text search gotchas
We're having quite a lot of difficulty with
At 13:53 +0200 2001-06-26, Bruce Stewart wrote:
If you searched for '% john %' - note the spaces, you would not find
'johnson' etc..
*Sigh* Since when do wildcards work with the fulltext index?
Besides, there are characters beside a space wich can delimit words.
Three examples: Commas. Line
Hello,
thanks for your reply. I was wondering...I thought the LIKE function
is only for single words? I have to admit I never tested it and started
right off with fulltext option.
So would following work then...
Lets assume one entry in somefield is: The children are playing on the
play-ground
mysql select * from test;
+---+---+
| a | b |
+---+---+
| 1 | The children are playing on the play-ground
David Robley writes:
I came across this discussion from April 2001 on the archives, but
nothing more recent. I also have encountered the problem, and thought I
could submit a bit more information.
OS - Linux 2.4.3
XFree - 4.0.2
KDE- 2.1.1
The problem is not exactly that
Peter Volke writes:
hi everybody,
i have a problem with installation of mysql ++ api 1.7.9.
os: sun solaris 5.6
mysql version 3.23.33
after unpacking the archive with tar, autorun and autoconf i started configure.
everything was working fine ,
but make gave me the following message:
[EMAIL PROTECTED] writes:
Any idea when we'll be able to get our grubby little paws on VCC?
I was trying out mysqlgui last night, and i found it did'nt add much
to using the command line client, So i'd be interested to see where you
are going with it.
Thanks
Sean
Regarding mysqlgui,
On Mon, Jun 25, 2001 at 06:52:34PM +, patrick ward wrote:
Hello Mr. Ziegler,
I'm sorry if I'm intruding and promise not to do so again without your
consent but our db replication has come to a grinding halt with the error
'bad magic number, fire your magician'. I'm at my wits end
At 13:49 +0200 2001-06-26, Gunnar von Boehn wrote:
Lets take a single row, integer value for holding the sequence:
CREATE TABLE sequence(
id int4;
);
That works, though I would use a single table for all sequences, not
a new table per sequence.
The other solution would be to do check the
According to the MySQL documentation, it doesn't currently support full
outer joins and won't do in the immediate future. Does anyone have any
suggestions for a workaround?
I need to join three tables, only one of which has a common identifier with
the others, and produce a result which
Hi,
what does mean following ...
mysql show processlist;
++--+---+--++---+-+--+
| Id | User | Host | db | Command| Time |
State | Info |
Ok
Each Status ID is a thread and you can kill them with KILL "thredidnumber".
Delayed insert is just a sql insert command that has low priority.
Sleep is a thread that is kept open incase you would like to use it agene.
Question: How many thread do you allow on your set-up?
You have hit 102
Guðmundur Ólafsson [EMAIL PROTECTED] writes:
Hi,
I have a Linux machine (Linux cartman 2.4.2-2smp #1 SMP Sun Apr 8
20:21:34 EDT 2001 i686 unknown) that is running MySQL 3.23.38-log and
now I have a table that is getting VERY near to the ext2 filesystem
limitation of 2gb.
Ext2 doesn't
Running Unix, Apache, MySQL and PHP, should I worry about delay times, and
will the server always present the user with the latest database update
(after a possible delay)?
Suppose a user can add a new row to a database in a PHP page with a form,
and after submit, the next page he will see is
lipp maimone wrote:
is someone abble to tell me how can i do for running an sql database with windows98
without crashing my systeme?
Also, using asp ( activex server page ), is it possible with mysql version3,23?
Its most likely that you don't have enough memory on your system. If you
Hello,
I am developing a data application using wxWindows 2.2.7 on Redhat
Linux 7 with MySQL at back-end. When I try to connect to MySql
Database sometimes it says Segment fault (Core dumped) error.
Pls help.
Sudheer.
-
Hello,
I am developing a data application using wxWindows 2.2.7 on Redhat
Linux 7 with MySQL at back-end. When I try to connect to MySql
Database sometimes it says Segment fault (Core dumped) error.
Pls help.
Sudheer.
-
Sudheer Palapparambil [EMAIL PROTECTED] writes:
I am developing a data application using wxWindows 2.2.7 on Redhat
Linux 7 with MySQL at back-end. When I try to connect to MySql
Database sometimes it says Segment fault (Core dumped) error.
Which version of mysql?
--
Trond Eivind
Please send relevant pieces of code!
Hello,
I am developing a data application using wxWindows 2.2.7 on Redhat
Linux 7 with MySQL at back-end. When I try to connect to MySql
Database sometimes it says Segment fault (Core dumped) error.
Pls help.
Sudheer.
How do I define cursors in mysql as in Oracle?
Here is an example in Oracle:::
Cursor CurPerson is
Select Arstall_Godkj_Stkomp
From Person
Where Fodselsdato = inFDato And
Personnr = inPNr;;
Begin
Open curPerson;
Fetch CurPerson
I am administering a MySQL database that needs to be accessed by people who
don't know SQL. They need to be able to add and delete records, but they
don't need to be able to alter the structure of the database. Does anyone
know of a simple Windows app or web interface that I can throw on my
Try PhPMyadmin
http://phpwizard.net/projects/phpMyAdmin/index.html
Simon
-Original Message-
From: Mike Schwartz [mailto:[EMAIL PROTECTED]]
Sent: 26 June 2001 16:33
To: [EMAIL PROTECTED]
Subject: Simple Graphical Interface
I am administering a MySQL database that needs to be
A simple question...
I noticed that the newer MySQL binaries are listed as being for Solaris 2.7+
(mysql-3.23.39-sun-solaris2.7-sparc.tar.gz)
I want to run it on Solaris 2.6, will this run OK??
There didn't seem to be any docs relating to this (would be nice to see
these kind of comments in
Try
SELECT robotId, max(startTime) as crit
FROM RobotRun
WHERE startTime = '2001-06-26 00:00:00'
AND endTime IS NOT NULL
GROUP BY robotId
This should return the robotId and the most recent startTime labeled 'crit'
for all records specified in the where clause. And have a look in the manual
for
Slight correction in the query...
The query just looks like:
REPLACE into reflectivity.measurement_extended_data set content_typeID =
7, contentID = 121529, arrayID = 0, positionID = 1, testID = 1,
iteration = 0, test_locationID = 1, date_added = 993165848, added_by = 18,
data = '396
Just installed 3.23.37 on Red Hat 7.0 from source. I've done this a few
times but this time I encountered a mysterious problem.
a) server is started and runs under my designated user (mysqladm:mysqlgrp)
b) /usr/local/mysql/bin is in PATH of both root and mysqladm
c) using either of these users,
The above only implies that your program exited without calling
mysql_close(). Nothing to do with your problem.
But.. why would the console be reporting this? Ie, I'm getting the same
result (same error in the error log, same truncation) when I manually
pipe the query to the mysql console.
I have a MySQL myISAM database that has about 300 MB of information.
Recently the index files became corrupted and I ran the myisamchk
*.MYI -r -S to repair them.
Ever since then mySQLd process has been using up a ton of processor time.
And some of the queries that I run have started taking a
Could it be that you have two mysql client binaries accessing two different
config files - some remainders of a previous MySQL installation?
Hannes
On 6/26/01 9:02 AM, Peter Matulis [EMAIL PROTECTED] wrote:
Just installed 3.23.37 on Red Hat 7.0 from source. I've done this a few
times but
You must have an rpm installation of mysql and your source installation.
Check to see if there are mysql* commands within /usr/bin directory. It's
going to search there first, then /usr/local/bin. The commands within
/usr/bin are going to look for the mysql-everthing within /var/lib/
Jonathan
Hi Gunnar,
Why don't you keep the key out of the business rule and create a column to
identify the type of customer?
How are you going to handle the application when your business reaches more
than vip customers???
This is an issue that can be avoided by creating a type column .
Hi Tom,
The solution to your problem could be simple if the redundancy is across all
fields. Then you could simply issue a
CREATE table distinct_records
SELECT distinct field_1,.field_last
FROM table_duplicate_records
WHERE 1=1;
Or
CREATE table distinct_records
SELECT
Hi, I don't know if you can use 2.7+ in a 2.6.
However I downloaded and compiled the source without no problems. Until now it's
running ok.
Please, tell me if I can help!
{}S
Jose Vilmar Estacio de Souza
MailTO: [EMAIL PROTECTED]
+ 55 21 7894-3041
INFORMAL INFORMATICA
I had the same problem last night,
eventually grant all to root on *.* identified by 'yourpass' got me in
I must have mucked up the permissions at
(the problem was with mysqlgui not mysqlshow though)
Sean
-Original Message-
From: Peter Matulis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
On Tuesday 26 June 2001 04:49, Gunnar von Boehn wrote:
Hello everybody,
I thing, that I have a problem that needs a sequence and that
auto-increment can't do the job this time.
So, I think the only way to solve this is a sequence table.
Lets take a single row, integer value for holding
NUMBER(8,5). You'll need around 5 digits after the decimal point. (Think GPS
accuracy == 10 meters for high-grade, 100 m for dumbed-down civilian use. At
the equator, that's 0.9 or 0.0009 degrees respectively. At higher
latitudes, that'd be correspondingly less.)
If you value accuracy, DON'T
Recently the index files became corrupted and I ran the
myisamchk *.MYI -r -S to repair them.
Try an OPTIMIZE TABLE or ANALYZE TABLE. Your queries may be using the
incorrect indexes since the statistics have not been updated.
You can also do this: myisamchk *.MYI -a
Sincerely,
Steven
At 1:49 PM +0200 6/26/01, Gunnar von Boehn wrote:
Hello everybody,
I thing, that I have a problem that needs a sequence and that
auto-increment can't do the job this time.
I already consulted the manual and the mailarchive.
I saw several different proposals, now I'm a bit confused and don't
I want to prevent duplicate entries into my mysql database which holds
invertory of all network eqpt at my site. Engineers access it thru
netscape and the query insert is done via pdp [below].
I will place the script into php, any pointers on this would be
appreciated.
THX!
Pete
html
I appreciate that this might be a bit off topic but any help would be
appreciated.
I need to port this program (attached) to the Linux environment. This
is the first program I have attempted to port.
Has anyone ever had to port from Windows to Linux\Unix, and if so how
did it go and what
-- Original Message --
From: Pete Kuczynski [EMAIL PROTECTED]
Date: Tue, 26 Jun 2001 13:19:02 -0500
I want to prevent duplicate entries into my mysql database which holds
invertory of all network eqpt at my site. Engineers access it thru
netscape and the
It's possible get the number of years between two dates in a mysql
function?
thanks,
Augusto
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hello,
I was wondering, how can I lookup how much memory MySQL is currently allowed
to use, and how can I change this value?
Thanks in advance,
Leon Mergen
[EMAIL PROTECTED]
BlazeBox, Inc.
ICQ: 55677353
-
Before posting,
How do I get a default date time in the create table clause...
I have tried
Create table(
CreationDateDATETIMEDEFAULT NOW(),
Infovarchar(100)
);
Create table(
CreationDateDATETIMEDEFAULT NOW(),
Infovarchar(100)
);
Create table(
Hi... I downloaded the mysql binary for HPUX10.20 and when I run
script/mysql_install_db I got the followin message:
---
$ scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
How do I get a default date time in the create table clause...
I have tried
Create table(
CreationDateDATETIMEDEFAULT NOW(),
Infovarchar(100)
);
Create table(
CreationDateDATETIMEDEFAULT NOW(),
Infovarchar(100)
);
Create table(
Hi,
i found a method to do this:
try
extract(year from date1) - extract(year from date2)
I hope it will work
Michael
-Ursprüngliche Nachricht-
Von: Augusto Cesar Castoldi [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 26. Juni 2001 19:06
An: [EMAIL PROTECTED]
Betreff:
hallo!
i have a backup-problem:
when i use
mysqldump -u michael -p --opt --all-databases backup
i get the following error:
USE backup;
mysqldump: Got error: 1017: Can't find file: 'title.MYD' (errno: 2) when
using LOCK TABLES
but when i use
mysqldump -u michael -p --opt --database books
Can Cold Fusion querys work with MySQL? What would I have to do if
anything to make it work?
WD
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
(sql, to fool lame filter)
ryc [EMAIL PROTECTED] writes:
The OS may not have a 2GB limit, however the table MAY. If you do a
myisamchk on the table it will tell you if you are running out of space in
the table. If you are.. you need do something like alter table tablename
My primary key field is a auto incremented index, the field I want to
make unique, or to say, prevent duplicates in, is the hostname field,
which has, hostnames of devices. Is the key word UNIQUE then?
Not all of the devices have hostnames assigned to them, like terminals,
so the hostname field
Install an ODBC for MySql...
- Original Message -
From: Wade DeWerff [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 26, 2001 2:57 PM
Subject: CF and MySql?
Can Cold Fusion querys work with MySQL? What would I have to do if
anything to make it work?
WD
There are many ways to do this - I'm assuming you want to do this on an
Windows box.
One way is through MyODBC. It's an ODBC driver that you can install on your
server, available from the MySQL web site. From there, all you have to do is
create a new DSN, either through the CF Admin or Windows.
If you are using Cold Fusion server, yes they will work..
You have to download MyODBC from www.mysql.com install it.. and then set it
up in the ODBC control panel (assuming you are using windows).
Then you should be able to see the mysql databases as a datasource in the
Cold Fusion admin page.
Has anyone ever attempted, or succeded in converting a Btrieve database to a
MySQL database?
Peter Marchetti
Media Visions, Inc.
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the
hi.
check out the TIMESTAMP column type...maybe TIMESTAMP(14) as the column
type?
you can then format the date accordingly with...uh...DATE_FORMAT() in your
select statements...
hth.
-ravi
-Original Message-
From: Richard Bates [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001
At 3:05 PM -0300 6/26/01, Augusto Cesar Castoldi wrote:
It's possible get the number of years between two dates in a mysql
function?
That kind of depends on what you mean by the number of years between
two dates. For example, do you define the number of years between 2000-12-31
and 2001-01-01
At 2:43 PM -0400 6/26/01, Richard Bates wrote:
How do I get a default date time in the create table clause...
The MySQL Reference Manual states that DEFAULT values must be constants.
Insert NOW() into the field when you create new records.
I have tried
Create table(
CreationDate
On Tue, Jun 12, 2001 at 04:42:42PM -0700, Jeremy Zawodny wrote:
On Tue, Jun 12, 2001 at 05:06:59PM -0500, Zhu George-CZZ010 wrote:
Is there a way/tool to migrate the Application from MySql to Oracle
8i?
Oracle has one available on their web site...
Mostly a waste of space.
Tim.
But how about TIMESTAMP?
For example:
CREATE TABLE time_test (creation_date TIMESTAMP, info VARCHAR(100));
This should work fine too,doesn't it?
-sherzodR
On Tue, 26 Jun 2001, Paul DuBois wrote:
At 2:43 PM -0400 6/26/01, Richard Bates wrote:
How do I get a default date time in the
Can someone explain me why is it waste of space???
Thank you
-sherzodR
On Tue, 26 Jun 2001, Tim Bunce wrote:
On Tue, Jun 12, 2001 at 04:42:42PM -0700, Jeremy Zawodny wrote:
On Tue, Jun 12, 2001 at 05:06:59PM -0500, Zhu George-CZZ010 wrote:
Is there a way/tool to migrate the
Ok,
The message set that I noticed this morning sparked my interest in this.
Currently I'm developing a search engine that will utilize mysql's
fulltext match technology. The problem that i've run into is, I can't
seem to find any documentation on how to force an AND search with in
MATCH
Is their a C++ API library which is able to work on BOTH Windows (2K)
and Linux.
I need the SAME library to work on both platforms. I take it neither of
the top two will work (list below): Borland or MS libraries. What are
the other two.
I need to write a program which is portable to both
-- Original Message --
From: Pete Kuczynski [EMAIL PROTECTED]
Date: Tue, 26 Jun 2001 14:02:08 -0500
My primary key field is a auto incremented index, the field I want to
make unique, or to say, prevent duplicates in, is the hostname field,
which has,
On Tue, Jun 26, 2001 at 05:20:25PM -0400, Sherzod Ruzmetov wrote:
Can someone explain me why is it waste of space???
No support for emulating autoincrement fields.
No support for mysql specific types.
No support for mysql specific functions.
No support for ...
In fact no support for almost
I'm not an expert, but I've never heard of a db getting slower after an
index rebuild. It's possible that's just a red herring.
You've been speaking generally about things being slower, I'd suggest you
get specific. Track down the queries are slow now, use EXPLAIN on them to
see what
hello all,
I am kind of new to all the unix OS stuff. Lately i have been doing alot of work
in FreeBSD, and i have started playing with mysql. I got it to install and
everything, the only problem i am having, is i can't seem to connect from anywhere off
the machine, i run the grant
Hi to all,
I'm new to linux and mySql (about 5 days and nights :)), I have mandrake8.0
that provide a version of MySql which I'm trying to use from a VisualBasic
application (on win2000), I connect to my database on MySQL using MySqlODBC,
and everyting goes OK, except the table names wich I need
Don't know what a COPY RECORD command is but my best guess is that you are
looking for a create table with a select clause.
- Original Message -
From: Klein, Tracy ISTA:EX [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 27, 2001 0:11
Subject: Copy Record command
Hello, I
And what is the command you are using to connect?
- Original Message -
From: Jason Brunk [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 27, 2001 7:00
Subject: Newbie
hello all,
I am kind of new to all the unix OS stuff. Lately i have been doing
alot of work in
On Tue, 26 Jun 2001 22:29, Sinisa Milivojevic wrote:
David Robley writes:
I came across this discussion from April 2001 on the archives, but
nothing more recent. I also have encountered the problem, and thought
I could submit a bit more information.
OS - Linux 2.4.3
XFree -
I have used optimize table on several tables however it has not
affected the
speed of the queries or the large amount of processor resources that are
being used.
Have you heard of a way to rebuild a table more efficiently?
Go back and do this:
myisamchk -o *MYI
myisamchk -a *MYI
myisamchk
Did you convert the table/column names to lower case? If
lower_case_table_names is=1 MySQL will convert all table names to lower
case on storage and lookup ... but you need to first convert your old table
names to lower case before starting mysqld.
If you have not done so, you should run an
As it is such a big query, I don't have time to look at it for you but it
may be easier if you convert the RIGHT JOINS to LEFT JOINS for starters.
The manual does recommend LEFT JOINS, mainly for portability.
First part would be something like
(leg_activity LEFT JOIN leg_comm_hist ON
I wrote a perl script that will parse slow_queries logs, and output some
useful information. It's kind of hard to explain, but I'll try. I wanted to
see what queries were taking a lot of time, and how often they were
happening. I wrote a perl script that parses the log files, ignores
I have a database with a mix of myisam and innodb tables. I want to
create a copy of this database (ie the database name is different but
the table names and structures are the same) on the same server.
When I issue the create table command I get the following error:
ERROR 1005: Can't create
As a student CGI programmer, I've been working on an online questionnaire.
I have been working so hard to design the mysql db part, still I'm not
sure if I've done it right. Still somethings seem to be awkward.
Here I'm DESCRIBing the tables for you, then i'm explaining how I
inteded to use
At 12:11 27/06/2001 +1000, Jonathan Arthur wrote:
Hi,
Take a look in the err file and if you see an error like
this:
Innobase: error: table dbname/tablename already exists in Innobase data
dictionary
Means maybe you had created before the table in InnoDB and made a
drop database command, which
For the first time developing a PHP-MySQL system, I am experiencing strange
things. Perhaps it is the off-line mode (Localhost) I am running Apache in,
or my Wintel 98SE Pentium3. So I create and populate 3 small tables in a
database with a standard little PHP script. Then I start working on
For the first time developing a PHP-MySQL system, I am experiencing strange
things. Perhaps it is the off-line mode (Localhost) I am running Apache in,
or my Wintel 98SE Pentium3. So I create and populate 3 small tables in a
database with a standard little PHP script. Then I start working on
Thanks! I was able to work on the query today, and manually assemble a query
that did the same thing. And thus, was a lot faster. The main contention
MySQL seems to have is the nested joins, such as when Access does this:
FROM (((leg_version_hist RIGHT JOIN (leg_comm_hist RIGHT JOIN
Following the Tutorial
Creating and populating the table Shop in the db Test..
Why won't the following syntax work?
mysql select price
- from shop
- where price=Max(price) ;
ERROR : Invalid use of group function
Bob T
Why bother when the following works:
mysql SELECT price FROM shop ORDER BY price DESC LIMIT 1;
On Tue, 26 Jun 2001, R Talbot wrote:
Following the Tutorial
Creating and populating the table Shop in the db Test..
Why won't the following syntax work?
mysql select price
- from
1 - 100 of 111 matches
Mail list logo