Go Back   CodingForums.com > Search Forums
Reload this Page Search Results

Before you post, read our: Rules & Posting Guidelines

Page 1 of 20 1 2311 Last »
Showing results 1 to 25 of 500
Search took 3.18 seconds. Search: Posts Made By: BubikolRamios
Forum: General web building 05-17-2013, 11:01 PM
Replies: 1
Views: 175
Posted By BubikolRamios
disable ip browsing ?

When I type ip into browser my web page pops up.
How to disable that ? Only allow access via domain name.

Tomcat.

?
Forum: MySQL 05-07-2013, 08:28 AM
Replies: 2
Views: 236
Posted By BubikolRamios
Yes, there can be a problem with what you importd...

Yes, there can be a problem with what you importd via csv.

try

select ticker, hex(ticker)

That could reveal hidden characters.
Forum: MySQL 04-11-2013, 11:57 AM
Replies: 1
Views: 271
Posted By BubikolRamios
Something wrng with server or client, code got...

Something wrng with server or client, code got changed from upper good to lower corrupt.


'^(-|\\+){0,1}([0-9]+\\.[0-9]*|[0-9]*\\.[0-9]+|[0-9]+)$'...
Forum: MySQL 04-11-2013, 09:15 AM
Replies: 1
Views: 271
Posted By BubikolRamios
regex

select distinct(field)
from fixed_table
WHERE data not REGEXP '^(-|+){0,1}([0-9]+.[0-9]*|[0-9]*.[0-9]+|[0-9]+)$';


This was working, no change for 3 months.
now I suddenly get:
SQL...
Forum: MySQL 04-07-2013, 09:52 PM
Replies: 0
Views: 351
Posted By BubikolRamios
string help - I can't see something

EDIT: Ok.figured it, forget this thread.

want all between '&url=' and '&ei='
why it is not working ?

set @str =...
Forum: MySQL 04-07-2013, 12:21 PM
Replies: 0
Views: 295
Posted By BubikolRamios
secure dump of data ?

I have something like this on linux in crontab

mysqldump test -u user –pwd > /path/db-`date +\%Y-\%m-\%d`.sql


This sucks, coz linux has log of the things beeing executed that anyone able...
Forum: MySQL 04-05-2013, 08:59 PM
Replies: 1
Views: 319
Posted By BubikolRamios
LEFT JOIN mov_images ON...

LEFT JOIN mov_images ON mov_images.mov_id=mov_format.mov_id


This is normal (as per your command LEFT). You have many images per one movie, hence you get

mov1 image1
mov1 image2

hence...
Forum: MySQL 03-31-2013, 08:54 PM
Replies: 0
Views: 312
Posted By BubikolRamios
stored proc error handlingh

just did some testing, this:


DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
BEGIN
set i_result = -1;
END;

is pointless, coz jou don't get out what caused error.
Forum: MySQL 03-29-2013, 09:49 PM
Replies: 2
Views: 467
Posted By BubikolRamios
In your case it is pointless. The use od...

In your case it is pointless.

The use od declared variables comes in place where you need then and you can't use them unless they are declared: <-- this is the rule (EDIT: this applays to s.p....
Forum: MySQL 03-26-2013, 12:44 PM
Replies: 2
Views: 346
Posted By BubikolRamios
Your key (explain) is also empty. You probably...

Your key (explain) is also empty. You probably have not enought data so mysql would use any key. It fugures it is best to stash everythig into memory and does not use any key.
Forum: MySQL 03-26-2013, 12:24 PM
Replies: 1
Views: 282
Posted By BubikolRamios
ambiguous col

id is key


insert into test
select t1.id,@variable := t1.col from test t1
on duplicate key update col = col + @variable


same with this
Forum: MySQL 03-23-2013, 11:03 AM
Replies: 2
Views: 335
Posted By BubikolRamios
force column size

create destTable t as select column from sourceTable


the type & size of column in destTable is determined by mysql and is not necessary same as in sourceTable, besides it can be calculated, .......
Forum: MySQL 03-22-2013, 02:37 PM
Replies: 19
Views: 1,296
Posted By BubikolRamios
well, i do know what your problem is exactly, all...

