How to use auto-increment Id in another column in same INSERT QUERY in MYSQL?












0















How to use auto-increment Id in another column in INSERT QUERY in MYSQL?



I want to add user with code. like if user_id after insert is 1 the code will be US1 similarly if user_id after insert is 954 the code will be US954



This is what I'm currently doing



"INSERT INTO `users` (`user_id`, `user`, `code`) VALUES (NULL, 'Alice', NULL);"


and then retrieve last insert id in PHP (Codeigniter)



$insert_id = $this->db->insert_id();


and then update code with auto increment id



"UPDATE `users` SET `code` = CONCAT('US', '" . $insert_id . "') WHERE `user_id` = " . $insert_id . ";";


Is there anyway you can do it in a single INSERT QUERY in MYSQL?



EDIT:
This is not same as this Insert/ update at the same time in a MySql table?. Because this one asking on concurrent operation of two users simultaneously which is not my question






php mysql







share|improve this question




















  • 2





    No, think about it, you asking if it's possible to get the egg before the chicken has laid it!

    – SPlatten
    Nov 14 '18 at 11:25






  • 2





    "you asking if it's possible to get the egg before the chicken has laid it!" What makes me wonder was the chicken first or the egg? @SPlatten

    – Raymond Nijland
    Nov 14 '18 at 11:28













  • @RaymondNijland lol I get it now.

    – Faizan Rupani
    Nov 14 '18 at 11:30






  • 1





    @RaymondNijland, :) In this case you can get the last insert ID once the record has been inserted, but what is required here is to use the same ID...I would suggest writing a stored procedure which enables you to manage this kind of thing much easier.

    – SPlatten
    Nov 14 '18 at 12:50






  • 1





    "In this case you can get the last insert ID once the record has been inserted, but what is required here is to use the same ID." i know @SPlatten i did post and removed a answer about LAST_INSERT_ID() .. because it didn't know for sure if the topicstarter required that and because it wanted to do it in one query.

    – Raymond Nijland
    Nov 14 '18 at 16:49


















0















How to use auto-increment Id in another column in INSERT QUERY in MYSQL?



I want to add user with code. like if user_id after insert is 1 the code will be US1 similarly if user_id after insert is 954 the code will be US954



This is what I'm currently doing



"INSERT INTO `users` (`user_id`, `user`, `code`) VALUES (NULL, 'Alice', NULL);"


and then retrieve last insert id in PHP (Codeigniter)



$insert_id = $this->db->insert_id();


and then update code with auto increment id



"UPDATE `users` SET `code` = CONCAT('US', '" . $insert_id . "') WHERE `user_id` = " . $insert_id . ";";


Is there anyway you can do it in a single INSERT QUERY in MYSQL?



EDIT:
This is not same as this Insert/ update at the same time in a MySql table?. Because this one asking on concurrent operation of two users simultaneously which is not my question






php mysql







share|improve this question




















  • 2





    No, think about it, you asking if it's possible to get the egg before the chicken has laid it!

    – SPlatten
    Nov 14 '18 at 11:25






  • 2





    "you asking if it's possible to get the egg before the chicken has laid it!" What makes me wonder was the chicken first or the egg? @SPlatten

    – Raymond Nijland
    Nov 14 '18 at 11:28













  • @RaymondNijland lol I get it now.

    – Faizan Rupani
    Nov 14 '18 at 11:30






  • 1





    @RaymondNijland, :) In this case you can get the last insert ID once the record has been inserted, but what is required here is to use the same ID...I would suggest writing a stored procedure which enables you to manage this kind of thing much easier.

    – SPlatten
    Nov 14 '18 at 12:50






  • 1





    "In this case you can get the last insert ID once the record has been inserted, but what is required here is to use the same ID." i know @SPlatten i did post and removed a answer about LAST_INSERT_ID() .. because it didn't know for sure if the topicstarter required that and because it wanted to do it in one query.

    – Raymond Nijland
    Nov 14 '18 at 16:49
















