thank you gleb.
But,the "sql security"d description in the manual is not particular.
I mistaked the concept.
I understand the limit is procedure limit but not database object limit.
So,i believe this concept should more definitude if you add the example in this
part of manual.
--
On 1/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
>
> Vincente Aggrippino <[EMAIL PROTECTED]> wrote on 01/11/2006 11:33:38
> PM:
>
> > I have three tables joined on key fields: delivery is joined with
> > invoice_detail on delivery_id and with location on loc_id. I want to
> return
> >
Hey yall,
I have a delimited text file I'm trying to load into my db. The problem is
that for whatever reason (totally beyond my control) the line and field
delimiters include an Extended ASCII char (0xA0) like so:
05HIUT841427BLCA á Dell Computer á"One *Dell* Way, *Round
Rock*Texas 786
Vincente Aggrippino <[EMAIL PROTECTED]> wrote on 01/11/2006 11:33:38
PM:
> I have three tables joined on key fields: delivery is joined with
> invoice_detail on delivery_id and with location on loc_id. I want to
return
> records of deliveries that have corresponding records in the location
tab
I have three tables joined on key fields: delivery is joined with
invoice_detail on delivery_id and with location on loc_id. I want to return
records of deliveries that have corresponding records in the location table,
but have no corresponding records in the invoice table.
Here's the query I'm a
Hi, Shawn Green
Thanks for your reply. But I expect new version of MyODBC(one of
mysql-connectors), not of mysqld. We now use mysql5.0. The newest version of
MyODBC is 3.51.12.
Regards,
gulei
- Original Message -
From: <[EMAIL PROTECTED]>
To: "古雷" <[EMAIL PROTECTED]>
Cc: "MySQL List"
OK, I've just installed the MySQL server and client version 5.0.18 on RH
EL4. I was following through the manual and it says I should test
connectivity by entering mysqladmin version. I tried this, but got this
error:
connect to server 'localhost' failed
error: 'Access denied for user 'webuser
I have a problem. I had to upgrade to 4.1 yesterday for an application,
and now I can't convert my old isam tables to myisam:
ALTER TABLE codes TYPE = MYISAM;
ERROR 1017 (HY000): Can't find file: 'codes.MYI' (errno: 2)
and I can't use phpmyadmin because there are isam tables. Is there any
way
[EMAIL PROTECTED] wrote on 01/11/2006 03:53:26 PM:
> On 1/11/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> >
> > [EMAIL PROTECTED] wrote on 01/11/2006 02:42:27 PM:
> >
> >
> > > Hi List!
> > >
> > > Please forgive me if I'm asking the wrong list (and please guide me
to
> > > the righ
On 1/11/06, Gordon Bruce <[EMAIL PROTECTED]> wrote:
> I assume you are looking for both red and car.
> You can not use IN because that is implicitly an IN.
> You hae to join the tags table to itself using 2 different aliasis.
> {If you required 3 things then you would join it 3 times etc..}
>
> SEL
Hello.
> [EMAIL PROTECTED]:~# telnet localhost 43306
> Trying 127.0.0.1...
> Connected to localhost.
> Escape character is '^]'.
> Connection closed by foreign host.
I had an experience with similar symptoms which was caused by TCP
wrapper. Check your /etc/hosts.allow.
Lance Roc
Hello.
MySQL privilege tables can be created with mysql_install_db script. I
recommend you to backup your mysql database, before playing with them.
Are you sure that mysql.user table is not exist?
Jon Miller wrote:
> In a new setup I had the users table in MySQL. A few hours later I w
Hello.
This is a bug:
http://bugs.mysql.com/bug.php?id=16378
AESYS S.p.A. [Enzo Arlati] wrote:
> I found a problem using stored procedure and bin-log enabled.
>
> Suppose I stored procedure like this:
> ==
> DELIMITER $$;
>
> DROP
Hello.
> This doesn't list BIT at all:
>http://dev.mysql.com/doc/refman/5.0/en/c-api-prepared-statement-datatypes.html
Have you tried MYSQL_TYPE_BIT? It is listed among others in mysql_com.h.
Martijn Tonies wrote:
> Hi there,
>
> Still tracking down the BIT problems. For a simple
Mike,
You're in the right place. If I understand your requirement correctly,
you want entries which...
match on id,
match a selection from ('Mustang' or 'Beetle'),
match multiple values in tags (eg 'red' and 'car').
Here's one solution:
SELECT p.photo, t.tag
FROM pics p
INNER JOIN tags c USI
[EMAIL PROTECTED] wrote on 01/11/2006 02:42:27 PM:
> Hi List!
>
> Please forgive me if I'm asking the wrong list (and please guide me to
> the right place).
>
> I have two tables (simplified for this example) "pics" and "tags" like
so:
>
> pics:
> picid photo
> 1Mustang
> 2Apple
> 3
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
Paul,
SELECT * from encore enc, article art
WHERE enc.encore_id= '10' AND `article_id` IN (`articles`)
First, IN() accepts either a literal value list, or a subquery which
returns a value list. Just passing it a table name won't work.
Second, your join looks suspicious. Is this what you mean
Hi! Essentially this is true. However let me qualify that a little...
Clearly to take advantage of 64 to you'll want to change your memory
settings and allocate something in my.cnf over 2G. Also you'll want
to be using OS X 10.4.n, 10.3 and earlier don't really support 64
bit. Now that the
Hi List!
Please forgive me if I'm asking the wrong list (and please guide me to
the right place).
I have two tables (simplified for this example) "pics" and "tags" like so:
pics:
picid photo
1Mustang
2Apple
3Rock
4Beetle
tags:
tagid picidtag
11 Car
2
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, articl
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 encore,art
2wsxdr5 <[EMAIL PROTECTED]> wrote on 01/11/2006 12:30:10 PM:
> I have two tables with data on people in them. Table A is a subset of
> table B, However, there is data about these people in table B that is
> not in table A. with a simple select I can do a join and get a result
> set with all
Do chmod -R 755 on datapath
Thanks
Praj
- Original Message -
From: "Jay Paulson (CE CEN)" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, January 11, 2006 10:47 PM
Subject: LOAD DATA INFILE
I'm creating a file via PHP after getting information from a log file. I
create a new file for data
You probably want a multi table update assuming you are running at least
4.0.x.
Add the column(s) to A with an ALTER TABLE
UPDATE A
INNER JOIN B
ON (...
SETA.col_name = B.col_name,
A.col_name_2 = B.col
WHERE ..
You can copy the join structure from the FR
For any of you that run into this problem I found this:
"After receiving some help from a friend it turns out that one of the
directories within the path to the target destination was not flagged 755,
and because of that one ( which happened to be 3 levels back) it didn't
allow mysql to properly e
One huge problem with this approach. The new table doesn't have any of
the indexes that were present in the previous table. You may be better
off to build a script that renames the current tables followed with the
full CREATE TABLE statement(s).
Do a SHOW CREATE TABLE current table;
Then take tha
A couple of things.
first: as documented in http://ca3.php.net/mysql_connect, the third
(optional) parameter is supposed to be the password, so if the password
for root has been left blank, this connect statement cannot succeed. It
may well be the only immediate problem.
second:
The easiest way to do that would be to CREATE TABLE new_table_name
SELECT (query you use to join the tables)
The old tables then become redundant.
On 11 Jan 2006, at 17:30, 2wsxdr5 wrote:
I have two tables with data on people in them. Table A is a subset
of table B, However, there is dat
Jon Miller wrote:
Having an error in a script that I cannot figure out why it's not working. The problem
is on line 15 "while ($row = mysql_fetch_object" ($result)).
What, exactly is the error?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I'm creating a file via PHP after getting information from a log file. I
create a new file for data import into a table in MySQL. For some reason now
I'm getting this error below. I have no clue what it means. I've checked the
file and it is all there and I've even changed the permissions on
Having an error in a script that I cannot figure out why it's not working. The
problem is on line 15 "while ($row = mysql_fetch_object" ($result)).
Movie Database
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
I'm using c++builder 6 and MYDAC 3.55 component with "MySQL client version:
4.1.3 Direct"
The MYDAC support told me that "MyDAC reserves memory for field data on
describing fields, before getting values from server. Other products, which
ignore performance, can detect end of string values by #0 ter
2006/1/11, George Law <[EMAIL PROTECTED]>:
> Hi All,
>
>
[snip]
>
> I have to work on an automatic way to rotate these tables every week.
> Is there an easy way with SQL to create a new table based on the schema
> of an existing table?
>
I believe CREATE TABLE newtbl SELECT blah... is what you'r
CREATE TABLE blah LIKE old_table
On 1/11/06, George Law <[EMAIL PROTECTED]> wrote:
> Hi All,
>
>
>
> Just another follow up on my emails.
>
>
>
> What this came down to was sheer number of records and indices in my
> tables causing it to take several minutes to insert 10-20K records via
> "load da
Hi All,
Just another follow up on my emails.
What this came down to was sheer number of records and indices in my
tables causing it to take several minutes to insert 10-20K records via
"load data ..."
table1 has probably 15 million rows, 60 fields per row, 1 index
table2 has 7 millio
"AESYS S.p.A. [Enzo Arlati]" <[EMAIL PROTECTED]> wrote on 01/11/2006
03:00:37 AM:
>
> I found out that when I run a query like 'show slave status' mysql I get
> wrong size of the data field.
>
> The component I using to read the field are using the field length by
the db
> to allocate the spac
Hi!
What must I do to move our mysql-database from 32-bit binaries to 64-bit
(mac os x). Is it as simple as just changing binaries for must I prepare
the data-files somehow?
Thanks in advance
Roland Carlsson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
I wouldn't hold your breath for any new 3.xx releases or updates. MySQL AB
has moved through developing and releasing and almost retiring the 4.0.x
and 4.1.x versions of its server line and is actively promoting v5.0.x
while still working on v5.1.x. The 4.1.x version is being supported with
p
I am looking for an experience MySQL administrator in the Connecticut
area to help us with our MySQL configuration.
ideally, we need someone experienced with configuring automated
backups, server optimization, query optimization, replication and
troubleshooting.
We operate OS X (10.3.9)/ MySQ
Hello list,
I am in a need of a database that contains the list of all countries,
regions and cities in the world, in RUSSIAN language. Does anybody know
where can I find it?
I searched Google but all of the databases are in English.
Have a great day,
Denis S Gerasimov
Web Develope
Hi all,
Server version :4.0.26
OS: FeeBSD-4.10
The mysql server(slave) crashes with the following messages in its error
log, and gets restarted, after which rollbacks and starts replicating from
master
Page directory corruption: supremum not pointed to
051226 10:02:58 InnoDB: Page dump
Hi there,
Still tracking down the BIT problems. For a simple statement, prefixing it
with
b'' works (as written in the documentation). Even with the
STRICT
mode turned ON.
However, for prepared statements, how do you bind a BIT(1) or BIT(n)?
This doesn't list BIT at all:
http://dev.mysql.com/doc
Hello.
MySQL 5.0.18 for Wondows.
CREATE TABLE test (CHAR(1)).
Not assigned 0x80 - 0xFF for CHAR().
When use:
mysql_stmt_prepare(), mysql_stmt_bind_param(), mysql_stmt_execute().
For NCHAR() successfully assigned 0x80 -
0xFF.
Successfully executed:
INSERT INTO test (h) VALUES(CHAR(128))
IN MySQL 5 you could use a sub query(
http://dev.mysql.com/doc/refman/5.0/en/any-in-some-subqueries.html).
However, i would try using a left join between cart and products and
then bring back the results where the products.id field is 'NULL'.
There may be a better way of doing this but that
4.0.18-standard-log
I have a table cart and a table products
Key is as follows:
products.id = cart.prod_id
The problem I have is we have decided to store the users cart, so when they
come back it is still in the same state they left it. Pretty usual stuff so
far.
Two things can possible happen
I found out that when I run a query like 'show slave status' mysql I get
wrong size of the data field.
The component I using to read the field are using the field length by the db
to allocate the space for data, so the mismatch cause the read of truncated
data.
Is this bug already known, and if
47 matches
Mail list logo