Search results for query: *

and correct me if I am wrong with unique it will not allow me to do issue I explained in previous post..

Yes but what if I for one day have to insert these values: INSERT INTO activ (ms, year, month, day) VALUES ('99999423','2007','03','24'); INSERT INTO activ (ms, year, month, day) VALUES ('44433431','2007','03','24'); etc.. It should allow me to do so..but if I try to insert it again after one...

CREATE TABLE `activ` ( `id` int(10) unsigned NOT NULL auto_increment, `ms` char(15) NOT NULL default '', `year` char(4) default NULL, `month` char(2) default NULL, `day` char(2) default NULL, PRIMARY KEY (`id`,`ms`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 that is show create table...

I tried and it allows me to insert same row again..

Nothing happened..I still can insert same data like: INSERT INTO activ (ms, year, month, day) VALUES ('32434432','2007','03','24');

Hellooo I created table in mysql: CREATE TABLE activ ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (id), ms CHAR(15), year CHAR(4), month CHAR(2), day CHAR(2) ); I want to prevent...

Hmm...what to say..It is working..I do appreciate your help... And thanks for explanation..but this PHV's code is not clear to me.. :) Thanks it works cheers

Thanks...but I am not quiet sure for the meaning of SHORT_NAME=`echo $file | sed 's/file/&]/' | sed 's/].*//'` cat $file >> $SHORT_NAME Also I hope that content of 12file will be 2 files (12file1 + 12file34) etc. can U just help me out with meaning of whose 2 sed...

Helloo.. I have no idea where to start with this problem... In my directory there are ~1000 files.. each ones name starts with number.. for example.. 12file1 13file124 142file5 12file34 13file9 1file12 ok I sorted them but how to merge thoese with same digits numberst in their name.. to...

Helloo... I am not much familiar with python..I found this small script in python I even do not have python on my computer...can anyone help me out to convert this into ksh or sh.. PLEASE any help I will appreciate.. here is python code.. #!/usr/bin/env python import random # Get a random...

no...no more other scripts..:( here is output of select granted_role from user_role_privs; SQL> select granted_role from user_role_privs; GRANTED_ROLE ------------------------------ CONNECT SQL> I can tell it is very bad..not much privilages.. Also as I mention I connect to unix as...

ok here it is> >ls -l /etc/shadow -r-------- 1 root sys 608 Jan 9 11:39 /etc/shadow >ls -l /etc/passwd -r--r--r-- 1 root sys 1210 Nov 23 13:48 /etc/passwd >ls -l /usr/bin/passwd -r-sr-sr-x 3 root sys 96416 Feb 4 2000 /usr/bin/passwd Also...

here is it >cat /etc/nsswitch.conf # # /etc/nsswitch.files: # # An example file that could be copied over to /etc/nsswitch.conf; it # does not use any naming service. # # "hosts:" and "services:" in this file are used only if the # /etc/netconfig file has a "-" for nametoaddr_libs of "inet"...

no I change nothing... >cat /etc/passwd root:x:0:1:Super-User:/:/usr/bin/ksh daemon:x:1:1::/: bin:x:2:2::/usr/bin: sys:x:3:3::/: adm:x:4:4:Admin:/var/adm: lp:x:71:8:Line Printer Admin:/usr/spool/lp: smtp:x:0:0:Mail Daemon User:/: uucp:x:5:5:uucp Admin:/usr/lib/uucp: nuucp:x:9:9:uucp...

U said As root, you may change oracle's password. how could I do that?? if I do >passwd -s oracle I got this: Permission denied

OK maybe it is not working as root..I can see in my /etc/passwd that there is oracle user su -oracle I have been asked for oracle password..I do not know that password.. thanks

But still..I can not connect to database..

well..as U can see I have no experience in DB..I worked only with mySQL ..but comparing it with oracle mysql is very simple.. when I do cat config.s I get this: >cat config.s .section ".text",#alloc,#execinstr /* 0x0000 7 */ .file "x.c" .section...

Hello friends... I am having old machine with oracle 8 on it oracle is running on solaris /home/oracle/8.1.6 I do not know user name and password...is there a way to change user /pass or find out what was username /password I have root privelage on my solaris.. is there a way to recover out...

Heloo.. I have coded in PHP telnet conn. and I can with no problem execute any command on my solaris machhine (PHP is on windows doing telenet conn to solaris) for example I have script that works something on solaris I just add it to PHP code on windows and it executes it...BUT...only thing...