How do I insert data into SQLite using React Native?

How do I insert data into SQLite using React Native?

You can use the react-native-sqlite-storage library to insert data. First, ensure you have it installed.

What is the basic syntax for inserting data?

The basic syntax is: db.transaction(tx => { tx.executeSql('INSERT INTO table_name (column1, column2) VALUES (?, ?)', [value1, value2]); });

Can you show me a complete example?

Sure! Here's a complete example:

import SQLite from 'react-native-sqlite-storage';

const db = SQLite.openDatabase({name: 'my.db'});

db.transaction(tx => {
  tx.executeSql('CREATE TABLE IF NOT EXISTS Users (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT);');
  tx.executeSql('INSERT INTO Users (name) VALUES (?);', ['John Doe']);
});

What if I want to insert multiple rows?

You can loop through your data and call executeSql for each item, or use a single INSERT statement with multiple values.