| CodeLobster IDE http://codelobster.com/forum/ |
|
| How to generate a new table in SQL http://codelobster.com/forum/viewtopic.php?f=3&t=24602 |
Page 1 of 1 |
| Author: | luanvan24 [ Sat May 18, 2019 9:27 am ] |
| Post subject: | How to generate a new table in SQL |
I need to create a view vCustomerOrders that displays the customer's name, order number, and order date. What is the best route for this? |
|
| Author: | Ragnar [ Fri May 31, 2019 6:54 am ] |
| Post subject: | Re: How to generate a new table in SQL |
the beast way is to learn some SQL syntax, some DBMS theory and practice and a bit of SQL Server Architecture. In other words: RTFM, noob. |
|
| Author: | avisawant [ Sat Aug 03, 2019 5:50 am ] |
| Post subject: | Re: How to generate a new table in SQL |
SQL CREATE TABLE statement is used to create table in a database. If you want to create a table, you should name the table and define its column and each column's data type. Simple syntax to create table- create table "tablename" ("column1" "data type", "column2" "data type", "column3" "data type", ... "columnN" "data type"); |
|
| Author: | DaniGartenberg [ Thu Jun 17, 2021 8:40 am ] |
| Post subject: | Re: How to generate a new table in SQL |
If you want to create a table, you should name the table and define its column and each column's data type. |
|
| Author: | Lobsterboy22 [ Tue Jun 29, 2021 8:01 pm ] |
| Post subject: | Re: How to generate a new table in SQL |
try this to display the result <?php foreach ($scores as $_score) { ?> <tr style="background:#172335;color:white;"> <td style="border:0;padding:5px;border-bottom: solid #263a58 1px;text-align:center;"><?=$_score['rank']?></td> <td style="border:0;padding:5px;border-bottom: solid #263a58 1px;text-align:left;"> <?=$_score['name']?></td> <td style="border:0;padding:5px;border-bottom: solid #263a58 1px;text-align:center;"><?=$_score['lost']?></td> <td style="border:0;padding:5px;border-bottom: solid #263a58 1px;text-align:center;"><?= $_score['drawn']?></td> <td style="border:0;padding:5px;border-bottom: solid #263a58 1px;text-align:center;"><?= $_score['won']?></td> <td style="border:0;color:#e95842;padding:5px;border-bottom: solid #263a58 1px;text-align:center;"><?= $_score['points']?></td> </tr> <?php } ?> |
|
| Page 1 of 1 | All times are UTC |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|