0












0








0








How to use auto-increment Id in another column in INSERT QUERY in MYSQL?



I want to add user with code. like if user_id after insert is 1 the code will be US1 similarly if user_id after insert is 954 the code will be US954



This is what I'm currently doing



"INSERT INTO `users` (`user_id`, `user`, `code`) VALUES (NULL, 'Alice', NULL);"


and then retrieve last insert id in PHP (Codeigniter)



$insert_id = $this->db->insert_id();


and then update code with auto increment id



"UPDATE `users` SET `code` = CONCAT('US', '" . $insert_id . "') WHERE `user_id` = " . $insert_id . ";";


Is there anyway you can do it in a single INSERT QUERY in MYSQL?



EDIT:
This is not same as this Insert/ update at the same time in a MySql table?. Because this one asking on concurrent operation of two users simultaneously which is not my question






php mysql







share|improve this question
















How to use auto-increment Id in another column in INSERT QUERY in MYSQL?



I want to add user with code. like if user_id after insert is 1 the code will be US1 similarly if user_id after insert is 954 the code will be US954



This is what I'm currently doing



"INSERT INTO `users` (`user_id`, `user`, `code`) VALUES (NULL, 'Alice', NULL);"


and then retrieve last insert id in PHP (Codeigniter)



$insert_id = $this->db->insert_id();


and then update code with auto increment id



"UPDATE `users` SET `code` = CONCAT('US', '" . $insert_id . "') WHERE `user_id` = " . $insert_id . ";";


Is there anyway you can do it in a single INSERT QUERY in MYSQL?



EDIT:
This is not same as this Insert/ update at the same time in a MySql table?. Because this one asking on concurrent operation of two users simultaneously which is not my question






php mysql




php mysql






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 14 '18 at 11:30







Faizan Rupani

















asked Nov 14 '18 at 11:22









Faizan RupaniFaizan Rupani

320110




320110








  • 2





    No, think about it, you asking if it's possible to get the egg before the chicken has laid it!

    – SPlatten
    Nov 14 '18 at 11:25






  • 2





    "you asking if it's possible to get the egg before the chicken has laid it!" What makes me wonder was the chicken first or the egg? @SPlatten

    – Raymond Nijland
    Nov 14 '18 at 11:28













  • @RaymondNijland lol I get it now.

    – Faizan Rupani
    Nov 14 '18 at 11:30






  • 1





    @RaymondNijland, :) In this case you can get the last insert ID once the record has been inserted, but what is required here is to use the same ID...I would suggest writing a stored procedure which enables you to manage this kind of thing much easier.

    – SPlatten
    Nov 14 '18 at 12:50






  • 1





    "In this case you can get the last insert ID once the record has been inserted, but what is required here is to use the same ID." i know @SPlatten i did post and removed a answer about LAST_INSERT_ID() .. because it didn't know for sure if the topicstarter required that and because it wanted to do it in one query.

    – Raymond Nijland
    Nov 14 '18 at 16:49
















  • 2





    No, think about it, you asking if it's possible to get the egg before the chicken has laid it!

    – SPlatten
    Nov 14 '18 at 11:25






  • 2





    "you asking if it's possible to get the egg before the chicken has laid it!" What makes me wonder was the chicken first or the egg? @SPlatten

    – Raymond Nijland
    Nov 14 '18 at 11:28













  • @RaymondNijland lol I get it now.

    – Faizan Rupani
    Nov 14 '18 at 11:30






  • 1





    @RaymondNijland, :) In this case you can get the last insert ID once the record has been inserted, but what is required here is to use the same ID...I would suggest writing a stored procedure which enables you to manage this kind of thing much easier.

    – SPlatten
    Nov 14 '18 at 12:50






  • 1





    "In this case you can get the last insert ID once the record has been inserted, but what is required here is to use the same ID." i know @SPlatten i did post and removed a answer about LAST_INSERT_ID() .. because it didn't know for sure if the topicstarter required that and because it wanted to do it in one query.

    – Raymond Nijland
    Nov 14 '18 at 16:49










