I'm replying to you both personally and to the MySQL++ mailing list,
where this message is on topic. Please reply only on the list, not to
me directly.
wangxu wrote:
below is my code;these code works very fine until, the length of the
field content exceeds 30,
How certain are you
actually I am using this piece of code,but I replaced fprintf to printf
just to simplify the problem.
and the field content actually stores string content.
Shall this mean some thing different from your explanation?
while (r = res.fetch_row()) {
FILE *fp1
Hi,
I have the following query:
SELECT c2, c3, c4, Count(DISTINCT c5)
FROM table1
WHERE c1 IN (1, 2, 3...)
GROUP BY c2, c3, c4
order by null
Yet I can only get it at best to show (under extra): Using where, using
filesort.
I have read up on:
http://dev.mysql.com/doc/refman/5.0
is done also (usually because its
free). Sorting by NULL will tell MySQL to not even bother doing this. I've
seen 'sort by null' (as suggested elsewhere) avoid 'Using filesort' under
the Extra column when its not even needed.
Thanks for the response.
-Original Message-
From: Terry Mehlman
It's just occurred to me that the IN clause is not a constant.
This probably throws out any chance of using an index for group by?
Cheers
-Original Message-
From: Andrew Armstrong [mailto:[EMAIL PROTECTED]
Sent: Sunday, 29 July 2007 1:07 PM
To: mysql@lists.mysql.com
Subject: Using
Are you using MySQL Administrator for Windows ?
Are you using it against MySQL running in Linux ?
If so, you may prefer MySQL Administrator for Linux.
Just a couple more thoughts ...
- Original Message -
From: cfaust-dougot [EMAIL PROTECTED]
To: Weiqi Wang [EMAIL PROTECTED], mysql
Dear everyone:
I'm trying to simplify the operating of mySQL by using a GUI tool, mySQL
administrator. But it seems that I was only allowed to view the databases which
I have made up, but not allowed to edit them. Is it because I have to buy a
lisence or something which I didn't buy? Thanks
using mySQL administrator ?
Dear everyone:
I'm trying to simplify the operating of mySQL by using a GUI tool, mySQL
administrator. But it seems that I was only allowed to view the databases which
I have made up, but not allowed to edit them. Is it because I have to buy a
lisence or something
to simplify the operating of mySQL by using a GUI tool, mySQL
administrator. But it seems that I was only allowed to view the databases which
I have made up, but not allowed to edit them. Is it because I have to buy a
lisence or something which I didn't buy? Thanks for any answer!
Best Regards
On 6/29/07, Rich Brant [EMAIL PROTECTED] wrote:
Hello all. I'm looking for help with the query below. Is there anyway
to prevent the temporary and filesort?
The filesort is caused by either the ORDER BY or the GROUP BY. There
are sections in the manual about how to get it to use indexes for
Rich Brant schrieb:
Is there anyway to prevent the temporary and filesort?
SELECT
t1.sourceID as sourceID,
count(t1.sourceID) as clicks,
[...]
ORDER BY clicks desc, conversions desc;
When using EXPLAIN:
[...] Using where; Using temporary; Using filesort |
when
Hi,
Could someone please help me to get rid of Using temporary; Using filesort
from the following SQL statement?
SELECT a.document_id AS id, attr_name AS name, attr_value AS value, attr_order
AS ord FROM attributes a INNER JOIN status s ON (a.document_id = s.document_id)
WHERE update_flag
BY
sourceID ORDER BY clicks desc, conversions desc;
When using EXPLAIN:
++-+---+---+---+--+-+--+--+--+
| id | select_type | table | type | possible_keys | key |
key_len | ref | rows | Extra
desc;
When using EXPLAIN:
++-+---+---+---+--+-+--+--+--+
| id | select_type | table | type | possible_keys | key |
key_len | ref | rows | Extra
Hi,
I have an application that is using the MySQL HANDLER heavily. The
application was ported from a legacy ISAM database to use MySQL.
The upshot is that the application works by index walking - i.e.,
HANDLER tablename OPEN
HANDLER tablename OPEN as indexname
HANDLER indexname READ indexname
On Wed, Jun 27, 2007 at 01:27:24PM +1200, Ian Collins wrote:
Are HANDLER queries cached in the query cache?
No, they are not. The query cache only caches the results of SELECT
statements.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
There was a comment this week about a v5 master having problems connecting
to a v4 slave, or vice versa.
Can someone shed some light on this issue.
A manual reference is good, too.
Thanks,
David
Hello,
Did you already check:
http://dev.mysql.com/doc/refman/5.0/en/replication-compatibility.html
You cannot replicate from a master that uses a newer binary log format
to a slave that uses an older format (for example, from MySQL 5.0 to
MySQL 4.1.)
Thanks,
Jimmy Guerrero
Sr Product
hi all,
Here's a nut to crack:
I would like to extract a part of a string stored in a varchar column in a
mysql table.
Since the part of string I want to extract is neither at a fixed position
nor logically separated by a fixed character I was thinking using regexp
would by a good idea
Sample
hi all,
Here's a nut to crack:
I would like to extract a part of a string stored in a varchar column in a
mysql table.
Since the part of string I want to extract is neither at a fixed position
nor logically separated by a fixed character I was thinking using regexp
would by a good idea
Sample
I'ld like to accomplish something like:
set @myvar=concat_ws(,,(SELECT column from table1 order by column;
where ...))
or
select concat_ws(,,(SELECT column from table1 order by column where ...));
for further usage in sql-scripts
I forgot to mention: As I need it in a function, i think i
Hi,
Is it possible to insert values into two tables simultaneously and
have the value of one of the columns in the second table be the
auto_increment value from inserting into the first?
E.g. if table1 has an auto_increment column c1, the logic I'm looking
for would be something like:
INSERT
Hi,
Hamish Allan wrote:
Hi,
Is it possible to insert values into two tables simultaneously and
have the value of one of the columns in the second table be the
auto_increment value from inserting into the first?
No, because you can only insert into one table at a time. But you can write a
On 6/11/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
Hamish Allan wrote:
Hi,
Is it possible to insert values into two tables simultaneously and
have the value of one of the columns in the second table be the
auto_increment value from inserting into the first?
No, because you can only
Hi,
gwh wrote:
Hi everyone,
I¹m trying to figure out the best sequence to enter data into my database
(the SQL code for the structure is included below). If I have a number of
tab delimited .txt files containing the data for the different tables, I
thought as a first step I could use the
Hi everyone,
I¹m trying to figure out the best sequence to enter data into my database
(the SQL code for the structure is included below). If I have a number of
tab delimited .txt files containing the data for the different tables, I
thought as a first step I could use the following code to
Hi,
I am using tinymce to save news articles with very basic html styling in a
database. This works well upto a point but when I get over a certain number of
characters and then the 'you have an error in your SQL syntax' error. I am
saving in as a LONGBLOB so it should not be a data type
Hi,
[EMAIL PROTECTED] wrote:
Hi,
I am using tinymce to save news articles with very basic html styling in a
database. This works well upto a point but when I get over a certain number of
characters and then the 'you have an error in your SQL syntax' error. I am
saving in as a LONGBLOB so
Why are you saving it as a LONGBLOB and not as TEXT data type?
[EMAIL PROTECTED] wrote:
Hi,
I am using tinymce to save news articles with very basic html styling in a
database. This works well upto a point but when I get over a certain number
of characters and then the 'you have an error
Hi,
I installed mysql 4.1.22 for Debian testing.
I launched the manual installation.
However, when I do :
mysql -u root
I get :
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
I tried to reinstall it, but it fails.
Thanks for help,
Thibaud.
--
MySQL
may have to give the complete path to mysqladmin.
CheersCassj
-Original Message-
From: Thibaud Hulin [EMAIL PROTECTED]
Sent: May 9, 2007 4:13 PM
To: mysql@lists.mysql.com
Subject: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
Hi,
I installed mysql
Hello Group,
Looking to use this REPLACE to strip multi line data out of my return
data.
I am having problems getting the \n to work correctly, any ideas?
REPLACE(DESCRIPTION,\n,' ')
SELECT
rpad(CASE WHEN DESCRIPTION IS NULL THEN '' ELSE
REPLACE(DESCRIPTION,'\n',' ') END,80,' ') as var
Ok.. I found the problem.. I needed to add a \r.. but now that opens up
the question can I have a Multi replace search in replace?
Example can I do something like this in MySQL
REPLACE (STRING,'\r' or '\n',' ')
REPLACE(DESCRIPTION,'\r\n',' ')
Wishing you the best you know you deserve,
I always go with REPLACE(REPLACE(STRING, '\n', ''), '\r', ''), since
depending on where your data came from there may be one or the other, or
both. Although if there is a shorthand/more efficient way I'd love to
hear it.
[EMAIL PROTECTED] wrote:
Ok.. I found the problem.. I needed to add a
On 3/14/07, Bill Guion [EMAIL PROTECTED] wrote:
At 11:33 PM + 3/13/07, [EMAIL PROTECTED] wrote:
Date: Tue, 13 Mar 2007 20:56:08 +0530
To: mysql@lists.mysql.com
From: Yashesh Bhatia [EMAIL PROTECTED]
Subject: using DISTINCT after the ORDER BY clause has been applied
Message-ID: [EMAIL
, Bill Guion [EMAIL PROTECTED] wrote:
At 11:33 PM + 3/13/07, [EMAIL PROTECTED] wrote:
Date: Tue, 13 Mar 2007 20:56:08 +0530
To: mysql@lists.mysql.com
From: Yashesh Bhatia [EMAIL PROTECTED]
Subject: using DISTINCT after the ORDER BY clause has been applied
Message-ID: [EMAIL PROTECTED]
Hello
Hello:
I had a quick question on using the DISTINCT clause in a SELECT query.
I have the following table which stores webpages viewed
table: page_viewed
page_id int unsigned page id of the page viewed
user_id int unsigned user id of the page viewed
ts timestamp timestamp of the page view
Hello:
I had a quick question on using the DISTINCT clause in a SELECT query.
I have the following table which stores webpages viewed
table: page_viewed
page_idint unsignedpage id of the page viewed
user_id int unsigneduser id of the page viewed
ts timestamp
At 11:33 PM + 3/13/07, [EMAIL PROTECTED] wrote:
Date: Tue, 13 Mar 2007 20:56:08 +0530
To: mysql@lists.mysql.com
From: Yashesh Bhatia [EMAIL PROTECTED]
Subject: using DISTINCT after the ORDER BY clause has been applied
Message-ID: [EMAIL PROTECTED]
Hello:
I had a quick question on using
| PRIMARY | name | 62 |
NULL | 7 | Using index; Using temporary; Using filesort |
| 1 | SIMPLE | e2s | ref | co_id | co_id | 4 |
test.c.id | 55591
Additional information.
MySQL Version: 5.0.33
Platform: Mac OS X 10.4.8
Machine Spec: 2.16GHZ Intel Core 2 Duo Memory 2GB MHZ SDRAM
Test was done using the following dummy data.
employees table:
20 ascii chars as employees' name
skills:
INSERT INTO skills
(name)
VALUES
('C'),
('C++'),
('C
Hi,
if your selectivity is very low, try to use multiple index on e2s(co_id,
mod_time) and force this index in query.
Filip
employees2skills:
INSERT INTO employees2skills SELECT id, 1, 2, NOW() FROM employees;
# Yes, 100 have same skill_id, co_id, and even mod_time.
# selectivity is
Thank you for answering.
I tried your suggestion and it's got fast, but still slow and
could not get rid of Using temporary; Using filesort.
I don't understand why this simple query is so slow
data.
Filip
Thank you for answering.
I tried your suggestion and it's got fast, but still slow and
could not get rid of Using temporary; Using filesort.
I don't understand why this simple query is so slow
I agree that my testing data is wrong, but
what I was wondering is why the query gets slow only when using join,
although without join it gives me lightning answer.
BTW, you gave me a big hint!
I didn't know about 'cardinality', so searched on the web with the
word 'cardinality',
which leads me
SELECT *
FROM employees2skills e2s FORCE INDEX (mod_time )
INNER JOIN companies c ON c.id = e2s.co_id
ORDER BY e2s.mod_time limit 5;
Yes, this query will be probably the best.
This go through mod_time index (which is already sorted) from begin and
try to join companies.
When row count
One thing I don't understand is what MySQL tried to do first.
Why did MySQL chose co.name as a key?
On 3/3/07, Filip Krejci [EMAIL PROTECTED] wrote:
SELECT *
FROM employees2skills e2s FORCE INDEX (mod_time )
INNER JOIN companies c ON c.id = e2s.co_id
ORDER BY e2s.mod_time limit 5;
Yes,
Hi,
I'm looking for using FIELD CONSTRAINTS on Mysql but I can´t find it ...
Doesn´t Mysql implement it??
For example:
age int 0
MySQL doesn't support declarative CHECK CONSTRAINTs,
you could use triggers as a workaround.
Martijn Tonies
Database Workbench - development tool for MySQL
Hi.
I'm looking for using FIELD CONSTRAINTS on Mysql but I can´t find it ...
Doesn´t Mysql implement it??
For example:
age int 0
Thanks,
RAUL DUQUE
Bogotá, Colombia
-
Do You Yahoo!? La mejor conexión a Internet y 2GB
In the last episode (Feb 25), Raúl Andrés Duque Murillo said:
I'm looking for using FIELD CONSTRAINTS on Mysql but I can't find
it ... Doesn't Mysql implement it??
For example:
age int 0
You can do those checks with triggers:
http://dev.mysql.com/doc/refman/5.0/en/triggers.html
Cory Robin wrote:
We have a statement that joins 8 different tables to pull
multiple rows from each table.
I have heard of people using triggers to create, update and
delete records in a table based on statements in other
tables.
The obvious result of this would be to SPEED up results
We have a statement that joins 8 different tables to pull
multiple rows from each table.
I have heard of people using triggers to create, update and
delete records in a table based on statements in other
tables.
The obvious result of this would be to SPEED up results
right? :)
I'd love
: SQL_CALC_FOUND_ROWS using ODBC driver
Hi,
I've used PHP with MySQL and I was able to count the rows of a table by
using the following code:
SELECT SQL_CALC_FOUND_ROWS * FROM MyTableName; SELECT FOUND_ROWS();
However, I would like to do the same thing using Visual Basic 6...
When I set the RS.Source
Hi,
I have a table LOCAIS with:
id typedesc
1 t1 blah blah
2 t1 uihuih
3 t2 pokpokp
I want to list only the distinct types and create a table with those
results.
I know how to list the
This may help you:
mysql create table locais(
- id int,
- type varchar(2),
- `desc` varchar(10));
Query OK, 0 rows affected (0.12 sec)
mysql select * from locais;
+--+--+---+
| id | type | desc |
+--+--+---+
|1 | t1 | sk|
|2 | t2 | dsk |
|
INSERT INTO ztipos (type) VALUES (SELECT DISTINCT type FROM locais)
?
-afan
Miguel Vaz wrote:
Hi,
I have a table LOCAIS with:
idtypedesc
1t1blah blah
2t1uihuih
3t2pokpokp
I want to list only the distinct types and create a
Maybe I should rephrase this in the form of a question :) I have a
table with workstations and timestamps. I'd like to select the record
with the most recent timestamp for each workstation. I know there is a
simple query to accomplish this but I'm having difficulty. Does anyone
have any
the LIMIT part, it escaped from the code... I was using it but because
the code wasn't working I started changing it and the LIMIT got lost...
I've just tried to retrieve the value of the .Fields(0) and yes... It contains
the number of records of the table...
I hadn't figured this out because using
Hi,
Nuno Oliveira wrote:
When I set the RS.Source to the first SELECT statement and open it, it
run OK but I need to close the RS and open it again using the second
SELECT statement.
After any of this operations I get a Recordset-RecordsCount = 1
That is actually a correct figure, SELECT
Nils Meyer wrote:
SELECT
SQL_CALC_FOUND_ROWS doesn't make much sense without a where clause by
the way.
LIMIT, not where.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thu, Feb 15, 2007 at 01:04:26AM +, Nuno Oliveira wrote:
Hi,
I've used PHP with MySQL and I was able to count the rows of a table by
using the following code:
SELECT SQL_CALC_FOUND_ROWS * FROM MyTableName;
SELECT FOUND_ROWS();
However, I would like to do the same thing using
Hi,
I've used PHP with MySQL and I was able to count the rows of a table by
using the following code:
SELECT SQL_CALC_FOUND_ROWS * FROM MyTableName;
SELECT FOUND_ROWS();
However, I would like to do the same thing using Visual Basic 6...
When I set the RS.Source to the first SELECT statement
The default host table can possibly have multiple records for a given
workstation. Presumable the duplicate records are for historical
purposes, but only one is actually current. I don't really care why
there are duplicates but only need to a query to exclude the duplicate
records (leaving the
Thanks! That really seems to do the trick. Amazing. Now, for some
stupid questions: The values 69.1 and 57.3... are you aware of some
documentation or tutorial explaining these values and the math? I'd
like to understand why it works.
Also, I would like to figure out how to, if possible, speed
haven't followed the complete thread so i don't know what you're
after, but maybe this helps?
SELECT latitude, longitude, SQRT( POW( 69.1 * ( latitude - [startlat]
) , 2 ) + POW( 69.1 * ( [startlng] - longitude ) * COS( latitude /
57.3 ) , 2 ) ) AS distance FROM foobar ORDER BY distance ASC
Thanks for the reply... It returns results, but not exactly what I am
hoping for--basically, I get the nearest latitudes (but not near
longitude), and nearest longitude (but not near latitudes). In other
words, it doesn't return the closest lat/lng pair... Also, the query
takes about 8
is
being used which is a new concept in MySQL 5. My initial doubt was on this but
now when I checked top it shows that mysqld is consistently using 59% of Memory
and 25% of cpu even when there is no load.
the SHOW STATUS command in mysql shows:
Threads_created21863
Thanks,
By how much should I be increasing the thread_cache? currently it is 8...
Currently I can provide the EXPLAIN result of a query using index_merge on
MySQL 5.0.22.
EXPLAIN SELECT IFNULL(TAEM.FLD_FULL_NAME, TFMM.FLD_ASSIGNED_TO) AS ELE1 ,
TFMM.FLD_ASSIGNED_TO AS KEY_ID, SUM(1) AS ELE2
the monitor the threads-connected variable over a period of time and
calcuate the value. you can even look at max used connections status
variable and allot accordingly. BTW, is you application using demand based
connections or connection pooling ? If it is using connection pooling then
bumping
- MySQL 5 - mysqld using a lot of memory consistently
the monitor the threads-connected variable over a period of time and calcuate
the value. you can even look at max used connections status variable and allot
accordingly. BTW, is you application using demand based connections or
connection
: Tuesday, January 23, 2007 11:59 AM
Subject: Urgent - MySQL 5 - mysqld using a lot of memory consistently
Hello all,
Recently we upgraded from MySQL 4.1.11 to MySQL 5.0.22. The queries are
taking a lot of time to execute in the newer version. The queries which were
executing within 10 secs
select_type: SIMPLE
table: games
type: index
possible_keys: PRIMARY
key: ix_games_GameName
key_len: 102
ref: NULL
rows: 3
Extra: Using index; Using temporary; Using filesort
*** 2. row
possible_keys: PRIMARY
key: ix_games_GameName
key_len: 102
ref: NULL
rows: 3
Extra: Using index; Using temporary; Using filesort
*** 2. row ***
id: 1
select_type: SIMPLE
table: games_sets
Make sure that all joined fields are of identical types, otherwise the
query executor must cast each and every join value, which may be
affecting the query time...
Can you even define fields having foreign keys to be of a different type?
Anyway, taking a look at my JOIN
INNER JOIN users ON
so i'm debating between mysql and postgresql so far for choosing our data
warehouse platform, and i've been using mysql for about 8 years now and would
hate to move into postgresql if possible. mysql definitely has it's pros and
cons, but so far, more pros than cons except for big joins
Hi.
mysql --version
mysql Ver 14.7 Distrib 4.1.21, for pc-linux-gnu (i686) using readline 5.1
I'm trying to secure a replication connection between a master and a
slave. However, seems to me that the issue I'm facing relates to any SSL
client-server connection, so the scenario I'll
Is there a command at the command line that can tell me if I am using MyISAM
or InnoDB? Thanks :-).
--
John Kopanas
[EMAIL PROTECTED]
http://www.kopanas.com
http://www.cusec.net
http://www.soen.info
If mySQL is using MyISAM or InnoDB?
Is there a command at the command line that can tell me if I am using MyISAM
or InnoDB? Thanks :-).
--
John Kopanas
[EMAIL PROTECTED]
http://www.kopanas.com
http://www.cusec.net
http://www.soen.info
--
MySQL General Mailing List
For list archives: http
Know If mySQL is using MyISAM or InnoDB?
This is will tell you your default storage engine type
should you create a table without specifying an engine:
show variables like 'storage engine';
If you want to create a table with a specific engine,
specify it at the end od the CREATE TABLE like
For any specific table if you do:
show create table tablename;
It will tell you what the able was created using. To create tables using
a specific engine add ENGINE=name to the end of your create statement.
To see the default that is used (I think this is what the table_type
variable does
This is in 4.0, it has changed in more recent versions.
Mike Kruckenberg wrote:
For any specific table if you do:
show create table tablename;
It will tell you what the able was created using. To create tables
using a specific engine add ENGINE=name to the end of your create
statement
PROTECTED]
To: John Kopanas [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Friday, November 17, 2006 12:32:19 PM GMT-0500 US/Eastern
Subject: Re: How Do I Know If mySQL is using MyISAM or InnoDB?
For any specific table if you do:
show create table tablename;
It will tell you what the able
Do I Know If mySQL is using MyISAM or InnoDB?
Is there a command at the command line that can tell me if I am using
MyISAM
or InnoDB? Thanks :-).
--
John Kopanas
[EMAIL PROTECTED]
http://www.kopanas.com
http://www.cusec.net
http://www.soen.info
--
MySQL General Mailing List
For list
Hi:
I'm going use MySQL to log transactions so that I can report on them
later.
Ex:
CREATE TABLE statistics (
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT
, user_id BIGINT UNSIGNED
, entity_id INT UNSIGNED
, transaction_type INTEGER(2) UNSIGNED
, datetime_logged
In the last episode (Nov 10), James Tu said:
I'm going use MySQL to log transactions so that I can report on them
later.
Ex:
CREATE TABLE statistics (
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT
, user_id BIGINT UNSIGNED
, entity_id INT UNSIGNED
, transaction_type
I have a script that builds a data file. The data looks like this:
62527427012682984, 191151, 177628526, 3634025281, 1, 58400,
80, 1899, , 2006/10/02 23:15:02, 19,
47,,2006-11-02-231557-cust.txt, 0, 0, IKE, ESP: AES-256 +
SHA1, cx-ccb_vpn, Cx-CCB, ,
62527427012682983, 191150, 177628526,
Ok.. Disregard... the spaces I added for troubleshooting after the
commas fubar'd it.
Hi,
I have a computer lab where students learn bioinformatics. The
courses include a crash course on database and we want to use MySQL
since it is a popular engine for bioinformatics.
No one like to remember multiple passwords and since want each student
to have its own MySQL user and
In the last episode (Oct 13), Yannick Gingras said:
I have a computer lab where students learn bioinformatics. The
courses include a crash course on database and we want to use MySQL
since it is a popular engine for bioinformatics.
No one like to remember multiple passwords and since want
Dan Nelson [EMAIL PROTECTED] writes:
Is it possible to do the same with MySQL?
Not yet,
Argh!
but it being looked at:
http://bugs.mysql.com/bug.php?id=4703
http://forge.mysql.com/wiki/PluggableAuthenticationSupport
Very good! Keep up the good work guys. I guess our students will
have
Sorry for the multiple post screw up.
My Bad
On Thu, 2006-10-12 at 11:43 +0800, Ow Mun Heng wrote:
On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
Hey
方外 醉月 wrote:
How can i do if i want to drop tables with the same predix?
If you are using 5.0:
DELIMITER //
DROP
How can i do if i want to drop tables with the same predix?
For example, there is a database including a lot of tables,such as
tableA,tableB(table*)
Now,how can i drop those tables by using only one single statement?
_
与联机的
Hey
方外 醉月 wrote:
How can i do if i want to drop tables with the same predix?
For example, there is a database including a lot of tables,such as
tableA,tableB(table*)
Now,how can i drop those tables by using only one single statement
On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
Hey
方外 醉月 wrote:
How can i do if i want to drop tables with the same predix?
If you are using 5.0:
DELIMITER //
DROP PROCEDURE drop_table_prefix//
CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHAR(63
On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
Hey
方外 醉月 wrote:
How can i do if i want to drop tables with the same predix?
If you are using 5.0:
DELIMITER //
DROP PROCEDURE drop_table_prefix//
CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHAR(63
On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
Hey
方外 醉月 wrote:
How can i do if i want to drop tables with the same predix?
If you are using 5.0:
DELIMITER //
DROP PROCEDURE drop_table_prefix//
CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHAR(63
On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
Hey
方外 醉月 wrote:
How can i do if i want to drop tables with the same predix?
If you are using 5.0:
DELIMITER //
DROP PROCEDURE drop_table_prefix//
CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHAR(63
affected (0.00 sec)
test Select * from test;
+---+--+---+
| x | y| z |
+---+--+---+
| 1 | dan | yes |
| 2 | joe | no|
| 3 | NULL | maybe |
| 3 | NULL | yes |
+---+--+---+
Should the duplicate key checker be using the null-safe equals operator when
|
+---+--+---+
| 1 | dan | yes |
| 2 | joe | no|
| 3 | NULL | maybe |
| 3 | NULL | yes |
+---+--+---+
Should the duplicate key checker be using the null-safe equals operator when
checking for duplicate unique keys? Since primary keys cannot have nulls in
them, then they are fine
|
+---+--+---+
| 1 | dan | yes |
| 2 | joe | no|
| 3 | NULL | maybe |
| 3 | NULL | yes |
+---+--+---+
Should the duplicate key checker be using the null-safe equals operator
when
checking for duplicate unique keys? Since primary keys cannot have nulls
in
them
501 - 600 of 3107 matches
Mail list logo
