Questions tagged as 'mysql'

Tagged questions
1
answer

Backup Restore Mysql does not insert all tables

I have a database MySql , where I performed a backup of all data from a particular database (all data was actually saved within a .sql file) but when I > reset using this file not all bank tables (Total 18, Inserted 14) Ques...
asked by 02.09.2015 / 16:08
3
answers

Insert into bank with function

I'm trying to make an insert into the database using a function but I'm not able to enter its values; HTML: <?php if (isset($_POST['submitTexto'])) { inserir('empresa', $_POST); } ?> where sub...
asked by 10.08.2015 / 16:29
1
answer

Return mysql result with function

I'm trying to list a database table using a function but I can not use it outside of function : The HTML: <tbody> <?php listar('empresa'); ?> <?php foreach ($row as $listar): ?> <tr> <td><...
asked by 10.08.2015 / 19:23
2
answers

Check if data already exists in the bank with codeigniter

I am starting with codeigniter using the active record to make the conversation with the bank, and wanted to know how do I know if an email already exists in db, would it list all emails and create a foreache doing the verification? Is there a s...
asked by 19.12.2015 / 20:13
1
answer

How to use mysql_result with MySQLi?

I would like to know how to use mysql_result in mysqli I'm not getting it, I was looking at the php.net site and the only thing I saw was mysqli_data_seek if anyone can help me ... Code I'd like to pass to mysql...
asked by 18.12.2015 / 01:59
1
answer

add values from one table and put the result in another

I have a table called players and I need to add the values of the points column but only those that have the same account_id and after putting the result in another table called accounts just in which it has the indicated id. The result would be...
asked by 26.08.2015 / 19:32
1
answer

Error connecting to remote database

Good evening, I'm having trouble with the following context: MySql Using the line of code below I tried connecting to a remote mysql server to try to access some tables and comes with the following error: SinceI'vetriedeverythingan...
asked by 19.08.2015 / 01:03
1
answer

Sort MySQL query for the last 3 months

I want to do an ordered SQL query for the first 3 months from the current month, for example: Current month is August (08), so I order as: 10 9 8 1 12 I am using the following command: SELECT * FROM 'tb_convencao' WHERE 'lg_historico'...
asked by 25.08.2015 / 19:10
1
answer

Update with join MYSQL

I have a table with client data, with the fields 'name_name' and 'code_name'. I need to update the 'codcorretor' from the data of my user table, where I have 'name' and 'codusuario'. So that something like codcorretor=codusuario where nomecor...
asked by 23.11.2015 / 12:37
2
answers

mysql self-increment restarts on its own

I have the same problem described here at this link: link The guidance given here was to do this: link But I did not quite understand, could anyone explain the solution given in this second link?     
asked by 26.11.2015 / 11:07