![excel data generator excel data generator](https://s.wincalendar.net/img/excel-to-calendar.png)
INSERT INTO dummy_insert(dummy_1,dummy_2) values (1,2) Summary INSERT INTO dummy_insert(dummy_1,dummy_2) values (1,2) = CONCATENATE(A2,B2,",",C2,D2)īelow is generate insert clause INSERT INTO dummy_insert(dummy_1,dummy_2) values (1,2) Insert statement syntax INSERT INTO table_name(column_name.) values (values.) Ĭheck the image to create the excel sheet and use formula. Using the same approach you can create insert statement as shown in below image. You can use the same method to generate more complex scripts for insert, update and delete. Copy and paste or click and drag this formula to all cells. Write an excel concatenate function as shown below. Open excel which has table information as shown below.ģ. These are the following File structures for this tutorial: config.php (database connection file), index.php (For fetching data), generate- excel.php (For generating excel file), all in PHP functions. You can also use a text editor like Notepad++ and copy and paste to create commands.ġ. One way is to write a logic using PL/SQL and use execute immediate statement. Now you want to drop all or all the selected tables. Let’s assume a random set of data which contains table information like table name, owner, and other information. You can have up to 255 items, up to a total of 8,192 characters. Text2, … (optional) Additional text items to join. The item can be a text value, number, or cell reference. Argument name Description text1 (required) The first item to join. =CONCATENATE(“Hello “, A2, ” How are you “)Ī2 – is replaced with cell data.CONCATENATE It is built-in excel function to concatenate multiple strings into on single sting. You can use it to do simple tasks and even create a game. Here I will share a simple tip to generate repeating SQL statement using Excel.īefore going further let’s discuss concatenate function in Excel. Microsoft Excel is one of the most used product in the IT Industry for project management and tracking.
#Excel data generator how to#
This article explains how to use Excel to generate SQL statements like drop table, insert and update easily using built-in CONCATENATE excel function.