Page 28 - Fister jr., Iztok, and Andrej Brodnik (eds.). StuCoSReC. Proceedings of the 2015 2nd Student Computer Science Research Conference. Koper: University of Primorska Press, 2015
P. 28
ySQL Database Online Update 4 Conclusions
3.1 Online Adding This paper introduces how to use JSP combined with
Online adding operations can be achieved by SQL statements to achieve the processes about online
adding, online changing and deleting operations for the
‘insert into’ statement, and it is used to insert data to database data to implement the MySQL database online
the specified table. The syntax of ‘insert into’ update, which makes the database more convenient for
statement is as follows: insert into table values (value1, common using.
value2 ...)
5 Acknowledgments
Taking the ‘table’ as an example, the specific
method is as follows: This work is supported by National Natural Science
Foundation of China (No. 71102174 and No. 51306058),
the Fundamental Research Funds for the Central
Universities (No. 2014QN46), the Hebei Science and
Technology Support Project (No. 15212204D), the Tianjin
Science and Technology Support Project (No.
15ZCZDNC00130), and the State Scholarship Fund for
Visiting Scholar by the China Scholarship Council (No.
201406735004).
References
3.2 Online Deleting [1] Emmanuel Cecchet, Julie Marguerite and Willy
Online delete can be achieved by ‘delete from’ Zwaenepoel. C-JDBC: Flexible Database Clustering
Middleware. USENIX Annual Technical Conference
statement. The syntax of the statement is as follows: Freenix track, June 2004.
‘delete from’ table where ‘field name = record name’.
[2] P. Chen, E. Lee, G. Gibson, R. Katz and D. Patterson.
For example, named ‘table’, field named ‘id’, the RAID: High-Performance, Reliable Secondary
specific method is as follows: Storage. ACM Computing Survey, volume 26, n2, pp.
145-185, 1994.
Recording name is the data to be deleted.
3.3 Online Changing [3] P. Furtado. Efficiently Processing Query-Intensive
Databases over a Non-dedicated Local Network. In:
According to ‘add’ and ‘delete’ SQL Proceedings of the 19th IEEE International Parallel
implementations, the operation of changing the and Distributed Processing Symposium (IPDPS’05),
database-related data is as follows: IEEE Computer Society, 2005.
The number of ‘value’ is related to the data [4] Bradford W. Wade, Donald D. Chamberlin. IBM
account. Relational Database Systems: The Early Years. IEEE
Annals of the History of Computing, vol.34, no. 4, pp.
38-48, 2012.
StuCoSReC Proceedings of the 2015 2nd Student Computer Science Research Conference 28
Ljubljana, Slovenia, 6 October
3.1 Online Adding This paper introduces how to use JSP combined with
Online adding operations can be achieved by SQL statements to achieve the processes about online
adding, online changing and deleting operations for the
‘insert into’ statement, and it is used to insert data to database data to implement the MySQL database online
the specified table. The syntax of ‘insert into’ update, which makes the database more convenient for
statement is as follows: insert into table values (value1, common using.
value2 ...)
5 Acknowledgments
Taking the ‘table’ as an example, the specific
method is as follows: This work is supported by National Natural Science
Foundation of China (No. 71102174 and No. 51306058),
the Fundamental Research Funds for the Central
Universities (No. 2014QN46), the Hebei Science and
Technology Support Project (No. 15212204D), the Tianjin
Science and Technology Support Project (No.
15ZCZDNC00130), and the State Scholarship Fund for
Visiting Scholar by the China Scholarship Council (No.
201406735004).
References
3.2 Online Deleting [1] Emmanuel Cecchet, Julie Marguerite and Willy
Online delete can be achieved by ‘delete from’ Zwaenepoel. C-JDBC: Flexible Database Clustering
Middleware. USENIX Annual Technical Conference
statement. The syntax of the statement is as follows: Freenix track, June 2004.
‘delete from’ table where ‘field name = record name’.
[2] P. Chen, E. Lee, G. Gibson, R. Katz and D. Patterson.
For example, named ‘table’, field named ‘id’, the RAID: High-Performance, Reliable Secondary
specific method is as follows: Storage. ACM Computing Survey, volume 26, n2, pp.
145-185, 1994.
Recording name is the data to be deleted.
3.3 Online Changing [3] P. Furtado. Efficiently Processing Query-Intensive
Databases over a Non-dedicated Local Network. In:
According to ‘add’ and ‘delete’ SQL Proceedings of the 19th IEEE International Parallel
implementations, the operation of changing the and Distributed Processing Symposium (IPDPS’05),
database-related data is as follows: IEEE Computer Society, 2005.
The number of ‘value’ is related to the data [4] Bradford W. Wade, Donald D. Chamberlin. IBM
account. Relational Database Systems: The Early Years. IEEE
Annals of the History of Computing, vol.34, no. 4, pp.
38-48, 2012.
StuCoSReC Proceedings of the 2015 2nd Student Computer Science Research Conference 28
Ljubljana, Slovenia, 6 October