well, i do know what your problem is exactly, all the time, as old pedant do, do nnt doubt of that at all (-: But you are forcing it all the time in the wrong way. Wrong way is not having any index...
Forum: MySQL 03-22-2013, 03:22 AM
Replies: 19
Views: 1,296
Posted By BubikolRamios
To hopefuly clarify to you some things. to...

To hopefuly clarify to you some things.

to merge two tables with any chance of good result:

1. they have to have identical structure
2. merged table must have the same structure as the source...
Forum: MySQL 03-19-2013, 08:44 PM
Replies: 19
Views: 1,296
Posted By BubikolRamios
where are indexes, keys ? To quote again, how...

where are indexes, keys ?
To quote again, how should create table code look like.
Forum: MySQL 03-19-2013, 08:18 PM
Replies: 26
Views: 1,577
Posted By BubikolRamios
Man, I was observing your patience & providing...

Man, I was observing your patience & providing tons of code and wondered when will this pop out :)
Forum: MySQL 03-19-2013, 08:08 PM
Replies: 19
Views: 1,296
Posted By BubikolRamios
Ok you figured you have auto inc field which is a...

Ok you figured you have auto inc field which is a key. I'm not a spoon bender to
figure out what other key fields you will pull out in next zilion posts.

You should understand one thing about...
Forum: MySQL 03-19-2013, 05:40 PM
Replies: 19
Views: 1,296
Posted By BubikolRamios
Well it is like this, in order to ask me a...

Well it is like this, in order to ask me a question about potatoes you must know ,approximately at least,what potatoes are, right ?

So get forinstance this: http://www.heidisql.com/download.php
...
Forum: MySQL 03-19-2013, 04:45 PM
Replies: 19
Views: 1,296
Posted By BubikolRamios
No . As I said, give as your students_merged ...

No . As I said, give as your students_merged table strcture.
Forum: MySQL 03-19-2013, 02:46 PM
Replies: 6
Views: 731
Posted By BubikolRamios
field name is name of what, user, course, ... ?

field name is name of what, user, course, ... ?
Forum: MySQL 03-19-2013, 02:30 PM
Replies: 19
Views: 1,296
Posted By BubikolRamios
order by when merging is pointles, you can always...

order by when merging is pointles, you can always do order by when geting data from merged table


only to update the merged tables




The key here is ignore keyword.
Forum: MySQL 03-19-2013, 12:15 AM
Replies: 19
Views: 1,296
Posted By BubikolRamios
http://dev.mysql.com/doc/refman/5.1/en/merge-stora...

http://dev.mysql.com/doc/refman/5.1/en/merge-storage-engine.html:

CREATE TABLE total (
-> a INT NOT NULL AUTO_INCREMENT,
-> message CHAR(20), INDEX(a))
-> ENGINE=MERGE...
Forum: MySQL 03-18-2013, 06:12 PM
Replies: 4
Views: 540
Posted By BubikolRamios
as OLdPedant pointed out the other day(s), the...

as OLdPedant pointed out the other day(s), the 'where' part for dependant table should be in join part
so this:

select s.sr_id, p.item_code, p.lot_number from sr_chemicals AS s JOIN wms_picking...
Forum: MySQL 03-17-2013, 10:32 PM
Replies: 4
Views: 545
Posted By BubikolRamios
Yes this can be done via mysql: SELECT...

Yes this can be done via mysql:


SELECT t.*, @num := @num + 1 b from table t, (SELECT @num := 0) d;



This is a copy from my stash, so don't ask me how it works. It just does.:thumbsup:
Forum: MySQL 03-17-2013, 10:18 PM
Replies: 1
Resolved Case null
Views: 294
Posted By BubikolRamios
found solution here:...

found solution here: http://dev.mysql.com/doc/refman/5.0/en/working-with-null.html
Showing results 1 to 25 of 500
Page 1 of 20 1 2311 Last »

 
Forum Jump

All times are GMT +1. The time now is 09:46 PM.