I am creating a C # project with MySQL, my connector follows the Singleton pattern and I use MySqlDataReader to retrieve the data from the table and popular a List so far so good.
My problem started when I had to recover data from one table b...
I have two tables in my DB (mysql), where:
1st Table: CADASTROS
With the following fields: ID, NOME, IDADE, CIDADE
2nd Table: FUNCIONARIO
With the following fields: ID, ID_CADASTRO, PROFISSAO, SALARIO
Running...
I'm looking for help to understand an error given in a call to mysql_result (), that I can not resolve this error:
Warning: mysql_result () expects parameter 1 to be resource, object
given in C: \ wamp \ www \
I do not know what para...
I have a simple question but I could not find a solution.
In the same way I can when I use select to bring an empty column using select a.x,NULL as y,a.z from DADOS a , how can I make a column instead of having only NULL ,...
I'm working with a query system, and I would like, for example: If I look for the "a" value, it would return all the rows that have "a".
I tried using the like command, as shown below:
SELECT * FROM usuario WHERE nome LIKE 'a%';
But it on...
I'm starting my journey in programming and I came across a mistake
in creating the MySQL database:
1005 - Can not create table 'mydb.provider' (errno: 150)
What will it be? I have already logged into several forums but this same error...
I'm creating a bbcode function for a blog I'm doing and wanted to know if it's possible (and safe) to insert Javascript codes into my database.
I'm working with MySql.
Another question, I can not insert single quotation marks (which are...
I have an InnoDB table in MySQL where I store a user's account balance. To give a% of the balance I use Transactions to prevent two or more queries from attempting to give UPDATE simultaneously and end up corrupting the balance amount...
I need to develop a system in which when filling in the client's registry, be checked if the registered email already exists in the database, and if it already exists, that inform the user (via Ajax) that it already has this and -mail, and other...
It is very common to find a search on sites that returns records from different tables.
I need to implement a search on my site that returns produtos and usuários (profile) registered on the site. The result should be mix, but t...