Contents:
May I know which programming or development is your main focus?
there is a mistake, do you mean show the last 4 symbols from each string?
Are you sure you wrote it correct?
is there any source from where i could extract predefined tables into my mysql workbench and practise with?
Which sql database would be thriving in the long run?
Or would the popularity of open source db would plummet?
May I know which programming or development is your main focus?
there is a mistake, do you mean show the last 4 symbols from each string?
Are you sure you wrote it correct?
is there any source from where i could extract predefined tables into my mysql workbench and practise with?
Which sql database would be thriving in the long run?
Or would the popularity of open source db would plummet?
ranasharif 2020-07-23 03:02:30
piterden 2020-07-23 03:00:42
Windows is good for gaming and for low skilled users
Thanks for your suggestion.
piterden 2020-07-23 03:02:36
Suggest you to use any popular linux (Ubuntu, Mint, Elementary, and so on…) or mac
piterden 2020-07-23 03:03:14
Mac is good for develop but has too much bad shit for me
ranasharif 2020-07-23 03:03:36
Thank you, I will try to follow your suggestion
piterden 2020-07-23 03:03:49
I use Manjaro (Arch based dist)
piterden 2020-07-23 03:04:55
It’s simple and user friendly such as Ubuntu, but has much more nice features from out of the box
piterden 2020-07-23 03:06:24
If you are used to use Windows, and will choose linux, take Gnome or KDE for the start
ranasharif 2020-07-23 03:06:48
May I know which programming or development is your main focus? Please….
piterden 2020-07-23 03:07:09
Or Elementary would be fine and the same for Deepin
piterden 2020-07-23 03:07:38
ranasharif 2020-07-23 03:06:48
May I know which programming or development is your main focus? Please….
https://coderstats.net/github/#Piterden
CoderStats – Summary Statistics, Rankings and Repositories – coderstats.net
Summary statistics, rankings and repositories about public source code repositories on GitHub.
Summary statistics, rankings and repositories about public source code repositories on GitHub.
piterden 2020-07-23 03:08:15
It’s only github stats
piterden 2020-07-23 03:08:52
There is both github and gitlab https://sourcerer.io/piterden
piterden 2020-07-23 03:10:38
Sites, bots, mobile apps focused on web-technologies
ranasharif 2020-07-23 03:11:48
piterden 2020-07-23 03:10:38
Sites, bots, mobile apps focused on web-technologies
Glad to know, thanks for share your career based information
piterden 2020-07-23 03:12:25
Earlier I have win in virtual box, but about 1.5 years ago I just remove that shit out away
piterden 2020-07-23 03:13:02
Never need need it since that time
piterden 2020-07-23 03:13:39
ranasharif 2020-07-23 03:11:48
Glad to know, thanks for share your career based information
NP) it is not a secret ))
piterden 2020-07-23 03:14:18
rather the opposite
ranasharif 2020-07-23 03:15:36
piterden 2020-07-23 03:14:18
rather the opposite
You are right💐💐💐
MasterZiv 2020-07-23 08:14:41
ranasharif 2020-07-23 02:29:39
I have started my xampp control panel to do practice but MySQL wasn’t start when I went it.
And I want know how can I recover my exist database if don’t create any backup before the MySQL disaster.
Thanks in advance.
Look into the logs, what else is there
ranasharif 2020-07-23 17:33:15
MasterZiv 2020-07-23 08:14:41
Look into the logs, what else is there
Thanks the problem was solved
ranasharif 2020-07-23 17:34:32
Table Name frn_limit
column Name f_code
column Name f_code
CDDC93001
CDDC88001
CIR01081
CIR01141
IRD0173001
IRD1204001
RDC1204001
RDC1204002
RDC1285001
Now I want to remove characters prefix and show 4 digits from ending of prefix.
Anyone helps me to make the query please
acromegale 2020-07-23 17:36:15
SELECT REVERSE(REVERSE(‘abc12341241’) * 1)
acromegale 2020-07-23 17:37:21
only if you sure that strings have only prefixes
ranasharif 2020-07-23 17:41:17
acromegale 2020-07-23 17:37:21
only if you sure that strings have only prefixes
There is different type prefixes but all are string
acromegale 2020-07-23 17:45:29
this code will truncate all characters exclude numbers
ranasharif 2020-07-23 17:56:20
Will you share me the query please
acromegale 2020-07-23 17:58:26
there is a mistake, do you mean show the last 4 symbols from each string?
ranasharif 2020-07-23 18:00:14
acromegale 2020-07-23 17:58:26
there is a mistake, do you mean show the last 4 symbols from each string?
CDDC93001 => 9301
CDDC88001 => 8800
CIR01081 => 0108
CIR01141 => 0114
IRD0173001 => 0173
I want to like that
acromegale 2020-07-23 18:02:46
so, you can use previous query and wrap expression to left function like this:
SELECT LEFT(REVERSE(REVERSE(‘abc12341241’) * 1), 4)
SELECT LEFT(REVERSE(REVERSE(‘abc12341241’) * 1), 4)
Roshangiri11 2020-07-23 18:37:26
How can i backup themysql file
piterden 2020-07-23 18:40:45
ranasharif 2020-07-23 18:00:14
CDDC93001 => 9301
CDDC88001 => 8800
CIR01081 => 0108
CIR01141 => 0114
IRD0173001 => 0173
CDDC88001 => 8800
CIR01081 => 0108
CIR01141 => 0114
IRD0173001 => 0173
I want to like that
Are you sure you wrote it correct? It seems the first number should be 9300
ranasharif 2020-07-23 18:41:15
piterden 2020-07-23 18:40:45
Are you sure you wrote it correct? It seems the first number should be 9300
Sorry, you are right
piterden 2020-07-23 18:42:30
Then you need to split it by the boundary between numbers and letters an then to take first four numbers
piterden 2020-07-23 18:43:20
Regular expressions can solve it
ranasharif 2020-07-23 18:44:45
piterden 2020-07-23 18:43:20
Regular expressions can solve it
You are expart I am new and lerner of RDBMS
all things are little bit hard for me sir.
piterden 2020-07-23 18:56:47
@acromegale WTF?
piterden 2020-07-23 18:57:01
https://dev.mysql.com/doc/refman/8.0/en/regexp.html#function_regexp-replace
piterden 2020-07-23 18:57:13
v8
piterden 2020-07-23 18:59:06
Example exactly from docs not works too
ranasharif 2020-07-23 19:00:03
I am trying to solve that but still not succss
acromegale 2020-07-23 19:30:45
piterden 2020-07-23 18:56:47
@acromegale WTF?
because only 8+
piterden 2020-07-23 20:01:49
acromegale 2020-07-23 19:30:45
because only 8+
Do you mean 9?
lionel_lolly 2020-07-25 14:59:42
Hello. is there any source from where i could extract predefined tables into my mysql workbench and practise with? I’m aware of W3school sql resource, but I’d want to try it on my sql workbench? Any hacks?
piterden 2020-07-26 04:24:10
lionel_lolly 2020-07-25 14:59:42
Hello. is there any source from where i could extract predefined tables into my mysql workbench and practise with? I’m aware of W3school sql resource, but I’d want to try it on my sql workbench? Any hacks?
Workbench is enough intuitive to understand it without help or try F1
piterden 2020-07-26 08:03:43
Wat?
piterden 2020-07-26 08:13:22
Never used it
lionel_lolly 2020-07-26 09:39:32
piterden 2020-07-26 04:24:10
Workbench is enough intuitive to understand it without help or try F1
👍 Just a random question. Which sql database would be thriving in the long run?
piterden 2020-07-26 09:43:43
lionel_lolly 2020-07-26 09:39:32
👍 Just a random question. Which sql database would be thriving in the long run?
Sorry, what do you mean “long run”?
lionel_lolly 2020-07-26 10:05:23
With commercial db like oracle and Ms sql servers, could mysql give a tough competition, maybe 4 to 5 yrs from now. Or would the popularity of open source db would plummet?