Skip to content

Tag: sql

SQL: mysqli_query, no output

Im not sure what’s the problem with this, I’ve tried searching around here and tried different ways of writing the syntax and checking for errors in parameter but still no output for the command. What am i missing here? UPDATE As answered by the others, I tried doing this. There is still no output…

SQL one to one relationship vs. single table

Consider a data structure such as the below where the user has a small number of fixed settings. User UserSettings Is it considered correct to move the user’s settings into a separate table, thereby creating a one-to-one relationship with the users table? Does this offer any real advantage over storing …

CSV to MySQl Import

i need to insert csv into mysql database in proper column. let say csv has header and then data A B C and Mysql has table with column C A B i need to know best way to insert csv data to mysql table Answer I believe you can use the following syntax for mysql: So you can build up

SQL Server: Best way to concatenate multiple columns?

I am trying to concatenate multiple columns in a query in SQL Server 11.00.3393. I tried the new function CONCAT() but it’s not working when I use more than two columns. So I wonder if that’s the best way to solve the problem: I can’t use COLUMN1 + COLUMN2 because of NULL values. EDIT If I t…