Inserting rows into a custom table, when plugin is activated

The table isn’t defined on your insert function. So you will need to add – $table_name = $wpdb->prefix . 'countries'; as you did for the create table function.

Related Posts:

  1. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  2. Case in Select Statement
  3. What is a stored procedure?
  4. Unknown column in ‘field list’ error on MySQL Update query
  5. SQL Inner-join with 3 tables?
  6. Conversion failed when converting date and/or time from character string while inserting datetime
  7. MySQL create table if not exists and insert record only if table was created
  8. error, string or binary data would be truncated when trying to insert
  9. ORA-00907: missing right parenthesis
  10. How do I use properly CASE..WHEN in MySQL
  11. Rename column SQL Server 2008
  12. Why do we need “Relationships” between tables at all?
  13. Using group by on multiple columns
  14. How to declare a variable in MySQL?
  15. ORA-01843 not a valid month- Comparing Dates
  16. How do I escape a single quote in SQL Server?
  17. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  18. How Stuff and ‘For Xml Path’ work in SQL Server?
  19. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  20. Oracle SELECT TOP 10 records
  21. must appear in the GROUP BY clause or be used in an aggregate function
  22. How can I return pivot table output in MySQL?
  23. The multi-part identifier could not be bound
  24. MySQL syntax for Join Update
  25. Get day of week in SQL Server 2005/2008
  26. incorrect syntax error CREATE VIEW must be the only statement in the batch
  27. PLS-00103: Encountered the symbol when expecting one of the following:
  28. SQLite – UPSERT *not* INSERT or REPLACE
  29. how to drop partition without dropping data in MySQL?
  30. Simple way to calculate median with MySQL
  31. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  32. Error 1046 No database Selected, how to resolve?
  33. What is it exactly a BLOB in a DBMS context
  34. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  35. Insert text with single quotes in PostgreSQL
  36. SQL Server IF NOT EXISTS Usage?
  37. How to insert date values into table
  38. Arithmetic overflow error converting numeric to data type numeric
  39. I want to use CASE statement to update some records in sql server 2005
  40. Postgresql tables exists, but getting “relation does not exist” when querying
  41. SELECT DISTINCT on one column
  42. how to remove time from datetime
  43. TSQL PIVOT MULTIPLE COLUMNS
  44. MySQL – UPDATE multiple rows with different values in one query
  45. How to create a MySQL hierarchical recursive query?
  46. Microsoft OLE DB Provider for SQL Server error ‘80004005’
  47. Query to convert from datetime to date mysql
  48. SQL Parentheses use in an OR clause
  49. Is it possible to GROUP BY multiple columns using MySQL?
  50. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  51. How to query MongoDB with “like”
  52. Equivalent of Oracle’s RowID in SQL Server
  53. Subtract one day from datetime
  54. MySQL equivalent of DECODE function in Oracle
  55. what is the difference between triggers, assertions and checks (in database)
  56. Replacing NULL with 0 in a SQL server query
  57. How to delete from multiple tables in MySQL?
  58. How to copy a row and insert in same table with a autoincrement field in MySQL?
  59. Backup a single table with its data from a database in sql server 2008
  60. Error converting data type varchar
  61. updating table rows in postgres using subquery
  62. I want to use CASE statement to update some records in sql server 2005
  63. Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
  64. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  65. ROW_NUMBER() in MySQ
  66. Foreign key references invalid table
  67. Is there a coalesce-like function in Excel?
  68. What are database constraints?
  69. Postgresql column reference “id” is ambiguous
  70. Inner Joining three tables
  71. How do I view the Explain Plan in Oracle Sql developer?
  72. ORA-01779: cannot modify a column which maps to a non key-preserved table
  73. SUM OVER PARTITION BY
  74. MySQL LIKE IN()?
  75. Filter data based on date in sql
  76. Varchar invalid for Sum operator
  77. SQL: How to properly check if a record exists
  78. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  79. SQL query to extract only the “current” wp_posts?
  80. Sorting search results by taxonomy terms
  81. SQL select of users by metadata
  82. How to properly sanitize strings without $wpdb->prepare?
  83. How to retrieve sticky post in raw sql?
  84. How to remove in the wordpress database all posts revisions except the last three?
  85. Backticks (`) Instead of Single Quotes (‘) in an SQL Statement?
  86. $wpdb get_var issue
  87. posts_where Fails with More than One Custom Field in Query
  88. Auto-update tables from database
  89. dbDelta not creating table (yes, once more)
  90. Posts modified in the last 48 hours
  91. How can i restore only Blogs from a SQL backup file?
  92. DB_HOST – is LOCALHOST speedy than domain name? [closed]
  93. post id not displaying
  94. How to export 2 week’s worth of posts
  95. Insert multiple checkbox values
  96. How to get EVENT based on startday, using BETWEEN
  97. wpdb prepare without placeholder
  98. Adding profile data to database
  99. This SQL request call all time and overload my server : SELECT meta_value FROM wp_sitemeta WHERE meta_key = ‘wp_installer_network’ AND site_id = 1
  100. Deleting the MySQL database