| A | |
| 1 | =demo.query("select EID, NAME+?+SURNAME as FULLNAME, GENDER, STATE, BIRTHDAY, SALARY from EMPLOYEE"," ") |
| 2 |
 >A1.insert(0,2000,"Julia Jones","F","Florida",date("1988-1-10"),10000)
|
| 3 |
>A1.insert(2,20,"M":GENDER,"Brandon Williams":FULLNAME,"California":STATE,"test")
|
| 4 |
>A1.delete(3)
|
| 5 |
>A1.delete([4,20,7])
|
| 6 |
>A1.modify(1,1,"Emily Lee","F","California",date("1984-4-2"),8000)
|
| 7 |
>A1.modify(2,8000:SALARY)
|
| 8 |
>A1(3).FULLNAME="Helen Brown"
|
| 9 |
>A1.delete(A1.pselect@a(SALARY>15000))
|
修改后，序表被修改，可以在A1中查看:
