text
file..
Can you help
Cheers
:-)
Neeraj Black Bits
_
From: Harish TM [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 31, 2006 9:54 PM
To: sheeri kritzer
Cc: Neeraj; mysql@lists.mysql.com
Subject: Re: Problem in using LOAD DATA LOCAL INFILE
You need to check your
: Neeraj; mysql@lists.mysql.com
Subject: Re: Problem in using LOAD DATA LOCAL INFILE
I went through a lot of trouble with Load data local infile... There are a
lot of things regarding Local that MySql does not allow due to security
reasons. As mentioned before this you could give us the error
in using LOAD DATA LOCAL INFILE
I went through a lot of trouble with Load data local infile... There are a
lot of things regarding Local that MySql does not allow due to security
reasons. As mentioned before this you could give us the error... that might
help
alternatively try out mysqlimport
http
@lists.mysql.com
Subject: Re: Problem in using LOAD DATA LOCAL INFILE
I went through a lot of trouble with Load data local infile... There are
a
lot of things regarding Local that MySql does not allow due to security
reasons. As mentioned before this you could give us the error... that
might
help
What's the error you are getting? What MySQL version are you using?
On 5/26/06, Neeraj [EMAIL PROTECTED] wrote:
Hi all
I have a table with following structure
CREATE TABLE `dsc` (
`ch_code` varchar(255) default NULL,
`name` varchar(255) default NULL,
`inof` blob
) ENGINE
Hi all
I have a table with following structure
CREATE TABLE `dsc` (
`ch_code` varchar(255) default NULL,
`name` varchar(255) default NULL,
`inof` blob
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
And I have give a text file with following format
Ü
¢
Ch.Code :02Ü
MEATÜ
Dear All,
My contact table has email field which contains many invalid email addresses.
I find them using following php function. Is there a way to do that check in
MySQL query?
function emailValidate ($str)
{
$reg = ^([a-zA-Z0-9._-]+)@([a-zA-Z0-9-])+(\.[a-zA-Z0-9
From: Yesmin Patwary [EMAIL PROTECTED]
Subject: Find invalid email formats using MySQL query.
Dear All,
My contact table has email field which contains many
invalid email addresses. I find them using following php
function. Is there a way to do that check in MySQL
query
Yesmin Patwary wrote:
Dear All,
My contact table has email field which contains many invalid email addresses. I find them using following php function. Is there a way to do that check in MySQL query?
function emailValidate ($str)
{
$reg = "^([a-zA-Z0-9._-]+)@([a-zA
adding it is the normal way this is
done.
-Original Message-
From: Yesmin Patwary [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 20, 2006 10:48 AM
To: mysql@lists.mysql.com
Subject: Find invalid email formats using MySQL query.
Dear All,
My contact table has email field which contains many
Probably the most efficient place to do this sort of field
checking would be using javascript in the browser. That
would stop the bad addresses even being sent down the line
to the server in the first place.
Keith
In theory, theory and practice are the same;
in practice they are not.
On Sat
At 22:10 +0100 20/5/06, Keith Roberts wrote:
Probably the most efficient place to do this sort of field
checking would be using javascript in the browser. That
would stop the bad addresses even being sent down the line
to the server in the first place.
Sure, but if you're being conscientious
I have a similar desire like my first question regarding a DATETIME field. I
have a DATETIME field in my db that I would like to DEFAULT to the exact
value of another DATETIME field in the same table... However, if I write a
trigger for this and the application or the user or someone accessing
Hello
using MySQL administrator tool, I can view databases under the
catalog folder, but I can't view the data filled in the tables, when
doing right click table -- Edit table Data , nothing shows up
Thanks for your help
hicham
--
MySQL General Mailing List
For list archives: http
-
From: hicham [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 18, 2006 6:30 AM
To: mysql@lists.mysql.com
Subject: viewing data using MySQL Administrator tool
Hello
using MySQL administrator tool, I can view databases under the
catalog folder, but I can't view the data filled in the tables
Hey folks I'm trying to crate a view that runs a stored procedure. Can
anyone tell me what I might be doing wrong or if what I'm trying it
possible?
Here is what I get:
mysql create view v as CALL flatscore(6,2);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that
.locid
and t2.locid = t3.locid
and t2.locid = t4.locid
and t3.locid = t4.locid
and (2720518136 = t3.startIpNum)
and (2720518136 = t4.endIpNum)
limit 1
Hope this helps!
Dan
Hello,
I am running Ver 14.7 Distrib 4.1.12, for redhat-linux-gnu
(i386) using readline 4.3 on a Dual Xeon 2.4Ghz RHEL4
Hello,
I am running Ver 14.7 Distrib 4.1.12, for redhat-linux-gnu (i386)
using readline 4.3 on a Dual Xeon 2.4Ghz RHEL4 box with 4GB of RAM.
I have a query that takes anywhere from .25 - .85 seconds to run.
Following are the query and the related table structures I have
currently set
UNCOMPRESS(IMAGE_DATA) FROM table, when I get this using jdbc
ResultSetMetaData rsmd = rs.getMetaData();
System.out.println(SHOW THE COLUMN TYPE: + rsmd.getColumnType(1));
I am getting the Column type as
VARCHARhttp://java.sun.com/j2se/1.4.2/docs/api/java/sql/Types.html#VARCHAR,
whereas if I don't
In theory, theory and practice are the same;
in practice they are not.
On Mon, 20 Mar 2006, Martijn Tonies wrote:
To: mysql@lists.mysql.com
From: Martijn Tonies [EMAIL PROTECTED]
Subject: Re: Discussion: the efficiency in using foreign keys
Hi,
This is a fundamental concept in RDBMS
I've always been a believer in avoiding sql procedures, for the main
reason that I want to be as database-independent as possible. I know it
is less efficient, but being able to switch between MySQL, Postgre, and
the new freebies from IBM, Oracle, and Microsoft is a strong advantage
from the
checking when adding a new
record that references a record id from another table. I understand that
this may not be efficient because it becomes 2 database calls (and db
calls are expensive in high-load environments).
What are the advantages/ disadvantages in using foreign keys? In MySQL
IMHO I think you will find that there is a balance between
the speed of opening and reading/writing several related
smaller tables connected by FK's, rather than one mega-sized
gigantic table.
How do you normalise a table without using FK's.
Your right, MySQL does not currently do any
Hello Keith,
Thanks for responding. I was actually referring to the subject of using
foreign keys, as opposed to leaving it to the calling application to do
the necessary checks. In particular issues of performance, efficiency
etc. IMHO, foreign keys add 'strictness' to the consistency
checking when adding a new
record that references a record id from another table. I understand that
this may not be efficient because it becomes 2 database calls (and db
calls are expensive in high-load environments).
What are the advantages/ disadvantages in using foreign keys? In MySQL
'
AND email_verified = 'Y';
--Praj
On Mon, 13 Mar 2006 17:18:58 -0500
fbsd_user [EMAIL PROTECTED] wrote:
Trying to bump the count_of_logons by 1 using this update.
Phpmyadmin shows the count staying at zero.
I think that this SET count_of_logons = 'count_of_logons + 1'
is not coded correctly, but I get
Trying to bump the count_of_logons by 1 using this update.
Phpmyadmin shows the count staying at zero.
I think that this SET count_of_logons = 'count_of_logons + 1'
is not coded correctly, but I get no errors so can not tell.
Anybody have any ideas?
The table def has count_of_logons INT
fbsd_user wrote:
Trying to bump the count_of_logons by 1 using this update.
Phpmyadmin shows the count staying at zero.
I think that this SET count_of_logons = 'count_of_logons + 1'
is not coded correctly, but I get no errors so can not tell.
Anybody have any ideas?
The table def has
Hi all,
I am trying to use the replace() function in MySQL 4.1.13a to find and
remove tab characters. I'm not sure how to signify the tab char, however.
I've tried, \t to no avail:
update products_description set products_description =
replace(`products_description`,\t, ) where products_id
[snip]
Does anyone have any suggestions? The mysql server [and client] are
running under Linux. The products_description field is a 'text' type. If
there's further info you need, please let me know.
[/snip]
Are you using REPLACE(column_name, '\t', ' ') ?
--
MySQL General Mailing List
For list
On Wed, 1 Mar 2006 [EMAIL PROTECTED] wrote:
} [snip]
} Does anyone have any suggestions? The mysql server [and client] are
} running under Linux. The products_description field is a 'text' type. If
}
} there's further info you need, please let me know.
} [/snip]
}
} Are you using REPLACE
On Wed, 1 Mar 2006, Vince LaMonica wrote:
} update products_description set products_description =
} replace(`products_description`,'\t',' ') where products_id = 37;
[snip]
I should have also stated that in the above example, both the table name
and the column name are the same - that's not a
@lists.mysql.com
Subject: using replace() to remove tab chars
Hi all,
I am trying to use the replace() function in MySQL 4.1.13a to find and
remove tab characters. I'm not sure how to signify the tab char,
however.
I've tried, \t to no avail:
update products_description set products_description
On Wed, 1 Mar 2006, Price, Randall wrote:
} Try the following:
}
} REPLACE(products_description, CHAR(9), )
Thanks, Randall, that did it. And I feel quite stupid, as well, because I
re-checked my two test entries [33 and 37] and both had had their tabs
removed at some point. So it turns out
Why does this query not work using mysql 3.23.58?
$SQL =SQL;
UPDATE $tablename SET rank = '$qdj_rank_en', rank_icon = '$qdj_rank_icon', qdj
= qdj+'$adata{qdj_credit}', gold = gold+'$adata{gold_credit}' WHERE subscribe
!= '' OR artist = '1' OR rank_change != '1'
SQL
$dbh-do($SQL) || cgierr
, February 25, 2006 4:28 PM
Subject: using WHERE and OR in a query
Why does this query not work using mysql 3.23.58?
$SQL =SQL;
UPDATE $tablename SET rank = '$qdj_rank_en', rank_icon = '$qdj_rank_icon',
qdj = qdj+'$adata{qdj_credit}', gold = gold+'$adata{gold_credit}' WHERE
subscribe != '' OR artist
Why does this query not work using mysql 3.23.58?
The query is updating all records with no regards to the WHERE clauses.
Do I need to do separate updates for each WHERE clause?
$SQL =SQL;
UPDATE $tablename SET rank = '$qdj_rank_en', rank_icon = '$qdj_rank_icon', qdj
= qdj+'$adata{qdj_credit
sometimes
confuse Perl and PHP.
Is '!=' a legitimate way to say 'not equal' in this version of MySQL and the
language you are using? I normally use either the NOT keyword or the symbols
'' to negate conditions, for example:
- WHERE NOT subscribe = ''
- WHERE subscribe ''
Some dialects of SQL and some
fields with default values all of a sudden show as
NOT NULL. I'm using MySQL Server 5.0.11 and Migration Toolkit 1.0.21rc.
Any suggestions / ideas as to why this is happening (the transfer is
done online, so all objects and data is moved online and not scripted).
Thanks,
Dewald Troskie
GIS
pulling a SCSI cable out.
If this turns out to be a good way to scale MySQL someone could just pay
to have NBD enhanced to support fault tolerance with mirror nodes.
Thoughts?
Why would this be better than just using MySQL Cluster (NDB)?
With this method you're reliant on one single server
:
http://www.ussg.iu.edu/hypermail/linux/kernel/9704.3/0492.html
Basically they just buy cheap 1U boxes with 4-8 gig and then mount
them... this way they allow the process to allocate as much memory as
it wants and it will them start swapping but instead of uses disk it
starts using the remote
hi,
since 3 days, i'm trying to connect to MYSQL 5.0.18 from php scripts using
Apache et Macromedia 2004 Dreamweaver.
Could someone help me doing this?
Best regard.
-
Nouveau : téléphonez moins cher avec Yahoo! Messenger ! Découvez les
persant mpote [EMAIL PROTECTED] wrote on 02/16/2006 10:29:37 AM:
hi,
since 3 days, i'm trying to connect to MYSQL 5.0.18 from php
scripts using Apache et Macromedia 2004 Dreamweaver.
Could someone help me doing this?
Best regard.
-
Nouveau
://www.student.nada.kth.se/~f91-men/qps/
It give a graphical UI, into the running processes.
I noticed using qps, that sometimes the mysqld_safe script
loads into memory, but does not actually load a mysqld
process. Also, version 4.0.21 only spawns one child process,
where 5.0.18 starts several processes
-Original Message-
From: Skarlatos, Matthew P.
To: 'mysql@lists.mysql.com'
Sent: 2/13/2006 8:37 AM
Subject: Any help with resetting the administrative password using
'mysqld_safe' w/ the --init-file option
Has anyone run into a problem with setting the root user password in
mysql
Has anyone run into a problem with setting the root user password in mysql
using mysqld_safe with the '--init-file' option that contains the new
password for startup?
What I'm seeing after I issue the kill command for the 'host.pid' file and
then restarting 'mysqld_safe --init-file
it into the
BLOB field using LOAD_FROM_FILE.
Slower I know but I get no errors.
Kerry
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: 03 February 2006 11:28
To: mysql@lists.mysql.com
Subject: Re: update a Blob field using UPDATE
Hello.
Have you applied
Hello.
Have you applied mysql_real_escape_string to your BLOB variable first?
See:
http://dev.mysql.com/doc/refman/5.0/en/mysql-real-escape-string.html
I do not see the quotes around mystring$ as well.
Kerry Frater wrote:
I am importing data from a non MySQL table into MySQL.
In the
Scott Klarenbach [EMAIL PROTECTED] wrote on 02/02/2006 02:01:11
PM:
I have a table `requirement` which is left joining to a table
`inventory`
based on a matching `partNumber` column. The inventory table has
millions
of records, the requirement table has tens of thousands. I'm noticing
Thanks a lot Shawn. As always, your advice has been very helpful.
On 2/3/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Scott Klarenbach [EMAIL PROTECTED] wrote on 02/02/2006 02:01:11
PM:
I have a table `requirement` which is left joining to a table
`inventory`
based on a matching
I have a table `requirement` which is left joining to a table `inventory`
based on a matching `partNumber` column. The inventory table has millions
of records, the requirement table has tens of thousands. I'm noticing that
the left join between requirement and inventory doesn't take advantage of
Try this:
[EMAIL PROTECTED]:ule select * from a;
++--+
| id | data |
++--+
| 1 | a|
| 2 | b|
| 3 | c|
| 4 | d|
| 5 | e|
++--+
5 rows in set (0.00 sec)
[EMAIL PROTECTED]:ule select * from b;
++--+
| id | data |
++--+
| 1 | aa |
|
I am importing data from a non MySQL table into MySQL.
In the table there is a text field of up to length 4000 chars. I have
defined the column as blob in the MySQL table.
I can read the text field of the source table into a variable e.g.
mystring$. The MySQL table has been set, except for this
for mysqlbinlog utility. See:
http://dev.mysql.com/doc/refman/5.0/en/mysqlbinlog.html
Rob Gormley wrote:
Am hoping someone can give me the safest advice here.
Using 4.1 and InnoDB, someone in an attempt to be helpful set up a lot
of foreign key constraints. However...
ON DELETE CASCADE
When
Am hoping someone can give me the safest advice here.
Using 4.1 and InnoDB, someone in an attempt to be helpful set up a lot
of foreign key constraints. However...
ON DELETE CASCADE
When we needed RESTRICT.
Net effect? Some editing today lead to cries of Where has half the data
gone?
We have
Hello.
MySQL doesn't support this yet. The CHECK clause is parsed but ignored
by all storage engines.
Ferindo Middleton Jr wrote:
I have the following table where I have a CHECK CONSTRAINT to check for
logical data values but for some reason it's not working on INSERTs to
the table. MySQL
I have the following table where I have a CHECK CONSTRAINT to check for
logical data values but for some reason it's not working on INSERTs to
the table. MySQL doesn't give any error message when I CREATE TABLE. Any
ideas what I'm doing wrong?... or Is this type of declaration not
supported...
Hello.
Perhaps this can resolve some queries:
http://lists.mysql.com/mysql/177314
John Lauck wrote:
I'm using SET time_zone = 'US/Hawaii' to convert timezones and it's not
working.
What am I doing wrong?
I have verified that the session.time_zone var is set correctly.
if(defined
I'm using SET time_zone = 'US/Hawaii' to convert timezones and it's not
working.
What am I doing wrong?
I have verified that the session.time_zone var is set correctly.
if(defined('ZMM_USER_LOCALE')) {
$query = SET time_zone = ' .
mysql_real_escape_string(ZMM_USER_LOCALE
Hello,
I'm trying to run q query with an IN statement in MySQL 5. Like so:
SELECT * from encore enc, article art
WHERE enc.encore_id= '10' AND `article_id` IN (`articles`)
Its should return all the articles in the encore.articles column but
instead only returns the first article.
In
Your select has two tables, but you don't join them.
Can you provide the table info, and a subset of the data that should be
pulled back by this query?
David
Paul Nowosielski wrote:
Hello,
I'm trying to run q query with an IN statement in MySQL 5. Like so:
SELECT * from encore enc,
mean?...
SELECT *
FROM encore AS enc
INNER JOIN article AS art USING (article_id)
WHERE enc.encore_id= 10;
PB
-
Paul Nowosielski wrote:
Hello,
I'm trying to run q query with an IN statement in MySQL 5. Like so:
SELECT * from encore enc, article art
WHERE enc.encore_id= '10
Paul Nowosielski [EMAIL PROTECTED] wrote on 01/11/2006 02:41:05
PM:
Hello,
I'm trying to run q query with an IN statement in MySQL 5. Like so:
SELECT * from encore enc, article art
WHERE enc.encore_id= '10' AND `article_id` IN (`articles`)
Its should return all the articles in the
Pete Harlan wrote:
FYI,
4.1.16 appears not to be using prefixes of compound indexes when doing
updates. Reverting to 4.1.15, or adding an index consisting of only
the desired field, restores reasonable behavior.
I have added feedback to a possibly-related bug,
http://bugs.mysql.com
FYI,
4.1.16 appears not to be using prefixes of compound indexes when doing
updates. Reverting to 4.1.15, or adding an index consisting of only
the desired field, restores reasonable behavior.
I have added feedback to a possibly-related bug,
http://bugs.mysql.com/bug.php?id=15935, but wanted
Using this tool (VeriTas Backup Exec for windows server v9.1) to backup the
database crashes MySQLd-nt, has anyone else come across this issue at all?
regards
answer to Mr Ikar, hoping to have more detail on
this topic.
-Messaggio originale-
Da: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Inviato: martedì 27 dicembre 2005 17.13
A: mysql@lists.mysql.com
Oggetto: Re: field truncate trying to using 'show slave status'
Hello. Is this a limit of mysql
Normal query , the one started with the select statement works well, so I'm
thinking about a workaround if possible.
The info returned by 'show slave status' are available in some table, when I
can retrieve data using normal select statement ?
regards, Enzo
-Messaggio originale-
Da
Hello.
The info returned by 'show slave status' are available in some table,
when I can retrieve data using normal select statement ?
As far as I know - not.
AESYS S.p.A. [Enzo Arlati] wrote:
Normal query , the one started with the select statement works well, so I'm
thinking
Can some one please tell me what I am doing wrong here I have installed
and configured users in the database. I am using ODBC driver to logon.
When I use the password, it does not work but surprisingly the logon is
allowed without a password. I have tried to use MySQL Administrator to
logon
Aftab Khan [EMAIL PROTECTED] wrote on 12/28/2005 02:15:33 PM:
Can some one please tell me what I am doing wrong here I have
installed
and configured users in the database. I am using ODBC driver to logon.
When I use the password, it does not work but surprisingly the logon is
allowed
Title Current Company
Emp X DirectorCompany A
Emp X Chairman Company B
Emp Y President -
To implement rule 2, I tried using 'group by' clause on executive_id,
but if I do that, then I get only one record
I'm using mysql 5.0.15 on windows 2000.
I connect to database using MYDAC component, which seems to work well
enough.
I got a problem when I tried to load the resultset returned by a query like
'show slave status'.
In this case some of the fields are truncated.
As example the first field named
and have no problems. MYDAC can work with MySQL in two ways
- using MySQL client or native MySQL network protocol. Which of these
two options are you using?
AESYS S.p.A. [Enzo Arlati] wrote:
I'm using mysql 5.0.15 on windows 2000.
I connect to database using MYDAC component, which seems
greetings,
I know this is pretty basic stuff, but I couldn't find an answer in
google.
1. I want to set the @maxdate variable, but mysql complains. What am
I doing wrong?
2. The 3rd to the last line:
and (p.value - t.amount) -1000
I wanted to say
diff -1000
but mysql
Joseph Alotta wrote:
greetings,
I know this is pretty basic stuff, but I couldn't find an answer in
google.
1. I want to set the @maxdate variable, but mysql complains. What am I
doing wrong?
set @maxdate = select max(date) from positions where account =
111200512343222;
select
Hi,
I have two servers and am trying to move the database from one to the other.
The data is currently residing in a MySQL 4.0 database. The new server is
running MySQL 5.0.
Trying to import a table such as
CREATE DATABASE /*!32312 IF NOT EXISTS*/ db17058c;
USE db17058c;
DROP TABLE IF EXISTS
Hello.
The error should disappear if you perform the dump using --quote-names
option.
Alex Davies [EMAIL PROTECTED] wrote:
Hi,
I have two servers and am trying to move the database from one to the other.
The data is currently residing in a MySQL 4.0 database. The new server
this:
alter table example_table alter column aba_order_number set
default IF(LEFT(order_number,4) = 'ABA-',REPLACE(order_number, 'ABA-',
''),'');
doesn't seem to make a difference, as it assigns the string IF(LEFT...
as the default text, instead of seeing it as a function. The reason I am
using
of seeing it as a function. The reason I am
using an IF() is because some order_number values will not contain a
leading ABA- string.
I'm using 4.1.13, FWIW.
Thanks for any tips y'all might have.
/vjl/
First - THANK YOU for remembering to post your version!
Quoting from http
I have read the suggestions for optimization for innodb however I'm
curious if anyone can help me understand which buffers are common (thus
used by innodb action) and which are specific to myiasm. The server has
2GB of ram but runs multiple services. I have a number of different
types of
Please see my comments below :
On Thu, 2005-12-01 at 14:06 -0600, Ross Anderson wrote:
I have read the suggestions for optimization for innodb however I'm
curious if anyone can help me understand which buffers are common (thus
used by innodb action) and which are specific to myiasm. The
who actually signed the cert) seems to be validated by
the server CA certificate since login using a certificate signed by the
wrong CA is denied but still ...
Is this behaviour by the server correct? Is it possible to validate
users by their subject and issuer values from their certificates
://www.hotscripts.com/Detailed/28161.html (note, I claim no
liability, I just found that script doing a web search).
-Sheeri
On 11/22/05, Jacek Becla [EMAIL PROTECTED] wrote:
Hi,
Is there a way to load a section of an input file into mysql
(MyISAM table) using mysqlimport or LOAD DATA INTO?
The input data
tried that, but in Delphi with the particular component-set I'm using,
this raises: mySQL Error Code: (1312)
PROCEDURE test.p_Select() can't return a result set in the given context
Ah, you're not the first to have that error message, eg see the discussions
at http://forums.mysql.com/read.php
Hi there,
I cannot figure out how to use a Stored Procedure that returns a
resultset and I cannot find it in the documentation.
For example:
CREATE PROCEDURE P_Select()
READS SQL DATA
begin
select * from enum_table;
end
I believe that CALL can only be used for output parameters, correct?
Martin
CREATE PROCEDURE P_Select()
READS SQL DATA
begin
select * from enum_table;
end
How would I get a resultset?
No need for an OUT param, just call the sproc, you'll see.
PB
-
Martijn Tonies wrote:
Hi there,
I cannot figure out how to use a Stored Procedure that returns a
resultset
CREATE PROCEDURE P_Select()
READS SQL DATA
begin
select * from enum_table;
end
How would I get a resultset?
No need for an OUT param, just call the sproc, you'll see.
I tried that, but in Delphi with the particular component-set I'm using,
this
raises:
mySQL Error Code: (1312
Hi Martijn
I tried that, but in Delphi with the particular component-set I'm
using,
this raises: mySQL Error Code: (1312)
PROCEDURE test.p_Select() can't return a result set in the given
context
Ah, you're not the first to have that error message, eg see the
discussions at http
Hi,
Is there a way to load a section of an input file into mysql
(MyISAM table) using mysqlimport or LOAD DATA INTO?
The input data is in relatively large ascii files (10 million
rows per file), and I'd like to break the load into smaller
pieces rather than load whole file at once. Of course I
I'd really suggest looking at the data model that requies you to
dynamically select which table to read from, and find another
way. If there are several tables that have the same column that
differ only by name, why not make the name a column?
-Jason Martin
On Sat, Nov 19, 2005 at 02:28:41PM
Hello.
Have a look here:
http://dev.mysql.com/tech-resources/articles/mysql-storedproc.html
For a pity prepared statements are disabled now in stored routines:
http://dev.mysql.com/doc/refman/5.0/en/routine-restrictions.html
AESYS S.p.A. [Enzo Arlati] wrote:
I need to pass to
I need to pass to a stored procedure a var a table name.
But I don't known how use the variable in the sql statement.
If I use the method described belowe I get an error, the procedure use the
variable name as the name of the table.
Someone can help ?
CREATE FUNCTION `myFunc`( tbl_name
At 09:54 PM 11/8/2005, David Turner wrote:
If you could present sample data of both table1,
table2, and an example of the result set it would be
easier to give you the sql. I believe you could
eliminate the temporary table with a subselect in the
original query. The subselect is where you would
It appears mysql recommends against the solution given
to you
http://dev.mysql.com/doc/refman/5.0/en/join.html
You should generally not have any conditions in the
ON part that are used to restrict which rows you want
in the result set, but rather specify these conditions
in the WHERE clause.
into the ON clause of
a JOIN, especially when using the outer JOIN forms. In fact, some queries
require several conditions in the ON clause in order to perform correctly.
There have been several good generic suggestions so far but everyone has
had to guess what is going on because the OP failed
mos wrote:
Another user privately e-mailed me the errors of my ways.g
Here is the problem (returns 0 rows):
select * from table1 t1 left join table2 t2 on
t1.date1=t2.date2 where
t2.date2 is null
where t2.name='Smith'
Here is the solution:
select * from table1 t1 left join table2
I would like to find the missing subset of rows in table2 based on the rows
in table1.
Normally it would look like this:
select * from table1 t1 left join table2 t2 on t1.date1=t2.date2 where
t2.date2 is null
Well this works fine except I only want to compare a subset of rows in
table2 for
select * from table1 t1 left join table2 t2 on t1.date1=t2.date2 where
t2.date2 is null
where t2.name='Smith'
Maybe this?
select * from table1 t1 left join table2 t2 on t1.date1 = t2.date2 AND
t2.name = 'Smith' WHERE t2.date2 is null;
--
Scott Noyes
[EMAIL PROTECTED]
--
MySQL General Mailing
At 04:33 PM 11/8/2005, Scott Noyes wrote:
select * from table1 t1 left join table2 t2 on t1.date1=t2.date2 where
t2.date2 is null
where t2.name='Smith'
Maybe this?
select * from table1 t1 left join table2 t2 on t1.date1 = t2.date2 AND
t2.name = 'Smith' WHERE t2.date2 is null;
--
Scott Noyes
701 - 800 of 3107 matches
Mail list logo