2




2





No, think about it, you asking if it's possible to get the egg before the chicken has laid it!

– SPlatten
Nov 14 '18 at 11:25





No, think about it, you asking if it's possible to get the egg before the chicken has laid it!

– SPlatten
Nov 14 '18 at 11:25




2




2





"you asking if it's possible to get the egg before the chicken has laid it!" What makes me wonder was the chicken first or the egg? @SPlatten

– Raymond Nijland
Nov 14 '18 at 11:28







"you asking if it's possible to get the egg before the chicken has laid it!" What makes me wonder was the chicken first or the egg? @SPlatten

– Raymond Nijland
Nov 14 '18 at 11:28















@RaymondNijland lol I get it now.

– Faizan Rupani
Nov 14 '18 at 11:30





@RaymondNijland lol I get it now.

– Faizan Rupani
Nov 14 '18 at 11:30




1




1





@RaymondNijland, :) In this case you can get the last insert ID once the record has been inserted, but what is required here is to use the same ID...I would suggest writing a stored procedure which enables you to manage this kind of thing much easier.

– SPlatten
Nov 14 '18 at 12:50





@RaymondNijland, :) In this case you can get the last insert ID once the record has been inserted, but what is required here is to use the same ID...I would suggest writing a stored procedure which enables you to manage this kind of thing much easier.

– SPlatten
Nov 14 '18 at 12:50




1




1





"In this case you can get the last insert ID once the record has been inserted, but what is required here is to use the same ID." i know @SPlatten i did post and removed a answer about LAST_INSERT_ID() .. because it didn't know for sure if the topicstarter required that and because it wanted to do it in one query.

– Raymond Nijland
Nov 14 '18 at 16:49







"In this case you can get the last insert ID once the record has been inserted, but what is required here is to use the same ID." i know @SPlatten i did post and removed a answer about LAST_INSERT_ID() .. because it didn't know for sure if the topicstarter required that and because it wanted to do it in one query.

– Raymond Nijland
Nov 14 '18 at 16:49














3 Answers
3






active

oldest

votes


















0














Yes, it's possible.
You can do it using Store Procedure(SP) in MySQL.
You have to call SP one time for each registration instead of twice query(which you did).



It will save lot execution time.



    https://stackoverflow.com/questions/14957788/insert-and-update-with-stored-procedure    

    https://www.w3resource.com/mysql/mysql-procedure.php

    https://www.sitepoint.com/stored-procedures-mysql-php/

    http://php.net/manual/en/mysqli.quickstart.stored-procedures.php


Please use above links for more information.



I recommend to use SP for Login/Registration. It will give extra power to your PHP web app.



For your basic example. I've shared similar SP code with you.



BEGIN

declare autoIncr int;

//insert code

autoIncr = LAST_INSERT_ID(); 

//update code

END





share|improve this answer


























  • that doesn't give me any solid answer. I don't know what to look for in your answer

    – Faizan Rupani
    Nov 14 '18 at 11:47











  • Your questions is, you have to achieve using single query. Same, thing you can achieve using single SP call instead of two different call of query.

    – Darshak DRC
    Nov 14 '18 at 11:49













  • If I'm inserting and updating separately in SP, then there is no point of using it. because I can run insert and update query separately in code. And it will take less time as compared to SP.

    – Faizan Rupani
    Nov 14 '18 at 11:50











  • SP is take less time. If you will call insert and update query then every time call database server. But in SP, php call database server only time and database server can execute query in single database call instead of twice call of database.

    – Darshak DRC
    Nov 14 '18 at 11:53











  • To use SP you would have to access to SP permission from hosting provider. Some Hosting Providers doesn't allow it. unless you own your server. And doing insert and update query only makes difference negligible.

    – Faizan Rupani
    Nov 14 '18 at 11:58



















0














