|
DisIsHoody wrote: @jschell: In response to item 2, how can I check this?
Myself I use telnet (client). If you do not have this installed already then it already in the OS (windows) just go the "control panel" -> "Programs and Features" -> "Turn Windows features on or off" and then look for "Telnet Client".
You run telnet with the following command in a console window.
telnet <host> <port>
All you care about is whether it connects or not. If it connects you get a blank screen. If it fails, which can take some time (or not) you get an error.
You can find the regular ip of your computer by running the following command (windows) in a console window.
ipconfig
Both of the databases you cited use port 3306 by default.
So using the above the following three commands should tell you what is going on.
telnet local host 3306
telnet 127.0.0.1 host 3306
telnet <box ip address> host 3306
If all three fail then it means you are using a different port.
If just the localhost one fails then it means you have redirected local host.
If just the first two fail then it means that you have set your database up to bind to your regular ip and not 127.0.0.1.
The above of course makes the assumption that your really are running the database on your local box (and that your test with the GUI tool was valid and was actually connecting to the database on your box and not some database on another box.)
|
|
|
|
|
Hi I want to learn the basics of database. What is it?How we establish it.How can I attach it to my website.Please provide me some good tutorials for learning it. Thanks in advance.
|
|
|
|
|
There are multiple questions here and a variety of answers. To start with, there different types of databases by multiple companies. I would start out with MySql or MariaDB as both of these are available without paying a licensing fee.
Once you have determined what type of database you want to use then you have to determine what web technology you want to learn/use; ASP.NET, PHP, Java, etc.
Your question(s) are a too general to give you a specific answer. Google is your friend in this case. I would start by going to MySQL 5.6 Reference Manual. From this page you can learn everything about MySQL; tutorials, installation, administration. Download the software, read through the manual, and then if you have any specific questions I'm sure people here will help you as much as they can.
|
|
|
|
|
|
I have a table that it has a field with nvarchar datataype.
the content of this field Containing different of information such as phone number,address and ...
how do I grouping it In various fields?
|
|
|
|
|
Not enough information. Please provide more details as follows:
How many different information is contained in the field? Is the number of different information fixed? Is the sequence of different information fixed? How are they being separated (by comma or single space)?
|
|
|
|
|
some record containing 2 or 3 phone number that separate with space or 2dash or 3dash or ...
some record containing a sequenece of string or some record containing both of them.
|
|
|
|
|
Your table is in a mess, there is no fixed structure at all. The only way out is to do a manual clean up, and before that do remember to backup a copy of the original table. You must at least put in place some structure, say 'name', 'address', 'phone' that is comma separated and in fixed order and fixed number. Only then, you can use my solution to split and insert them into a new table. Work hard.
|
|
|
|
|
Peter, can you do us a favour and not edit spam questions in QA?
The instructions from Chris are to not edit the spam messages, just report them as spam and let the community (or a protector) delete them. The reasoning seems to be that from time to time he tries new spam filters and if you edit the message, then they "learn" what is and isn't spam from the edited message, which is no use!
Leaving them untouched, but hitting the "spam" button sends the unedited content to the filter, and it shoudl learn to distinguish real spam better.
Thanks!
Never underestimate the power of stupid things in large numbers
--- Serious Sam
|
|
|
|
|
|
No need to apologize - you weren't to know! 
Never underestimate the power of stupid things in large numbers
--- Serious Sam
|
|
|
|
|
can I use length of field?because the length of fields containing a sequence string is very more than phone number,and fields their length is less than phone number is other type information.
I think with this way,problem solve
but I don't know code.
|
|
|
|
|
|
|
The real learning comes from doing it yourself. No effort no gain. Have confidence in yourself. If you still encounter problems after trying, then come back to post your problems in the quick answer section.
|
|
|
|
|
I used this link,but I am having trouble.because some records is exception.
|
|
|
|
|
can I use SQl-CLR for this problem?
|
|
|
|
|
f,amiri882 wrote: the content of this field Containing different of information such as phone number,address and ...
f,amiri882 wrote: how do I grouping it In various fields?
You shouldn't; the correct way would be to have a separate field for each of those attributes.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
what?I don't underestnad 
|
|
|
|
|
Assuming your field values is comma separated and is of fixed number, check out this example at sql fiddle. It spilts the multiple-value field and insert them into a new table with separate fields. Adapt it to suit your need.
|
|
|
|
|
|
is there the C# code for this problem?
|
|
|
|
|
So, you don't want to understand your own problem and learn how to solve it and then you expect someone else to write code for you?
|
|
|
|
|
Hi All,
I am trying to debug a data issue, where in a query is reporting incorrect data.
Upon looking at the query having about 15 tables joined in the query, there is one join where it is specified as RIGHT OUTER JOIN but does not have a table it joins to. I am researching an existing query, written by someone else with no documentation.
I tried to add one join at a time to debug this issue, but the query fails when i try to add the RIGHT OUTER JOIN with no table to join on specified. I really don't know how the original query is working.
any ideas/inputs much appreciated!!
Thanks!
|
|
|
|
|
vkEE wrote: I really don't know how the original query is working.
Neither do I, but if you post the query here we could have a look at it 
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
