Dwight Tovey wrote:
Brent Anderson wrote:
Hello.
I'm developing a client application for several platforms that will
need to connect to a remote MySQL database. Unfortunately, MySQL
refuses connections from external IP's that aren't allowed and since
the clients using this will be on unknown IP
Ravi Kumar. wrote:
Dear Friends,
I have two tables: T1, T2.
T1 has 3 columns: playerid, gameid, score
T2 has 2 columns: playerid, totalscore.
I wish to update table T2 such that sum of T1.score of each player, gets
updated in T2.totalscore. It may be something like this:
update T2, T1 s
ViSolve DB Team wrote:
Hi,
Try this..
UPDATE table2 inner join table1 on table2.playedid=table1.playerid
SET table2.totalscore=sum(table1.score)
Just a guess...
Thanks,
ViSolve DB Team
- Original Message - From: "Ravi Kumar." <[EMAIL PROTECTED]>
To:
Sent: Wednesday, December 06, 200
C.R.Vegelin wrote:
Hi List,
I need to SUM() on months from a table like:
CREATE TABLE `data`
( `Jan` float default NULL,
...
) ENGINE=MyISAM; # V 5.0.15
Months may have NULL values, like:
INSERT INTO data (Jan) VALUES (1), (NULL);
However, when I use SELECT SUM(Jan) AS Jan,
the returned value
Joey wrote:
I wanted to confirm something as I am having a problem logging into mysql
from the network.
I have a server configured with a user showing host as % and the user with
it's appropriate privalages. It allows me to login from phpmyadmin as well
as via port 3306 to connect to the DB wi
Filipe Freitas wrote:
Hi,
This is not a mysql thing but maybe you can help me.
I want to call a stored procedure from PHP, so I tried it like normal
querys: mysql_query("CALL mySP();"); with no success.
thx
I'm not PHP expert but I've managed to do this in perl using DBI (in
spite of all d
John Kopanas wrote:
Argh... I am autogenerating a load file after parsing and massaging a
text file I get from an AS/400 system. My first field is an id that
is on auto_number so I put a tab at the begging of the line for each
one of my records... it throws a warning for each line... if instead
Jesse wrote:
Strange it ran just fine here on my 5.0.22-nt with sample MyISAM table
`alumni`... Is your table `alumni` MyISAM or Innodb?
It is MyISAM.
Here are few more pointers:
1. If it is possible *always* try latest version first when solving
problems. In your case 5.0.22 I think...
Y
Jesse wrote:
Are you sure this is the right line - I mean the whole statement?
You are right, I did not include the whole statement. Here's the entire
section:
/*!50003 SET @OLD_SQL_MODE=@@SQL_MODE*/;
DELIMITER ;;
/*!50003 SET SESSION
SQL_MODE="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENG
Jesse wrote:
I have a backup that was created by a MySQL 5 server using MySQLDump.
When I try to restore the database using the following command:
mysql -u root -p -D BPA < c:\backup\mydata.sql
I get the error:
ERROR 1064 (42000) at line 29765: You have an error in your SQL syntax;
check the
Jesse wrote:
I read in the manual that MySQLHotCopy would be better than MySQLDump
for backing up MyISAM tables. However, I cannot find a .exe in the bin
directory by that name. I found a script by that name in a 4.1
installation that I have, but I don't think it's the latest version. Is
th
Lubomir Host 'rajo' wrote:
Description:
Migration problem from 4.0.22 to 5.0.x. I can't create following table on 5.0.x
version of mysql. Problem does't apper on 4.0.x version:
CREATE TABLE `PHONESlog_uniq` (
`user_agent` varchar(80) default NULL,
`http_x_wap_profile` varchar(255) default
Jesse wrote:
I need to be able to do an UPDATE based on a relation. The following
code works in Microsoft SQL. What is the MySQL Equivalent?
UPDATE Chapters
SET MatSentDate='2006-07-04'
FROM Invoices I JOIN Chapters C ON C.ID=I.ChapterID
JOIN Schools S ON S.ID=C.SchoolID
WHERE I.InvoiceDate >=
If you are using autoincrement filed you could try this:
ALTER TABLE `my_database`.`my_table` AUTO_INCREMENT = 201;
...or else if it is some stored proc you should find and edit table
where it sotres index/counter data..
Tom Ray [Lists] wrote:
Hey, I have a really simple question (I h
Lukasz Budnik wrote:
Hi Remo,
just a thought... Can you try OPTIMIZE TABLE... or REPAIR TABLE ...
[EXTENDED] first
then try those queries again HTH
I've just run those statements, results:
optimize | status | OK
repair | status | OK
but like 'Szczec%' still returns 1 row
(now I know tha
Lukasz Budnik wrote:
Hi All,
I'm using 5.0.21 on Gentoo.
I've got very strange problem.
I have clients table with id_c and name columns.
I'm running simple selects:
mysql> select id_c, name, concat('#',name, '@'), length(name) from clients
where name like 'Szczec%';
+---+--+-
http://perso.easynet.fr/cibderf/tout.html
HTH
Pedro mpa wrote:
Greetings.
I'm building an application and I need to import data to mysql from a db
format I don't know. Unfortunately the person in charge of the data won't be
reachable for the next 2 weeks and I want to continue my work.
Luke Vanderfluit wrote:
Hi.
I've got mysql 4.0.18 installed on a sun X4100 running solaris.
This is just a 32 bit version of mysql.
I've reverted back to this version after trying mysql 5, 4.0.26 and
4.0.18 64bit.
Those versions were all unstable on 64bit, that is, the server would
just go aw
[EMAIL PROTECTED] wrote:
Hi,
Anyone out there using MySQL and Delphi together?
Would love to exchange experiences.
Regards,
John
John Barrington
[EMAIL PROTECTED]
+27 11 6489876
You'd better try Borland's newsgroups like:
borland.public.delphi.database.dbexpress
etc. - that's where the pro
David Godsey wrote:
This might be an unusual question because mysql always stores in little
endian for all platforms (if I'm not mistaken). However, I am receiving
data from several different platforms (custom boards with various
processors) in raw form. I will have stored as a configuration op
Perumal, Jai wrote:
Hi,
We install the mysql version 5.0.16 on Linux Red hat as the root operating
system user. After the install we changed the ownership and group to a mysql
UNIX user. We tested starting and stopping the mysql server using the mysql
UNIX user account and it worked fine.
kalin mintchev wrote:
system freebsd 4.10
mysql is binary: mysql-standard-5.0.15-freebsd4.7-i386
after mysql installation and root password set up i can type:
/usr/local/mysql/bin/mysql -u no_matter_what_user_here
and i get right in. even if i type -p. i do get the password prompt
kalin mintchev wrote:
system freebsd 4.10
mysql is binary: mysql-standard-5.0.15-freebsd4.7-i386
after mysql installation and root password set up i can type:
/usr/local/mysql/bin/mysql -u no_matter_what_user_here
and i get right in. even if i type -p. i do get the password prompt
Which component, Spider?
with TSQLQuery try setting: ParamCheck property to false. Look in help
for your specific component...
To Leo's :
Delphi/dbExpress uses ':' character to specify SQL Parameters much alike
mysql uses '@' for variables :)
e.g.:
q.sql := 'select * from tbl where col1=:val1
As seen in manual there's no exact data type for your kind of data:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-type-overview.html
see also:
http://dev.mysql.com/doc/refman/5.0/en/column-types.html
so you can:
1. Use 1 timestamp column and 1 INT column just for milliseconds
2. Use BIGINT
http://dev.mysql.com/doc/mysql/en/delete.html
...
Multiple-table syntax:
DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
tbl_name[.*] [, tbl_name[.*] ...]
FROM table_references
[WHERE where_definition]
Or:
DELETE [LOW_PRIORITY] [QUICK] [IGNORE]
FROM tbl_name[.*] [, tbl_name[
Philippe HAMEAU wrote:
Hi,
I noticed 1 bug with 5.0.13rc (win32 msi) :
when installing mysql in a custom location (eg c:\program
files\easyphp\mysql),
1) the service will not get installed properly
2) mysqld will complain about InnoDB engine not present.
Hope this helps.
Phil
Have you read:
...and 3. Are you running another instance of mysql? Then perhaps both
compete for same resource(s) like: port 3306 ;-)
Remo Tex wrote:
1) that's common problem when doing custom install on PATH containing
spaces like "C:\Program Files". Solution - try custom location with
sho
1) that's common problem when doing custom install on PATH containing
spaces like "C:\Program Files". Solution - try custom location with
short(er) path and without spaces like "C:\mysql5013\". Probably that
will solve problem 2. if not then..
2. Edit my.ini looking for skip-innodb or related o
Perhaps you could try "MySQL Migration Toolkit"
http://dev.mysql.com/downloads/migration-toolkit/1.0.html
still beta though...
NB!
ATTENTION: Before installing the MySQL Migration Toolkit please download
and install the Java 5.0 or 1.4.2 Runtime Environment (JRE) from
http://java.sun.com
NOTI
...and when MySQL-shared-compat-4.0.26-0.i386.rpm will be released?
rpm (and some older tools) complains :(
There is only:
Dynamic client libraries
(including 3.23.x libraries)4.0.25-0482.1K
Joerg Bruehe wrote:
Hi,
MySQL 4.0.26, a new version of the popular Open Source/
http://dev.mysql.com/doc/mysql/en/insert-select.html
There are 2 forms of INSERT INTO statement
1. INSERT INTO tbl_name (...) VALUES(...);
2. INSERT INTO tbl_name (...) SELECT ...;
there's no : INSERT INTO tbl_name (...) VALUES(...) SELECT ...;
its either ... or in MySQL i.e. aither provide values
Liz you didn't mention by I suppose you're using Windows client too i.e.
mysql.exe. A quick test revealed that in such a case char limit is <=255
i.e. that's limitation of Windows Command Prompt: command.com or in case
of Win NT,2000,XP - cmd.exe
try writing your long SQL command in text file a
s this server version issue mysql 4.0.24 accepts
column_priv w/o error(s) justs doesn't enforce them?
--
Remo Tex wrote:
I want to allow some users to SELECT, INSERT, UPDATE all columns in a
table EXCEPT 1 (last one). Is it possile in MYSQL and how?
So my question is :
What COLUMN_INSERT pr
I want to allow some users to SELECT, INSERT, UPDATE all columns in a
table EXCEPT 1 (last one). Is it possile in MYSQL and how?
So my question is :
What COLUMN_INSERT privilege does? How can I INSERT_COLUMN without
having to insert whole row? Does COLUMN_INSERT = TABLE_INSERT?
I've found some
NB! ...WHERE doycol=312
Valid only for dates <= 28.Feb
OR Dates > 29.Feb but not in leap year(s) ;-)
> doycol=DAYOFYEAR("2004-11-07")
>
> or
>
> doycol=312
Eric McGrane wrote:
How about adding another column that stores the day of year for the
birthday. You could then index on this column and your
SELECT DISTINCT study FROM table WHERE keyword='chemistry';
- Of course if it's 'chemistry' it IS <> ''computers' or anything else
'chemistry' <> 'computers'
so last part ot your SQL statement is obsolete
L a n a wrote:
Hello,
I've had a problem trying to get working except operator in mysql:
sta
Have you tried insertig non-breaking space instead #160 or 0xA0 ...i think so
" " - this shoud be it /taken from here "3,02 KB (3 098 bytes)"-All
NON-Breaking/
HTH ;-)
John Mistler wrote:
> Is there a way to force an invisible "space" character to be stored at the
> END of a string in a column (e
38 matches
Mail list logo