Get Newly user_id with MAX(user_id)+1 and then concat it with your string



INSERT INTO `users` (`user`, `code`) SELECT 'Alice',CONCAT("US",MAX(user_id)+1) from users





share|improve this answer
























  • If for example more than 300 people insert simultaneously then you'll have different max user_id for each user. Beside you won't get an actual user_id with MAX(user_id) until you insert the data. otherwise it'll give you last update id

    – Faizan Rupani
    Nov 14 '18 at 13:38













  • Plz elaborate with your code

    – Komal G.
    Nov 14 '18 at 13:49



















-1














when you created your table and column that time if you given the value of user_id Auto increment. After that when you want to insert the data no need to give value of user_id cause it's will auto incremented



for the create fresh create new table query



CREATE TABLE `users` (

    ID int NOT NULL AUTO_INCREMENT,

    user_id varchar(255) NOT NULL AUTO_INCREMENT,

    user varchar(255),

    code text,

    PRIMARY KEY (ID)

);


that is the inserting query



"INSERT INTO `users` (`user`, `code`) VALUES ('Alice', NULL);"





share|improve this answer


























  • I know. That was sample data. And that's not what I asked

    – Faizan Rupani
    Nov 14 '18 at 11:33











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53299069%2fhow-to-use-auto-increment-id-in-another-column-in-same-insert-query-in-mysql%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























3 Answers
3






active

oldest

votes








3 Answers
3






active

oldest

votes









active

oldest

votes






active

oldest

votes









0














Yes, it's possible.
You can do it using Store Procedure(SP) in MySQL.
You have to call SP one time for each registration instead of twice query(which you did).



It will save lot execution time.



    https://stackoverflow.com/questions/14957788/insert-and-update-with-stored-procedure    

    https://www.w3resource.com/mysql/mysql-procedure.php

    https://www.sitepoint.com/stored-procedures-mysql-php/

    http://php.net/manual/en/mysqli.quickstart.stored-procedures.php


Please use above links for more information.



I recommend to use SP for Login/Registration. It will give extra power to your PHP web app.



For your basic example. I've shared similar SP code with you.



BEGIN

declare autoIncr int;

//insert code

autoIncr = LAST_INSERT_ID(); 

//update code

END





share|improve this answer


























  • that doesn't give me any solid answer. I don't know what to look for in your answer

    – Faizan Rupani
    Nov 14 '18 at 11:47











  • Your questions is, you have to achieve using single query. Same, thing you can achieve using single SP call instead of two different call of query.

    – Darshak DRC
    Nov 14 '18 at 11:49













  • If I'm inserting and updating separately in SP, then there is no point of using it. because I can run insert and update query separately in code. And it will take less time as compared to SP.

    – Faizan Rupani
    Nov 14 '18 at 11:50











  • SP is take less time. If you will call insert and update query then every time call database server. But in SP, php call database server only time and database server can execute query in single database call instead of twice call of database.

    – Darshak DRC
    Nov 14 '18 at 11:53











  • To use SP you would have to access to SP permission from hosting provider. Some Hosting Providers doesn't allow it. unless you own your server. And doing insert and update query only makes difference negligible.

    – Faizan Rupani
    Nov 14 '18 at 11:58
















0














Yes, it's possible.
You can do it using Store Procedure(SP) in MySQL.
You have to call SP one time for each registration instead of twice query(which you did).



It will save lot execution time.



    https://stackoverflow.com/questions/14957788/insert-and-update-with-stored-procedure    

    https://www.w3resource.com/mysql/mysql-procedure.php

    https://www.sitepoint.com/stored-procedures-mysql-php/

    http://php.net/manual/en/mysqli.quickstart.stored-procedures.php


Please use above links for more information.



I recommend to use SP for Login/Registration. It will give extra power to your PHP web app.



For your basic example. I've shared similar SP code with you.



BEGIN

declare autoIncr int;

//insert code

autoIncr = LAST_INSERT_ID(); 

//update code

END





