Hi,
I am new to MySQL and old to MS Access (advanced skill level).
When building Access DBs, I write VB code, SQL, develop DBs using 3rd N.F.
and build lovely forms for data entry, print outs, reports etc, etc.
After examing MySQL's material, I don't see any forms like I use in Access.
So
Tomas Isakowitz [EMAIL PROTECTED] wrote:
The following query does not work. It fits the exact format of DELETE in
the documentation.
DELETE from price WHERE ticker ='MSFT' ORDER BY date DESC LIMIT 3;
I am trying to delete the most recent 3 records. I get an error You
have an error in
Do you know if there ever will be
possibility to not only match with REGEXes,
but also SELECT with them? Sth like
SELECT REGEX('img [^]+', x_article.Content) FROM ...
--
Seks, seksi, seksolatki... news:pl.soc.seks.moderowana
http://hyperreal.info { iWanToDie } WiNoNa) (
* Soheil Shaghaghi
Hello everyone,
I need help with MySQL coding in php please if anyone can help.
I can try. :)
I have 3 tables:
-users, where the user info is stored.
-awards: contains the list of all the awards for each user
-award_types: contains different types of award
The tables
On Dec 28, 2003, at 4:49 AM, Adam Jones wrote:
When building Access DBs, I write VB code, SQL, develop DBs using 3rd
N.F. and build lovely forms for data entry, print outs, reports etc,
etc.
After examing MySQL's material, I don't see any forms like I use in
Access. So what GUI should I use
hi
in the php manual, regarding 'mysql_affected_rows()'
it says:
When using UPDATE, MySQL will not update columns where
the new value is the same as the old value. This
creates the possiblity that mysql_affected_rows() may
not actually equal the number of rows matched, only
the number of rows that
--- Abs [EMAIL PROTECTED] wrote: hi
in the php manual, regarding 'mysql_affected_rows()'
it says:
When using UPDATE, MySQL will not update columns
where
the new value is the same as the old value. This
creates the possiblity that mysql_affected_rows()
may
not actually equal the number of
I don't think you can use alter table to change character sets in version 3.23.51.
You must do it at the server level. Try starting mysql with this command line option:
--default-character-set=hebrew
Hope this helps.
Jeremy
My application no longer works because COUNT(*) returns BIGINT in 4.1x
In 4.0x it returns INT. I cannot find any notification of the change from INT to
BIGINT.
How can I fix this with out having recode and recompile all my applications?
Thanks
SQL
Description:
User has ALL grants to the database.
mysql show grants for [EMAIL PROTECTED];
+---
--+
| Grants for [EMAIL PROTECTED]
|
Does anyone know of a site that offers online training in mysql for the
purpose of passing the certification tests? I am willing to pay for
descent training, especially if the provider is recognized by mysql AB.
Sincerely,
Marc DVer
--
MySQL General Mailing List
For list archives:
Hello Every Body ,
I have been facing a strange problem, that i assume its a mysql bug of
some sort.
In my datadabase there are 2 tables, if i tried to add any index to them
,any INSERT INTO request status will be - in show processlist- update
and will freeze like this forever , and consequently
At 06:28 PM 12/28/2003, you wrote:
Hello Every Body ,
I have been facing a strange problem, that i assume its a mysql bug of
some sort.
In my datadabase there are 2 tables, if i tried to add any index to them
,any INSERT INTO request status will be - in show processlist- update
and will freeze
I asked before regarding the supposed 100 million row limit of MySQL. The
said information was given to me by my colleague who has been using MSSQL
to develop applications. After asking him where he got the info., he gave
the follwoing URL:
designed to work with and not compatible with anything over are two
/VERY/ different things. Yes, it performs very well on smaller tables...it
also happens to work quite nicely on bloody huge ones. My computer's
motherboard has a designed for Windows XP sticker on its box. That
doesn't mean it
I have enough disk space for indexes, the problem doesn't happen during
adding an index. it happens after the index is added.
On Sun, 2003-12-28 at 21:33, mos wrote:
At 06:28 PM 12/28/2003, you wrote:
Hello Every Body ,
I have been facing a strange problem, that i assume its a mysql bug of
Hi folks,
just compiled up mysql-4.0.17.tar.gz on a (stock, basic install) RHEL3
system, and get similar symptoms to something I experienced a while ago
with RH9. that is... it compiles fine, but wont start.
The ./configure options are:
./configure '--prefix=/opt/local/stow/mysql-4.0.17'
Andres Montiel wrote:
I asked before regarding the supposed 100 million row limit of MySQL. The
said information was given to me by my colleague who has been using MSSQL
to develop applications. After asking him where he got the info., he gave
the follwoing URL:
Can't resist... or 100 million rows won't run with a real db, like
oracle, rather that the designers were thinking mysql when they built
it...
Sorry ;)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 28, 2003 6:56 PM
To: [EMAIL PROTECTED]
Hi All,
i have a problem everytime i call the function mysql_close(),
it result in Access Violation Error in module libmysql.dll
fyi,
im migrating from 3.23.52 to 4.0.x
server runs under linux,
im accesing the server through windows based application
built with delphi, using Object Pascal
20 matches
Mail list logo