How to insert comma separated string into SQL Server table while each part in new column

Question

Example:

$words = 'word1,word2,word3';

Ouput:

id    value1  value2 value3
---   ------  ------ -------
1     word1   word2  word3

I want the data to be inserted in a single row but in different columns

This is what I have tried so far:

$data = '"1","1","8009","8989"';
$stmt = odbc_prepare($con," INSERT INTO stock( SiteId, DatabaseId, Code, Category) VALUES(?,?,?,?)");
$success = odbc_execute($stmt,array($data) );
odbc_close($con);

Your title says MySQL, and your tag says SQL Server 2008. Which is it? — iainn
– iainn, Commented Feb 12, 2018 at 15:05
So explode $words on the comma to get an array of words; then you can insert them as individual words.... although why this table structure? — Mark Baker
– Mark Baker, Commented Feb 12, 2018 at 15:07
edit your post stackoverflow.com/posts/48749373/edit not including code in comments — Funk Forty Niner
– Funk Forty Niner, Commented Feb 12, 2018 at 15:13
Will there only ever be 3 words? Could there be 1? Perhaps 4, 10, more? — Thom A
– Thom A ♦, Commented Feb 12, 2018 at 15:15

Mohit Kumar · Accepted Answer · 2018-02-12 15:46:26Z

1

use explode function

<?php
$words = 'word1,word2,word3';

$data_array = explode(',', $words);

    $a=$data_array[0];
    $b=$data_array[1];
    $c=$data_array[2];
    //insert Qquery here.
?>

answered Feb 12, 2018 at 15:46

Mohit Kumar

9302 gold badges7 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

The Cypher Over a year ago

Thank you ,one challenge is i have tables with +300 columns is possible to use $data_array in my insert Query without assigning each $data_array element to a variable

Mark Baker Over a year ago

If you have tables with 300+ columns like this, then you have a database design problem

Collectives™ on Stack Overflow

How to insert comma separated string into SQL Server table while each part in new column

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related