create Table with text type column - Android Database

Android examples for Database:Table Create

  1. HOME
  2. Android
  3. Database
  4. Table Create

Description

create Table with text type column

Demo Code


//package com.java2s;

import android.database.sqlite.SQLiteDatabase;

import android.util.Log;

public class Main {
    public static SQLiteDatabase db;
    public static String detailname = "detaillist";

    public static void createDetailTable() {
        try {//from  w w w. j  a v  a 2s  .co m

            db.execSQL("create table if not exists " + detailname + "("
                    + " _id integer PRIMARY KEY autoincrement, "
                    + " number text," 
                    + " detail text, " 
                    + " memo text);");
        } catch (Exception ext) {
            Log.d("Create table fail", "table make fail");
        }
    }
}

Related Tutorials