Generate Primary Key Without Table 3,5/5 8762 reviews
- How to generate create table script without primary and foreign key in Oracle duplicate. How to generate create table script without. I want to generate.
- The result set will be a row for each insert statement for every row in the table TABLE. The INSERT statement is generated from concatenating the INSERT statement text with the values in Field1. OMG, it was so easy that I never thought about it! I was thinking in make some SP with fetch cursor and etc.
Jan 05, 2018 SQL Create table with primary key: In my previous articles, I have explained about the different SQL statements, Interview questions for different MNCs.In this article, I will explain the multiple ways to create table. Generate ssh key id_rsa pub and bar. Apr 26, 2011 To resolve this problem we made all the primary keys as varchar (bad idea) and to generate unique value what we do is as below: 1.) Local machines: Count all the rows in the table and add 1 to it and concatenate a unique value allocated to a local machine.
Posted by: Vikram Chhetry
Date: April 26, 2011 02:22AM
Date: April 26, 2011 02:22AM
Hi All,
I am creating one web application with mysql innodb tables. Now, the scenario is that my application & database runs on a public server and same application & database runs on individual local machines(multiple) where there is no interet connection. The only protocol that is enabled in local machines is SMTP. The requirement of my project is to bring all the databases in sync everyday via. email which will have an attachment as an xml with updated/inserted rows. Problem we faced was to generate primary keys which are universally unique i.e. if there is any insert in any local machine and on server, that id should never get generated in any other local machine. To resolve this problem we made all the primary keys as varchar (bad idea) and to generate unique value what we do is as below:
1.) Local machines: Count all the rows in the table and add 1 to it and concatenate a unique value allocated to a local machine. So if any row is inserted in the local machines the value would look like localmachineid_count+1. Ex: 1_1 (local machine id = 1), 2_1 (local machine id = 2) for same table.
2.) Public server: Count all the rows in the table and add 1 to it.
Now i understand that this thing will fail in two cases, when there is simultaneous insert request for same table and when some one deletes any row.
Is there any way of handling this scenario in mysql (like: sequence).
Any help would be appreciated.
Thanks in advance.
--
Vikram
I am creating one web application with mysql innodb tables. Now, the scenario is that my application & database runs on a public server and same application & database runs on individual local machines(multiple) where there is no interet connection. The only protocol that is enabled in local machines is SMTP. The requirement of my project is to bring all the databases in sync everyday via. email which will have an attachment as an xml with updated/inserted rows. Problem we faced was to generate primary keys which are universally unique i.e. if there is any insert in any local machine and on server, that id should never get generated in any other local machine. To resolve this problem we made all the primary keys as varchar (bad idea) and to generate unique value what we do is as below:
1.) Local machines: Count all the rows in the table and add 1 to it and concatenate a unique value allocated to a local machine. So if any row is inserted in the local machines the value would look like localmachineid_count+1. Ex: 1_1 (local machine id = 1), 2_1 (local machine id = 2) for same table.
2.) Public server: Count all the rows in the table and add 1 to it.
Now i understand that this thing will fail in two cases, when there is simultaneous insert request for same table and when some one deletes any row.
Is there any way of handling this scenario in mysql (like: sequence).
Any help would be appreciated.
Thanks in advance.
--
Vikram
Options:Reply•Quote
Written By
Sorry, you can't reply to this topic. It has been closed.
Generate Primary Key Without Table Of Water
Generate Primary Key Without Table Of Life
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.