API tools faq
paste
Guest User

Untitled

a guest
Jan 23rd, 2019
58
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.53 KB | None | 0 0
raw download clone embed print report
  1. Enter password: *****
  2. Welcome to the MySQL monitor. Commands end with ; or \g.
  3. Your MySQL connection id is 5
  4. Server version: 5.5.62 MySQL Community Server (GPL)
  5.  
  6. Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
  7.  
  8. Oracle is a registered trademark of Oracle Corporation and/or its
  9. affiliates. Other names may be trademarks of their respective
  10. owners.
  11.  
  12. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  13.  
  14. mysql> show databases;
  15. +--------------------+
  16. | Database |
  17. +--------------------+
  18. | information_schema |
  19. | base |
  20. | college |
  21. | db1 |
  22. | div1 |
  23. | hell |
  24. | jatin |
  25. | mayhem |
  26. | mohitdatabase |
  27. | mrinal |
  28. | mydatabase |
  29. | mysql |
  30. | performance_schema |
  31. | person |
  32. | sqlt |
  33. | startup |
  34. | student |
  35. | student_record |
  36. | test |
  37. | v |
  38. | vaibhav |
  39. | x |
  40. +--------------------+
  41. 22 rows in set (0.00 sec)
  42.  
  43. mysql> use student_record
  44. Database changed
  45. mysql> CREATE TABLE Person(FIRST_NAME VARCHAR(50) NOT NULL, LAST_NAME VARCHAR(50) NOT NULL, ID INT AUTO_INCREMENT PRIMARY KEY, MOBILE_NO INT(10) CHECK(LENGTH(MOBILE_NO)=10), EMAIL VARCHAR(50), CITY VARCHAR(50), AGE INT(2) CHECK(AGE>18));
  46. Query OK, 0 rows affected (0.11 sec)
  47. mysql> ALTER TABLE Person MODIFY MOBILE_NO VARCHAR(10);
  48. Query OK, 0 rows affected (0.16 sec)
  49. Records: 0 Duplicates: 0 Warnings: 0
  50. mysql> INSERT INTO Person VALUES("ALPHA","SAD",1,9876543210,"ALPHASAD@GMAIL.COM","DELHI",20);
  51. Query OK, 1 row affected (0.03 sec)
  52. for i in range(10):
  53. print ("INSERT INTO Person VALUES(",repr("ALPHA"+str(chr(65+i))),",",repr("SAD"+str(chr(65+i))),",",1+i,",","987654321"+str(i),",",repr(str(chr(65+i))+"LPHASAD@GMAIL.COM"),",",repr("DELHI"),",",20+i,");")
  54. INSERT INTO Person VALUES( 'ALPHAA' , 'SADA' , 1 , 9876543210 , 'ALPHASAD@GMAIL.COM' , 'DELHI' , 20 );
  55. mysql> INSERT INTO Person VALUES( 'ALPHAA' , 'SADA' , 1 , 9876543210 , 'ALPHASAD@GMAIL.COM' , 'DELHI' , 20 );
  56. ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY'
  57. mysql> INSERT INTO Person VALUES( 'ALPHAB' , 'SADB' , 2 , 9876543211 , 'BLPHASAD@GMAIL.COM' , 'DELHI' , 21 );
  58. Query OK, 1 row affected (0.03 sec)
  59.  
  60. mysql> INSERT INTO Person VALUES( 'ALPHAC' , 'SADC' , 3 , 9876543212 , 'CLPHASAD@GMAIL.COM' , 'DELHI' , 22 );
  61. Query OK, 1 row affected (0.03 sec)
  62.  
  63. mysql> INSERT INTO Person VALUES( 'ALPHAD' , 'SADD' , 4 , 9876543213 , 'DLPHASAD@GMAIL.COM' , 'DELHI' , 23 );
  64. Query OK, 1 row affected (0.03 sec)
  65.  
  66. mysql> INSERT INTO Person VALUES( 'ALPHAE' , 'SADE' , 5 , 9876543214 , 'ELPHASAD@GMAIL.COM' , 'DELHI' , 24 );
  67. Query OK, 1 row affected (0.03 sec)
  68.  
  69. mysql> INSERT INTO Person VALUES( 'ALPHAF' , 'SADF' , 6 , 9876543215 , 'FLPHASAD@GMAIL.COM' , 'DELHI' , 25 );
  70. Query OK, 1 row affected (0.03 sec)
  71.  
  72. mysql> INSERT INTO Person VALUES( 'ALPHAG' , 'SADG' , 7 , 9876543216 , 'GLPHASAD@GMAIL.COM' , 'DELHI' , 26 );
  73. Query OK, 1 row affected (0.03 sec)
  74.  
  75. mysql> INSERT INTO Person VALUES( 'ALPHAH' , 'SADH' , 8 , 9876543217 , 'HLPHASAD@GMAIL.COM' , 'DELHI' , 27 );
  76. Query OK, 1 row affected (0.03 sec)
  77.  
  78. mysql> INSERT INTO Person VALUES( 'ALPHAI' , 'SADI' , 9 , 9876543218 , 'ILPHASAD@GMAIL.COM' , 'DELHI' , 28 );
  79. Query OK, 1 row affected (0.03 sec)
  80.  
  81. mysql> INSERT INTO Person VALUES( 'ALPHAJ' , 'SADJ' , 10 , 9876543219 , 'JLPHASAD@GMAIL.COM' , 'DELHI' , 29 );
  82. Query OK, 1 row affected (0.03 sec)
  83.  
  84. mysql> SELECT * FROM PERSON
  85. -> ;
  86. +------------+-----------+----+------------+--------------------+-------+------+
  87. | FIRST_NAME | LAST_NAME | ID | MOBILE_NO | EMAIL | CITY | AGE |
  88. +------------+-----------+----+------------+--------------------+-------+------+
  89. | ALPHA | SAD | 1 | 9876543210 | ALPHASAD@GMAIL.COM | DELHI | 20 |
  90. | ALPHAB | SADB | 2 | 9876543211 | BLPHASAD@GMAIL.COM | DELHI | 21 |
  91. | ALPHAC | SADC | 3 | 9876543212 | CLPHASAD@GMAIL.COM | DELHI | 22 |
  92. | ALPHAD | SADD | 4 | 9876543213 | DLPHASAD@GMAIL.COM | DELHI | 23 |
  93. | ALPHAE | SADE | 5 | 9876543214 | ELPHASAD@GMAIL.COM | DELHI | 24 |
  94. | ALPHAF | SADF | 6 | 9876543215 | FLPHASAD@GMAIL.COM | DELHI | 25 |
  95. | ALPHAG | SADG | 7 | 9876543216 | GLPHASAD@GMAIL.COM | DELHI | 26 |
  96. | ALPHAH | SADH | 8 | 9876543217 | HLPHASAD@GMAIL.COM | DELHI | 27 |
  97. | ALPHAI | SADI | 9 | 9876543218 | ILPHASAD@GMAIL.COM | DELHI | 28 |
  98. | ALPHAJ | SADJ | 10 | 9876543219 | JLPHASAD@GMAIL.COM | DELHI | 29 |
  99. +------------+-----------+----+------------+--------------------+-------+------+
  100. 10 rows in set (0.00 sec)
  101. 10 rows in set (0.00 sec)
  102.  
  103. mysql> UPDATE PERSON SET AGE=22 WHERE FIRST_NAME="ALPHAJ";
  104. Query OK, 1 row affected (0.03 sec)
  105. Rows matched: 1 Changed: 1 Warnings: 0
  106.  
  107. mysql> DELETE FROM PERSON WHERE LAST_NAME="SADF";
  108. Query OK, 1 row affected (0.03 sec)
  109.  
  110. mysql> SELECT * FROM PERSON
  111. -> ;
  112. +------------+-----------+----+------------+--------------------+-------+------+
  113. | FIRST_NAME | LAST_NAME | ID | MOBILE_NO | EMAIL | CITY | AGE |
  114. +------------+-----------+----+------------+--------------------+-------+------+
  115. | ALPHA | SAD | 1 | 9876543210 | ALPHASAD@GMAIL.COM | DELHI | 20 |
  116. | ALPHAB | SADB | 2 | 9876543211 | BLPHASAD@GMAIL.COM | DELHI | 21 |
  117. | ALPHAC | SADC | 3 | 9876543212 | CLPHASAD@GMAIL.COM | DELHI | 22 |
  118. | ALPHAD | SADD | 4 | 9876543213 | DLPHASAD@GMAIL.COM | DELHI | 23 |
  119. | ALPHAE | SADE | 5 | 9876543214 | ELPHASAD@GMAIL.COM | DELHI | 24 |
  120. | ALPHAG | SADG | 7 | 9876543216 | GLPHASAD@GMAIL.COM | DELHI | 26 |
  121. | ALPHAH | SADH | 8 | 9876543217 | HLPHASAD@GMAIL.COM | DELHI | 27 |
  122. | ALPHAI | SADI | 9 | 9876543218 | ILPHASAD@GMAIL.COM | DELHI | 28 |
  123. | ALPHAJ | SADJ | 10 | 9876543219 | JLPHASAD@GMAIL.COM | DELHI | 22 |
  124. +------------+-----------+----+------------+--------------------+-------+------+
  125. 9 rows in set (0.00 sec)
  126.  
  127. mysql> SELECT FIRST_NAME, MOBILE_NO FROM PERSON;
  128. +------------+------------+
  129. | FIRST_NAME | MOBILE_NO |
  130. +------------+------------+
  131. | ALPHA | 9876543210 |
  132. | ALPHAB | 9876543211 |
  133. | ALPHAC | 9876543212 |
  134. | ALPHAD | 9876543213 |
  135. | ALPHAE | 9876543214 |
  136. | ALPHAG | 9876543216 |
  137. | ALPHAH | 9876543217 |
  138. | ALPHAI | 9876543218 |
  139. | ALPHAJ | 9876543219 |
  140. +------------+------------+
  141. 9 rows in set (0.00 sec)
  142.  
  143. mysql>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!