sql - MySQL Order of Index Checks -

-

i running mysql , have simple table below:

create table `new_schema`.`test1` (   `id` int not null auto_increment,   `unique1` varchar(45) null,   `unique2` varchar(45) null,   primary key (`id`),   unique index `unique1_unique` (`unique1` asc),   unique index `unique2_unique` (`unique2` asc));

i add row such:

insert `new_schema`.`test1` (`unique1`, `unique2`) values ('x', 'x');

i add row same values in unique unique columns:

insert `new_schema`.`test1` (`unique1`, `unique2`) values ('x', 'x');

i error expected:

11:54:06    insert `new_schema`.`test1` (`unique1`, `unique2`) values ('x', 'x')   error code: 1062. duplicate entry 'x' key 'unique1_unique'  0.203 sec

my question is, how change order in mysql checks unique values entered. so, given example above, provided 2 violations of unique entries (unique1 , unique2), want check unique2 first, error this:

11:54:06    insert `new_schema`.`test1` (`unique1`, `unique2`) values ('x', 'x')   error code: 1062. duplicate entry 'x' key 'unique2_unique'  0.203 sec

thanks, mark

have trie change position that

    unique key index `unique_unique` (`unique2`,`unique1`)

like that:

 create table `new_schema`.`test1` (    `id` int not null auto_increment,    `unique1` varchar(45) null,    `unique2` varchar(45) null,   primary key (`id`),  unique key index `unique_unique` (`unique2`,`unique1`)  );

Comments

Post a Comment

Popular posts from this blog

c# - SelectList with Dictionary, add values to the Dictionary after it's assigned to SelectList -

-
i have following code - dictionary<string, string> mydict = new dictionary<string, string>(); mydict.add("keya", "valuea"); mydict.add("keyb", "valueb"); ienumerable<selectlistitem> myselectlist = new selectlist(mydict, "key", "value") further down in program, want add values mydict . possible? if yes, how? want - myselectlist.mydict.add("keyc", "valuec"); if you're wanting add items mydict, possible, , changes reflected in of myselectlist 's enumerations long changes made before enumeration (e.g. using .tolist() ) generated. as worked example: dictionary<string, string> mydict = new dictionary<string, string>(); mydict.add("keya", "valuea"); mydict.add("keyb", "valueb"); ienumerable<selectlistitem> myselectlist = new selectlist(mydict, "key", "value...
Read more

how can i manage url using .htaccess in php? -

-
i want manage url of website right showing me www.computermall.co.in/product_details.php?prdid=34 but want www.computermall.co.in/product_details/34 how can it? i have tried this options +followsymlinks -multiviews rewriteengine on rewritebase /computermall # uri-path directly the_request variable rewritecond %{the_request} ^(get|head)\s/(.*)\.php [nc] # strip extension , redirect permanently rewriterule .* /%2 [r=301,l,nc] rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewritecond %{request_uri} !\.php [nc] # map internally original resource rewriterule ^(.*)$ $1.php [l,qsa] try this: rewriteengine on rewriterule ^product_details/prdid/([^/]*)$ /product_details?prdid=$1 [l] edit: removed leading slash
Read more

ios - I get the error Property '...' not found on object of type '...' -

-
appdelegate.h #import <uikit/uikit.h> @interface appdelegate : uiresponder <uiapplicationdelegate> @property (strong, nonatomic) uiwindow *window; @end appdelegate.m #import "appdelegate.h" #import "firstviewcontroller.h" #import "secondviewcontroller.h" @implementation appdelegate - (bool)application:(uiapplication *)application didfinishlaunchingwithoptions: goes on normal app.......... @end firstviewcontroller.h #import <uikit/uikit.h> @interface firstviewcontroller : uiviewcontroller @property (strong, nonatomic) iboutlet uiimageview *bground; - (ibaction)settingspressed:(id)sender; - (ibaction)startpressed:(id)sender; @end @class secondviewcontroller; @interface secondviewcontroller : uiviewcontroller @property(strong,nonatomic)secondviewcontroller *secondviewcontroller; @end firstviewcontroller.m #import "firstviewcontroller.h" @interface firstviewcontroller () @end @implement...
Read more