Developers

developers@phpmyadmin.net

2 participants
7003 discussions

[Phpmyadmin-devel] Using Case or If statement
by Rick Beach 08 Feb '12

08 Feb '12

When creating a view in phpmyadmin on yahoo business I need to know the corrct syntax to return text. Below are two examples of an If statement and a case statement that return an Integer. Both of these views work correctly. There are also three examples of an If statement to return text and three examples of case statements to return text. None of these six examples work correctly even when using using single quotes, double qoutes or no quotes at all. Please review all of the below examples and let me know what is happening that the select statement changes. SELECT If(Month(Now())=2,555,999) works correctly SELECT case Month(now()) when 2 then 555 else 999 end works correctly SELECT If(Month(Now())=2,'Feb','Oth') changes the select statement to: SELECT If(Month(Now())=2,\'Feb\',\'Oth\') and gives error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Feb\',\'Oth\')' at line 5 SELECT If(Month(Now())=2,"Feb","Oth") changes the select statement to: SELECT If(Month(Now())=2,\"Feb\",\"Oth\") and gives error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\"Feb\",\"Oth\")' at line 5 SELECT If(Month(Now())=2,Feb,Oth) gives below error: #1054 - Unknown column 'Feb' in 'field list' SELECT case Month(now()) when 2 then 'Feb' else 'Other' end changes the select statement to: SELECT case Month(now()) when 2 then \'Feb\' else \'Other\' end and gives error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Feb\' else \'Other\' end' at line 5 SELECT case Month(now()) when 2 then "Feb" else "Other" end changes the select statement to: SELECT case Month(now()) when 2 then \"Feb\" else \"Other\" end and gives below error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\"Feb\" else \"Other\" end' at line 5 SELECT case Month(now()) when 2 then Feb else Other end gives below error: #1054 - Unknown column 'Feb' in 'field list'

2 1

[Phpmyadmin-devel] github outage
by Marc Delisle 08 Feb '12

08 Feb '12

Hi, github.com currently has network connectivity issues, see http://twitter.com/github -- Marc Delisle http://infomarc.info

1 0

[Phpmyadmin-devel] Doing changes in multiple branches
by Michal Čihař 08 Feb '12

08 Feb '12

Hi all several times, I've noticed some of you make same changes in all branches. The preferred way (so that we have only one commit in history doing the change) is to make change first in most specific/oldest branch and then merge it to others. This is also explained on our wiki: http://wiki.phpmyadmin.net/pma/Git#Committing_fixes_to_several_branches -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz

1 0

[Phpmyadmin-devel] We're on github
by Michal Čihař 07 Feb '12

07 Feb '12

Hi all I've just updated the repos on github and enabled notifications hooks there, so the switch to github is done. All you need to do is point your repositories to pull/push to github, for main repository it can be done using: git remote set-url origin git@github.com:phpmyadmin/phpmyadmin.git If you are using just read only access then use following: git remote set-url origin git://github.com/phpmyadmin/phpmyadmin.git For other repositories just replace last part of the URL with repository name (they have not changed). Everything should work as before, pushes should be now faster, because all notifications are done in background on github and they don't block pushing. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

2 3

[Phpmyadmin-devel] Migration to github
by Michal Čihař 07 Feb '12

07 Feb '12

Hi all as agreed yesterday, we are going to move our repositories to Github, all you need to do are few simple steps described on the wiki: https://wiki.phpmyadmin.net/pma/Git_migration What I need right now is you to send me your login on github so that I can add you to the project. Once all people are granted access we will actually switch to using github, what will be announced later. PS: Our code is just being pushed there as I write this. -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz

9 14

[Phpmyadmin-devel] about QA_3_5 and master
by Marc Delisle 01 Feb '12

01 Feb '12

Hi, I'm not sure what is happening between these branches but please wait before merging QA_3_5 into master until the situation is fixed. The usual recipe of git merge -X ours QA_3_5 does not seem to work. -- Marc Delisle http://infomarc.info

2 4

[Phpmyadmin-devel] different behavior for 'More'
by Marc Delisle 31 Jan '12

31 Jan '12

Hi, have we ever discussed the two different behaviors for 'More'? - in the menu tabs, 'More' appears only if forced by the window size - in the table structure, it is forced (contains various index links) Someone with a larger screen could prefer to see her screen filled horizontally. -- Marc Delisle http://infomarc.info

2 1

[Phpmyadmin-devel] Find junior jobs to start
by Jesús Cova 30 Jan '12

30 Jan '12

I could realize that all junior jobs are done where can I find more? -- Regards Jesús Rafael Cova Huerta

2 1

[Phpmyadmin-devel] Can I work on this?
by Jesús Cova 30 Jan '12

30 Jan '12

I want to make this Copying multiple tables rfe:1863198<https://sourceforge.net/tracker/index.php?func=detail&aid=1863198&group_id=…>, I wonder do you have something that explain me the differences classes, functions and libraries that you use? -- Regards Jesús Rafael Cova Huerta

2 2

[Phpmyadmin-devel] I want to help with codes
by Jesús Cova 30 Jan '12

30 Jan '12

I want to help with codes, how can I do? -- Regards Jesús Rafael Cova Huerta

2 1

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

Developers