How can I add a row in a table from a Linux Shell?

I’d assume you can use WP-CLI for that.

Especially wp db import should be usable for that.

Last but not least the MySQL Command-Line Tool itself, which I’d think is used by WP-CLI for the tasks, can be used.

A word of warning though, there might be some logic to consider regarding the rows you want to add to the table. That logic might not be easily reproducible – or you have to rebuild it – when doing things from the CLI.

So it might be better to use the according and existing functions for the import or adding of rows, because those have the logic implemented already. You can go that route by working with a custom PHP script, the loading of wp-load.php will be necessary – at least. This approach is pretty good documented, so just search this site and the net for it.

Related Posts:

  1. Display Tables in a slider
  2. Why majority of fileds in wp_posts table prefixed with post_?
  3. How to insert more than one row of data into a table at one time
  4. Tablepress won’t update the table data [closed]
  5. WP_List_Table error on WordPress 4.4
  6. Bulk actions redirects to “options.php” page when clicked (WP_List_Table)
  7. putting wp_query data into html table
  8. Looking for a simple tool to update a table
  9. Table editing in WordPress
  10. WordPress admin Tables use to display own data – In admin WP
  11. Creating a Restaurant Menu
  12. How to populate custom tables with rows of data
  13. Table not getting created upon activation of WP Theme
  14. How to build a dynamic data table with backend fields for the user
  15. How to add custom field to wp_list_table
  16. database select issue
  17. get table prefixes for SUB-SITES?
  18. WordPress Table didn’t look right
  19. CSS for Table Rows and Columns
  20. How can I create this type of table/catalog? [closed]
  21. table chaos since upgrade to 4.8
  22. echo spesific title get_the_title
  23. Why does ENOENT mean “No such file or directory”?
  24. How do I grep recursively?
  25. -bash: syntax error near unexpected token `newline’ for display command
  26. SSH using python script
  27. Changing the resolution of a VNC session in linux
  28. Using putty to scp from windows to Linux
  29. How does “cat << EOF" work in bash?
  30. What is difference between arm64 and armhf?
  31. standard_init_linux.go:178: exec user process caused “exec format error”
  32. How to count lines in a document?
  33. What does `set -x` do?
  34. How to get the process ID to kill a nohup process?
  35. Using ls to list directories and their total sizes
  36. tar: add all files and directories in current directory INCLUDING .svn and so on
  37. What does set -e mean in a bash script?
  38. What is `S_ISREG()`, and what does it do?
  39. Pipe to/from the clipboard in a Bash script
  40. what does -zxvf mean in tar -zxvf filename? 
  41. Android – Command not found
  42. EC2 ssh Permission denied (publickey,gssapi-keyex,gssapi-with-mic)
  43. What does ‘bash -c’ do?
  44. How do I know the script file name in a Bash script?
  45. What is the use of to_ping and pinged column?
  46. Removing filter dropdown in posts table (in this case Yoast SEO)
  47. Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
  48. How To Make Connection To WordPress Data Base In A Plugin?
  49. Visual Editor freezing on text highlight since 4.3
  50. Should I global $wpdb outside of any of my plugin’s functions scope?
  51. login wp impossible
  52. input data and output table [closed]
  53. Retrieve data from the database to table such as comments in the admin control panel
  54. Modification of how the data is controlled/showed and stored
  55. Can’t delete the two native plugins of WordPress
  56. Gutenberg table block with Bootstrap .table class
  57. Is it a good idea to add a column to the posts table?
  58. Create new database through static page code
  59. How to make wordpress use a non-wordpress users table?
  60. Editing mysql tables/database with wordpress or other app/cms
  61. Can i set css class for table via TinyMCE [closed]
  62. PHP Parse error on WP-CLI, not on web server
  63. Serial Number from custom table not appear in woocommerce_email_before_order_table action
  64. Plugins custom table not being created on activation
  65. How to edit custom table data in frontend
  66. How to configure both webserver and appserver for WordPress CMS?
  67. How to remove all plugins, posts, pages, and inactive themes in one line with wp-cli? WordPress bloatware removal
  68. How to display custom fields as table in Woocommerce
  69. Table styles disappear when updating content
  70. Adding list of Indexes in wordpress document
  71. Create hundreds of users with just ID in phpMyAdmin
  72. How to list Tags using get_tags in an html table?
  73. get the count of table rows
  74. Add new MCE button for toggle specific cell background color
  75. Communcation with wordrpess and linux server [closed]
  76. WordPress files owner changed silently
  77. Why is my crontab not working, and how can I troubleshoot it?
  78. Why is “chmod -R 777 /” destructive?
  79. How to check if a library is installed?
  80. Is it normal to get hundreds of break-in attempts per day?
  81. How do I prevent accidental rm -rf /*?
  82. What does Virtual memory size in top mean?
  83. What’s the best way to check if a volume is mounted in a Bash script?
  84. How do I find the UUID of a filesystem
  85. Find out symbolic link target via command line
  86. Meaning of directories on Unix and Unix like systems
  87. How to handle security updates within Docker containers?
  88. Is it possible to make Nginx listen to different ports?
  89. REJECT vs DROP when using iptables
  90. Linux command line best practices and tips?
  91. How to run command as user who has /usr/sbin/nologin as Shell?
  92. How to get pid of just started process
  93. How to disable everything in crontab -l?
  94. df says disk is full, but it is not
  95. What is the maximum port number?
  96. How to sort ps output by process start time?
  97. Is there a proper way to clear logs?
  98. protocol version mismatch — is your shell clean?
  99. How do I join two named pipes into single input stream in linux
  100. How should an IT department choose a standard Linux distribution?