I've got a text field called source_recid. It stores half string half
number like strings in it.
Example
shop.orders.32442
the syntax is DATABASENAME.TABLENAME.RECID
My goal is to scan this col and find out the biggest RECID ( the
integer) in it.
So, in a case like this
shop.orders.32442
shop
Hi, I'm trying to get this work;
SELECT distinct `term`,count(*) as count FROM
blp_sql_distinct_temp_table where count >= 5 group by `term` order by
count DESC
But I get this error;
Unknown column 'count' in 'where clause'
How do I get only those records whose group by count is above 5?
--
My
Please take a look at the following code and tell me if there is a way
around it.
if ($current_server_is_mysql):
while ($row = mysql_fetch_assoc($RS)) {
else:
while( $row = sqlsrv_fetch_array( $RS, SQLSRV_FETCH_ASSOC)){
endif:
Depending on the server I'm working with, I'd like to compile m
My initial goal was to write a very convenient php function that display a
table view based on arguments that are super simple to write - without
requiring the developer to type-in ( or know ) the ins and outs of joins,
natural joins etc.
Something like this
function showtable($dbh,$table,$fields)
Gary,
you've mentioned that the user would have had access to the sysobjects
Let's assume he did. The page that this attempt occurred is hard-wired
to display a single record in detail view. In the code, I have a bunch
of echo $row- wrote:
> On 13/02/2012 21:48, Haluk Karamete wr
sorry, i overlooked that this IS a mysql mailing-list and we are
running ms-sql in this particular case. good catch...
I'd appreciate any insight though.
On Mon, Feb 13, 2012 at 1:56 PM, Gary Smith wrote:
> On 13/02/2012 21:48, Haluk Karamete wrote:
>>
>> My logs shows that
My logs shows that we have tried with a SQL Injection attempt, but
our engine has detected and avoided it but I am just curious, what are
these SQL statements are intending to achieve?
SELECT * FROM lecturer WHERE recID='25 ' and exists (select * from
sysobjects) and ''='' ORDER BY EntryDate DES
f any?
On Mon, Jan 16, 2012 at 7:41 PM, Willy Mularto wrote:
> use LIKE
>
>
>
> On Jan 17, 2012, at 10:36 AM, Haluk Karamete wrote:
>
>> How do I do case insensitive searches and replace operations?
>> Is there an easy way to do this? Like some sort of a server l
How do I do case insensitive searches and replace operations?
Is there an easy way to do this? Like some sort of a server level
setting telling mySQL to ignore case for once and for all?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.