mysql - How do I assign the same id to rows having the same field -

-

i have mysql table containing 2553 novels information (like author, year etc.), , table containing 1059 authors (with biographical informations).

now, authors in second table writers of novels in first table. i'd assign same id authors in first table second table ones.

how can do? tried doing without success.

this how 'novels' table should (at moment there isn't author_id column)

 __ _____ ______ _________ |id|title|author|author_id| |0 |xyz  |john  |0        | |1 |xyz2 |john  |0        | |2 |abc  |rob   |1        | |3 |qwer |jeff  |2        | |4 |zxcv |jeff  |2        | |_________________________|

this 'authors' table

 __ ____ _____  |id|name|birth| |0 |john|1956 | |1 |rob |1898 | |2 |jeff|1932 | |_____________|

you can update join.

update novels inner join authors  set novels.author_id=authors.id novels.author=authors.name

there after should want drop author column in novels table since becomes redundant (assuming of course authors correctly represented in authors table)


Comments

Post a Comment

Popular posts from this blog

php - Autoloader issue not returning Class -

-
problem? bootloader (autoloader) not seem working properly, or i'm missing something. here simplified code. the code below returns class "skeleton" not exist. on index.php file. index.php <?php include 'bootloader.php'; use skeleton\html\loginheader; $tool = new skeleton/html/loginheader(); bootloader.php <?php function boot($classname) { $filename = ''; $namespace = ''; // sets include path "src" directory $includepath = dirname(__file__).directory_separator.'src'; if (false !== ($lastnspos = strripos($classname, '\\'))) { $namespace = substr($classname, 0, $lastnspos); $classname = substr($classname, $lastnspos + 1); $filename = str_replace('\\', directory_separator, $namespace) . directory_separator; } $filename .= str_replace('_', directory_separator, $classname) . '.php'...
Read more

java - How to put two numbers separated by a space into two different arrays -

-
i have 2 number inputs 1010 212 i want put these 2 different arrays ([1 0 1 0] , [2 1 2]) this code import java.io.*; import java.util.*; public class solution { public static void main(string[] args) { int array[] = new int[8]; int array2[] = new int[8]; int = 0; scanner getnumber = new scanner(system.in); { array[i] = getnumber.nextint(); i++; } while(getnumber.hasnextint()); system.out.println(arrays.tostring(array)); } } but output [1010, 212, 0, 0, 0, 0, 0, 0] (i put 8 generic array length because java compiler forced initialize each array) you need store numbers first initialize arrays based on length of number. can length turning string. once left number , empty array, can split integer array of digits number of ways. int[] array, array2; scanner in = new scanner(system.in); int a, b; = in.nextint(); b = in.nextint(); array = new int[integer.tostring(a...
Read more

c++ - Why am i getting wrong values when performing PE base relocation? -

-
i trying perform pe base relocation , whole concept, data structures, method , why doing not problem that. days have been trying code work whatever keep getting undefined/wrong relocation types in variable called relocationtype(obviously) , have feeling might getting wrong offsets aswell allthought when checked debugger few bytes off, regardless cause crash. i should inform of relocation types correct, , either image_rel_absolute or image_rel_based_highlow 1 expect, after few loops finds wrong values. not have clue happening, suspect pbaserelocation might few bytes of reason after while. here relocation function: int fixrelocs(dword imagebase, pimage_nt_headers ntheaders, image_base_relocation *reloc, unsigned int size) { pimage_base_relocation pbaserelocation; image_data_directory datadir; pword list; dword delta; dword count; dword *patchaddr; unsigned char* dest; unsigned char* base = (unsigned char*)imagebase; bool ndelta = false; datadir = (image_data_directory)ntheader...
Read more