share|improve this answer


























  • that doesn't give me any solid answer. I don't know what to look for in your answer

    – Faizan Rupani
    Nov 14 '18 at 11:47











  • Your questions is, you have to achieve using single query. Same, thing you can achieve using single SP call instead of two different call of query.

    – Darshak DRC
    Nov 14 '18 at 11:49













  • If I'm inserting and updating separately in SP, then there is no point of using it. because I can run insert and update query separately in code. And it will take less time as compared to SP.

    – Faizan Rupani
    Nov 14 '18 at 11:50











  • SP is take less time. If you will call insert and update query then every time call database server. But in SP, php call database server only time and database server can execute query in single database call instead of twice call of database.

    – Darshak DRC
    Nov 14 '18 at 11:53











  • To use SP you would have to access to SP permission from hosting provider. Some Hosting Providers doesn't allow it. unless you own your server. And doing insert and update query only makes difference negligible.

    – Faizan Rupani
    Nov 14 '18 at 11:58














0












0








0







Yes, it's possible.
You can do it using Store Procedure(SP) in MySQL.
You have to call SP one time for each registration instead of twice query(which you did).



It will save lot execution time.



    https://stackoverflow.com/questions/14957788/insert-and-update-with-stored-procedure    

    https://www.w3resource.com/mysql/mysql-procedure.php

    https://www.sitepoint.com/stored-procedures-mysql-php/

    http://php.net/manual/en/mysqli.quickstart.stored-procedures.php


Please use above links for more information.



I recommend to use SP for Login/Registration. It will give extra power to your PHP web app.



For your basic example. I've shared similar SP code with you.



BEGIN

declare autoIncr int;

//insert code

autoIncr = LAST_INSERT_ID(); 

//update code

END





share|improve this answer















Yes, it's possible.
You can do it using Store Procedure(SP) in MySQL.
You have to call SP one time for each registration instead of twice query(which you did).



It will save lot execution time.



    https://stackoverflow.com/questions/14957788/insert-and-update-with-stored-procedure    

    https://www.w3resource.com/mysql/mysql-procedure.php

    https://www.sitepoint.com/stored-procedures-mysql-php/

    http://php.net/manual/en/mysqli.quickstart.stored-procedures.php


Please use above links for more information.



I recommend to use SP for Login/Registration. It will give extra power to your PHP web app.



For your basic example. I've shared similar SP code with you.



BEGIN

declare autoIncr int;

//insert code

autoIncr = LAST_INSERT_ID(); 

//update code

END






share|improve this answer














share|improve this answer



share|improve this answer








edited Nov 14 '18 at 11:42

























answered Nov 14 '18 at 11:36









Darshak DRCDarshak DRC

56




56













  • that doesn't give me any solid answer. I don't know what to look for in your answer

    – Faizan Rupani
    Nov 14 '18 at 11:47











  • Your questions is, you have to achieve using single query. Same, thing you can achieve using single SP call instead of two different call of query.

    – Darshak DRC
    Nov 14 '18 at 11:49













  • If I'm inserting and updating separately in SP, then there is no point of using it. because I can run insert and update query separately in code. And it will take less time as compared to SP.

    – Faizan Rupani
    Nov 14 '18 at 11:50











  • SP is take less time. If you will call insert and update query then every time call database server. But in SP, php call database server only time and database server can execute query in single database call instead of twice call of database.

    – Darshak DRC
    Nov 14 '18 at 11:53











  • To use SP you would have to access to SP permission from hosting provider. Some Hosting Providers doesn't allow it. unless you own your server. And doing insert and update query only makes difference negligible.

    – Faizan Rupani
    Nov 14 '18 at 11:58



















  • that doesn't give me any solid answer. I don't know what to look for in your answer

    – Faizan Rupani
    Nov 14 '18 at 11:47











  • Your questions is, you have to achieve using single query. Same, thing you can achieve using single SP call instead of two different call of query.

    – Darshak DRC
    Nov 14 '18 at 11:49













  • If I'm inserting and updating separately in SP, then there is no point of using it. because I can run insert and update query separately in code. And it will take less time as compared to SP.

    – Faizan Rupani
    Nov 14 '18 at 11:50











  • SP is take less time. If you will call insert and update query then every time call database server. But in SP, php call database server only time and database server can execute query in single database call instead of twice call of database.

    – Darshak DRC
    Nov 14 '18 at 11:53











  • To use SP you would have to access to SP permission from hosting provider. Some Hosting Providers doesn't allow it. unless you own your server. And doing insert and update query only makes difference negligible.

    – Faizan Rupani
    Nov 14 '18 at 11:58

















