MySQL Database Forum

I have bunch of data in the table in my database, the field is in a varchar type, the field has deimal numbers, has integers, has letters etc. i only want to check if the data in that field is a decimal, how can i check that using only mysql syntax? no php. Any comment are so apprecitaed, thank you. :)

I tried editing .ini file, it prompts access in denied. And if i try to chnage using command prompt that also it does no allow me to do so.I cannot even use "Show Max_allowed_packets". It says show is not recognized as internal and external command. # For advice on how to change settings please see #...

HELP PLEASE!!!!!!!!!!!!! Error MySQL said: Documentation #2003 - Can't connect to MySQL server on '127.0.0.1' (10061) Connection for controluser as defined in your configuration failed.

i am trying to feed a number to database in this case my reference number which is of a (AAA/BBB/28AUG2015 - 4082) format, which should be selected by user,and the date should be the system date while the last number should be auto-generated in that sequence. the 1st and 2nd values are fixed.kindly i am unable to do that on phpmyadmin DB...

My goal is to connect my SSIS package to a MySQL server running on a different machine (windows). I am new to MySQL and my client's system admin doesn't know much about MySQL either. I've been trying to connect to using ODBC MySQL driver 5.3 but i keep getting this error: ERROR: Can't connect to MySQL server on '' (10061) Do i need to have a...

Is it possible to install MySQL standard edition to a remote server using filezilla to upload files and putty to run and execute the setup MySQL? if yes, how to run the installation

I was trying to create a website that enables the users to Input something in it, like user info. but it always gives an error whenever I try to test submit the inputted data's into the database. 'Could not Connect: Access denied for user 'smdg'@'localhost' (using password: YES)' connection: define('DB_NAME', 'testdb'); define('DB_USER',...

how do i change this to mysqli? <?php require 'connect.php'; session_start(); $username = ""; $password = "";

I have created a search box now want to add search function to it that searches for text entered only in my site. I want to know how things are put together for search to work. I know we need to call data from tables we want to search, but do i need to create a table for this search function just read it somewhere, if it is so what is the purpose...

I am using the code below for search function but it is not protected from injections and I am not programming expert so can anyone help me on this my code is <?php include ( "./inc/header.inc.php" ); ?> <?php if(!isset($_POST)) { header("Location: main.php"); } $search_sql="SELECT * FROM blogs WHERE title LIKE '%".$_POST."%' OR body...

I am building a query that gives the following information Total Claims, Total Charges, Total Payment, Denial Count, % of Billed Charges and % of Claims Denied This is all grouped by provider id, provider name and denied count then ordered by Total Claims. I have been successful with my query until it comes to getting the % of Billed...

I wanted to use MySQL for storage of login information. Then I will have multiple services (RADIUS, Proxy, etc) checking against the information. Is there a way to make a master table that will have all the information that is needed, then have a bunch of child tables that have the redundant information from the master table, however, only...

I need some help writing a sql query. I have below 2 queries and I want to combine them together. Now I already tried 'union' but it doesn't work. I first want to print all results of query1 than at bottom of that I want to print all results for query2. --Query#1 SELECT DISTINCT a., b.Description FROM CONTAINSTABLE(myTable, *,...

I have a long, complicated set of conditions that I would like to use in a MySQL stored procedure to either (a) update a table with the complicated set of conditions in the WHERE clause, or (b) return a single value based on the same set of complicated conditions. I know how to write a stored procedure to do one or the other, but cannot see a way...

***> here is the code***. > when i search single word like GOOGLE then the result is appear > if i search two or more word search then the result is not appear. <?php include("connection.php"); @ob_start(); session_start(); $GLOBALS=isset($_GET) ? htmlspecialchars(urldecode(urlencode($_GET))):"";

Alo all, We are targeting specific kind of customers who use different kind of services such as fashion shops, cosmetics etc. This service providers just buy a package (domain, web site, db etc) and they are good to go. Now they customers are repeated time and again and so a single customer is registered 5-6 times in a single computer running...

I am working on a project similar to Cleverbot (a chatbot). It will store user input and quickly match it with a response that another user already gave for that input. What would be the proper way to store the conversation in a database? Just as a table with a bunch of individual records of sentences? (with key>value type pairs?)... or is that...

Hey everybody, Problems everywhere ain't they? Well this one is about mysql and when I open phpmyadmin, I get "Access Denied. Error! Cannot connect: invalid settings. Connection for controluser as defined in your configuration failed. phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check...

I need help designing a separate lookup database that allows me to find information about members quickly. On our main system each account can have 3 sub-members linked to it including the main which makes 4. They can only purchase an event once per member + sub member. Each member has its own 15 Digit ID. I need help figuring out how to join...

Hi, I have used inner join but need to remove leading zero's in one of the field because my query is "select * from table1 inner join table2 where table1.start = table2.start" here table1.start field consistleading zero's. how can i apply query in where condition to remove leading zero's.

I am creating a login page , tables: database has tables &quot;student&quot; and &quot;faculty&quot; schema: "student" table has columns "sid,spass,sfname.....etc." "faculty" table has columns "fid,fpass,ffname......etc." Problem---

i wish to now know how to normalize a table which have duplicate names and number repeated severally and i tried normalizing but could not

Hello, I am trying to query the data set below for the data_value for the data_id of the recent data_date. So for data_id 18554 the recent data_date will be 2/8/2016 18:40 and its data_value will be 29504.76 And for data_id 18555 the recent data_date will be 2/8/2016 18:40 and its data_value will be -90909090909 ...

I've tried Googling this and can't find an answer anywhere, which is an issue because I can't get Laravel to connect to my DB. I'm using a MySql DB which is managed through phpMyAdmin which I access from an app called InstantWordPress. I've always been able to connect to databases this way before but when I try to get Laravel to connect it just...

i have some dynamic rows, when i submit a single row submit into my database. how can i insert my dynamic all rows into database by submit? entry_history.php (page)