In Feburary 2016 24,
Run your database, and open your usual textual SQL query generator.
Write a query that includes the value you want to check. Using SQL, you can check a field's value by using a regular expression. For example,SELECT DISTINCT my_data FROM my_tableWHERE my_data REGEXP ('[0-9]');Substitute the value 'my_data' with your field name and 'my_table' with your table name. Construct your query using the above as an example of how to determine whether a field is numeric or not.
Execute your query on some test data first. Check that the output matches what you expect to happen before using the query on live data.
In Feburary 2016 24,
Showing posts with label regular. Show all posts
Showing posts with label regular. Show all posts
Wednesday, 24 February 2016
Friday, 12 February 2016
How to Make My Own Web ServerIn Feburary 2016 12,
In Feburary 2016 12,
If you don't have a high-speed Internet connection, secure one with a local provider in your area.
Secure your own domain name. This will help people get to and from your files on the Internet. This will also give you a place to send and receive email. If you do not have a static web address (if you have cable or DSL connection, you probably will not have a static address) there are several places you can go to secure your domain. Check the resources section.
Get your router. Use a regular router, because wireless routers are not suggested for home server set-ups. Your router should have Ethernet jacks and should be capable of port forwarding in order to allow outside Internet traffic.
Set up your computer. Make sure that you have your standard computer items including a keyboard, mouse, and a 10/100 Ethernet Network Card. Make sure to have an uninterrupted power supply to keep your system safe in the event of a power outage.
To configure your web server, you should start system-config services. Make sure that httpd and mysqld are started and selected to start on boot, then save the service configuration.
Verify that your web server is working correctly by opening a browser and pointing it at http://localhost/ (which always points to the web server on your computer). You should see the test page for apache, the web server application.
Set up port forwarding as directed by your router. Make sure that all http services or port 80 traffic is sent to the IP address of your web server.
In Feburary 2016 12,
If you don't have a high-speed Internet connection, secure one with a local provider in your area.
Secure your own domain name. This will help people get to and from your files on the Internet. This will also give you a place to send and receive email. If you do not have a static web address (if you have cable or DSL connection, you probably will not have a static address) there are several places you can go to secure your domain. Check the resources section.
Get your router. Use a regular router, because wireless routers are not suggested for home server set-ups. Your router should have Ethernet jacks and should be capable of port forwarding in order to allow outside Internet traffic.
Set up your computer. Make sure that you have your standard computer items including a keyboard, mouse, and a 10/100 Ethernet Network Card. Make sure to have an uninterrupted power supply to keep your system safe in the event of a power outage.
To configure your web server, you should start system-config services. Make sure that httpd and mysqld are started and selected to start on boot, then save the service configuration.
Verify that your web server is working correctly by opening a browser and pointing it at http://localhost/ (which always points to the web server on your computer). You should see the test page for apache, the web server application.
Set up port forwarding as directed by your router. Make sure that all http services or port 80 traffic is sent to the IP address of your web server.
In Feburary 2016 12,
Subscribe to:
Comments (Atom)