Initially, the table “MyTable” has been defined in the following way: CREATE TABLE IF NOT EXISTS `MyTable` ( `Col1` smallint(6) NOT NULL AUTO_INCREMENT, `Col2` smallint(6) DEFAULT NULL, `Col3` …
Undefined index uid calling GET fetch
I have a function that calls a SQL query, the function is type fetch_user Now i get an Undefined Index error when I call my query, The error message is Undefined index: uid in profile.php on line 3 But the thing is that i cant find the error, This is my user.inc.php that have the function And this is my
Need help converting date in format 20120130 to Date data type oracle sql
Could you please help me in converting date from the format “20120101” to DATE format in Orcle Sql. I looked at this link but it does not mention if the date format is custom.. EDIT: Is it possible …
How to get Database Name from Connection String using SqlConnectionStringBuilder
I do not want to split connection strings using string manipulation functions to get Server, Database, Username, and Password. I read the following link and read the accepted answer, I found that is the best way to get username and password out from connection string, but what about Database Name? Right way t…
Formatting column in SQL
I would like to insert the pipe character | in a column to separate two sections of the output. Is there a way to put one in every row of a column as long as there is data in that row? Answer
Why am I getting an error in this create table script? [closed]
This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the …
JOIN two SELECT statement results
Is it possible to join the results of 2 sql SELECT statements in one statement? I have a database of tasks where each record is a separate task, with deadlines (and a PALT, which is just an INT of days from start to deadline. Age is also an INT number of days.) I want to have a table which has
file conversion- .mwb to .sql file
I have a database in .mwb format. I want to use it in eclipse so i need to convert it into .sql format. If anyone know how to do that by using any tool. I think My sql workbench can do that, but don’t know how to do that. Answer In the menu click “Database” and then “Forward engineerin…
Determine ROW that caused “unexpected end of file” error in BULK INSERT?
i am doing a bulk insert: DECLARE @row_terminator CHAR; SET @row_terminator = CHAR(10); — or char(10) DECLARE @stmt NVARCHAR(2000); SET @stmt = ‘ BULK INSERT accn_errors FROM ”F:FullUnzipped…
In a currency exchange rate what is the maximum number of decimal places used?
I need to store currency exchange rate data in the SQL 2008 database. I would like to keep rate as a decimal data type in the database. One thing I am not sure about, is how many decimal places to give (e.g. decimal(18, ?)). Since, I will be using this service as a source: http://openexchangerates.org/latest.…