>From: Mitchell Wright <[EMAIL PROTECTED]>
>
>Is phpmyadmin secure?
I believe in the default install, it sends cleartext passwords. I use it on a trusted
LAN only, so I don't care, but you should probably buttress it's login with a
.htaccess and password.
--
SQL SQL SQL SQL SQL SQL SQL SQ
This is what happens when you use LIMIT
MySQL retrieves the entire record set for the select and then sends the
number requested in the LIMIT parameter to the client. MySQL has to
retrieve the entire result set to accommodate a LIMIT clause which skips
n records i.e. LIMIT 250,10.
With no ORDER B
David Lloyd wrote:
Mark,
Note that mysql does not support bind variables. If you think
you're>using them, whatever API you are using is filling them in
before>sending the statement to mysql. Bind variables do solve
quoting>problems, though, so if you use them, know why you're using
them :)>
At 15:46 -0600 10/25/02, Jeff Mathis wrote:
forgive me.
i was initially using the perl DBI methods to load. I am not intimately
familiar with the inner workings of DBI, but obviously it must be doing
something if you say mysql does not support binding variables
(i am using 4.0.4). This is signifi
Hi,
When trying to check/repair/analaiz a table with a name like 'table-name'
mysqlcheck (from source package 3.23.53) fails with:
mysqlcheck: Got error: 1064: You have an error in your SQL syntax near '-name'
at line 1 when executing 'CHECK TABLE ...
Here's the patch for it:
--- mysqlcheck.old
Artem,
Thursday, October 24, 2002, 7:34:02 PM, you wrote:
AK> Description:
AK> Probably it's variation of recent bug with null joins, but just in case I want to
post it here because result depends on values inserted into tables, even if these
values are not participating in
AK> join.
AK> After d
Hi MySQLs
Iv'e been using gcc 2.96-10 to compile a database
program (ver. 3.23.49 I guess) in c and everything
worked fine. It was compiled as a cc program. Lately
I've installed mysql 4.0.4 with developer and gcc 3.2
(default with Redhat 8.0) and simply want to compile
the same program, but get t
I am trying a "worst-case-scenario" of my databse.
I have, so far, come up with some numbers to do the
calculations with and perhaps a way of splitting one
big table into smaller, yet structured, tables.
(These questions are not limited by hardware, because
if the need for speed is there, the reve
On Fri, 2002-10-25 at 23:42, Michael J. Fuhrman wrote:
> Hello All,
>
> Need to know if a RecordSet AppendChunk is interactive or does it accumulate
> the field's data until an Update is called? I'm finding that the Update
> fails if the total RecordSet size is greater than Max_Allowed_Packet. I
I want to do:
SELECT @Rate:=Rate FROM Project WHERE ProjectID = 'x';
INSERT INTO BillingTime (Start, End, ProjectID, Rate) values (a, b, x,
@Rate);
... but I'm sure its doable in a single query, even if I have multiple
values to query, is it?
INSERT INTO BillingTime (Start, End, ProjectID, Rat
Mark,
> >>Note that mysql does not support bind variables. If you think
> >you're>using them, whatever API you are using is filling them in
> >before>sending the statement to mysql. Bind variables do solve
> >quoting>problems, though, so if you use them, know why you're using
> >them :)>
Rumou
Franklin Williams Jr. wrote:
> I have a table with names in it where the names can function as 1 of 2
> things -
> either an artist or a group. In order to make searching easy I wished
> to keep
> these names in one table. EG: searching for artist name, whether a
> group or
> soloist you would hav
Franklin, the "basic relational rules"
(http://hometown.aol.com/mbaddenda/art120.html,
http://www.cs.sfu.ca/CC/354/zaiane/material/notes/Chapter7/node1.html) say,
decompose relationships like your artists & groups to separate tables, and
your example fits right in.
PB
-
- Original Messag
I have a table with names in it where the names can function as 1 of 2 things -
either an artist or a group. In order to make searching easy I wished to keep
these names in one table. EG: searching for artist name, whether a group or
soloist you would have to search only one table. The problem aris
Hello All,
Need to know if a RecordSet AppendChunk is interactive or does it accumulate
the field's data until an Update is called? I'm finding that the Update
fails if the total RecordSet size is greater than Max_Allowed_Packet. If
the later is true .. I guess I'll need work around suggestions,
15 matches
Mail list logo