that doesn't give me any solid answer. I don't know what to look for in your answer

– Faizan Rupani
Nov 14 '18 at 11:47





that doesn't give me any solid answer. I don't know what to look for in your answer

– Faizan Rupani
Nov 14 '18 at 11:47













Your questions is, you have to achieve using single query. Same, thing you can achieve using single SP call instead of two different call of query.

– Darshak DRC
Nov 14 '18 at 11:49







Your questions is, you have to achieve using single query. Same, thing you can achieve using single SP call instead of two different call of query.

– Darshak DRC
Nov 14 '18 at 11:49















If I'm inserting and updating separately in SP, then there is no point of using it. because I can run insert and update query separately in code. And it will take less time as compared to SP.

– Faizan Rupani
Nov 14 '18 at 11:50





If I'm inserting and updating separately in SP, then there is no point of using it. because I can run insert and update query separately in code. And it will take less time as compared to SP.

– Faizan Rupani
Nov 14 '18 at 11:50













SP is take less time. If you will call insert and update query then every time call database server. But in SP, php call database server only time and database server can execute query in single database call instead of twice call of database.

– Darshak DRC
Nov 14 '18 at 11:53





SP is take less time. If you will call insert and update query then every time call database server. But in SP, php call database server only time and database server can execute query in single database call instead of twice call of database.

– Darshak DRC
Nov 14 '18 at 11:53













To use SP you would have to access to SP permission from hosting provider. Some Hosting Providers doesn't allow it. unless you own your server. And doing insert and update query only makes difference negligible.

– Faizan Rupani
Nov 14 '18 at 11:58





To use SP you would have to access to SP permission from hosting provider. Some Hosting Providers doesn't allow it. unless you own your server. And doing insert and update query only makes difference negligible.

– Faizan Rupani
Nov 14 '18 at 11:58













0














Get Newly user_id with MAX(user_id)+1 and then concat it with your string



INSERT INTO `users` (`user`, `code`) SELECT 'Alice',CONCAT("US",MAX(user_id)+1) from users





share|improve this answer
























  • If for example more than 300 people insert simultaneously then you'll have different max user_id for each user. Beside you won't get an actual user_id with MAX(user_id) until you insert the data. otherwise it'll give you last update id

    – Faizan Rupani
    Nov 14 '18 at 13:38













  • Plz elaborate with your code

    – Komal G.
    Nov 14 '18 at 13:49
















0














Get Newly user_id with MAX(user_id)+1 and then concat it with your string



INSERT INTO `users` (`user`, `code`) SELECT 'Alice',CONCAT("US",MAX(user_id)+1) from users





share|improve this answer
























  • If for example more than 300 people insert simultaneously then you'll have different max user_id for each user. Beside you won't get an actual user_id with MAX(user_id) until you insert the data. otherwise it'll give you last update id

    – Faizan Rupani
    Nov 14 '18 at 13:38













  • Plz elaborate with your code

    – Komal G.
    Nov 14 '18 at 13:49














0












0








0







Get Newly user_id with MAX(user_id)+1 and then concat it with your string



INSERT INTO `users` (`user`, `code`) SELECT 'Alice',CONCAT("US",MAX(user_id)+1) from users





share|improve this answer













Get Newly user_id with MAX(user_id)+1 and then concat it with your string



