how to deal with $ table in ms sql code example

Example 1: how to create an SQL table in ruby

def self.create_table
    sql = <<-SQL
      CREATE TABLE IF NOT EXISTS students (
        name TEXT,
        grade TEXT
      )
    SQL
    DB[:conn].execute(sql)
  end

Example 2: AUTO TRANSFER OF DATA FROM SYBASE TABLE TO PHPMYSQL TABLE

<?php
include 'config.php';
include 'opendb.php';

$tableName  = 'mypet';
$backupFile = 'mypet.sql';
$query      = "LOAD DATA INFILE 'backupFile' INTO TABLE $tableName";
$result = mysql_query($query);

include 'closedb.php';
?>

Tags:

Php Example

Related