Hello Everyone,
I am new with sql but trying to get at it.

I have a word press website and with the below table(my_table_1) in my SQL DB and form the data within the column3 of my_table_1 i want to create a table(wish_table) which i will be displaying in webpage with a php function ( i am not sure).

Here is my_table_1 :

r/webdev - Need Help in creating a table from desired values within existing table column

my_table_1

I want to make a new table with the text within column3 with the column headers as: your-name, your-email, customer-enquiry-subject, customer-enquiry-details and enquiry-customer-contact.

With my limited knowledge I have created a table_2 just with column3 from my_table_1 by using the following command:

CREATE TABLE table_2
    AS (SELECT form_value FROM my_table_1);

Created table_2 from above code:

r/webdev - Need Help in creating a table from desired values within existing table column

table_2

My question is how do i get the text values from individual cells of column 3 of my_table_1 such as s:16:”Abhishek Bacchan”, s:23:”This is enquiry subject”, s:24:”Bla Customer Details” and s:10:”1231231233″ and insert them to get my wish_table as :

r/webdev - Need Help in creating a table from desired values within existing table column

wish_table

Can someone please help me or suggest me if my approach to get the data within the column3 cell is wrong as if i need to use php to get the data instead of using SQL.

THANK YOU READER



Source link

Write A Comment