Quick way to import multiple CSV files to phpMyAdmin?
I have a bit of a arduous task each few days whereby my new CSV files (stored locally and on Google Drive) are used for data for my website tables.
The current task involves TRUNCATEing of 15 tables, and then updating each table with the latest CSV by using the IMPORT and “Choose file” option (skipping row 1).
Need to add substring from colum, column and custom value but returns 0 in SQL (phpMyAdmin)
I need to update the value of a column that should equal to initial from name + last name + “@simuladores”
The name column is called nombre_jefe, the last name column is called apellido_jefe, and the column it should be added to is called email_empresa.
The problem is, everytime I try something and it goes through it just returns 0 in every row.
All the columns are type VARCHAR
It returns me:
An opening bracket followed by a set of values was expected. (near “” at position 0)
How can I solve this error ?