INSERT INTO `users` (`user`, `code`) SELECT 'Alice',CONCAT("US",MAX(user_id)+1) from users






share|improve this answer












share|improve this answer



share|improve this answer










answered Nov 14 '18 at 13:07









Komal G.Komal G.

315112




315112













  • If for example more than 300 people insert simultaneously then you'll have different max user_id for each user. Beside you won't get an actual user_id with MAX(user_id) until you insert the data. otherwise it'll give you last update id

    – Faizan Rupani
    Nov 14 '18 at 13:38













  • Plz elaborate with your code

    – Komal G.
    Nov 14 '18 at 13:49



















  • If for example more than 300 people insert simultaneously then you'll have different max user_id for each user. Beside you won't get an actual user_id with MAX(user_id) until you insert the data. otherwise it'll give you last update id

    – Faizan Rupani
    Nov 14 '18 at 13:38













  • Plz elaborate with your code

    – Komal G.
    Nov 14 '18 at 13:49

















If for example more than 300 people insert simultaneously then you'll have different max user_id for each user. Beside you won't get an actual user_id with MAX(user_id) until you insert the data. otherwise it'll give you last update id

– Faizan Rupani
Nov 14 '18 at 13:38







If for example more than 300 people insert simultaneously then you'll have different max user_id for each user. Beside you won't get an actual user_id with MAX(user_id) until you insert the data. otherwise it'll give you last update id

– Faizan Rupani
Nov 14 '18 at 13:38















Plz elaborate with your code

– Komal G.
Nov 14 '18 at 13:49





Plz elaborate with your code

– Komal G.
Nov 14 '18 at 13:49











-1














when you created your table and column that time if you given the value of user_id Auto increment. After that when you want to insert the data no need to give value of user_id cause it's will auto incremented



for the create fresh create new table query



CREATE TABLE `users` (

    ID int NOT NULL AUTO_INCREMENT,

    user_id varchar(255) NOT NULL AUTO_INCREMENT,

    user varchar(255),

    code text,

    PRIMARY KEY (ID)

);


that is the inserting query



"INSERT INTO `users` (`user`, `code`) VALUES ('Alice', NULL);"





share|improve this answer


























  • I know. That was sample data. And that's not what I asked

    – Faizan Rupani
    Nov 14 '18 at 11:33
















-1














when you created your table and column that time if you given the value of user_id Auto increment. After that when you want to insert the data no need to give value of user_id cause it's will auto incremented



for the create fresh create new table query



CREATE TABLE `users` (

    ID int NOT NULL AUTO_INCREMENT,

    user_id varchar(255) NOT NULL AUTO_INCREMENT,

    user varchar(255),

    code text,

    PRIMARY KEY (ID)

);


that is the inserting query



"INSERT INTO `users` (`user`, `code`) VALUES ('Alice', NULL);"





share|improve this answer


























  • I know. That was sample data. And that's not what I asked

    – Faizan Rupani
    Nov 14 '18 at 11:33














-1












-1








-1







when you created your table and column that time if you given the value of user_id Auto increment. After that when you want to insert the data no need to give value of user_id cause it's will auto incremented



for the create fresh create new table query



CREATE TABLE `users` (

    ID int NOT NULL AUTO_INCREMENT,

    user_id varchar(255) NOT NULL AUTO_INCREMENT,

    user varchar(255),

    code text,

    PRIMARY KEY (ID)

);


that is the inserting query



"INSERT INTO `users` (`user`, `code`) VALUES ('Alice', NULL);"





share|improve this answer















when you created your table and column that time if you given the value of user_id Auto increment. After that when you want to insert the data no need to give value of user_id cause it's will auto incremented



for the create fresh create new table query



CREATE TABLE `users` (

    ID int NOT NULL AUTO_INCREMENT,

    user_id varchar(255) NOT NULL AUTO_INCREMENT,

    user varchar(255),

    code text,

    PRIMARY KEY (ID)

);


