e_i_pi's Profile
User Rating:
Find Topics
Find Posts
View Reputation Given
Reputation: 745
Enlightened
- Group:
- Mentors
- Active Posts:
- 1,521 (0.97 per day)
- Joined:
- 30-January 09
- Profile Views:
- 31,389
- Last Active:
24 minutes ago- Currently:
- Viewing Topic: if 1=1? WHY?
Previous Fields
- Country:
- AU
- OS Preference:
- Windows
- Favorite Browser:
- FireFox
- Favorite Processor:
- AMD
- Favorite Gaming Platform:
- Playstation
- Your Car:
- Mitsubishi
- Dream Kudos:
- 75
- Expert In:
- Databases
Latest Visitors
-
RandomlyKnighted 
08 May 2013 - 16:09 -
vks.gautam1
07 May 2013 - 23:36 -
aaron1178
05 May 2013 - 19:50 -
CreaturGames
01 May 2013 - 05:49 -
el_pancho
19 Apr 2013 - 15:16
e_i_pi has set their status
Posts I've Made
-
In Topic: Execution Plan
Posted 17 May 2013
What's that remote query? Are you connecting to a remote server? If so, you can expect the execution time to blow out in a big way, especially if the remote server is having to pipe a large amount of data across the connection. Are you able to provide the SQL query to see if it can be optimised? -
In Topic: Issues with table design
Posted 15 May 2013
That diagram looks good, and meets 3NF. -
In Topic: Issues with table design
Posted 14 May 2013
You can still have a table called user, you just need to delimit it, like this:
CREATE TABLE [User]
Note that reserved keywords that are used as column names also require delimiting. -
In Topic: PHP and Frameworks.
Posted 13 May 2013
Like others here, I use my own framework, though it's not released publicly. I found that creating my own framework basically taught me PHP properly. Not to say that I am expert in PHP, but before I started using a framework, my code was sloppy, inefficient, and clunky. -
In Topic: Issues with table design
Posted 10 May 2013
RandomlyKnighted, on 11 May 2013 - 11:10 AM, said:Alright, I just have 2 questions. With the removal of the Parent Company table, you made the Company table have a parentID and you made it have a foreign key to the companyID in the same table. Did I read that right?
Yep, so the parentID refers to the companyID of the same table. Keep in mind that you will need to make parentID nullable for the purposes of root nodes. If you want to learn about working with hierarchical data, I wrote a tutorial here, though it only covers MSSQL.
Quote
Second, I tried searching for Microsoft parameter notation, but kept coming up with something else other than what you did. Could you provide me with either an explanation of it or a link to the documentation for it so I can read up on it?
In MSSQL, you declare variables (parameters) as @parameterName.
In MySQL, you declare regular variables as parameterName and session-wide variables as @parameterName.
In PHP PDO, you declare parameters as ? or :parameterName.
In PostgreSQL, you declare variables as parameterName.
So, when I said Microsoft parameter notation, I really meant Microsoft variable declaration, which is why you see queries with clauses like myTable.myColumn = @myParameter. You'll need to adjust the queries to match the syntax of whatever DB/DBA you are utilising.
My Information
- Member Title:
- = -1
- Age:
- 38 years old
- Birthday:
- June 24, 1974
- Gender:
-
- Location:
- Australia
- Years Programming:
- 4
- Programming Languages:
- HTML, XML, jQuery, PHP, SQL, MySQL, VBA, VBScript, PostgreSQL
Contact Information
- E-mail:
- Private
- Website URL:
-
http://www.artofwar.cc/
|
|
| 
Comments
cupidvogel
09 Jun 2012 - 11:30Duckington
04 Apr 2012 - 00:57modi123_1
13 Mar 2012 - 06:56RudiVisser
08 Mar 2012 - 15:20RudiVisser
06 Sep 2011 - 00:37RudiVisser
06 Sep 2011 - 00:37e_i_pi
05 Sep 2011 - 22:15no2pencil
05 Sep 2011 - 19:52Sayid Ahmed
13 Jul 2011 - 14:02Dormilich
17 Feb 2011 - 13:25