 | | | MySQL General | | Hi List
We have a transactions table (~600k records). I 'm trying a simple update
query it fails.
I thought this could be due to a reserved word problem but all names
have been escaped.
mysql > UPD
Is there a way to restrict the length of text field in MySQL. For example it
is of 65K limit and could hold more than 20000 characters. Is there a way to
restrict that to 4000 characters at table/fiWhen i do this he say MySL package is not installed but when i reinstall the same thing is
happen so thats what i told you he dont realy instal mysql and i dont know why........
Datum Fri 12 Nothing
the server is definetively not running
You get the bug script from me......
regards
Daniel
Datum Fri 12 Oct 2007 15 44 29 +0530
Von "Ananda Kumar " <anandkl@(protected) >
An "Daniel Bau " Hi Douglas
Douglas Pearson wrote
> Sorry if this is a dumb question but are SQL transactions in MySQL atomic?
> I 'm using InnoDB tables in MySQL5.
>
> Clearly transactions have the property thatSorry if this is a dumb question but are SQL transactions in MySQL atomic?
I 'm using InnoDB tables in MySQL5.
Clearly transactions have the property that either all updates occur or
none do. By at
> Hello
> where is the FROM for f1 table?
> Martin--
Why would there be any "FROM " for the f1 table? It 's not needed in the result.
Anyway I 've come up with a query that actually seems to do what Wagner
SHOW PROFILE[S] is documented at
http //dev.mysql.com/doc/refman/5.0/en/show-profiles.html.
5.0 Community edition only. Perhaps it will appear in 5.1 Community?
They do not say so.
PB
WaHi friends
Somebody here in this list have or knows where i get or read about the PROFILE of MySQL (SHOW PROFILE) ?
I see this article of Schummi but is most superficial. (http //dev.mysql.com/techAnders Norrbring wrote
> I 'm trying to set up a query but I don 't really get the result I
> expected so can someone please help me out here?
>
> The query I 've built is this
>
> SELECT a1.usernI 'm trying to set up a query but I don 't really get the result I
expected so can someone please help me out here?
The query I 've built is this
SELECT a1.username FROM accountuser AS a1
LEFT JOINThanks to all
> Check for bind-address in your my.cnf file
That solved the problem.
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysql
To unsubscribe http //listsCheck your my.cf file a /etc/my.cf.
To add the "bind-address <ip > " at the end of the file. Restart your
mysql. And grant the access to the user who you want to connect your
database from where yoFranz
Did you setup user access permissions outside of 127.0.0.1 and is port
3306 open on your firewall/router?
Jim Ginn
http //www.Tenant.com
> Hello
>
> Can anyone please give me a hint what IHi Chris
Chris W wrote
> I have 2 queries to give me a list of names.
>
> Q1
> SELECT DISTINCT FName LName
> FROM user u
> JOIN userprofile p
> USING ( UserID )
> JOIN trainingstatus t
> USING (After check the my.cnf how said by friend Patricio give the GRANT ALL ON *.* TO root@ '% ' for thet user do the remote connections.
For some doubts keep on list!
Bye!
Wagner Bianchi
Diretor de Check for bind-address in your my.cnf file
----- "Franz Edler " <franz.edler@(protected) > escribi??
> Hello
>
> Can anyone please give me a hint what I can do that MySQL also listens
> to
> the physicaHello
Can anyone please give me a hint what I can do that MySQL also listens to
the physical address of the host.
I see that MySQL listen only to 127.0.0.1 3306 and therefore every
connection via thHi friends
This is the first time i post in this list and send a "hello " 4 all. I 'm from Brazil.
So I have a doubt about the moment when u creat a new user.
In my high-school course That is a string comparison so they will never be equal. You don 't
have to put quotes around field names unless you are using reserved
words which you shouldn 't. If you do use "quotes " around fiOh and here 's the output (Sorry)
+-----------+Here 's my full test solution
use test
drop table if exists releases
create temporary table releases
(
releaseid int(10) unsigned not null auto_increment primary key
name varchar(255)
)engine m
> -----Original Message-----
> From Jay Pipes [mailto jay@(protected)]
> Sent Friday October 12 2007 2 07 PM
> To Daevid Vincent
> Cc mysql@(protected)
> Subject Re Need help with a "natAndrew Carlson wrote
> Is there a purchase order (10002) with no orders in the order_details table?
No PO 10002 is related to the order_id 2 here
> >mysql > SELECT order_id SUM(quantity * unit_pDaevid Vincent wrote
>
> I 'm trying to get some 'release/version numbers ' to sort properly.
>
> mysql > SELECT ReleaseID Name FROM releases ORDER BY Name DESC
> +-----------+-------------I have 2 queries to give me a list of names.
Q1
SELECT DISTINCT FName LName
FROM user u
JOIN userprofile p
USING ( UserID )
JOIN trainingstatus t
USING ( UserID )
WHERE ProgramID 12
ORDER BY LName
I 'm trying to get some 'release/version numbers ' to sort properly.
mysql > SELECT ReleaseID Name FROM releases ORDER BY Name DESC
+-----------+using 5.0.24
mysql > describe order_details
+------------+Paul
Take a look at the ulimit command. We had a similar issue and it turns out there are OS level per-process limits as well. We have now configured the /etc/init.d/mysql file set the ulimit to w >Mostly because use 2 field to represent the same data is a waste of storage
i think.
Oh ok. So you 're sending a non-date value and you want to transform it into
an
actual character presentation of |
|
|