that is the inserting query



"INSERT INTO `users` (`user`, `code`) VALUES ('Alice', NULL);"






share|improve this answer














share|improve this answer



share|improve this answer








edited Nov 14 '18 at 11:34

























answered Nov 14 '18 at 11:32









Istiyak AminIstiyak Amin

15312




15312













  • I know. That was sample data. And that's not what I asked

    – Faizan Rupani
    Nov 14 '18 at 11:33



















  • I know. That was sample data. And that's not what I asked

    – Faizan Rupani
    Nov 14 '18 at 11:33

















I know. That was sample data. And that's not what I asked

– Faizan Rupani
Nov 14 '18 at 11:33





I know. That was sample data. And that's not what I asked

– Faizan Rupani
Nov 14 '18 at 11:33


















draft saved

draft discarded




















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid …



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53299069%2fhow-to-use-auto-increment-id-in-another-column-in-same-insert-query-in-mysql%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







-

Popular posts from this blog

Bressuire

Image
Subprefecture and commune in Nouvelle-Aquitaine, France Bressuire Subprefecture and commune Chateau de Bressuire and the Eglise Notre-Dame Coat of arms Location of Bressuire Bressuire Show map of France Bressuire Show map of Nouvelle-Aquitaine Coordinates: 46°50′27″N 0°29′14″W  /  46.8408°N 0.4872°W  / 46.8408; -0.4872 Coordinates: 46°50′27″N 0°29′14″W  /  46.8408°N 0.4872°W  / 46.8408; -0.4872 Country France Region Nouvelle-Aquitaine Department Deux-Sèvres Arrondissement Bressuire Canton Bressuire Government  • Mayor .mw-parser-output .nobold{font-weight:normal} (2014–20) Jean Michel Bernier Area 1 180.59 km 2 (69.73 sq mi) Population (2014) 2 19,300  • Density 110/km 2 (280/sq mi) Time zone UTC+01:00 (CET)  • Summer (DST) UTC+02:00 (CEST) INSEE/Postal code 79049 /79300 Elevation 98–236 m (322–774 ft) (avg. 173 m or 568 ft) 1 French Land Register data, which exclude...
Read more

Vorschmack

Image
Vorschmack Ukrainian Jewish-style vorschmack served on rye bread Course Hors d'oeuvre Region or state Eastern Europe Associated national cuisine Ashkenazi Jewish, Finnish, German, Ukrainian, Polish, Russian Main ingredients Ground meat and/or fish Cookbook: Vorschmack   Media: Vorschmack Vorschmack or forshmak (Yiddish: פֿאָרשמאַק ‎, from archaic German Vorschmack , "foretaste" [1] or "appetizer" [2] ) is an originally East European dish made of salty minced fish or meat. Different variants of this dish are especially common in Ashkenazi Jewish and Finnish cuisine. Some varieties are also known in Russian and Polish cuisine. Contents 1 In Jewish cuisine 2 In Russian cuisine 3 In Polish cuisine 4 In Finnish cuisine 5 See also 6 References In Jewish cuisine According to Gil Marks, the German name points to the possible Germanic origin of this dish. [1] William Pokhlyobkin descr...
Read more

Quarantine

Image
For other uses, see Quarantine (disambiguation). Signal flag "Lima" called the "Yellow Jack" which when flown in harbor means ship is under quarantine. A simple yellow flag (also called the "Yellow Jack") had historically been used to signal quarantine (it stands for Q among signal flags), but now indicates the opposite, as a signal of a ship free of disease that requests boarding and inspection. A quarantine is used to separate and restrict the movement of people; it is 'a restraint upon the activities or communication of persons or the transport of goods designed to prevent the spread of disease or pests', for a certain period of time. [1] This is often used in connection to disease and illness, such as those who may possibly have been exposed to a communicable disease. [2] The term is often erroneously used to mean medical isolation, which is "to separate ill persons who have a communicable disease from those who are healthy...
Read more